python操作数据库简单程序

qder

• #!/usr/bin/python
  
  
• # coding=utf-8
  
• '''
  
  
• Created on 2015年4月13日
  
• Script : E:/EclipseCode/python/myTestDjango/src/myTestDjango/conn_db.py
  
• @author: ceagle
  
• '''
  
• import MySQLdb
  
• try:
  
•     #conn=MySQLdb.connect(host='localhost',user='root',passwd='',db='myTestDjango',port=3306,charset='gbk')
  
•     conn=MySQLdb.connect(host='localhost',user='root',passwd='',port=3306,charset='gbk')
  
•     cur=conn.cursor()
  
•     cur.execute('create database if not exists myTestDjango')
  
•     conn.select_db('myTestDjango')
  
•    
  
•     #cur.execute('create table if not exists student (id int,name varchar(20))')
  
•     # insert single data
  
•     value = [1,'ceagle']
  
•     cur.execute('insert into student values (%s,%s)',value)
  
•     #insert many data
  
•     values = []
  
•     for i in range(5):
  
•         values.append((i,'student'+str(i)))
  
•     cur.executemany('insert into student values (%s,%s)',values)
  
•    
  
•    
  
•     #display
  
•     count = cur.execute('select * from student')
  
•     print 'There has %s lines in student' % count
  
•    
  
•     print '1 records:'
  
•     result = cur.fetchone()
  
•     print 'ID:%s Name:%s' % result
  
•     print "=="*10
  
•     print '3 records:'
  
•     result =cur.fetchmany(3)
  
•     for i in result:
  
•         print i
  
•     print "=="*10
  
•    
  
•     print 'all records:'
  
•     result =cur.fetchall()
  
•     for i in result:
  
•         print i
  
•     print "=="*10
  
•     #cur.execute('select * from mysql.user')
  
•     conn.commit()
  
•     cur.close()
  
•     conn.close()
  
• except MySQLdb.Error,e:
  
•     print "Mysql Error %d: %s" % (e.args[0], e.args[1])