[Python]代码
01 | #-*- encoding: gb2312 -*- |
02 | import os, sys, string |
03 | import MySQLdb |
04 |
05 | # 连接数据库 |
06 | try : |
07 | conn = MySQLdb.connect(host = 'localhost' ,user = 'root' ,passwd = 'xxxx' ,db = 'test1' ) |
08 | except Exception, e: |
09 | print e |
10 | sys.exit() |
11 |
12 | # 获取cursor对象来进行操作 |
13 |
14 | cursor = conn.cursor() |
15 | # 创建表 |
16 | sql = "create table if not exists test1(name varchar(128) primary key, age int(4))" |
17 | cursor.execute(sql) |
18 | # 插入数据 |
19 | sql = "insert into test1(name, age) values ('%s', %d)" % ( "zhaowei" , 23 ) |
20 | try : |
21 | cursor.execute(sql) |
22 | except Exception, e: |
23 | print e |
24 |
25 | sql = "insert into test1(name, age) values ('%s', %d)" % ( "张三" , 21 ) |
26 | try : |
27 | cursor.execute(sql) |
28 | except Exception, e: |
29 | print e |
30 | # 插入多条 |
31 |
32 | sql = "insert into test1(name, age) values (%s, %s)" |
33 | val = (( "李四" , 24 ), ( "王五" , 25 ), ( "洪六" , 26 )) |
34 | try : |
35 | cursor.executemany(sql, val) |
36 | except Exception, e: |
37 | print e |
38 |
39 | #查询出数据 |
40 | sql = "select * from test1" |
41 | cursor.execute(sql) |
42 | alldata = cursor.fetchall() |
43 | # 如果有数据返回,就循环输出, alldata是有个二维的列表 |
44 | if alldata: |
45 | for rec in alldata: |
46 | print rec[ 0 ], rec[ 1 ] |
47 |
48 |
49 | cursor.close() |
50 |
51 | conn.close() |