Python学习笔记（二）

Mysql连接

config={    'host' : '127.0.0.1',    'database' : 'dbname',    'user' : '',    'password' : '',    'charset' : 'utf8',    'port' : 3306,    #'_connection_string' : "mysql:host=127.0.0.1;dbname=dbname;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))

以上是读数据库操作。
未完待续。