Spring demo 2017-04-18

/* Navicat MySQL Data Transfer Source Server : localhos_lj Source Server Version : 50516 Source Host : localhost:3306 Source Database : hibernatedb Target Server Type : MYSQL Target Server Version : 50516 File Encoding : 65001 Date: 2017-04-18 21:06:15 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for `account` -- ---------------------------- DROP TABLE IF EXISTS `account`; CREATE TABLE `account` ( `username` varchar(255) DEFAULT NULL, `balance` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of account -- ---------------------------- INSERT INTO `account` VALUES ('admin', '9400'); -- ---------------------------- -- Table structure for `book` -- ---------------------------- DROP TABLE IF EXISTS `book`; CREATE TABLE `book` ( `isbn` varchar(255) DEFAULT NULL, `bookname` varchar(255) DEFAULT NULL, `price` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of book -- ---------------------------- INSERT INTO `book` VALUES ('1001', 'Java', '100'); INSERT INTO `book` VALUES ('1002', 'C#', '100'); INSERT INTO `book` VALUES ('1003', 'Oracle', '100'); -- ---------------------------- -- Table structure for `book_stock` -- ---------------------------- DROP TABLE IF EXISTS `book_stock`; CREATE TABLE `book_stock` ( `isbn` varchar(255) DEFAULT NULL, `stock` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of book_stock -- ---------------------------- INSERT INTO `book_stock` VALUES ('1001', '996'); INSERT INTO `book_stock` VALUES ('1002', '1982'); INSERT INTO `book_stock` VALUES ('1003', '282'); -- ---------------------------- -- Table structure for `roleinfo` -- ---------------------------- DROP TABLE IF EXISTS `roleinfo`; CREATE TABLE `roleinfo` ( `id` int(11) NOT NULL AUTO_INCREMENT, `roleDes` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of roleinfo -- ---------------------------- INSERT INTO `roleinfo` VALUES ('1', 'Normal'); INSERT INTO `roleinfo` VALUES ('2', 'Adminitor'); -- ---------------------------- -- Table structure for `userinfo` -- ---------------------------- DROP TABLE IF EXISTS `userinfo`; CREATE TABLE `userinfo` ( `id` int(11) NOT NULL AUTO_INCREMENT, `username` varchar(100) DEFAULT NULL, `password` varchar(100) DEFAULT NULL, `age` int(11) DEFAULT NULL, `email` varchar(50) DEFAULT NULL, `active` bit(1) DEFAULT NULL, `roleid` int(1) DEFAULT '1', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of userinfo -- ---------------------------- INSERT INTO `userinfo` VALUES ('15', 'admin', 'pwd_-1241773117', '18', 'adminitor@qq.com', '
', '1'); INSERT INTO `userinfo` VALUES ('16', 'adminitor', '6666666666', '18', '567567789@qq.com', '
', '1'); INSERT INTO `userinfo` VALUES ('17', 'lijian002', 'lijian11111111111', '18', 'adfasdf@qq.com', '
', '1'); INSERT INTO `userinfo` VALUES ('18', 'lijian001', 'lijian11111111111', '17', 'lijian001@qq.com', '
', '1'); INSERT INTO `userinfo` VALUES ('19', 'lijian002', 'lijian11111111111', '17', 'lijian002@qq.com', '
', '1'); INSERT INTO `userinfo` VALUES ('20', 'lijian003', 'lijian11111111111', '17', 'lijian003@qq.com', '
', '1'); INSERT INTO `userinfo` VALUES ('21', 'lijian004', 'lijian11111111111', '17', 'lijian004@qq.com', '
', '1'); INSERT INTO `userinfo` VALUES ('22', 'lijian005', 'lijian11111111111', '17', 'lijian005@qq.com', '
', '1'); INSERT INTO `userinfo` VALUES ('23', 'test0001', 'dddddddddd', '17', 'tes001@qq.com', '
', '1'); INSERT INTO `userinfo` VALUES ('24', 'user_335315929', 'dddddddddd', '17', 'user_335315929@qq.com', '
', '1'); INSERT INTO `userinfo` VALUES ('25', 'user_-643862084', 'dddddddddddd', '17', 'user_-643862084@qq.com', '
', '1');