连接mysql数据库,需要安装一个模块,在windows下安装一个程序,我的是2.5版本的python,是这个MySQL-python-1.2.2.win32-py2.5.exe 可以到网上很容易找到。操作数据也是很方便的。下面代码摘自网络。
- #-*- encoding: gb2312 -*-
- import os, sys, string
- import MySQLdb
- # 连接数据库
- try:
- conn = MySQLdb.connect(host='localhost',user='root',passwd='xxxx',db='test1')
- except Exception, e:
- print e
- sys.exit()
- # 获取cursor对象来进行操作
- cursor = conn.cursor()
- # 创建表
- sql = "create table if not exists test1(name varchar(128) primary key, age int(4))"
- cursor.execute(sql)
- # 插入数据
- sql = "insert into test1(name, age) values ('%s', %d)" % ("zhaowei", 23)
- try:
- cursor.execute(sql)
- except Exception, e:
- print e
- sql = "insert into test1(name, age) values ('%s', %d)" % ("张三", 21)
- try:
- cursor.execute(sql)
- except Exception, e:
- print e
- # 插入多条
- sql = "insert into test1(name, age) values (%s, %s)"
- val = (("李四", 24), ("王五", 25), ("洪六", 26))
- try:
- cursor.executemany(sql, val)
- 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]
- cursor.close()
- conn.close()