python操作数据库简单程序

#!/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])