/*
Navicat MySQL Data Transfer
Source Server : localhost
Source Server Version : 50157
Source Host : localhost:3306
Source Database : scaffold
Target Server Type : MYSQL
Target Server Version : 50157
File Encoding : 65001
Date: 2017-07-06 10:47:20
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `dept`
-- ----------------------------
DROP TABLE IF EXISTS `dept`;
CREATE TABLE `dept` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键id',
`num` int(11) DEFAULT NULL COMMENT '排序',
`pid` int(11) DEFAULT NULL COMMENT '父部门id',
`simplename` varchar(45) DEFAULT NULL COMMENT '简称',
`fullname` varchar(255) DEFAULT NULL COMMENT '全称',
`tips` varchar(255) DEFAULT NULL COMMENT '提示',
`version` int(11) DEFAULT NULL COMMENT '版本（乐观锁保留字段）',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=40 DEFAULT CHARSET=utf8 COMMENT='部门表';
-- ----------------------------
-- Records of dept
-- ----------------------------
INSERT INTO `dept` VALUES ('25', '2', '24', '开发部', '开发部', '', null);
INSERT INTO `dept` VALUES ('26', '3', '24', '运营部', '运营部', '', null);
INSERT INTO `dept` VALUES ('27', '4', '24', '战略部', '战略部', '', null);
INSERT INTO `dept` VALUES ('34', '5', '1', '测试', '测试fullname', '测试tips', '1');
INSERT INTO `dept` VALUES ('35', '5', '1', '测试', '测试fullname', '测试tips', '1');
INSERT INTO `dept` VALUES ('36', '5', '1', '测试', '测试fullname', '测试tips', '1');
INSERT INTO `dept` VALUES ('37', '5', '1', '测试', '测试fullname', '测试tips', '1');
INSERT INTO `dept` VALUES ('38', '5', '1', '测试', '测试fullname', '测试tips', '1');
INSERT INTO `dept` VALUES ('39', '5', '1', '测试', '测试fullname', '测试tips', '1');
-- ----------------------------
-- Table structure for `dict`
-- ----------------------------
DROP TABLE IF EXISTS `dict`;
CREATE TABLE `dict` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键id',
`num` int(11) DEFAULT NULL COMMENT '排序',
`pid` int(11) DEFAULT NULL COMMENT '父级字典',
`name` varchar(255) DEFAULT NULL COMMENT '名称',
`tips` varchar(255) DEFAULT NULL COMMENT '提示',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=54 DEFAULT CHARSET=utf8 COMMENT='字典表';
-- ----------------------------
-- Records of dict
-- ----------------------------
INSERT INTO `dict` VALUES ('29', '0', '0', '性别', null);
INSERT INTO `dict` VALUES ('30', '1', '29', '男', null);
INSERT INTO `dict` VALUES ('31', '2', '29', '女', null);
INSERT INTO `dict` VALUES ('35', '0', '0', '账号状态', null);
INSERT INTO `dict` VALUES ('36', '1', '35', '启用', null);
INSERT INTO `dict` VALUES ('37', '2', '35', '冻结', null);
INSERT INTO `dict` VALUES ('38', '3', '35', '已删除', null);
INSERT INTO `dict` VALUES ('39', '0', '0', '这是一个字典测试', null);
INSERT INTO `dict` VALUES ('40', '1', '39', '测试1', null);
INSERT INTO `dict` VALUES ('41', '2', '39', '测试2', null);
INSERT INTO `dict` VALUES ('42', '0', '0', '测试', null);
INSERT INTO `dict` VALUES ('43', '1', '42', '测试1', null);
INSERT INTO `dict` VALUES ('44', '2', '42', '测试2', null);
INSERT INTO `dict` VALUES ('49', '0', '0', '推送方式', null);
INSERT INTO `dict` VALUES ('50', '0', '49', '全局', null);
INSERT INTO `dict` VALUES ('51', '1', '49', '安卓', null);
INSERT INTO `dict` VALUES ('52', '2', '49', 'ios', null);
INSERT INTO `dict` VALUES ('53', '3', '49', 'wp', null);
-- ----------------------------
-- Table structure for `e_driving`
-- ----------------------------
DROP TABLE IF EXISTS `e_driving`;
CREATE TABLE `e_driving` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
`title` varchar(255) DEFAULT NULL COMMENT '标题',
`type` int(11) DEFAULT NULL COMMENT '类型',
`content` text COMMENT '内容',
`createtime` datetime DEFAULT NULL COMMENT '创建时间',
`creater` int(11) DEFAULT NULL COMMENT '创建人',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='e代驾表';
-- ----------------------------
-- Records of e_driving
-- ----------------------------
INSERT INTO `e_driving` VALUES ('13', '22', '22', '222大丰收2', '2017-07-03 14:24:46', null);
INSERT INTO `e_driving` VALUES ('14', '标题3', null, '内容33', '2017-07-04 11:38:12', '1');
INSERT INTO `e_driving` VALUES ('16', '标题11', null, '内容1防守打法dfdsf1', '2017-07-04 15:29:39', '1');
INSERT INTO `e_driving` VALUES ('20', '标题4', null, '内容44', null, null);
INSERT INTO `e_driving` VALUES ('25', '6', null, '666', null, null);
-- ----------------------------
-- Table structure for `login_log`
-- ----------------------------
DROP TABLE IF EXISTS `login_log`;
CREATE TABLE `login_log` (
`id` int(65) NOT NULL AUTO_INCREMENT COMMENT '主键',
`logname` varchar(255) DEFAULT NULL COMMENT '日志名称',
`userid` int(65) DEFAULT NULL COMMENT '管理员id',
`createtime` datetime DEFAULT NULL COMMENT '创建时间',
`succeed` varchar(255) DEFAULT NULL COMMENT '是否执行成功',
`message` text COMMENT '具体消息',
`ip` varchar(255) DEFAULT NULL COMMENT '登录ip',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=169 DEFAULT CHARSET=utf8 COMMENT='登录记录';
-- ----------------------------
-- Records of login_log
-- ----------------------------
INSERT INTO `login_log` VALUES ('126', '退出日志', '1', '2017-06-04 10:21:55', '成功', null, '127.0.0.1');
INSERT INTO `login_log` VALUES ('127', '登录日志', '1', '2017-06-04 10:21:59', '成功', null, '127.0.0.1');
INSERT INTO `login_log` VALUES ('128', '退出日志', '1', '2017-06-04 10:22:59', '成功', null, '127.0.0.1');
INSERT INTO `login_log` VALUES ('129', '登录日志', '1', '2017-06-04 10:23:01', '成功', null, '127.0.0.1');
INSERT INTO `login_log` VALUES ('130', '登录日志', '1', '2017-06-30 13:57:39', '成功', null, '0:0:0:0:0:0:0:1');
INSERT INTO `login_log` VALUES ('131', '退出日志', '1', '2017-06-30 14:06:53', '成功', null, '0:0:0:0:0:0:0:1');
INSERT INTO `login_log` VALUES ('132', '登录日志', '45', '2017-06-30 14:06:56', '成功', null, '0:0:0:0:0:0:0:1');
INSERT INTO `login_log` VALUES ('133', '退出日志', '45', '2017-06-30 14:08:58', '成功', null, '0:0:0:0:0:0:0:1');
INSERT INTO `login_log` VALUES ('134', '登录日志', '1', '2017-06-30 14:09:01', '成功', null, '0:0:0:0:0:0:0:1');
INSERT INTO `login_log` VALUES ('135', '退出日志', '1', '2017-06-30 14:13:02', '成功', null, '0:0:0:0:0:0:0:1');
INSERT INTO `login_log` VALUES ('136', '登录日志', '1', '2017-06-30 14:13:07', '成功', null, '0:0:0:0:0:0:0:1');
INSERT INTO `login_log` VALUES ('137', '退出日志', '1', '2017-06-30 14:14:18', '成功', null, '0:0:0:0:0:0:0:1');
INSERT INTO `login_log` VALUES ('138', '登录日志', '45', '2017-06-30 14:14:21', '成功', null, '0:0:0:0:0:0:0:1');
INSERT INTO `login_log` VALUES ('139', '退出日志', '45', '2017-06-30 14:14:52', '成功', null, '0:0:0:0:0:0:0:1');
INSERT INTO `login_log` VALUES ('140', '登录日志', '1', '2017-06-30 14:14:55', '成功', null, '0:0:0:0:0:0:0:1');
INSERT INTO `login_log` VALUES ('141', '退出日志', '1', '2017-06-30 14:46:20', '成功', null, '0:0:0:0:0:0:0:1');
INSERT INTO `login_log` VALUES ('142', '登录日志', '1', '2017-06-30 14:46:47', '成功', null, '0:0:0:0:0:0:0:1');
INSERT INTO `login_log` VALUES ('143', '退出日志', '1', '2017-07-03 13:40:52', '成功', null, '0:0:0:0:0:0:0:1');
INSERT INTO `login_log` VALUES ('144', '登录日志', '1', '2017-07-03 13:40:54', '成功', null, '0:0:0:0:0:0:0:1');
INSERT INTO `login_log` VALUES ('145', '退出日志', '1', '2017-07-03 13:44:40', '成功', null, '0:0:0:0:0:0:0:1');
INSERT INTO `login_log` VALUES ('146', '登录日志', '46', '2017-07-03 13:44:43', '成功', null, '0:0:0:0:0:0:0:1');
INSERT INTO `login_log` VALUES ('147', '退出日志', '46', '2017-07-03 13:45:07', '成功', null, '0:0:0:0:0:0:0:1');
INSERT INTO `login_log` VALUES ('148', '登录日志', '1', '2017-07-03 13:45:11', '成功', null, '0:0:0:0:0:0:0:1');
INSERT INTO `login_log` VALUES ('149', '退出日志', '1', '2017-07-03 14:08:20', '成功', null, '0:0:0:0:0:0:0:1');
INSERT INTO `login_log` VALUES ('150', '登录日志', '1', '2017-07-03 14:08:22', '成功', null, '0:0:0:0:0:0:0:1');
INSERT INTO `login_log` VALUES ('151', '退出日志', '1', '2017-07-03 16:58:45', '成功', null, '0:0:0:0:0:0:0:1');
INSERT INTO `login_log` VALUES ('152', '登录日志', '1', '2017-07-03 16:58:48', '成功', null, '0:0:0:0:0:0:0:1');
INSERT INTO `login_log` VALUES ('153', '退出日志', '1', '2017-07-04 16:42:11', '成功', null, '0:0:0:0:0:0:0:1');
INSERT INTO `login_log` VALUES ('154', '登录日志', '46', '2017-07-04 16:42:16', '成功', null, '0:0:0:0:0:0:0:1');
INSERT INTO `login_log` VALUES ('155', '退出日志', '46', '2017-07-04 16:43:06', '成功', null, '0:0:0:0:0:0:0:1');
INSERT INTO `login_log` VALUES ('156', '登录日志', '45', '2017-07-04 16:43:10', '成功', null, '0:0:0:0:0:0:0:1');
INSERT INTO `login_log` VALUES ('157', '退出日志', '45', '2017-07-04 16:43:22', '成功', null, '0:0:0:0:0:0:0:1');
INSERT INTO `login_log` VALUES ('158', '登录日志', '1', '2017-07-04 16:43:24', '成功', null, '0:0:0:0:0:0:0:1');
INSERT INTO `login_log` VALUES ('159', '退出日志', '1', '2017-07-04 16:44:26', '成功', null, '0:0:0:0:0:0:0:1');
INSERT INTO `login_log` VALUES ('160', '登录失败日志', null, '2017-07-04 16:44:35', '成功', '账号:test,账号密码错误', '0:0:0:0:0:0:0:1');
INSERT INTO `login_log` VALUES ('161', '登录失败日志', null, '2017-07-04 16:44:41', '成功', '账号:test,账号密码错误', '0:0:0:0:0:0:0:1');
INSERT INTO `login_log` VALUES ('162', '登录日志', '1', '2017-07-04 16:44:48', '成功', null, '0:0:0:0:0:0:0:1');
INSERT INTO `login_log` VALUES ('163', '退出日志', '1', '2017-07-04 16:45:19', '成功', null, '0:0:0:0:0:0:0:1');
INSERT INTO `login_log` VALUES ('164', '登录日志', '44', '2017-07-04 16:45:24', '成功', null, '0:0:0:0:0:0:0:1');
INSERT INTO `login_log` VALUES ('165', '退出日志', '44', '2017-07-04 16:45:35', '成功', null, '0:0:0:0:0:0:0:1');
INSERT INTO `login_log` VALUES ('166', '登录日志', '45', '2017-07-04 16:45:39', '成功', null, '0:0:0:0:0:0:0:1');
INSERT INTO `login_log` VALUES ('167', '退出日志', '45', '2017-07-04 16:45:49', '成功', null, '0:0:0:0:0:0:0:1');
INSERT INTO `login_log` VALUES ('168', '登录日志', '1', '2017-07-04 16:45:51', '成功', null, '0:0:0:0:0:0:0:1');
-- ----------------------------
-- Table structure for `menu`
-- ----------------------------
DROP TABLE IF EXISTS `menu`;
CREATE TABLE `menu` (
`id` int(65) NOT NULL AUTO_INCREMENT COMMENT '主键id',
`code` varchar(255) DEFAULT NULL COMMENT '菜单编号',
`pcode` varchar(255) DEFAULT NULL COMMENT '菜单父编号',
`pcodes` varchar(255) DEFAULT NULL COMMENT '当前菜单的所有父菜单编号',
`name` varchar(255) DEFAULT NULL COMMENT '菜单名称',
`icon` varchar(255) DEFAULT NULL COMMENT '菜单图标',
`url` varchar(255) DEFAULT NULL COMMENT 'url地址',
`num` int(65) DEFAULT NULL COMMENT '菜单排序号',
`levels` int(65) DEFAULT NULL COMMENT '菜单层级',
`ismenu` int(11) DEFAULT NULL COMMENT '是否是菜单（1：是 0：不是）',
`tips` varchar(255) DEFAULT NULL COMMENT '备注',
`status` int(65) DEFAULT NULL COMMENT '菜单状态 : 1:启用 0:不启用',
`isopen` int(11) DEFAULT NULL COMMENT '是否打开: 1:打开 0:不打开',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=172 DEFAULT CHARSET=utf8 COMMENT='菜单表';
-- ----------------------------
-- Records of menu
-- ----------------------------
INSERT INTO `menu` VALUES ('105', 'system', '0', '[0],', '系统管理', 'fa-user', '', '3', '1', '1', null, '1', '1');
INSERT INTO `menu` VALUES ('106', 'mgr', 'system', '[0],[system],', '用户管理', '', '/mgr', '1', '2', '1', null, '1', '0');
INSERT INTO `menu` VALUES ('107', 'mgr_add', 'mgr', '[0],[system],[mgr],', '添加用户', null, '/mgr/add', '1', '3', '0', null, '1', '0');
INSERT INTO `menu` VALUES ('108', 'mgr_edit', 'mgr', '[0],[system],[mgr],', '修改用户', null, '/mgr/edit', '2', '3', '0', null, '1', '0');
INSERT INTO `menu` VALUES ('109', 'mgr_delete', 'mgr', '[0],[system],[mgr],', '删除用户', null, '/mgr/delete', '3', '3', '0', null, '1', '0');
INSERT INTO `menu` VALUES ('110', 'mgr_reset', 'mgr', '[0],[system],[mgr],', '重置密码', null, '/mgr/reset', '4', '3', '0', null, '1', '0');
INSERT INTO `menu` VALUES ('111', 'mgr_freeze', 'mgr', '[0],[system],[mgr],', '冻结用户', null, '/mgr/freeze', '5', '3', '0', null, '1', '0');
INSERT INTO `menu` VALUES ('112', 'mgr_unfreeze', 'mgr', '[0],[system],[mgr],', '解除冻结用户', null, '/mgr/unfreeze', '6', '3', '0', null, '1', '0');
INSERT INTO `menu` VALUES ('113', 'mgr_setRole', 'mgr', '[0],[system],[mgr],', '分配角色', null, '/mgr/setRole', '7', '3', '0', null, '1', '0');
INSERT INTO `menu` VALUES ('114', 'role', 'system', '[0],[system],', '角色管理', null, '/role', '2', '2', '1', null, '1', '0');
INSERT INTO `menu` VALUES ('115', 'role_add', 'role', '[0],[system],[role],', '添加角色', null, '/role/add', '1', '3', '0', null, '1', '0');
INSERT INTO `menu` VALUES ('116', 'role_edit', 'role', '[0],[system],[role],', '修改角色', null, '/role/edit', '2', '3', '0', null, '1', '0');
INSERT INTO `menu` VALUES ('117', 'role_remove', 'role', '[0],[system],[role],', '删除角色', null, '/role/remove', '3', '3', '0', null, '1', '0');
INSERT INTO `menu` VALUES ('118', 'role_setAuthority', 'role', '[0],[system],[role],', '配置权限', null, '/role/setAuthority', '4', '3', '0', null, '1', '0');
INSERT INTO `menu` VALUES ('119', 'menu', 'system', '[0],[system],', '菜单管理', null, '/menu', '4', '2', '1', null, '1', '0');
INSERT INTO `menu` VALUES ('120', 'menu_add', 'menu', '[0],[system],[menu],', '添加菜单', null, '/menu/add', '1', '3', '0', null, '1', '0');
INSERT INTO `menu` VALUES ('121', 'menu_edit', 'menu', '[0],[system],[menu],', '修改菜单', null, '/menu/edit', '2', '3', '0', null, '1', '0');
INSERT INTO `menu` VALUES ('122', 'menu_remove', 'menu', '[0],[system],[menu],', '删除菜单', null, '/menu/remove', '3', '3', '0', null, '1', '0');
INSERT INTO `menu` VALUES ('128', 'log', 'system', '[0],[system],', '业务日志', null, '/log', '6', '2', '1', null, '1', '0');
INSERT INTO `menu` VALUES ('130', 'druid', 'system', '[0],[system],', '监控管理', null, '/druid', '7', '2', '1', null, '1', null);
INSERT INTO `menu` VALUES ('131', 'dept', 'system', '[0],[system],', '部门管理', null, '/dept', '3', '2', '1', null, '1', null);
INSERT INTO `menu` VALUES ('132', 'dict', 'system', '[0],[system],', '字典管理', null, '/dict', '4', '2', '1', null, '1', null);
INSERT INTO `menu` VALUES ('133', 'loginLog', 'system', '[0],[system],', '登录日志', null, '/loginLog', '6', '2', '1', null, '1', null);
INSERT INTO `menu` VALUES ('134', 'log_clean', 'log', '[0],[system],[log],', '清空日志', null, '/log/delLog', '3', '3', '0', null, '1', null);
INSERT INTO `menu` VALUES ('135', 'dept_add', 'dept', '[0],[system],[dept],', '添加部门', null, '/dept/add', '1', '3', '0', null, '1', null);
INSERT INTO `menu` VALUES ('136', 'dept_update', 'dept', '[0],[system],[dept],', '修改部门', null, '/dept/update', '1', '3', '0', null, '1', null);
INSERT INTO `menu` VALUES ('137', 'dept_delete', 'dept', '[0],[system],[dept],', '删除部门', null, '/dept/delete', '1', '3', '0', null, '1', null);
INSERT INTO `menu` VALUES ('138', 'dict_add', 'dict', '[0],[system],[dict],', '添加字典', null, '/dict/add', '1', '3', '0', null, '1', null);
INSERT INTO `menu` VALUES ('139', 'dict_update', 'dict', '[0],[system],[dict],', '修改字典', null, '/dict/update', '1', '3', '0', null, '1', null);
INSERT INTO `menu` VALUES ('140', 'dict_delete', 'dict', '[0],[system],[dict],', '删除字典', null, '/dict/delete', '1', '3', '0', null, '1', null);
INSERT INTO `menu` VALUES ('141', 'notice', 'system', '[0],[system],', '通知管理', null, '/notice', '9', '2', '1', null, '1', null);
INSERT INTO `menu` VALUES ('142', 'notice_add', 'notice', '[0],[system],[notice],', '添加通知', null, '/notice/add', '1', '3', '0', null, '1', null);
INSERT INTO `menu` VALUES ('143', 'notice_update', 'notice', '[0],[system],[notice],', '修改通知', null, '/notice/update', '2', '3', '0', null, '1', null);
INSERT INTO `menu` VALUES ('144', 'notice_delete', 'notice', '[0],[system],[notice],', '删除通知', null, '/notice/delete', '3', '3', '0', null, '1', null);
INSERT INTO `menu` VALUES ('145', 'hello', '0', '[0],', '通知', 'fa-rocket', '/notice/hello', '1', '1', '1', null, '1', null);
INSERT INTO `menu` VALUES ('148', 'code', 'system', '[0],[system],', '代码生成', 'fa-user', '/code', '10', '2', '1', null, '1', null);
INSERT INTO `menu` VALUES ('149', 'api_mgr', '0', '[0],', '接口文档', 'fa-leaf', '/swagger-ui.html', '2', '1', '1', null, '1', null);
INSERT INTO `menu` VALUES ('150', 'to_menu_edit', 'menu', '[0],[system],[menu],', '菜单编辑跳转', '', '/menu/menu_edit', '4', '3', '0', null, '1', null);
INSERT INTO `menu` VALUES ('151', 'menu_list', 'menu', '[0],[system],[menu],', '菜单列表', '', '/menu/list', '5', '3', '0', null, '1', null);
INSERT INTO `menu` VALUES ('152', 'to_dept_update', 'dept', '[0],[system],[dept],', '修改部门跳转', '', '/dept/dept_update', '4', '3', '0', null, '1', null);
INSERT INTO `menu` VALUES ('153', 'dept_list', 'dept', '[0],[system],[dept],', '部门列表', '', '/dept/list', '5', '3', '0', null, '1', null);
INSERT INTO `menu` VALUES ('154', 'dept_detail', 'dept', '[0],[system],[dept],', '部门详情', '', '/dept/detail', '6', '3', '0', null, '1', null);
INSERT INTO `menu` VALUES ('155', 'to_dict_edit', 'dict', '[0],[system],[dict],', '修改菜单跳转', '', '/dict/dict_edit', '4', '3', '0', null, '1', null);
INSERT INTO `menu` VALUES ('156', 'dict_list', 'dict', '[0],[system],[dict],', '字典列表', '', '/dict/list', '5', '3', '0', null, '1', null);
INSERT INTO `menu` VALUES ('157', 'dict_detail', 'dict', '[0],[system],[dict],', '字典详情', '', '/dict/detail', '6', '3', '0', null, '1', null);
INSERT INTO `menu` VALUES ('158', 'log_list', 'log', '[0],[system],[log],', '日志列表', '', '/log/list', '2', '3', '0', null, '1', null);
INSERT INTO `menu` VALUES ('159', 'log_detail', 'log', '[0],[system],[log],', '日志详情', '', '/log/detail', '3', '3', '0', null, '1', null);
INSERT INTO `menu` VALUES ('160', 'del_login_log', 'loginLog', '[0],[system],[loginLog],', '清空登录日志', '', '/loginLog/delLoginLog', '1', '3', '0', null, '1', null);
INSERT INTO `menu` VALUES ('161', 'login_log_list', 'loginLog', '[0],[system],[loginLog],', '登录日志列表', '', '/loginLog/list', '2', '3', '0', null, '1', null);
INSERT INTO `menu` VALUES ('162', 'to_role_edit', 'role', '[0],[system],[role],', '修改角色跳转', '', '/role/role_edit', '5', '3', '0', null, '1', null);
INSERT INTO `menu` VALUES ('163', 'to_role_assign', 'role', '[0],[system],[role],', '角色分配跳转', '', '/role/role_assign', '6', '3', '0', null, '1', null);
INSERT INTO `menu` VALUES ('164', 'role_list', 'role', '[0],[system],[role],', '角色列表', '', '/role/list', '7', '3', '0', null, '1', null);
INSERT INTO `menu` VALUES ('165', 'to_assign_role', 'mgr', '[0],[system],[mgr],', '分配角色跳转', '', '/mgr/role_assign', '8', '3', '0', null, '1', null);
INSERT INTO `menu` VALUES ('166', 'to_user_edit', 'mgr', '[0],[system],[mgr],', '编辑用户跳转', '', '/mgr/user_edit', '9', '3', '0', null, '1', null);
INSERT INTO `menu` VALUES ('167', 'mgr_list', 'mgr', '[0],[system],[mgr],', '用户列表', '', '/mgr/list', '10', '3', '0', null, '1', null);
INSERT INTO `menu` VALUES ('168', 'eDriving', '0', null, 'e代驾管理', '', '/eDriving', '1', '1', '1', null, '1', null);
INSERT INTO `menu` VALUES ('169', 'eDriving_add', 'eDriving', 'null[eDriving],', 'e代驾-新增按钮', '', '/eDriving/add', '1', '2', '0', null, '1', null);
INSERT INTO `menu` VALUES ('170', 'eDriving_update', 'eDriving', 'null[eDriving],', 'e代驾-修改按钮', '', '/eDriving/update', '2', '2', '0', null, '1', null);
INSERT INTO `menu` VALUES ('171', 'eDriving_delete', 'eDriving', 'null[eDriving],', 'e代驾-删除按钮', '', '/eDriving/delete', '3', '2', '0', null, '1', null);
-- ----------------------------
-- Table structure for `notice`
-- ----------------------------
DROP TABLE IF EXISTS `notice`;
CREATE TABLE `notice` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
`title` varchar(255) DEFAULT NULL COMMENT '标题',
`type` int(11) DEFAULT NULL COMMENT '类型',
`content` text COMMENT '内容',
`createtime` datetime DEFAULT NULL COMMENT '创建时间',
`creater` int(11) DEFAULT NULL COMMENT '创建人',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 COMMENT='通知表';
-- ----------------------------
-- Records of notice
-- ----------------------------
INSERT INTO `notice` VALUES ('6', '世界', '10', '欢迎使用 Scaffold 管理系统', '2017-01-11 08:53:20', '1');
INSERT INTO `notice` VALUES ('8', '你好', null, '你好', '2017-05-10 19:28:57', '1');
INSERT INTO `notice` VALUES ('11', 'hello all', null, '请按时做面，谢谢！！！', '2017-06-30 14:05:25', '1');
-- ----------------------------
-- Table structure for `operation_log`
-- ----------------------------
DROP TABLE IF EXISTS `operation_log`;
CREATE TABLE `operation_log` (
`id` int(65) NOT NULL AUTO_INCREMENT COMMENT '主键',
`logtype` varchar(255) DEFAULT NULL COMMENT '日志类型',
`logname` varchar(255) DEFAULT NULL COMMENT '日志名称',
`userid` int(65) DEFAULT NULL COMMENT '用户id',
`classname` varchar(255) DEFAULT NULL COMMENT '类名称',
`method` text COMMENT '方法名称',
`createtime` datetime DEFAULT NULL COMMENT '创建时间',
`succeed` varchar(255) DEFAULT NULL COMMENT '是否成功',
`message` text COMMENT '备注',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=572 DEFAULT CHARSET=utf8 COMMENT='操作日志';
-- ----------------------------
-- Records of operation_log
-- ----------------------------
INSERT INTO `operation_log` VALUES ('521', '业务日志', '清空业务日志', '1', 'com.gaowh. scaffold.modular.system.controller.LogController', 'delLog', '2017-06-30 17:56:05', '成功', '主键id=null');
INSERT INTO `operation_log` VALUES ('522', '业务日志', '修改菜单', '1', 'com.gaowh. scaffold.modular.system.controller.MenuController', 'edit', '2017-07-03 12:12:51', '成功', '菜单名称=e代驾管理;;;字段名称:菜单名称,旧值:订单管理,新值:e代驾管理;;;字段名称:url地址,旧值:/dict,新值:/eDriving');
INSERT INTO `operation_log` VALUES ('523', '业务日志', '添加管理员', '1', 'com.gaowh. scaffold.modular.system.controller.UserMgrController', 'add', '2017-07-03 13:44:18', '成功', '账号=aaa');
INSERT INTO `operation_log` VALUES ('524', '业务日志', '分配角色', '1', 'com.gaowh. scaffold.modular.system.controller.UserMgrController', 'setRole', '2017-07-03 13:44:29', '成功', '账号=aaa,角色名称集合=临时');
INSERT INTO `operation_log` VALUES ('525', '业务日志', '修改管理员', '1', 'com.gaowh. scaffold.modular.system.controller.UserMgrController', 'edit', '2017-07-03 14:08:10', '成功', '账号=admin;;;字段名称:性别,旧值:女,新值:男');
INSERT INTO `operation_log` VALUES ('526', '业务日志', '修改通知', '1', 'com.gaowh. scaffold.modular.system.controller.NoticeController', 'update', '2017-07-03 14:44:41', '成功', '标题=hello all;;;字段名称:内容,旧值:请按时做面，谢谢！,新值:请按时做面，谢谢！！！');
INSERT INTO `operation_log` VALUES ('527', '业务日志', '修改通知', '1', 'com.gaowh. scaffold.modular.system.controller.NoticeController', 'update', '2017-07-03 14:44:51', '成功', '标题=hello all;;;');
INSERT INTO `operation_log` VALUES ('528', '业务日志', '新增通知', '1', 'com.gaowh. scaffold.modular.system.controller.NoticeController', 'add', '2017-07-03 14:44:56', '成功', '标题=22');
INSERT INTO `operation_log` VALUES ('529', '业务日志', '删除通知', '1', 'com.gaowh. scaffold.modular.system.controller.NoticeController', 'delete', '2017-07-03 14:45:10', '成功', '标题=22');
INSERT INTO `operation_log` VALUES ('530', '业务日志', '修改角色', '1', 'com.gaowh. scaffold.modular.system.controller.RoleController', 'edit', '2017-07-03 14:45:30', '成功', '角色名称=临时;;;字段名称:角色排序,旧值:2,新值:3');
INSERT INTO `operation_log` VALUES ('531', '业务日志', '修改角色', '1', 'com.gaowh. scaffold.modular.system.controller.RoleController', 'edit', '2017-07-03 14:45:37', '成功', '角色名称=城管;;;');
INSERT INTO `operation_log` VALUES ('532', '业务日志', '修改菜单', '1', 'com.gaowh. scaffold.modular.system.controller.MenuController', 'edit', '2017-07-03 16:01:28', '成功', '菜单名称=e代驾管理;;;字段名称:菜单编号,旧值:1,新值:eDriving');
INSERT INTO `operation_log` VALUES ('533', '业务日志', '配置权限', '1', 'com.gaowh. scaffold.modular.system.controller.RoleController', 'setAuthority', '2017-07-03 16:08:06', '成功', '角色名称=超级管理员,资源名称=系统管理,用户管理,添加用户,修改用户,删除用户,重置密码,冻结用户,解除冻结用户,分配角色,分配角色跳转,编辑用户跳转,用户列表,角色管理,添加角色,修改角色,删除角色,配置权限,修改角色跳转,角色分配跳转,角色列表,菜单管理,添加菜单,修改菜单,删除菜单,菜单编辑跳转,菜单列表,业务日志,清空日志,日志列表,日志详情,监控管理,部门管理,添加部门,修改部门,删除部门,修改部门跳转,部门列表,部门详情,字典管理,添加字典,修改字典,删除字典,修改菜单跳转,字典列表,字典详情,登录日志,清空登录日志,登录日志列表,通知管理,添加通知,修改通知,删除通知,代码生成,通知,接口文档,e代驾管理');
INSERT INTO `operation_log` VALUES ('534', '业务日志', '菜单新增', '1', 'com.gaowh. scaffold.modular.system.controller.MenuController', 'add', '2017-07-03 16:56:01', '成功', '菜单名称=e代驾-新增按钮');
INSERT INTO `operation_log` VALUES ('535', '业务日志', '修改菜单', '1', 'com.gaowh. scaffold.modular.system.controller.MenuController', 'edit', '2017-07-03 16:56:35', '成功', '菜单名称=e代驾-新增按钮;;;字段名称:菜单编号,旧值:1,新值:eDriving_add');
INSERT INTO `operation_log` VALUES ('536', '业务日志', '菜单新增', '1', 'com.gaowh. scaffold.modular.system.controller.MenuController', 'add', '2017-07-03 16:57:53', '成功', '菜单名称=e代驾-修改按钮');
INSERT INTO `operation_log` VALUES ('537', '业务日志', '菜单新增', '1', 'com.gaowh. scaffold.modular.system.controller.MenuController', 'add', '2017-07-03 16:58:18', '成功', '菜单名称=e代驾-删除按钮');
INSERT INTO `operation_log` VALUES ('538', '业务日志', '配置权限', '1', 'com.gaowh. scaffold.modular.system.controller.RoleController', 'setAuthority', '2017-07-03 16:58:39', '成功', '角色名称=超级管理员,资源名称=系统管理,用户管理,添加用户,修改用户,删除用户,重置密码,冻结用户,解除冻结用户,分配角色,分配角色跳转,编辑用户跳转,用户列表,角色管理,添加角色,修改角色,删除角色,配置权限,修改角色跳转,角色分配跳转,角色列表,菜单管理,添加菜单,修改菜单,删除菜单,菜单编辑跳转,菜单列表,业务日志,清空日志,日志列表,日志详情,监控管理,部门管理,添加部门,修改部门,删除部门,修改部门跳转,部门列表,部门详情,字典管理,添加字典,修改字典,删除字典,修改菜单跳转,字典列表,字典详情,登录日志,清空登录日志,登录日志列表,通知管理,添加通知,修改通知,删除通知,代码生成,通知,接口文档,e代驾管理,e代驾-新增按钮,e代驾-修改按钮,e代驾-删除按钮');
INSERT INTO `operation_log` VALUES ('539', '业务日志', '删除e代驾', '1', 'com.gaowh. scaffold.modular.eDriving.controller.EDrivingController', 'delete', '2017-07-04 11:16:17', '成功', 'null=12');
INSERT INTO `operation_log` VALUES ('540', '异常日志', '', '1', null, null, '2017-07-04 11:36:31', '失败', 'com.gaowh. scaffold.common.exception.BussinessException: 请求有错误\r\n at com.gaowh. scaffold.modular.eDriving.controller.EDrivingController.add(EDrivingController.java:98)\r\n at com.gaowh. scaffold.modular.eDriving.controller.EDrivingControllerTTFastClassBySpringCGLIBTTaeaaa191.invoke()\r\n at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)\r\n at org.springframework.aop.framework.CglibAopProxyTCglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:738)\r\n at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)\r\n at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:85)\r\n at com.gaowh. scaffold.core.intercept.SessionInterceptor.sessionKit(SessionInterceptor.java:31)\r\n at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\r\n at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)\r\n at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\r\n at java.lang.reflect.Method.invoke(Method.java:483)\r\n at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:629)\r\n at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:618)\r\n at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:70)\r\n at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)\r\n at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:85)\r\n at com.gaowh. scaffold.core.aop.PermissionAop.doPermission(PermissionAop.java:52)\r\n at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\r\n at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)\r\n at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\r\n at java.lang.reflect.Method.invoke(Method.java:483)\r\n at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:629)\r\n at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:618)\r\n at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:70)\r\n at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:168)\r\n at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:85)\r\n at com.gaowh. scaffold.core.aop.LogAop.recordSysLog(LogAop.java:45)\r\n at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\r\n at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)\r\n at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\r\n at java.lang.reflect.Method.invoke(Method.java:483)\r\n at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:629)\r\n at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:618)\r\n at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:70)\r\n at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:168)\r\n at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)\r\n at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)\r\n at org.springframework.aop.framework.CglibAopProxyTDynamicAdvisedInterceptor.intercept(CglibAopProxy.java:673)\r\n at com.gaowh. scaffold.modular.eDriving.controller.EDrivingControllerTTEnhancerBySpringCGLIBTT50d1e6cd.add()\r\n at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\r\n at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)\r\n at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\r\n at java.lang.reflect.Method.invoke(Method.java:483)\r\n at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)\r\n at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:133)\r\n at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:97)\r\n at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:827)\r\n at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:738)\r\n at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)\r\n at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:963)\r\n at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:897)\r\n at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970)\r\n at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:872)\r\n at javax.servlet.http.HttpServlet.service(HttpServlet.java:661)\r\n at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)\r\n at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:61)\r\n at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108)\r\n at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137)\r\n at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)\r\n at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66)\r\n at org.apache.shiro.web.servlet.AbstractShiroFilter.executeChain(AbstractShiroFilter.java:449)\r\n at org.apache.shiro.web.servlet.AbstractShiroFilterT1.call(AbstractShiroFilter.java:365)\r\n at org.apache.shiro.subject.support.SubjectCallable.doCall(SubjectCallable.java:90)\r\n at org.apache.shiro.subject.support.SubjectCallable.call(SubjectCallable.java:83)\r\n at org.apache.shiro.subject.support.DelegatingSubject.execute(DelegatingSubject.java:387)\r\n at org.apache.shiro.web.servlet.AbstractShiroFilter.doFilterInternal(AbstractShiroFilter.java:362)\r\n at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n at com.gaowh. scaffold.core.util.xss.XssFilter.doFilter(XssFilter.java:22)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n at com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:123)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99)\r\n at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n at org.springframework.web.filter.HttpPutFormContentFilter.doFilterInternal(HttpPutFormContentFilter.java:105)\r\n at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:81)\r\n at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:197)\r\n at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198)\r\n at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)\r\n at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:478)\r\n at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)\r\n at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:80)\r\n at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)\r\n at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)\r\n at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:799)\r\n at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)\r\n at org.apache.coyote.AbstractProtocolTConnectionHandler.process(AbstractProtocol.java:861)\r\n at org.apache.tomcat.util.net.NioEndpointTSocketProcessor.doRun(NioEndpoint.java:1455)\r\n at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)\r\n at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)\r\n at java.util.concurrent.ThreadPoolExecutorTWorker.run(ThreadPoolExecutor.java:617)\r\n at org.apache.tomcat.util.threads.TaskThreadTWrappingRunnable.run(TaskThread.java:61)\r\n at java.lang.Thread.run(Thread.java:745)\r\n');
INSERT INTO `operation_log` VALUES ('541', '异常日志', '', '1', null, null, '2017-07-04 11:37:08', '失败', 'com.gaowh. scaffold.common.exception.BussinessException: 请求有错误\r\n at com.gaowh. scaffold.modular.eDriving.controller.EDrivingController.add(EDrivingController.java:98)\r\n at com.gaowh. scaffold.modular.eDriving.controller.EDrivingControllerTTFastClassBySpringCGLIBTTaeaaa191.invoke()\r\n at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)\r\n at org.springframework.aop.framework.CglibAopProxyTCglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:738)\r\n at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)\r\n at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:85)\r\n at com.gaowh. scaffold.core.intercept.SessionInterceptor.sessionKit(SessionInterceptor.java:31)\r\n at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\r\n at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)\r\n at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\r\n at java.lang.reflect.Method.invoke(Method.java:483)\r\n at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:629)\r\n at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:618)\r\n at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:70)\r\n at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)\r\n at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:85)\r\n at com.gaowh. scaffold.core.aop.PermissionAop.doPermission(PermissionAop.java:52)\r\n at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\r\n at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)\r\n at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\r\n at java.lang.reflect.Method.invoke(Method.java:483)\r\n at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:629)\r\n at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:618)\r\n at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:70)\r\n at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:168)\r\n at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:85)\r\n at com.gaowh. scaffold.core.aop.LogAop.recordSysLog(LogAop.java:45)\r\n at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\r\n at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)\r\n at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\r\n at java.lang.reflect.Method.invoke(Method.java:483)\r\n at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:629)\r\n at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:618)\r\n at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:70)\r\n at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:168)\r\n at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)\r\n at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)\r\n at org.springframework.aop.framework.CglibAopProxyTDynamicAdvisedInterceptor.intercept(CglibAopProxy.java:673)\r\n at com.gaowh. scaffold.modular.eDriving.controller.EDrivingControllerTTEnhancerBySpringCGLIBTT50d1e6cd.add()\r\n at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\r\n at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)\r\n at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\r\n at java.lang.reflect.Method.invoke(Method.java:483)\r\n at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)\r\n at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:133)\r\n at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:97)\r\n at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:827)\r\n at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:738)\r\n at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)\r\n at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:963)\r\n at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:897)\r\n at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970)\r\n at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:872)\r\n at javax.servlet.http.HttpServlet.service(HttpServlet.java:661)\r\n at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)\r\n at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:61)\r\n at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108)\r\n at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137)\r\n at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)\r\n at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66)\r\n at org.apache.shiro.web.servlet.AbstractShiroFilter.executeChain(AbstractShiroFilter.java:449)\r\n at org.apache.shiro.web.servlet.AbstractShiroFilterT1.call(AbstractShiroFilter.java:365)\r\n at org.apache.shiro.subject.support.SubjectCallable.doCall(SubjectCallable.java:90)\r\n at org.apache.shiro.subject.support.SubjectCallable.call(SubjectCallable.java:83)\r\n at org.apache.shiro.subject.support.DelegatingSubject.execute(DelegatingSubject.java:387)\r\n at org.apache.shiro.web.servlet.AbstractShiroFilter.doFilterInternal(AbstractShiroFilter.java:362)\r\n at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n at com.gaowh. scaffold.core.util.xss.XssFilter.doFilter(XssFilter.java:22)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n at com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:123)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99)\r\n at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n at org.springframework.web.filter.HttpPutFormContentFilter.doFilterInternal(HttpPutFormContentFilter.java:105)\r\n at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:81)\r\n at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:197)\r\n at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198)\r\n at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)\r\n at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:478)\r\n at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)\r\n at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:80)\r\n at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)\r\n at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)\r\n at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:799)\r\n at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)\r\n at org.apache.coyote.AbstractProtocolTConnectionHandler.process(AbstractProtocol.java:861)\r\n at org.apache.tomcat.util.net.NioEndpointTSocketProcessor.doRun(NioEndpoint.java:1455)\r\n at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)\r\n at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)\r\n at java.util.concurrent.ThreadPoolExecutorTWorker.run(ThreadPoolExecutor.java:617)\r\n at org.apache.tomcat.util.threads.TaskThreadTWrappingRunnable.run(TaskThread.java:61)\r\n at java.lang.Thread.run(Thread.java:745)\r\n');
INSERT INTO `operation_log` VALUES ('542', '异常日志', '', '1', null, null, '2017-07-04 11:38:33', '失败', 'com.gaowh. scaffold.common.exception.BussinessException: 请求有错误\r\n at com.gaowh. scaffold.modular.eDriving.controller.EDrivingController.update(EDrivingController.java:130)\r\n at com.gaowh. scaffold.modular.eDriving.controller.EDrivingControllerTTFastClassBySpringCGLIBTTaeaaa191.invoke()\r\n at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)\r\n at org.springframework.aop.framework.CglibAopProxyTCglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:738)\r\n at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)\r\n at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:85)\r\n at com.gaowh. scaffold.core.intercept.SessionInterceptor.sessionKit(SessionInterceptor.java:31)\r\n at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\r\n at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)\r\n at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\r\n at java.lang.reflect.Method.invoke(Method.java:483)\r\n at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:629)\r\n at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:618)\r\n at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:70)\r\n at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)\r\n at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:85)\r\n at com.gaowh. scaffold.core.aop.PermissionAop.doPermission(PermissionAop.java:52)\r\n at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\r\n at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)\r\n at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\r\n at java.lang.reflect.Method.invoke(Method.java:483)\r\n at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:629)\r\n at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:618)\r\n at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:70)\r\n at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:168)\r\n at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:85)\r\n at com.gaowh. scaffold.core.aop.LogAop.recordSysLog(LogAop.java:45)\r\n at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\r\n at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)\r\n at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\r\n at java.lang.reflect.Method.invoke(Method.java:483)\r\n at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:629)\r\n at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:618)\r\n at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:70)\r\n at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:168)\r\n at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)\r\n at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)\r\n at org.springframework.aop.framework.CglibAopProxyTDynamicAdvisedInterceptor.intercept(CglibAopProxy.java:673)\r\n at com.gaowh. scaffold.modular.eDriving.controller.EDrivingControllerTTEnhancerBySpringCGLIBTT224cffbc.update()\r\n at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\r\n at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)\r\n at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\r\n at java.lang.reflect.Method.invoke(Method.java:483)\r\n at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)\r\n at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:133)\r\n at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:97)\r\n at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:827)\r\n at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:738)\r\n at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)\r\n at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:963)\r\n at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:897)\r\n at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970)\r\n at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:872)\r\n at javax.servlet.http.HttpServlet.service(HttpServlet.java:661)\r\n at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)\r\n at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:61)\r\n at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108)\r\n at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137)\r\n at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)\r\n at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66)\r\n at org.apache.shiro.web.servlet.AbstractShiroFilter.executeChain(AbstractShiroFilter.java:449)\r\n at org.apache.shiro.web.servlet.AbstractShiroFilterT1.call(AbstractShiroFilter.java:365)\r\n at org.apache.shiro.subject.support.SubjectCallable.doCall(SubjectCallable.java:90)\r\n at org.apache.shiro.subject.support.SubjectCallable.call(SubjectCallable.java:83)\r\n at org.apache.shiro.subject.support.DelegatingSubject.execute(DelegatingSubject.java:387)\r\n at org.apache.shiro.web.servlet.AbstractShiroFilter.doFilterInternal(AbstractShiroFilter.java:362)\r\n at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n at com.gaowh. scaffold.core.util.xss.XssFilter.doFilter(XssFilter.java:22)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n at com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:123)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99)\r\n at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n at org.springframework.web.filter.HttpPutFormContentFilter.doFilterInternal(HttpPutFormContentFilter.java:105)\r\n at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:81)\r\n at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:197)\r\n at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198)\r\n at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)\r\n at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:478)\r\n at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)\r\n at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:80)\r\n at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)\r\n at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)\r\n at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:799)\r\n at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)\r\n at org.apache.coyote.AbstractProtocolTConnectionHandler.process(AbstractProtocol.java:861)\r\n at org.apache.tomcat.util.net.NioEndpointTSocketProcessor.doRun(NioEndpoint.java:1455)\r\n at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)\r\n at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)\r\n at java.util.concurrent.ThreadPoolExecutorTWorker.run(ThreadPoolExecutor.java:617)\r\n at org.apache.tomcat.util.threads.TaskThreadTWrappingRunnable.run(TaskThread.java:61)\r\n at java.lang.Thread.run(Thread.java:745)\r\n');
INSERT INTO `operation_log` VALUES ('543', '异常日志', '', '1', null, null, '2017-07-04 15:11:50', '失败', 'org.springframework.jdbc.UncategorizedSQLException: \r\n### Error updating database. Cause: java.sql.SQLException: sql injection violation, syntax error: syntax error, error in :\'g WHERE id=?\',expect SET, actual WHERE WHERE : UPDATE e_driving WHERE id=?\r\n### SQL: UPDATE e_driving WHERE id=?\r\n### Cause: java.sql.SQLException: sql injection violation, syntax error: syntax error, error in :\'g WHERE id=?\',expect SET, actual WHERE WHERE : UPDATE e_driving WHERE id=?\n; uncategorized SQLException for SQL []; SQL state [null]; error code [0]; sql injection violation, syntax error: syntax error, error in :\'g WHERE id=?\',expect SET, actual WHERE WHERE : UPDATE e_driving WHERE id=?; nested exception is java.sql.SQLException: sql injection violation, syntax error: syntax error, error in :\'g WHERE id=?\',expect SET, actual WHERE WHERE : UPDATE e_driving WHERE id=?\r\n at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:84)\r\n at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)\r\n at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)\r\n at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:73)\r\n at org.mybatis.spring.SqlSessionTemplateTSqlSessionInterceptor.invoke(SqlSessionTemplate.java:446)\r\n at com.sun.proxy.TProxy81.update(Unknown Source)\r\n at org.mybatis.spring.SqlSessionTemplate.update(SqlSessionTemplate.java:294)\r\n at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:62)\r\n at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:59)\r\n at com.sun.proxy.TProxy90.updateById(Unknown Source)\r\n at com.gaowh. scaffold.modular.eDriving.controller.EDrivingController.update(EDrivingController.java:138)\r\n at com.gaowh. scaffold.modular.eDriving.controller.EDrivingControllerTTFastClassBySpringCGLIBTTaeaaa191.invoke()\r\n at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)\r\n at org.springframework.aop.framework.CglibAopProxyTCglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:738)\r\n at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)\r\n at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:85)\r\n at com.gaowh. scaffold.core.intercept.SessionInterceptor.sessionKit(SessionInterceptor.java:31)\r\n at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\r\n at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)\r\n at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\r\n at java.lang.reflect.Method.invoke(Method.java:483)\r\n at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:629)\r\n at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:618)\r\n at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:70)\r\n at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)\r\n at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:85)\r\n at com.gaowh. scaffold.core.aop.PermissionAop.doPermission(PermissionAop.java:52)\r\n at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\r\n at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)\r\n at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\r\n at java.lang.reflect.Method.invoke(Method.java:483)\r\n at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:629)\r\n at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:618)\r\n at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:70)\r\n at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:168)\r\n at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:85)\r\n at com.gaowh. scaffold.core.aop.LogAop.recordSysLog(LogAop.java:45)\r\n at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\r\n at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)\r\n at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\r\n at java.lang.reflect.Method.invoke(Method.java:483)\r\n at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:629)\r\n at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:618)\r\n at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:70)\r\n at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:168)\r\n at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)\r\n at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)\r\n at org.springframework.aop.framework.CglibAopProxyTDynamicAdvisedInterceptor.intercept(CglibAopProxy.java:673)\r\n at com.gaowh. scaffold.modular.eDriving.controller.EDrivingControllerTTEnhancerBySpringCGLIBTTe5950892.update()\r\n at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\r\n at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)\r\n at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\r\n at java.lang.reflect.Method.invoke(Method.java:483)\r\n at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)\r\n at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:133)\r\n at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:97)\r\n at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:827)\r\n at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:738)\r\n at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)\r\n at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:963)\r\n at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:897)\r\n at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970)\r\n at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:872)\r\n at javax.servlet.http.HttpServlet.service(HttpServlet.java:661)\r\n at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)\r\n at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:61)\r\n at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108)\r\n at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137)\r\n at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)\r\n at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66)\r\n at org.apache.shiro.web.servlet.AbstractShiroFilter.executeChain(AbstractShiroFilter.java:449)\r\n at org.apache.shiro.web.servlet.AbstractShiroFilterT1.call(AbstractShiroFilter.java:365)\r\n at org.apache.shiro.subject.support.SubjectCallable.doCall(SubjectCallable.java:90)\r\n at org.apache.shiro.subject.support.SubjectCallable.call(SubjectCallable.java:83)\r\n at org.apache.shiro.subject.support.DelegatingSubject.execute(DelegatingSubject.java:387)\r\n at org.apache.shiro.web.servlet.AbstractShiroFilter.doFilterInternal(AbstractShiroFilter.java:362)\r\n at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n at com.gaowh. scaffold.core.util.xss.XssFilter.doFilter(XssFilter.java:22)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n at com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:123)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99)\r\n at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n at org.springframework.web.filter.HttpPutFormContentFilter.doFilterInternal(HttpPutFormContentFilter.java:105)\r\n at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:81)\r\n at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:197)\r\n at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198)\r\n at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)\r\n at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:478)\r\n at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)\r\n at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:80)\r\n at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)\r\n at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)\r\n at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:799)\r\n at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)\r\n at org.apache.coyote.AbstractProtocolTConnectionHandler.process(AbstractProtocol.java:861)\r\n at org.apache.tomcat.util.net.NioEndpointTSocketProcessor.doRun(NioEndpoint.java:1455)\r\n at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)\r\n at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)\r\n at java.util.concurrent.ThreadPoolExecutorTWorker.run(ThreadPoolExecutor.java:617)\r\n at org.apache.tomcat.util.threads.TaskThreadTWrappingRunnable.run(TaskThread.java:61)\r\n at java.lang.Thread.run(Thread.java:745)\r\nCaused by: java.sql.SQLException: sql injection violation, syntax error: syntax error, error in :\'g WHERE id=?\',expect SET, actual WHERE WHERE : UPDATE e_driving WHERE id=?\r\n at com.alibaba.druid.wall.WallFilter.check(WallFilter.java:725)\r\n at com.alibaba.druid.wall.WallFilter.connection_prepareStatement(WallFilter.java:253)\r\n at com.alibaba.druid.filter.FilterChainImpl.connection_prepareStatement(FilterChainImpl.java:448)\r\n at com.alibaba.druid.filter.FilterAdapter.connection_prepareStatement(FilterAdapter.java:928)\r\n at com.alibaba.druid.filter.FilterEventAdapter.connection_prepareStatement(FilterEventAdapter.java:122)\r\n at com.alibaba.druid.filter.FilterChainImpl.connection_prepareStatement(FilterChainImpl.java:448)\r\n at com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl.prepareStatement(ConnectionProxyImpl.java:342)\r\n at com.alibaba.druid.pool.DruidPooledConnection.prepareStatement(DruidPooledConnection.java:331)\r\n at org.apache.ibatis.executor.statement.PreparedStatementHandler.instantiateStatement(PreparedStatementHandler.java:87)\r\n at org.apache.ibatis.executor.statement.BaseStatementHandler.prepare(BaseStatementHandler.java:88)\r\n at org.apache.ibatis.executor.statement.RoutingStatementHandler.prepare(RoutingStatementHandler.java:59)\r\n at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\r\n at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)\r\n at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\r\n at java.lang.reflect.Method.invoke(Method.java:483)\r\n at org.apache.ibatis.plugin.Invocation.proceed(Invocation.java:49)\r\n at com.baomidou.mybatisplus.plugins.PaginationInterceptor.intercept(PaginationInterceptor.java:81)\r\n at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61)\r\n at com.sun.proxy.TProxy139.prepare(Unknown Source)\r\n at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:85)\r\n at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:49)\r\n at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:117)\r\n at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:76)\r\n at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:198)\r\n at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\r\n at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)\r\n at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\r\n at java.lang.reflect.Method.invoke(Method.java:483)\r\n at org.mybatis.spring.SqlSessionTemplateTSqlSessionInterceptor.invoke(SqlSessionTemplate.java:433)\r\n ... 118 more\r\nCaused by: com.alibaba.druid.sql.parser.ParserException: syntax error, error in :\'g WHERE id=?\',expect SET, actual WHERE WHERE\r\n at com.alibaba.druid.sql.parser.SQLParser.printError(SQLParser.java:239)\r\n at com.alibaba.druid.sql.parser.SQLParser.accept(SQLParser.java:247)\r\n at com.alibaba.druid.sql.dialect.mysql.parser.MySqlSelectParser.parseUpdateStatment(MySqlSelectParser.java:288)\r\n at com.alibaba.druid.sql.dialect.mysql.parser.MySqlStatementParser.parseUpdateStatement(MySqlStatementParser.java:257)\r\n at com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:119)\r\n at com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:79)\r\n at com.alibaba.druid.wall.WallProvider.checkInternal(WallProvider.java:620)\r\n at com.alibaba.druid.wall.WallProvider.check(WallProvider.java:574)\r\n at com.alibaba.druid.wall.WallFilter.check(WallFilter.java:712)\r\n ... 146 more\r\n');
INSERT INTO `operation_log` VALUES ('544', '异常日志', '', '1', null, null, '2017-07-04 15:21:39', '失败', 'org.springframework.jdbc.UncategorizedSQLException: \r\n### Error updating database. Cause: java.sql.SQLException: sql injection violation, syntax error: syntax error, error in :\'g WHERE id=?\',expect SET, actual WHERE WHERE : UPDATE e_driving WHERE id=?\r\n### SQL: UPDATE e_driving WHERE id=?\r\n### Cause: java.sql.SQLException: sql injection violation, syntax error: syntax error, error in :\'g WHERE id=?\',expect SET, actual WHERE WHERE : UPDATE e_driving WHERE id=?\n; uncategorized SQLException for SQL []; SQL state [null]; error code [0]; sql injection violation, syntax error: syntax error, error in :\'g WHERE id=?\',expect SET, actual WHERE WHERE : UPDATE e_driving WHERE id=?; nested exception is java.sql.SQLException: sql injection violation, syntax error: syntax error, error in :\'g WHERE id=?\',expect SET, actual WHERE WHERE : UPDATE e_driving WHERE id=?\r\n at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:84)\r\n at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)\r\n at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)\r\n at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:73)\r\n at org.mybatis.spring.SqlSessionTemplateTSqlSessionInterceptor.invoke(SqlSessionTemplate.java:446)\r\n at com.sun.proxy.TProxy81.update(Unknown Source)\r\n at org.mybatis.spring.SqlSessionTemplate.update(SqlSessionTemplate.java:294)\r\n at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:62)\r\n at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:59)\r\n at com.sun.proxy.TProxy90.updateById(Unknown Source)\r\n at com.gaowh. scaffold.modular.eDriving.controller.EDrivingController.update(EDrivingController.java:138)\r\n at com.gaowh. scaffold.modular.eDriving.controller.EDrivingControllerTTFastClassBySpringCGLIBTTaeaaa191.invoke()\r\n at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)\r\n at org.springframework.aop.framework.CglibAopProxyTCglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:738)\r\n at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)\r\n at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:85)\r\n at com.gaowh. scaffold.core.intercept.SessionInterceptor.sessionKit(SessionInterceptor.java:31)\r\n at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\r\n at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)\r\n at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\r\n at java.lang.reflect.Method.invoke(Method.java:483)\r\n at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:629)\r\n at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:618)\r\n at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:70)\r\n at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)\r\n at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:85)\r\n at com.gaowh. scaffold.core.aop.PermissionAop.doPermission(PermissionAop.java:52)\r\n at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\r\n at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)\r\n at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\r\n at java.lang.reflect.Method.invoke(Method.java:483)\r\n at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:629)\r\n at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:618)\r\n at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:70)\r\n at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:168)\r\n at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:85)\r\n at com.gaowh. scaffold.core.aop.LogAop.recordSysLog(LogAop.java:45)\r\n at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\r\n at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)\r\n at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\r\n at java.lang.reflect.Method.invoke(Method.java:483)\r\n at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:629)\r\n at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:618)\r\n at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:70)\r\n at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:168)\r\n at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)\r\n at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)\r\n at org.springframework.aop.framework.CglibAopProxyTDynamicAdvisedInterceptor.intercept(CglibAopProxy.java:673)\r\n at com.gaowh. scaffold.modular.eDriving.controller.EDrivingControllerTTEnhancerBySpringCGLIBTTe5950892.update()\r\n at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\r\n at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)\r\n at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\r\n at java.lang.reflect.Method.invoke(Method.java:483)\r\n at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205)\r\n at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:133)\r\n at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:97)\r\n at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:827)\r\n at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:738)\r\n at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)\r\n at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:963)\r\n at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:897)\r\n at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970)\r\n at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:872)\r\n at javax.servlet.http.HttpServlet.service(HttpServlet.java:661)\r\n at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846)\r\n at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:61)\r\n at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108)\r\n at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137)\r\n at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)\r\n at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66)\r\n at org.apache.shiro.web.servlet.AbstractShiroFilter.executeChain(AbstractShiroFilter.java:449)\r\n at org.apache.shiro.web.servlet.AbstractShiroFilterT1.call(AbstractShiroFilter.java:365)\r\n at org.apache.shiro.subject.support.SubjectCallable.doCall(SubjectCallable.java:90)\r\n at org.apache.shiro.subject.support.SubjectCallable.call(SubjectCallable.java:83)\r\n at org.apache.shiro.subject.support.DelegatingSubject.execute(DelegatingSubject.java:387)\r\n at org.apache.shiro.web.servlet.AbstractShiroFilter.doFilterInternal(AbstractShiroFilter.java:362)\r\n at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n at com.gaowh. scaffold.core.util.xss.XssFilter.doFilter(XssFilter.java:22)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n at com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:123)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99)\r\n at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n at org.springframework.web.filter.HttpPutFormContentFilter.doFilterInternal(HttpPutFormContentFilter.java:105)\r\n at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:81)\r\n at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:197)\r\n at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)\r\n at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)\r\n at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)\r\n at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198)\r\n at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)\r\n at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:478)\r\n at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)\r\n at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:80)\r\n at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)\r\n at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)\r\n at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:799)\r\n at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)\r\n at org.apache.coyote.AbstractProtocolTConnectionHandler.process(AbstractProtocol.java:861)\r\n at org.apache.tomcat.util.net.NioEndpointTSocketProcessor.doRun(NioEndpoint.java:1455)\r\n at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)\r\n at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)\r\n at java.util.concurrent.ThreadPoolExecutorTWorker.run(ThreadPoolExecutor.java:617)\r\n at org.apache.tomcat.util.threads.TaskThreadTWrappingRunnable.run(TaskThread.java:61)\r\n at java.lang.Thread.run(Thread.java:745)\r\nCaused by: java.sql.SQLException: sql injection violation, syntax error: syntax error, error in :\'g WHERE id=?\',expect SET, actual WHERE WHERE : UPDATE e_driving WHERE id=?\r\n at com.alibaba.druid.wall.WallFilter.check(WallFilter.java:725)\r\n at com.alibaba.druid.wall.WallFilter.connection_prepareStatement(WallFilter.java:253)\r\n at com.alibaba.druid.filter.FilterChainImpl.connection_prepareStatement(FilterChainImpl.java:448)\r\n at com.alibaba.druid.filter.FilterAdapter.connection_prepareStatement(FilterAdapter.java:928)\r\n at com.alibaba.druid.filter.FilterEventAdapter.connection_prepareStatement(FilterEventAdapter.java:122)\r\n at com.alibaba.druid.filter.FilterChainImpl.connection_prepareStatement(FilterChainImpl.java:448)\r\n at com.alibaba.druid.proxy.jdbc.ConnectionProxyImpl.prepareStatement(ConnectionProxyImpl.java:342)\r\n at com.alibaba.druid.pool.DruidPooledConnection.prepareStatement(DruidPooledConnection.java:331)\r\n at org.apache.ibatis.executor.statement.PreparedStatementHandler.instantiateStatement(PreparedStatementHandler.java:87)\r\n at org.apache.ibatis.executor.statement.BaseStatementHandler.prepare(BaseStatementHandler.java:88)\r\n at org.apache.ibatis.executor.statement.RoutingStatementHandler.prepare(RoutingStatementHandler.java:59)\r\n at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\r\n at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)\r\n at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\r\n at java.lang.reflect.Method.invoke(Method.java:483)\r\n at org.apache.ibatis.plugin.Invocation.proceed(Invocation.java:49)\r\n at com.baomidou.mybatisplus.plugins.PaginationInterceptor.intercept(PaginationInterceptor.java:81)\r\n at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61)\r\n at com.sun.proxy.TProxy139.prepare(Unknown Source)\r\n at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:85)\r\n at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:49)\r\n at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:117)\r\n at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:76)\r\n at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:198)\r\n at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)\r\n at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)\r\n at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)\r\n at java.lang.reflect.Method.invoke(Method.java:483)\r\n at org.mybatis.spring.SqlSessionTemplateTSqlSessionInterceptor.invoke(SqlSessionTemplate.java:433)\r\n ... 118 more\r\nCaused by: com.alibaba.druid.sql.parser.ParserException: syntax error, error in :\'g WHERE id=?\',expect SET, actual WHERE WHERE\r\n at com.alibaba.druid.sql.parser.SQLParser.printError(SQLParser.java:239)\r\n at com.alibaba.druid.sql.parser.SQLParser.accept(SQLParser.java:247)\r\n at com.alibaba.druid.sql.dialect.mysql.parser.MySqlSelectParser.parseUpdateStatment(MySqlSelectParser.java:288)\r\n at com.alibaba.druid.sql.dialect.mysql.parser.MySqlStatementParser.parseUpdateStatement(MySqlStatementParser.java:257)\r\n at com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:119)\r\n at com.alibaba.druid.sql.parser.SQLStatementParser.parseStatementList(SQLStatementParser.java:79)\r\n at com.alibaba.druid.wall.WallProvider.checkInternal(WallProvider.java:620)\r\n at com.alibaba.druid.wall.WallProvider.check(WallProvider.java:574)\r\n at com.alibaba.druid.wall.WallFilter.check(WallFilter.java:712)\r\n ... 146 more\r\n');
INSERT INTO `operation_log` VALUES ('545', '业务日志', '删除e代驾', '1', 'com.gaowh. scaffold.modular.eDriving.controller.EDrivingController', 'delete', '2017-07-04 15:29:46', '成功', 'null=15');
INSERT INTO `operation_log` VALUES ('546', '业务日志', '删除e代驾', '1', 'com.gaowh. scaffold.modular.eDriving.controller.EDrivingController', 'delete', '2017-07-04 16:09:59', '成功', 'null=17');
INSERT INTO `operation_log` VALUES ('547', '业务日志', '修改e代驾', '1', 'com.gaowh. scaffold.modular.eDriving.controller.EDrivingController', 'update', '2017-07-04 16:16:15', '成功', '标题=标题11;;;字段名称:标题,旧值:标题1,新值:标题11;;;字段名称:内容,旧值:内容1防守打法dfdsf,新值:内容1防守打法dfdsf1');
INSERT INTO `operation_log` VALUES ('548', '业务日志', '新增e代驾', '1', 'com.gaowh. scaffold.modular.eDriving.controller.EDrivingController', 'add', '2017-07-04 16:16:52', '成功', '标题=4');
INSERT INTO `operation_log` VALUES ('549', '业务日志', '删除e代驾', '1', 'com.gaowh. scaffold.modular.eDriving.controller.EDrivingController', 'delete', '2017-07-04 16:18:51', '成功', 'null=19');
INSERT INTO `operation_log` VALUES ('550', '业务日志', '删除e代驾', '1', 'com.gaowh. scaffold.modular.eDriving.controller.EDrivingController', 'delete', '2017-07-04 16:18:59', '成功', 'null=18');
INSERT INTO `operation_log` VALUES ('551', '业务日志', '新增e代驾', '1', 'com.gaowh. scaffold.modular.eDriving.controller.EDrivingController', 'add', '2017-07-04 16:19:14', '成功', '标题=标题4');
INSERT INTO `operation_log` VALUES ('552', '业务日志', '新增e代驾', '1', 'com.gaowh. scaffold.modular.eDriving.controller.EDrivingController', 'add', '2017-07-04 16:19:52', '成功', '标题=');
INSERT INTO `operation_log` VALUES ('553', '业务日志', '删除e代驾', '1', 'com.gaowh. scaffold.modular.eDriving.controller.EDrivingController', 'delete', '2017-07-04 16:19:57', '成功', 'null=21');
INSERT INTO `operation_log` VALUES ('554', '业务日志', '新增e代驾', '1', 'com.gaowh. scaffold.modular.eDriving.controller.EDrivingController', 'add', '2017-07-04 16:24:30', '成功', '标题=');
INSERT INTO `operation_log` VALUES ('555', '业务日志', '删除e代驾', '1', 'com.gaowh. scaffold.modular.eDriving.controller.EDrivingController', 'delete', '2017-07-04 16:24:37', '成功', 'null=22');
INSERT INTO `operation_log` VALUES ('556', '业务日志', '新增e代驾', '1', 'com.gaowh. scaffold.modular.eDriving.controller.EDrivingController', 'add', '2017-07-04 16:27:56', '成功', '标题=');
INSERT INTO `operation_log` VALUES ('557', '业务日志', '删除e代驾', '1', 'com.gaowh. scaffold.modular.eDriving.controller.EDrivingController', 'delete', '2017-07-04 16:28:00', '成功', 'null=23');
INSERT INTO `operation_log` VALUES ('558', '业务日志', '新增e代驾', '1', 'com.gaowh. scaffold.modular.eDriving.controller.EDrivingController', 'add', '2017-07-04 16:32:50', '成功', '标题=');
INSERT INTO `operation_log` VALUES ('559', '业务日志', '删除e代驾', '1', 'com.gaowh. scaffold.modular.eDriving.controller.EDrivingController', 'delete', '2017-07-04 16:32:55', '成功', 'null=24');
INSERT INTO `operation_log` VALUES ('560', '业务日志', '新增e代驾', '1', 'com.gaowh. scaffold.modular.eDriving.controller.EDrivingController', 'add', '2017-07-04 16:39:28', '成功', '标题=6');
INSERT INTO `operation_log` VALUES ('561', '业务日志', '修改菜单', '1', 'com.gaowh. scaffold.modular.system.controller.MenuController', 'edit', '2017-07-04 16:40:09', '成功', '菜单名称=e代驾-删除按钮;;;字段名称:菜单编号,旧值:3,新值:eDriving_delete');
INSERT INTO `operation_log` VALUES ('562', '业务日志', '配置权限', '1', 'com.gaowh. scaffold.modular.system.controller.RoleController', 'setAuthority', '2017-07-04 16:40:24', '成功', '角色名称=超级管理员,资源名称=系统管理,用户管理,添加用户,修改用户,删除用户,重置密码,冻结用户,解除冻结用户,分配角色,分配角色跳转,编辑用户跳转,用户列表,角色管理,添加角色,修改角色,删除角色,配置权限,修改角色跳转,角色分配跳转,角色列表,菜单管理,添加菜单,修改菜单,删除菜单,菜单编辑跳转,菜单列表,业务日志,清空日志,日志列表,日志详情,监控管理,部门管理,添加部门,修改部门,删除部门,修改部门跳转,部门列表,部门详情,字典管理,添加字典,修改字典,删除字典,修改菜单跳转,字典列表,字典详情,登录日志,清空登录日志,登录日志列表,通知管理,添加通知,修改通知,删除通知,代码生成,通知,接口文档,e代驾管理,e代驾-新增按钮,e代驾-修改按钮,e代驾-删除按钮');
INSERT INTO `operation_log` VALUES ('563', '业务日志', '配置权限', '1', 'com.gaowh. scaffold.modular.system.controller.RoleController', 'setAuthority', '2017-07-04 16:41:44', '成功', '角色名称=城管,资源名称=系统管理,用户管理,用户列表,角色管理,角色分配跳转,角色列表,菜单管理,菜单编辑跳转,菜单列表,业务日志,日志列表,日志详情,监控管理,部门管理,部门列表,部门详情,字典管理,字典列表,字典详情,登录日志,清空登录日志,登录日志列表,代码生成,接口文档,e代驾管理,e代驾-新增按钮');
INSERT INTO `operation_log` VALUES ('564', '业务日志', '配置权限', '1', 'com.gaowh. scaffold.modular.system.controller.RoleController', 'setAuthority', '2017-07-04 16:41:55', '成功', '角色名称=城管,资源名称=系统管理,用户管理,用户列表,角色管理,角色分配跳转,角色列表,菜单管理,菜单编辑跳转,菜单列表,业务日志,日志列表,日志详情,监控管理,部门管理,部门列表,部门详情,字典管理,字典列表,字典详情,登录日志,清空登录日志,登录日志列表,代码生成,接口文档,e代驾管理,e代驾-新增按钮,e代驾-修改按钮,e代驾-删除按钮');
INSERT INTO `operation_log` VALUES ('565', '业务日志', '分配角色', '1', 'com.gaowh. scaffold.modular.system.controller.UserMgrController', 'setRole', '2017-07-04 16:42:09', '成功', '账号=aaa,角色名称集合=城管');
INSERT INTO `operation_log` VALUES ('566', '业务日志', '新增e代驾', '46', 'com.gaowh. scaffold.modular.eDriving.controller.EDrivingController', 'add', '2017-07-04 16:42:54', '成功', '标题=7');
INSERT INTO `operation_log` VALUES ('567', '业务日志', '修改e代驾', '46', 'com.gaowh. scaffold.modular.eDriving.controller.EDrivingController', 'update', '2017-07-04 16:42:59', '成功', '标题=77;;;字段名称:标题,旧值:7,新值:77;;;字段名称:内容,旧值:77,新值:777');
INSERT INTO `operation_log` VALUES ('568', '业务日志', '删除e代驾', '46', 'com.gaowh. scaffold.modular.eDriving.controller.EDrivingController', 'delete', '2017-07-04 16:43:01', '成功', 'null=26');
INSERT INTO `operation_log` VALUES ('569', '业务日志', '配置权限', '1', 'com.gaowh. scaffold.modular.system.controller.RoleController', 'setAuthority', '2017-07-04 16:44:24', '成功', '角色名称=临时,资源名称=系统管理,业务日志,日志列表,日志详情,通知,接口文档');
INSERT INTO `operation_log` VALUES ('570', '业务日志', '重置管理员密码', '1', 'com.gaowh. scaffold.modular.system.controller.UserMgrController', 'reset', '2017-07-04 16:45:17', '成功', '账号=test');
INSERT INTO `operation_log` VALUES ('571', '业务日志', '配置权限', '1', 'com.gaowh. scaffold.modular.system.controller.RoleController', 'setAuthority', '2017-07-04 16:46:04', '成功', '角色名称=城管,资源名称=系统管理,用户管理,用户列表,角色管理,角色分配跳转,角色列表,菜单管理,菜单编辑跳转,菜单列表,业务日志,日志列表,日志详情,监控管理,部门管理,部门列表,部门详情,字典管理,字典列表,字典详情,登录日志,清空登录日志,登录日志列表,代码生成,通知,接口文档,e代驾管理,e代驾-新增按钮,e代驾-修改按钮,e代驾-删除按钮');
-- ----------------------------
-- Table structure for `relation`
-- ----------------------------
DROP TABLE IF EXISTS `relation`;
CREATE TABLE `relation` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
`menuid` int(11) DEFAULT NULL COMMENT '菜单id',
`roleid` int(11) DEFAULT NULL COMMENT '角色id',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4109 DEFAULT CHARSET=utf8 COMMENT='角色和菜单关联表';
-- ----------------------------
-- Records of relation
-- ----------------------------
INSERT INTO `relation` VALUES ('3961', '105', '1');
INSERT INTO `relation` VALUES ('3962', '106', '1');
INSERT INTO `relation` VALUES ('3963', '107', '1');
INSERT INTO `relation` VALUES ('3964', '108', '1');
INSERT INTO `relation` VALUES ('3965', '109', '1');
INSERT INTO `relation` VALUES ('3966', '110', '1');
INSERT INTO `relation` VALUES ('3967', '111', '1');
INSERT INTO `relation` VALUES ('3968', '112', '1');
INSERT INTO `relation` VALUES ('3969', '113', '1');
INSERT INTO `relation` VALUES ('3970', '165', '1');
INSERT INTO `relation` VALUES ('3971', '166', '1');
INSERT INTO `relation` VALUES ('3972', '167', '1');
INSERT INTO `relation` VALUES ('3973', '114', '1');
INSERT INTO `relation` VALUES ('3974', '115', '1');
INSERT INTO `relation` VALUES ('3975', '116', '1');
INSERT INTO `relation` VALUES ('3976', '117', '1');
INSERT INTO `relation` VALUES ('3977', '118', '1');
INSERT INTO `relation` VALUES ('3978', '162', '1');
INSERT INTO `relation` VALUES ('3979', '163', '1');
INSERT INTO `relation` VALUES ('3980', '164', '1');
INSERT INTO `relation` VALUES ('3981', '119', '1');
INSERT INTO `relation` VALUES ('3982', '120', '1');
INSERT INTO `relation` VALUES ('3983', '121', '1');
INSERT INTO `relation` VALUES ('3984', '122', '1');
INSERT INTO `relation` VALUES ('3985', '150', '1');
INSERT INTO `relation` VALUES ('3986', '151', '1');
INSERT INTO `relation` VALUES ('3987', '128', '1');
INSERT INTO `relation` VALUES ('3988', '134', '1');
INSERT INTO `relation` VALUES ('3989', '158', '1');
INSERT INTO `relation` VALUES ('3990', '159', '1');
INSERT INTO `relation` VALUES ('3991', '130', '1');
INSERT INTO `relation` VALUES ('3992', '131', '1');
INSERT INTO `relation` VALUES ('3993', '135', '1');
INSERT INTO `relation` VALUES ('3994', '136', '1');
INSERT INTO `relation` VALUES ('3995', '137', '1');
INSERT INTO `relation` VALUES ('3996', '152', '1');
INSERT INTO `relation` VALUES ('3997', '153', '1');
INSERT INTO `relation` VALUES ('3998', '154', '1');
INSERT INTO `relation` VALUES ('3999', '132', '1');
INSERT INTO `relation` VALUES ('4000', '138', '1');
INSERT INTO `relation` VALUES ('4001', '139', '1');
INSERT INTO `relation` VALUES ('4002', '140', '1');
INSERT INTO `relation` VALUES ('4003', '155', '1');
INSERT INTO `relation` VALUES ('4004', '156', '1');
INSERT INTO `relation` VALUES ('4005', '157', '1');
INSERT INTO `relation` VALUES ('4006', '133', '1');
INSERT INTO `relation` VALUES ('4007', '160', '1');
INSERT INTO `relation` VALUES ('4008', '161', '1');
INSERT INTO `relation` VALUES ('4009', '141', '1');
INSERT INTO `relation` VALUES ('4010', '142', '1');
INSERT INTO `relation` VALUES ('4011', '143', '1');
INSERT INTO `relation` VALUES ('4012', '144', '1');
INSERT INTO `relation` VALUES ('4013', '148', '1');
INSERT INTO `relation` VALUES ('4014', '145', '1');
INSERT INTO `relation` VALUES ('4015', '149', '1');
INSERT INTO `relation` VALUES ('4016', '168', '1');
INSERT INTO `relation` VALUES ('4017', '169', '1');
INSERT INTO `relation` VALUES ('4018', '170', '1');
INSERT INTO `relation` VALUES ('4019', '171', '1');
INSERT INTO `relation` VALUES ('4074', '105', '5');
INSERT INTO `relation` VALUES ('4075', '128', '5');
INSERT INTO `relation` VALUES ('4076', '158', '5');
INSERT INTO `relation` VALUES ('4077', '159', '5');
INSERT INTO `relation` VALUES ('4078', '145', '5');
INSERT INTO `relation` VALUES ('4079', '149', '5');
INSERT INTO `relation` VALUES ('4080', '105', '6');
INSERT INTO `relation` VALUES ('4081', '106', '6');
INSERT INTO `relation` VALUES ('4082', '167', '6');
INSERT INTO `relation` VALUES ('4083', '114', '6');
INSERT INTO `relation` VALUES ('4084', '163', '6');
INSERT INTO `relation` VALUES ('4085', '164', '6');
INSERT INTO `relation` VALUES ('4086', '119', '6');
INSERT INTO `relation` VALUES ('4087', '150', '6');
INSERT INTO `relation` VALUES ('4088', '151', '6');
INSERT INTO `relation` VALUES ('4089', '128', '6');
INSERT INTO `relation` VALUES ('4090', '158', '6');
INSERT INTO `relation` VALUES ('4091', '159', '6');
INSERT INTO `relation` VALUES ('4092', '130', '6');
INSERT INTO `relation` VALUES ('4093', '131', '6');
INSERT INTO `relation` VALUES ('4094', '153', '6');
INSERT INTO `relation` VALUES ('4095', '154', '6');
INSERT INTO `relation` VALUES ('4096', '132', '6');
INSERT INTO `relation` VALUES ('4097', '156', '6');
INSERT INTO `relation` VALUES ('4098', '157', '6');
INSERT INTO `relation` VALUES ('4099', '133', '6');
INSERT INTO `relation` VALUES ('4100', '160', '6');
INSERT INTO `relation` VALUES ('4101', '161', '6');
INSERT INTO `relation` VALUES ('4102', '148', '6');
INSERT INTO `relation` VALUES ('4103', '145', '6');
INSERT INTO `relation` VALUES ('4104', '149', '6');
INSERT INTO `relation` VALUES ('4105', '168', '6');
INSERT INTO `relation` VALUES ('4106', '169', '6');
INSERT INTO `relation` VALUES ('4107', '170', '6');
INSERT INTO `relation` VALUES ('4108', '171', '6');
-- ----------------------------
-- Table structure for `role`
-- ----------------------------
DROP TABLE IF EXISTS `role`;
CREATE TABLE `role` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键id',
`num` int(11) DEFAULT NULL COMMENT '序号',
`pid` int(11) DEFAULT NULL COMMENT '父角色id',
`name` varchar(255) DEFAULT NULL COMMENT '角色名称',
`deptid` int(11) DEFAULT NULL COMMENT '部门名称',
`tips` varchar(255) DEFAULT NULL COMMENT '提示',
`version` int(11) DEFAULT NULL COMMENT '保留字段(暂时没用）',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COMMENT='角色表';
-- ----------------------------
-- Records of role
-- ----------------------------
INSERT INTO `role` VALUES ('1', '1', '0', '超级管理员', '24', 'administrator', '1');
INSERT INTO `role` VALUES ('5', '3', '1', '临时', '26', 'temp', null);
INSERT INTO `role` VALUES ('6', '2', '0', '城管', null, '城管', null);
-- ----------------------------
-- Table structure for `test`
-- ----------------------------
DROP TABLE IF EXISTS `test`;
CREATE TABLE `test` (
`id` int(11) NOT NULL,
`value` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of test
-- ----------------------------
INSERT INTO `test` VALUES ('1', '123');
-- ----------------------------
-- Table structure for `user`
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键id',
`avatar` varchar(255) DEFAULT NULL COMMENT '头像',
`account` varchar(45) DEFAULT NULL COMMENT '账号',
`password` varchar(45) DEFAULT NULL COMMENT '密码',
`salt` varchar(45) DEFAULT NULL COMMENT 'md5密码盐',
`name` varchar(45) DEFAULT NULL COMMENT '名字',
`birthday` datetime DEFAULT NULL COMMENT '生日',
`sex` int(11) DEFAULT NULL COMMENT '性别（1：男 2：女）',
`email` varchar(45) DEFAULT NULL COMMENT '电子邮件',
`phone` varchar(45) DEFAULT NULL COMMENT '电话',
`roleid` varchar(255) DEFAULT NULL COMMENT '角色id',
`deptid` int(11) DEFAULT NULL COMMENT '部门id',
`status` int(11) DEFAULT NULL COMMENT '状态(1：启用 2：冻结 3：删除）',
`createtime` datetime DEFAULT NULL COMMENT '创建时间',
`version` int(11) DEFAULT NULL COMMENT '保留字段',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=utf8 COMMENT='管理员表';
-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES ('1', 'b56b3aa5-7a5d-4ccb-bae3-592394f01786.jpg', 'admin', 'ecfadcde9305f8891bcfe5a1e28c253e', '8pgby', '神逝花月魔', '2017-05-05 00:00:00', '1', '286899139@qq.com', '18200000000', '1', '27', '1', '2016-01-29 08:49:53', '25');
INSERT INTO `user` VALUES ('44', null, 'test', 'a57d596e105f4dcea0d708bebff4d105', 'ldp6d', 'test', '2017-05-01 00:00:00', '1', 'abc@123.com', '', '5', '26', '1', '2017-05-16 20:33:37', null);
INSERT INTO `user` VALUES ('45', null, 'gaowh', '4dd13211eaf750e47b6b76c7270858ba', 'duqyw', 'gaowh', '1983-06-30 00:00:00', '1', '', '', '6', '27', '1', '2017-06-30 14:00:20', null);
INSERT INTO `user` VALUES ('46', null, 'aaa', '5faf5847561ad5726d98c69908bdad2c', 'pr81c', 'aaa', '2017-07-03 00:00:00', '1', '', '', '6', '25', '1', '2017-07-03 13:44:18', null);