环境: window 开发环境
1. 安装python2.6
下载路径: http://www.python.org/ftp/python/2.6/python-2.6.msi
2. 安装 MySQL-python-1.2.2.win32-py2.6, 点击这下载
3. 访问MySQL 脚本如下:
import MySQLdb as mysql
import unittest, threading, random, os, socket, time
class ThreadRunner(threading.Thread):
def __init__(self,cur,sql):
threading.Thread.__init__(self)
self.cur = cur
self.sql = sql
def run(self):
self.cur.execute(self.sql);
class DBUtil():
def __init__(self,cur):
self.cur=cur
def create_table(self):
self.cur.execute("create table student(id integer,name varchar(45))");
def insert_simple(self):
self.cur.execute("insert into student(id ,name) values(1,'david')");
self.cur.execute("insert into student(id ,name) values(2,'hxw')");
def update(self):
self.cur.execute("update student set name='haha' where id=2");
def select(self):
self.cur.execute("select * from student");
for data in cur.fetchall():
print '%s' % data[0],data[1]
def clear(self):
self.cur.execute("delete from student");
self.cur.execute("drop table student");
def runAll(self):
self.create_table();
self.insert_simple();
self.update();
self.select();
self.clear();
def insert_currency(self):
for n in range(100):
thr = ThreadRunner(cur,"insert into student(id ,name) values(2,'hxw')")
thr.start()
def insert_loop(self,count):
self.cur.execute("insert into student(id ,name) values(2,'hxw')");
for n in range(count):
self.cur.execute("insert into student(id ,name) values(2,'hxw')");
if __name__ == '__main__':
conn= mysql.connect(host='127.0.0.1', user='root',passwd='123456',db='acid')
cur = conn.cursor()
du = DBUtil(cur)
du.runAll()
du.insert_loop(100)
du.select()