Mysql连接
config={
'host' :
'127.0.0.1',
'database' :
'dbname',
'user' :
'',
'password' :
'',
'charset' :
'utf8',
'port' :
3306,
}
@staticmethod
def get_user_info(dealer_id):
db = config.DBConfig.get()
try:
cnn = mysql.connector.connect(**db)
cursor = cnn.cursor()
sql_query =
"""SELECT id,user_name,age,gender,score FROM user_tbl WHERE user_name like %s limit 10 """
cursor.execute(sql_query,(
'nibushiren',))
column_names = cursor.column_names
print(
"""{} {}\t{}\t{}""".format(*column_names))
index =
0
for id,user_name,age,gender
in cursor:
if index >
100:
break
print(
'%4d\t\t%10s\t\t%2d\t%2s\t%6.4f' % (id,user_name,age,gender,score))
index +=
1
cursor.close()
cnn.close()
except mysql.connector.Error
as e:
print(
'connect fails!{}'.format(e))
以上是读数据库操作。 未完待续。
转载请注明原文地址: https://ju.6miu.com/read-1202860.html
