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.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()