Windows 下 Python + MySQL 的安装及操作方法
Windows 下 Python + MySQL 的安装及操作方法1、下载Mysql包:下载地址: http://www.lfd.uci.edu/~gohlke/pythonlibs/#mysql-python找到 32位或64位安装包:MySQL_python-1.2.5-cp27-none-win32.whlMySQL_python-1.2.5-cp27-none-
·
Windows 下 Python + MySQL 的安装及操作方法
下载地址: http://www.lfd.uci.edu/~gohlke/pythonlibs/#mysql-python
找到 32位或64位安装包:
MySQL_python-1.2.5-cp27-none-win32.whl
MySQL_python-1.2.5-cp27-none-win_amd64.whl
下载到本地E:盘根目录
到C:\Python27\Scripts 安装目录,Shift+右键-->在此处打开CMD命令窗口
执行命令:pip install E:\MySQL_python-1.2.5-cp27-none-win_amd64.whl
2、MySQL的操作及应用
import MySQLdb
# MySQL相关设置
mysql_host = '10.202.44.155'
mysql_user = 'test'
mysql_passwd = 'test'
mysql_port = '3306'
mysql_database = 'test'
def my_connect():
"""链接数据库"""
global conn, cursor
#print MySQLdb.version_info
try:
conn = MySQLdb.connect(host=mysql_host, user=mysql_user, passwd=mysql_passwd,charset='utf8', autocommit=True, db=mysql_database)
print u"\nMesses:连接MySQL成功"
except Exception:
print(u'\nMesses: 连接失败' )
exit(20)
cursor = conn.cursor()
def add():
#add
sql = "insert into user(name,age) values(%s,%s)"
param = ("tom",str(20))
n = cursor.execute(sql,param)
print n
def update():
#更新
sql = "update user set name=%s where Id=9001"
param = ("ken")
n = cursor.execute(sql,param)
print n
def Select():
#查询
try:
n = cursor.execute("SELECT t.mainWaybillNo,t.opCode from track t ORDER BY t.insertTime DESC LIMIT 2")
data = cursor.fetchall()
for row in data:
#注意int类型需要使用str函数转义
print("\nmainWaybillNo: " + row[0] + ' opCode: '+row[1])
print ""
#提交事务
conn.commit()
cursor.close()#关闭游标
conn.close()#释放数据库资源
except Exception :
#异常情况下,进行事务回滚
conn.rollback()
print(u"\n操作失败,数据已回滚")
def delete():
#删除
sql = "delete from user where name=%s"
param =("ted")
n = cursor.execute(sql,param)
print n
cursor.close()
my_connect()
Select()
更多推荐
所有评论(0)