8) Struts2 2 SpringMVC

/*
Navicat MySQL Data TransferSource Server : 新服务器
Source Server Version : 50173
Source Host : 123.57.10.10:3306
Source Database : testTarget Server Type : MYSQL
Target Server Version : 50173
File Encoding : 65001Date: 2016-07-29 13:49:43
*/SET FOREIGN_KEY_CHECKS=0;-- ----------------------------
-- Table structure for smse_access_permission
-- ----------------------------
DROP TABLE IF EXISTS `smse_access_permission`;
CREATE TABLE `smse_access_permission` (
`ID` varchar(36) NOT NULL,
`NAME` varchar(200) DEFAULT NULL,
`URL` varchar(200) DEFAULT NULL,
`MENU_ID` varchar(36) DEFAULT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;-- ----------------------------
-- Records of smse_access_permission
-- ----------------------------
INSERT INTO `smse_access_permission` VALUES ('21FAD71BFE994AA1E053433210AC638C', '用户新增数据保存', 'system/saveUserAdd.json', '21FAD71BFE974AA1E053433210AC638C');
INSERT INTO `smse_access_permission` VALUES ('21FAD71BFE9F4AA1E053433210AC638C', '用户删除', 'system/deleteUser.json', '21FAD71BFE9A4AA1E053433210AC638C');
INSERT INTO `smse_access_permission` VALUES ('21FAD71BFEA04AA1E053433210AC638C', '用户编辑页面数据保存', 'system/saveUserEdit.json', '21FAD71BFE9A4AA1E053433210AC638C');
INSERT INTO `smse_access_permission` VALUES ('21FAD71BFEA34AA1E053433210AC638C', '角色新增页面数据保存', 'system/saveRoleAdd.json', '21FAD71BFEA14AA1E053433210AC638C');
INSERT INTO `smse_access_permission` VALUES ('21FAD71BFEA94AA1E053433210AC638C', '角色编辑页面数据保存', 'system/saveRoleEdit.json', '21FAD71BFEA44AA1E053433210AC638C');
INSERT INTO `smse_access_permission` VALUES ('21FAD71BFEAA4AA1E053433210AC638C', '角色删除', 'system/deleteRole.json', '21FAD71BFEA44AA1E053433210AC638C');
INSERT INTO `smse_access_permission` VALUES ('75b1dd28-54b4-11e6-9619-00163e001b41', '菜单删除', 'system/deleteMenu.json', '21943DC037B643EDE053433210AC4939');
INSERT INTO `smse_access_permission` VALUES ('75b8f34c-54b4-11e6-9619-00163e001b41', '菜单信息保存', 'system/saveMenu.json', '21943DC037B643EDE053433210AC4939');-- ----------------------------
-- Table structure for smse_menu
-- ----------------------------
DROP TABLE IF EXISTS `smse_menu`;
CREATE TABLE `smse_menu` (
`ID` varchar(36) NOT NULL,
`NAME` varchar(200) DEFAULT NULL,
`URL` varchar(200) DEFAULT NULL,
`ICON` varchar(200) DEFAULT NULL,
`VISIBLE` varchar(200) DEFAULT NULL,
`PID` varchar(36) DEFAULT NULL,
`SORT` int(11) DEFAULT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;-- ----------------------------
-- Records of smse_menu
-- ----------------------------
INSERT INTO `smse_menu` VALUES ('21943DC037B443EDE053433210AC4939', '系统管理', '', '', '', '', '');
INSERT INTO `smse_menu` VALUES ('21943DC037B643EDE053433210AC4939', '菜单管理', 'system/initMenu.htm', '', '', '21943DC037B443EDE053433210AC4939', '');
INSERT INTO `smse_menu` VALUES ('21FAD71BFE954AA1E053433210AC638C', '用户管理', '', '', '', '21943DC037B443EDE053433210AC4939', '');
INSERT INTO `smse_menu` VALUES ('21FAD71BFE964AA1E053433210AC638C', '角色管理', '', '', '', '21943DC037B443EDE053433210AC4939', '');
INSERT INTO `smse_menu` VALUES ('21FAD71BFE974AA1E053433210AC638C', '用户新增', 'system/initUserAdd.htm', '', '', '21FAD71BFE954AA1E053433210AC638C', '');
INSERT INTO `smse_menu` VALUES ('21FAD71BFE9A4AA1E053433210AC638C', '用户列表', 'system/initUserList.htm', '', '', '21FAD71BFE954AA1E053433210AC638C', '');
INSERT INTO `smse_menu` VALUES ('21FAD71BFEA14AA1E053433210AC638C', '角色新增', 'system/initRoleAdd.htm', '', '', '21FAD71BFE964AA1E053433210AC638C', '');
INSERT INTO `smse_menu` VALUES ('21FAD71BFEA44AA1E053433210AC638C', '角色列表', 'system/initRoleList.htm', '', '', '21FAD71BFE964AA1E053433210AC638C', '');-- ----------------------------
-- Table structure for smse_role
-- ----------------------------
DROP TABLE IF EXISTS `smse_role`;
CREATE TABLE `smse_role` (
`ID` varchar(36) NOT NULL,
`NAME` varchar(200) DEFAULT NULL,
`ROLE` varchar(200) DEFAULT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;-- ----------------------------
-- Records of smse_role
-- ----------------------------
INSERT INTO `smse_role` VALUES ('21943DC037B343EDE053433210AC4939', '系统管理员', 'root');-- ----------------------------
-- Table structure for smse_role_menu_link
-- ----------------------------
DROP TABLE IF EXISTS `smse_role_menu_link`;
CREATE TABLE `smse_role_menu_link` (
`ROLE_ID` varchar(36) DEFAULT NULL,
`MENU_ID` varchar(36) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;-- ----------------------------
-- Records of smse_role_menu_link
-- ----------------------------
INSERT INTO `smse_role_menu_link` VALUES ('21943DC037B343EDE053433210AC4939', '21FAD71BFE964AA1E053433210AC638C');
INSERT INTO `smse_role_menu_link` VALUES ('21943DC037B343EDE053433210AC4939', '21943DC037B443EDE053433210AC4939');
INSERT INTO `smse_role_menu_link` VALUES ('21943DC037B343EDE053433210AC4939', '21FAD71BFE974AA1E053433210AC638C');
INSERT INTO `smse_role_menu_link` VALUES ('21943DC037B343EDE053433210AC4939', '21FAD71BFE9A4AA1E053433210AC638C');
INSERT INTO `smse_role_menu_link` VALUES ('21943DC037B343EDE053433210AC4939', '21943DC037B643EDE053433210AC4939');
INSERT INTO `smse_role_menu_link` VALUES ('21943DC037B343EDE053433210AC4939', '21FAD71BFE954AA1E053433210AC638C');
INSERT INTO `smse_role_menu_link` VALUES ('21943DC037B343EDE053433210AC4939', '21FAD71BFEA14AA1E053433210AC638C');
INSERT INTO `smse_role_menu_link` VALUES ('21943DC037B343EDE053433210AC4939', '21FAD71BFEA44AA1E053433210AC638C');
INSERT INTO `smse_role_menu_link` VALUES ('21943DC037B343EDE053433210AC4939', 'e0f4b6e0-53e3-11e6-9619-00163e001b41');
INSERT INTO `smse_role_menu_link` VALUES ('38950038-53cd-11e6-9619-00163e001b41', 'e0f4b6e0-53e3-11e6-9619-00163e001b41');-- ----------------------------
-- Table structure for smse_user
-- ----------------------------
DROP TABLE IF EXISTS `smse_user`;
CREATE TABLE `smse_user` (
`ID` varchar(36) NOT NULL,
`NAME` varchar(200) DEFAULT NULL,
`USERNAME` varchar(200) DEFAULT NULL,
`PASSWORD` varchar(200) DEFAULT NULL,
`MOBILE` varchar(200) DEFAULT NULL,
`EMAIL` varchar(200) DEFAULT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;-- ----------------------------
-- Records of smse_user
-- ----------------------------
INSERT INTO `smse_user` VALUES ('21943DC037B243EDE053433210AC4939', '大木桶', 'root', 'ff9830c42660c1dd1942844f8069b74a', '', '1007951312@qq.com');-- ----------------------------
-- Table structure for smse_user_role_link
-- ----------------------------
DROP TABLE IF EXISTS `smse_user_role_link`;
CREATE TABLE `smse_user_role_link` (
`USER_ID` varchar(36) DEFAULT NULL,
`ROLE_ID` varchar(36) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;-- ----------------------------
-- Records of smse_user_role_link
-- ----------------------------
INSERT INTO `smse_user_role_link` VALUES ('21943DC037B243EDE053433210AC4939', '21943DC037B343EDE053433210AC4939');
INSERT INTO `smse_user_role_link` VALUES ('21943DC037B243EDE053433210AC4939', '38950038-53cd-11e6-9619-00163e001b41');
INSERT INTO `smse_user_role_link` VALUES ('e6a35232-53ce-11e6-9619-00163e001b41', '38950038-53cd-11e6-9619-00163e001b41');