#!/usr/bin/python
# -*- coding: UTF-8 -*-
from _ast import Param
#查询数据库
'''
import MySQLdb
conn = MySQLdb.connect(host='127.0.0.1',user='root', passwd='1234', db='08day05')
cur = conn.cursor()
reCount = cur.execute('select * from userinfo')
data = cur.fetchall()
cur.close()
conn.close()
print reCount
print data
'''
#插入数据
'''
import MySQLdb
conn = MySQLdb.connect(host='127.0.0.1',user='root', passwd='1234', db='08day05')
cur = conn.cursor()
sql = "insert into userinfo (name ,address) values(%s,%s)"
params = ('wang','use')
reCount = cur.execute(sql, params)
conn.commit()
#data = cur.fetchall()
cur.close()
conn.close()
print reCount
'''
#删除数据
'''
import MySQLdb
conn = MySQLdb.connect(host='127.0.0.1',user='root', passwd='1234', db='08day05')
cur = conn.cursor()
sql = "delete from userinfo where id = %s"
params = ('8')
reCount = cur.execute(sql, params)
conn.commit() #需要提交，语句才能生效
#data = cur.fetchall()
cur.close()
conn.close()
print reCount
'''
#更新数据
'''
import MySQLdb
conn = MySQLdb.connect(host='127.0.0.1',user='root', passwd='1234', db='08day05')
cur = conn.cursor()
sql = "update userinfo set name = %s where id =4"
params = ('www')
reCount = cur.execute(sql, params)
conn.commit() #需要提交，语句才能生效
#data = cur.fetchall()
cur.close()
conn.close()
print reCount
'''
#批量插入数据
'''
import MySQLdb
conn = MySQLdb.connect(host='127.0.0.1',user='root', passwd='1234', db='08day05')
cur = conn.cursor()
li = [
('alax','feifie'),
('wangba','dagou'),
('wangba','dagou'),
('wangba','dagou'),
('wangba','dagou'),
('wangba','dagou'),
('wangba','dagou'),
('wangba','dagou'),
('wangba','dagou'),
]
reCount = cur.executemany('insert into userinfo(name,address ) values(%s,%s )',li)
conn.commit() #需要提交，语句才能生效
#data = cur.fetchall()
cur.close()
conn.close()
print reCount
'''
#把ID 义字典的形式读取出来
'''
import MySQLdb
conn = MySQLdb.connect(host='127.0.0.1',user='root', passwd='1234', db='08day05')
cur = conn.cursor(cursorclass = MySQLdb.cursors.DictCursor)
reCount = cur.execute('select * from userinfo')
data = cur.fetchall()
cur.close()
conn.close()
print reCount
print data
'''
'''
import MySQLdb
conn = MySQLdb.connect(host='127.0.0.1',user='root', passwd='1234', db='08day05')
cur = conn.cursor()
#cur = conn.cursor(cursorclass = MySQLdb.cursors.DictCursor)
reCount = cur.execute('select * from userinfo')
#data = cur.fetchall()
data = cur.fetchone()
print data
#cur.scroll(0,mode='absolute')
data = cur.fetchone()
print data
cur.scroll(-1,mode='relative')
data = cur.fetchone()
#cur.scroll(0,mode='absolute')
cur.close()
conn.close()
#print reCount
print data
'''
import MySQLdb
conn = MySQLdb.connect(host='127.0.0.1',user='root', passwd='1234', db='08day05')
cur = conn.cursor()
sql = "insert into userinfo (name ,address) values(%s,%s)"
params = ('wang','use')
reCount = cur.execute(sql, params)
conn.commit()
#data = cur.fetchall()
cur.close()
conn.close()
print reCount
