中信银行Java笔试题，基于ssm医院病历管理系统

CREATE TABLE allusers (

id int(11) NOT NULL AUTO_INCREMENT,

username varchar(50) DEFAULT NULL,

pwd varchar(50) DEFAULT NULL,

cx varchar(50) DEFAULT ‘普通管理员’,

addtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,

PRIMARY KEY (id)

) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=gb2312;

---

– Records of allusers

---

INSERT INTO allusers VALUES (‘2’, ‘hsg’, ‘hsg’, ‘超级管理员’, ‘2020-03-30 15:58:07’);

---

– Table structure for binglixinxi

---

DROP TABLE IF EXISTS binglixinxi;

CREATE TABLE binglixinxi (

id int(11) NOT NULL AUTO_INCREMENT,

zhanghao varchar(50) DEFAULT NULL,

xingming varchar(50) DEFAULT NULL,

shenfenzheng varchar(50) DEFAULT NULL,