基于SSM医药后台管理系统

QQ626162193

于 2023-03-02 22:00:54 发布

阅读量148

点赞数

文章标签： mybatis java spring

本文链接：https://blog.csdn.net/QQ626162193/article/details/129310171

版权

                介绍：

spring：springmvc：mybatis：mysql：eclipse。

截图：
请添加图片描述

数据库表：

CREATE TABLE (
ano char(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
aname char(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
asex char(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
aphone char(12) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
aremark varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
aid int(11) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (ano) USING BTREE,
UNIQUE INDEX ano_UNIQUE(ano) USING BTREE,
UNIQUE INDEX aid_UNIQUE(aid) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 12036 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

CREATE TABLE user (
uUsername varchar(12) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
uPassword varchar(45) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
uAccess varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
PRIMARY KEY (uUsername) USING BTREE,
UNIQUE INDEX uUsername_UNIQUE(uUsername) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

– Records of user

INSERT INTO user VALUES (‘admir’, ‘1234’, ‘信息查询功能,信息录入功能,信息删除功能,信息修改功能,信息浏览功能,数据报表功能,用户管理功能’); INSERT INTO user VALUES (‘Adobe’, ‘123’, ‘信息查询功能,信息录入功能,信息删除功能,信息修改功能,信息浏览功能,数据报表功能’); INSERT INTO user VALUES (‘test’, ‘1201’, ‘信息查询功能’); INSERT INTO user VALUES (‘zuidaima’, ‘111111’, ‘信息查询功能’);