#coding:utf-8
import MySQLdb
import json
#连接
conn= MySQLdb.connect(
host='localhost',
port = 3306,
user='root',
passwd='',
db ='test'
)
cur=conn.cursor()
#单条插入
cur.execute("insert into user (name ,age,sex) value ('%s',%s,%s)"%('a',1,1))
#批量
cur.executemany("insert into user (name ,age,sex) values (%s,%s,%s)",[("e", 1, 1), ("f", 1, 1), ("g", 1, 1)])
#查询单条
cur.execute("select * from user where id = %s and name = '%s'" % (1,'张三'))
res_data=json.dumps(cur.fetchone(),ensure_ascii=False,encoding="utf8")
print res_data
#查询多条
cur.execute("select * from user")
res_data=json.dumps(cur.fetchmany(15),ensure_ascii=False,encoding="utf8")
print res_data
#修改
cur.execute("update user set name='%s' where id= %s"%('王麻子',1))