import MySQLdb

class MysqlSearch(object):

def get_conn(self):
# 获取链接
	try:
		self.conn = MySQLdb.connect(
	    	host = '127.0.0.1',
	    	user = 'root',
	    	password = '',
	    	db = 'news',
	    	port = 3306,
	    	charset = 'utf8'
	 	)	
	except MySQLdb.Error as e:
		print('Error: %s' % e)

def close_conn(self):
	try:
		if self.conn:
			# 关闭连接
			self.conn.close()
	except MySQLdb.Error as e:
		print('Error: %s' % e)
# 获取数据
def get_one(self):
	# 准备 SQL
	sql = 'SELECT * FROM `news` WHERE `types` = %s ORDER BY `created_at` DESC;'
	# 找到cursor
	cursor = self.conn.cursor()
	# 执行SQL
	cursor.execute(sql,('百家', ))
	# 拿到结果
	print(dir(cursor))
	rest = cursor.fetchone()
	# 处理数据
	print(rest)
	# 关闭cursor/连接
	cursor.close()
	self.close_conn()

def main():
obj = MysqlSearch()
obj.get_one()

if name == ‘main’:
main()
报错信息：
Traceback (most recent call last):
File “test_tranning_1.py”, line 48, in
main()
File “test_tranning_1.py”, line 45, in main
obj.get_one()
File “test_tranning_1.py”, line 31, in get_one
cursor = self.conn.cursor()
AttributeError: ‘MysqlSearch’ object has no attribute ‘conn’

Repl Closed