mysql_jdbc.py# -*- coding:UTF-8 -*-import pymysqlclass 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
来源:https://www.cnblogs.com/kopao/p/11981897.html