win7上python2.7连接mysql数据库02

来源：互联网发布：linux鸟哥的私房菜pdf 编辑：程序博客网时间：2024/05/22 22:42

win7上python2.7连接mysql数据库，配置写到配置文件中，本例子找那个包括：
1、单条插入
2、批量插入
3、事务处理

myapp.conf

# database source[downdb]host = XXX.XXX.XXX.XXXport = 3306user = funnelpass = 1qaz@<2wsxdbName = user_privileges[ondb]host = XXX.XXX.XXX.XXXport = 3306user = funnelpass = 1qaz@<2wsxdbName = bi_data

mysqlHelper.py

#!/usr/bin/python# -*- coding: UTF-8 -*-import ConfigParserimport codecsimport pymysqlDBSource = "ondb"cp = ConfigParser.SafeConfigParser()with codecs.open('myapp.conf', 'r', encoding='utf-8') as f:    cp.readfp(f)'''mysql的连接'''conn = pymysql.connect(host=cp.get(DBSource, 'host'), user=cp.get(DBSource, 'user'), password=cp.get(DBSource, 'pass'),                       database=cp.get(DBSource, 'dbName'), use_unicode=True)'''mysql的游标'''cursor = conn.cursor()def mysqlExecute(sql):    try:        cursor.execute(sql)        conn.commit()    except:        cursor.rollback()def mysqlSearch(sql):    try:        cursor.execute(sql)        return cursor.fetchall()    except:        cursor.rollback()def mysqlBatchInset(sql, args):    try:        cursor.executemany(sql, args)        conn.commit()    except:        cursor.rollback()def mysqlClose():    conn.close()if __name__ == "__main__":    sql = "select * from hdfs_delete_file_record order by DATE  DESC  limit 100 "    # sql = "select * from hdfs_path_Monitor order by DATE  DESC  limit 100 "    # 使用 fetchone() 方法获取一条数据库。    values = mysqlSearch(sql)    for line in values:        print line    mysqlClose()

阅读全文

0 0