#插入数据
with connect:
print "insert some data into test table ..."
insertSql = 'insert into test (id,value) values (null,"t.liu")'
print cur.execute(insertSql)
#批量插入
with connect:
print "batch insert starting .... "
insertSql = "insert into test (id,value) values (null,%s)"
insertDataList = []
max = 100
while max > 0:
max -= 1
insertDataList.append(randStr(random.randint(4,18)))
print cur.executemany(insertSql,insertDataList)
print "batch insert over total insert %d records " % (cur.rowcount)
#查询数据
print "select ... "
print cur.execute("select * from test")
#获取上条语句执行后影响记录总条数
print cur.rowcount
print cur.fetchmany(cur.rowcount)
#元组集合，包含字典元素，
print "result dictory format : "
curDict = connect.cursor(mdb.cursors.DictCursor)
#!/usr/bin/env python
# encoding:utf8
# import module
from module.module import randStr
import string
# 导入包
import pack.testPack as test
__author__ = 'flybird1971'
timer = 1
while True:
if timer > 10:
break
timer += 1
print string.capitalize(randStr(timer))
print "*" * 32
test.show()
#!/usr/bin/env python
# encoding:utf8
# import module
from module.module import randStr
import string
# 导入包
import pack.testPack as test
__author__ = 'flybird1971'
timer = 1
while True:
if timer > 10:
break
timer += 1
print string.capitalize(randStr(timer))
print "*"*32
test.show()
