Python对数据库实现增删查改

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("3.修改部门"