直接看代码:
#-*- encoding: gb2312 -*-
'''
Created on 2013-3-5
@author: naughty
'''
import os, sys, string
import MySQLdb
try:
conn = MySQLdb.connect(host='localhost',user='',passwd='',db='test')
except Exception, e:
print "连接数据库失败:"+e
sys.exit()
cursor = conn.cursor()
# 创建表
sql="drop table test1;"
cursor.execute(sql)
sql = "create table if not exists test1(name varchar(128), age int(4))"
cursor.execute(sql)
# 插入数据
sql = "insert into test1(name, age) values ('%s', %d)" % ("sassdddd", 23)
try:
cursor.execute(sql)
except Exception, e:
print e
#查询出数据
sql = "select * from test1"
cursor.execute(sql)
alldata = cursor.fetchall()
# 如果有数据返回,就循环输出, alldata是有个二维的列表
if alldata:
for rec in alldata:
print rec[0], rec[1]
conn.commit()
cursor.close()
conn.close()
最后记得conn.commit()把数据提交。
pybatis后面的系列中海会介绍数据库连接池的使用。