Python连接Mysql数据库

mysql_jdbc.py
# -*- coding:UTF-8 -*-
import pymysql

class MYSQL:
    def __init__(self,host,port,user,pwd,db):
        self.host = host
        self.port = port
        self.user = user
        self.pwd = pwd
        self.db = db



    def __GetConnect(self):
        if not self.db:
            raise(NameError,"没有设置数据库信息")
        self.conn = pymysql.connect(host=self.host,port=self.port,user=self.user,passwd=self.pwd,db=self.db)

        cur = self.conn.cursor()
        if not cur:
            raise(NameError,"连接数据库失败")
        else:
            return cur

    def ExecQuery(self,sql):
        cur = self.__GetConnect()
        cur.execute(sql)
        resList = cur.fetchall()

        #查询完毕后必须关闭连接
        self.conn.close()
        return resList

    def ExecNonQuery(self,sql):
        cur = self.__GetConnect()
        cur.execute(sql)
        self.conn.commit()
        self.conn.close()



使用：
test.py

# -*- coding:UTF-8 -*-

import mysql_jdbc as mysql

msql=mysql.MYSQL(host="xxx.xxx.xxx.xxx",port=3306,user="xxx",pwd="xxxx",db="xxxx")
sql="xxxxxxxxxxxxxxxxxxxxxx"

query_list=msql.ExecQuery(sql)

for data in table_list:
  print data