介绍:
spring,springmvc,mybatis,mysql,eclipse
截图:
数据库表:
CREATE TABLE account
(
id
int(11) NOT NULL AUTO_INCREMENT,
name
varchar(32) NOT NULL,
password
varchar(32) NOT NULL,
realName
varchar(32) DEFAULT NULL,
idCard
varchar(32) CHARACTER SET utf32 DEFAULT NULL,
mobile
varchar(16) DEFAULT NULL,
address
varchar(128) DEFAULT NULL,
status
int(1) DEFAULT ‘0’,
PRIMARY KEY (id
)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;
– Records of account
INSERT INTO account
VALUES (‘1’, ‘李四’, ‘123456’, ‘李四’, ‘62225225666552’, ‘13656565656’, ‘上海 浦东’, ‘0’);
INSERT INTO account
VALUES (‘2’, ‘张三’, ‘123’, ‘张三五’, ‘4622987745565656’, ‘13912233333’, ‘北京 三里屯 酒吧’, ‘0’);
INSERT INTO account
VALUES (‘3’, ‘李四1’, ‘123’, ‘李四1’, ‘6565656565656’, ‘13999999999’, ‘南京’, ‘0’);
INSERT INTO account
VALUES (‘4’, ‘王麻子’, ‘123’, ‘大刀王五’, ‘110110120121110110’, ‘13656565656’, ‘北京 朝阳区 群众’, ‘-1’);
INSERT INTO account
VALUES (‘5’, ‘小明’, ‘123456’, ‘张小明’, ‘31012002522555’, ‘13545455454’, ‘江苏 南京’, ‘0’);
INSERT INTO account
VALUES (‘6’, ‘xia’, ‘123456’, null, null, ‘17615042024’, null, ‘0’);
INSERT INTO account
VALUES (‘7’, ‘李胜’, ‘123456’, ‘李胜’, null, ‘17615042024’, null, ‘0’);
INSERT INTO account
VALUES (‘8’, ‘zhangmaowen’, ‘123456’, ‘张茂’, ‘3412223234780’, ‘17615042024’, ‘大连’, ‘0’);
– Table structure for authority
DROP TABLE IF EXISTS authority
;
CREATE TABLE authority
(
id
int(11) NOT NULL AUTO_INCREMENT,
roleId
int(11) NOT NULL,
menuId
int(11) NOT NULL,
PRIMARY KEY (id
),
KEY roleId
(roleId
),
KEY menuId
(menuId
),
CONSTRAINT authority_ibfk_1
FOREIGN KEY (roleId
) REFERENCES role
(id
),
CONSTRAINT authority_ibfk_2
FOREIGN KEY (menuId
) REFERENCES menu
(id
)
) ENGINE=InnoDB AUTO_INCREMENT=437 DEFAULT CHARSET=utf8;