python 学生信息关系系统

短命女 2022-05-17 04:51 140阅读 0赞

这里废话不多说,我们直接进入代码:

import sqlite3
    class Student(object):
        def __init__(self,name='',age='',tel = ''):
            self.name = name
            self.age = age
            self.tel = tel
    class DBAction(object):
        def __init__(self,dbName,tableName):
            self.dbName = dbName
            self.tableName= tableName
            #属性可以在勒种任意地方使用
            self.connect =  None
            self.cuedor = None
        def createDBAnaTable(self):
            self.connect = sqlite3.connect('{}'.format(self.dbName))
            self.cursor = self.connect.cursor()
            self.cursor.execute('create table if not exists"{}"(name text,age text,tel text)'.format(self.tableName))
        def commitAndClose(self):
            self.connect.commit()
            self.cursor.close()
            self.connect.close()
        def openDB(self):
            self.connect = sqlite3.connect('{}'.format(self.dbName))
            self.cursor = self.connect.cursor()
        def addNewStudentToTable(self,student):
            self.openDB()
            self.cursor.execute('insert into "{}"(name,age,tel)VALUES ("{}","{}","{}")'.format(self.tableName,student.name,student.age,student.tel))
            self.commitAndClose()
        def deleteStudenttoTable(self,name):
            self.openDB()
            self.cursor.execute('delete from "{}" WHERE name ="{}"'.format(self.tableName,name))
            self.commitAndClose()
    # student = Student('王老吉',107,123)
    
    myDB = DBAction('BDAction','tableAction')
    myDB.createDBAnaTable()
    
    while True:
        value = input("""
        请输入操作:
        1.增加学生信息
        2.删除学生信息
        3.修改学生信息
        4.查看学生信息
        """)
        value = int(value)
    
        if value ==1:
            name = input('请输入姓名')
            age = input('请输入年龄')
            tel = input('请输入联系方式')
            student = Student(name,age,tel)
            myDB.addNewStudentToTable(student)
        if value == 2:
            name = input('请输入要删除的学生信息')
            myDB.deleteStudenttoTable(name)

代码量不多,应该很容易看懂...,不懂的可以下方留言询问,一起交流...