我是靠谱客的博主 狂野手套,这篇文章主要介绍python3 mysql 封装多表_python3操作mysql数据库表01(封装查询单条、多条数据),现在分享给大家,希望可以做个参考。

import pymysql

# import os

'''

封装查询单条、多条数据

'''

# os.environ['NLS_LANG'] = 'SIMPLIFIED CHINESE_CHINA.UTF8'

pdbinfo = {"host": '912.168.1.133',

"port": 3306,

"user": 'root',

"passwd": '123456',

"db": 'employees',

"charset": 'utf8'}

class MySQLUtil:

def __init__(self):

self.dbinfo=pdbinfo

self.conn=MySQLUtil.__getConnect(self.dbinfo)

@staticmethod

def __getConnect(pdbinfo):

try:

conn=pymysql.connect(host=pdbinfo['host'],port=pdbinfo['port'],user=pdbinfo['user'],passwd=pdbinfo['passwd'],

db=pdbinfo['db'],charset=pdbinfo['charset'])

return conn

except Exception as error:

print("get connect happen error %s "%error)

def close_db(self):

try:

self.conn.close()

except Exception as error:

print("close db happen error %s "%error)

def get_alldata(self,psql):

cur=self.conn.cursor()

try:

cur.execute(psql)

except Exception as error:

print("execute sql happen error %s "%error)

else:

rows = cur.fetchall()

cur.close()

return rows

def get_singledata(self,psql):

rows = self.get_alldata(psql)

row_len=len(rows)

# print(row_len)

# if rows != None:

# for row in rows:

# for i in row:

# print(i)

# return i

if __name__=='__main__':

conn=MySQLUtil()

selectSql = "select * from salaries sal where sal.salary > '%d'" % (150000)

rows=conn.get_alldata(selectSql)

# for i,element in enumerate(rows):

# print(i,element)

# print(rows)

# row=conn.get_singledata(selectSql)

# print(row)

for i in rows:

listRes=list(i)

print(listRes[2])

conn.close_db()

最后

以上就是狂野手套最近收集整理的关于python3 mysql 封装多表_python3操作mysql数据库表01(封装查询单条、多条数据)的全部内容,更多相关python3内容请搜索靠谱客的其他文章。

本图文内容来源于网友提供,作为学习参考使用,或来自网络收集整理,版权属于原作者所有。
点赞(47)

评论列表共有 0 条评论

立即
投稿
返回
顶部