#准备工作
开发环境:Python3.7
开发工具:pycharm 2019.3
用到的Python模块:pymysql ,hashlib
#程序实现
面向对象+数据库+异常+模块。用户登录实现对学生名片的增删改查显示所有学生信息
#设计数据库
数据库:information
user表:存储用户信息
CREATE TABLE `user` (
`id` int(11) PRIMARY KEY NOT NULAUTO_INCREMENT,
`user_name` varchar(11) UNIQUE,
`passward` varchar(256) DEFAULT NULL);
student_msg:存储学生名片信息
CREATE TABLE `student_msg` (
`id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
`no` varchar(12) UNIQUE ,
`name` char(10) ,
`sex` char(2) ENUM('男','女') DEFAULT '男',
`phone` varchar(11) ,
`class` varchar(10) ,);
#代码
#模块MySQLHelper将数据库操作封装
import pymysql
class MySQLTool(object):
def __init__(self,host,port,database,user,pwd,charset):
self.host = host
self.port = port
self.database = database
self.user = user
self.pwd = pwd
self.charset = charset
def __connect(self):
#创建连接 建立游标对象
self.conn = None
self.cursor = None
self.conn = pymysql.connect(host = self.host,
port = self.port,
database = self.database,
user = self.user,
password = self.pwd,
charset = self.charset)
self.cursor = self.conn.cursor()
def __close(self):
if self.cursor:
self.cursor.close()
if self.conn:
self.conn.close()
#增删改
def __cud(self,sql,params):
rowcount = 0
try:
self.__connect()
rowcount = self.cursor.execute(sql,para