Python与数据库连接
from pymysql import *
class MyDb(object):
def __init__(self):
self.my_conn()
def my_conn(self):
try:
self.conn = connect(host="127.0.0.1",port=3306,user="root",passwd="root",db="mb",charset="utf8")
except Exception as e:
print(e)
def get_one(self):
cs = self.con.cursor
sql = "select * from 库名;"
cs.execute(sql)
res = cs.fetvhone()
cs.close()
self.conn.close()
return res
def get_all(self):
cs = self.con.cursor
sql = "select * from goods;"
cs.execute(sql)
res = cs.fetchall()
cs.close()
self.conn.close()
def close_conn(self):
self.conn.close()
def main():
db = MyDb()
all_data = db.get_all()
for data in all_data:
print(data)
if __name__ == '__main__'
main()