Python对数据库实现增删查改
此版本是控制台版本
先来写个基础类
我使用的数据库 pymsql
dbHelper 数据库连接工具类
"""
数据库连接工具类
"""
import pymysql
class DbHelper(object):
def __init__(self):
# 获得mysql的连接对象
self.conn = pymysql.connect(host="localhost", user="root", password="p@ssw0rd", database="test", charset="utf8")
self.cursor = self.conn.cursor()
def close(self):
self.cursor.close()
self.conn.close()
if __name__ == " main ":
dbHelper = DbHelper()
print(dbHelper.conn)
dept 实体类
"""
部门实体类
"""
class Dept(object):
def __init__(self,did,dname,dempnums):
self.did = did
self.dname = dname
self.dempnums = dempnums
def __str__(self):
return f"{self.did},{self.dname},{self.dempnums},"
if __name__ == " main ":
dept = Dept(1, "研发部", 20)
print(dept)
dao方法
DeptDao
"""
导入数据库的工具类
"""
# import db.dbhelper
from db.dbhelper import DbHelper
from entity.dept import Dept
class DeptDao(object):
def __init__(self):
self.dbHelper = DbHelper()
# 静态方法 控制台输出语句
@staticmethod
def choiceFunc():
print("*" * 20)
print("1.添加部门")
print("2.删除部门")
print(