python 学生信息关系系统

原创

微笑@鼠 2022-09-22 18:49:06 博主文章分类：Python ©著作权

文章标签 sqlite 文章分类 Spark 大数据

©著作权归作者所有：来自51CTO博客作者微笑@鼠的原创作品，请联系作者获取转载授权，否则将追究法律责任

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

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)