python数据库连接模板

#!/usr/bin/python# -*- coding:utf-8 -*-__author__ = 'huangpeng03'import sysfrom DBUtils.PooledDB import PooledDBimport MySQLdbreload(sys)sys.setdefaultencoding("utf-8")DB_HOST = ''DB_USER = ''DB_PASSWD = ''DB_NAME = ''MySQLPool = PooledDB(creator=MySQLdb,                    host=DB_HOST,                    user=DB_USER,                    passwd=DB_PASSWD,                    db=DB_NAME,                    charset='utf8')def main():    conn = MySQLPool.connection()    cur = conn.cursor()    conn.commit()    cur.close()    conn.close()if __name__ == '__main__':    main()