1 import os, sys, string
2 import MySQLdb
3 try:
4 conn = MySQLdb.connect(host='localhost',user='root',passwd='wangmoon',db='hello')
5 except Exception, e:
6 print e
7 sys.exit()
8 cursor = conn.cursor()
9
10
11 sql = "create table if not exists test1(name varchar(128) primary key, age int(4))"
12 try:
13 cursor.execute(sql)
14 except Exception,e:
15 print e;
16
17 sql = "insert into test1(name, age) values ('%s', %d)" % ("zhaowei", 23)
18 try:
19 cursor.execute(sql)
20 except Exception, e:
21 print e
22 sql = "insert into test1(name, age) values ('%s', %d)" % ("ee", 21)
23 try:
24 cursor.execute(sql)
25 except Exception, e:
26 print e
27 sql = "insert into test1(name, age) values (%s, %s)"
28 val = (("aa", 24), ("bb", 25), ("cc", 26))
29 try:
30 cursor.executemany(sql, val)
31 except Exception, e:
32 print e
33 sql = "select * from test1"
34 cursor.execute(sql)
35 alldata = cursor.fetchall()
36 if alldata:
37 for rec in alldata:
38 print rec[0], rec[1]
39 cursor.close()
40 conn.close()
41
