python访问mysql 数据库

环境： 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()