Python 连接数据库

kider

import MySQLdb as mydb
db = mydb.connect(host='192.168.0.110',user='jianjun',passwd='lovelinux',db='webdatabase', charset="utf-8")
cur = db.cursor()
sql = unicode("select user,id from user_table where sex = '男'","utf-8")
print sql
cur.execute(sql)
cur.close()
db.close()