#插入数据 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()