/*
Navicat MySQL Data Transfer
Source Server : Mysql
Source Server Version : 50618
Source Host : 127.0.0.1:3306
Source Database : fhadmin
Target Server Type : MYSQL
Target Server Version : 50618
File Encoding : 65001
Date: 2016-01-28 00:16:27
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for sys_app_user
-- ----------------------------
DROP TABLE IF EXISTS `sys_app_user`;
CREATE TABLE `sys_app_user` (
`USER_ID` varchar(100) NOT NULL,
`USERNAME` varchar(255) DEFAULT NULL,
`PASSWORD` varchar(255) DEFAULT NULL,
`NAME` varchar(255) DEFAULT NULL,
`RIGHTS` varchar(255) DEFAULT NULL,
`ROLE_ID` varchar(100) DEFAULT NULL,
`LAST_LOGIN` varchar(255) DEFAULT NULL,
`IP` varchar(100) DEFAULT NULL,
`STATUS` varchar(32) DEFAULT NULL,
`BZ` varchar(255) DEFAULT NULL,
`PHONE` varchar(100) DEFAULT NULL,
`SFID` varchar(100) DEFAULT NULL,
`START_TIME` varchar(100) DEFAULT NULL,
`END_TIME` varchar(100) DEFAULT NULL,
`YEARS` int(10) DEFAULT NULL,
`NUMBER` varchar(100) DEFAULT NULL,
`EMAIL` varchar(32) DEFAULT NULL,
PRIMARY KEY (`USER_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of sys_app_user
-- ----------------------------
INSERT INTO `sys_app_user` VALUES ('1e89e6504be349a68c025976b3ecc1d1', 'a1', '698d51a19d8a121ce581499d7b701668', '会员甲', '', '115b386ff04f4352b060dffcd2b5d1da', '', '', '1', '121', '1212', '1212', '2015-12-02', '2015-12-25', '2', '111', '313596790@qq.com');
INSERT INTO `sys_app_user` VALUES ('ead1f56708e4409c8d071e0a699e5633', 'a2', 'bcbe3365e6ac95ea2c0343a2395834dd', '会员乙', '', '1b67fc82ce89457a8347ae53e43a347e', '', '', '0', '', '', '', '2015-12-01', '2015-12-24', '1', '121', '978336446@qq.com');
-- ----------------------------
-- Table structure for sys_createcode
-- ----------------------------
DROP TABLE IF EXISTS `sys_createcode`;
CREATE TABLE `sys_createcode` (
`CREATECODE_ID` varchar(100) NOT NULL,
`PACKAGENAME` varchar(50) DEFAULT NULL COMMENT '包名',
`OBJECTNAME` varchar(50) DEFAULT NULL COMMENT '类名',
`TABLENAME` varchar(50) DEFAULT NULL COMMENT '表名',
`FIELDLIST` varchar(5000) DEFAULT NULL COMMENT '属性集',
`CREATETIME` varchar(100) DEFAULT NULL COMMENT '创建时间',
`TITLE` varchar(255) DEFAULT NULL COMMENT '描述',
PRIMARY KEY (`CREATECODE_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of sys_createcode
-- ----------------------------
INSERT INTO `sys_createcode` VALUES ('002ea762e3e242a7a10ea5ca633701d8', 'system', 'Buttonrights', 'sys_,fh,BUTTONRIGHTS', 'NAME,fh,String,fh,名称,fh,是,fh,无,fh,255Q313596790', '2016-01-16 23:20:36', '按钮权限');
INSERT INTO `sys_createcode` VALUES ('c7586f931fd44c61beccd3248774c68c', 'system', 'Department', 'SYS_,fh,DEPARTMENT', 'NAME,fh,String,fh,名称,fh,是,fh,无,fh,30Q313596790NAME_EN,fh,String,fh,英文,fh,是,fh,无,fh,50Q313596790BIANMA,fh,String,fh,编码,fh,是,fh,无,fh,50Q313596790PARENT_ID,fh,String,fh,上级ID,fh,否,fh,无,fh,100Q313596790BZ,fh,String,fh,备注,fh,是,fh,无,fh,255Q313596790HEADMAN,fh,String,fh,负责人,fh,是,fh,无,fh,30Q313596790TEL,fh,String,fh,电话,fh,是,fh,无,fh,50Q313596790FUNCTIONS,fh,String,fh,部门职能,fh,是,fh,无,fh,255Q313596790ADDRESS,fh,String,fh,地址,fh,是,fh,无,fh,255Q313596790', '2015-12-20 01:49:25', '组织机构');
INSERT INTO `sys_createcode` VALUES ('d514dbd2474d4b6c8b6ab9904cc9cc7c', 'new', 'News', 'TB_,fh,NEWS', 'TITLE,fh,String,fh,标题,fh,是,fh,无,fh,255Q313596790', '2016-01-25 16:38:14', '新闻管理');
INSERT INTO `sys_createcode` VALUES ('dbd7b8330d774dcabd184eca8668a295', 'system', 'Fhsms', 'SYS_,fh,FHSMS', 'CONTENT,fh,String,fh,内容,fh,是,fh,无,fh,1000Q313596790TYPE,fh,String,fh,类型,fh,否,fh,无,fh,5Q313596790TO_USERNAME,fh,String,fh,收信人,fh,是,fh,无,fh,255Q313596790FROM_USERNAME,fh,String,fh,发信人,fh,是,fh,无,fh,255Q313596790SEND_TIME,fh,String,fh,发信时间,fh,是,fh,无,fh,100Q313596790STATUS,fh,String,fh,状态,fh,否,fh,无,fh,5Q313596790SANME_ID,fh,String,fh,共同ID,fh,是,fh,无,fh,100Q313596790', '2016-01-23 01:44:15', '站内信');
INSERT INTO `sys_createcode` VALUES ('fe239f8742194481a5b56f90cad71520', 'system', 'Fhbutton', 'SYS_,fh,FHBUTTON', 'NAME,fh,String,fh,名称,fh,是,fh,无,fh,30Q313596790QX_NAME,fh,String,fh,权限标识,fh,是,fh,无,fh,50Q313596790BZ,fh,String,fh,备注,fh,是,fh,无,fh,255Q313596790', '2016-01-15 18:38:40', '按钮管理');
-- ----------------------------
-- Table structure for sys_department
-- ----------------------------
DROP TABLE IF EXISTS `sys_department`;
CREATE TABLE `sys_department` (
`DEPARTMENT_ID` varchar(100) NOT NULL,
`NAME` varchar(30) DEFAULT NULL COMMENT '名称',
`NAME_EN` varchar(50) DEFAULT NULL COMMENT '英文',
`BIANMA` varchar(50) DEFAULT NULL COMMENT '编码',
`PARENT_ID` varchar(100) DEFAULT NULL COMMENT '上级ID',
`BZ` varchar(255) DEFAULT NULL COMMENT '备注',
`HEADMAN` varchar(30) DEFAULT NULL COMMENT '负责人',
`TEL` varchar(50) DEFAULT NULL COMMENT '电话',
`FUNCTIONS` varchar(255) DEFAULT NULL COMMENT '部门职能',
`ADDRESS` varchar(255) DEFAULT NULL COMMENT '地址',
PRIMARY KEY (`DEPARTMENT_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of sys_department
-- ----------------------------
INSERT INTO `sys_department` VALUES ('0956d8c279274fca92f4091f2a69a9ad', '销售会计', 'xiaokuai', '05896', 'd41af567914a409893d011aa53eda797', '', '', '', '', '');
INSERT INTO `sys_department` VALUES ('3e7227e11dc14b4d9e863dd1a1fcedf6', '成本会计', 'chengb', '03656', 'd41af567914a409893d011aa53eda797', '', '', '', '', '');
INSERT INTO `sys_department` VALUES ('5cccdb7c432449d8b853c52880058140', 'B公司', 'b', '002', '0', '冶铁', '李四', '112', '冶铁', '河北');
INSERT INTO `sys_department` VALUES ('83a25761c618457cae2fa1211bd8696d', '销售B组', 'xiaob', '002365', 'cbbc84eddde947ba8af7d509e430eb70', '', '李四', '', '', '');
INSERT INTO `sys_department` VALUES ('8f8b045470f342fdbc4c312ab881d62b', '销售A组', 'xiaoA', '0326', 'cbbc84eddde947ba8af7d509e430eb70', '', '张三', '0201212', '', '');
INSERT INTO `sys_department` VALUES ('a0982dea52554225ab682cd4b421de47', '1队', 'yidui', '02563', '8f8b045470f342fdbc4c312ab881d62b', '', '小王', '12356989', '', '');
INSERT INTO `sys_department` VALUES ('a6c6695217ba4a4dbfe9f7e9d2c06730', 'A公司', 'a', '001', '0', '挖煤', '张三', '110', '洼煤矿', '山西');
INSERT INTO `sys_department` VALUES ('cbbc84eddde947ba8af7d509e430eb70', '销售部', 'xiaoshoubu', '00201', '5cccdb7c432449d8b853c52880058140', '推销商品', '小明', '11236', '推销商品', '909办公室');
INSERT INTO `sys_department` VALUES ('d41af567914a409893d011aa53eda797', '财务部', 'caiwubu', '00101', 'a6c6695217ba4a4dbfe9f7e9d2c06730', '负责发工资', '王武', '11236', '管理财务', '308办公室');
-- ----------------------------
-- Table structure for sys_dictionaries
-- ----------------------------
DROP TABLE IF EXISTS `sys_dictionaries`;
CREATE TABLE `sys_dictionaries` (
`DICTIONARIES_ID` varchar(100) NOT NULL,
`NAME` varchar(30) DEFAULT NULL COMMENT '名称',
`NAME_EN` varchar(50) DEFAULT NULL COMMENT '英文',
`BIANMA` varchar(50) DEFAULT NULL COMMENT '编码',
`ORDER_BY` int(11) NOT NULL COMMENT '排序',
`PARENT_ID` varchar(100) DEFAULT NULL COMMENT '上级ID',
`BZ` varchar(255) DEFAULT NULL COMMENT '备注',
`TBSNAME` varchar(100) DEFAULT NULL COMMENT '排查表',
PRIMARY KEY (`DICTIONARIES_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of sys_dictionaries
-- ----------------------------
INSERT INTO `sys_dictionaries` VALUES ('096e4ec8986149d994b09e604504e38d', '黄浦区', 'huangpu', '0030201', '1', 'f1ea30dde
java自动生成全套代码项目，可直接生成页面 （2000个子文件） 
changelog 7KB UserController.class 13KB LoginController.class 12KB HeadController.class 11KB RoleController.class 11KB ImgmsgController.class 10KB AppuserController.class 10KB Uploader.class 10KB WeixinController.class 10KB TextmsgController.class 9KB PagePlugin.class 9KB MenuController.class 9KB PicturesController.class 9KB CreateCodeController.class 8KB DictionariesController.class 8KB Page.class 8KB CommandController.class 8KB DepartmentController.class 7KB ToolController.class 7KB FhbuttonController.class 7KB FhsmsController.class 7KB Tools.class 7KB WeixinController$2.class 7KB SmsUtil.class 6KB TwoDimensionCode.class 5KB FileUtil.class 5KB Jurisdiction.class 5KB OnlineChatServer.class 5KB SimpleMailSender.class 5KB ButtonrightsController.class 5KB ChatServer.class 5KB ObjectExcelView.class 4KB AppUtil.class 4KB Watermark.class 4KB SecCodeController.class 4KB Department.class 4KB PageData.class 4KB GetPinyin.class 4KB DateUtil.class 4KB UserService.class 4KB JPushClientUtil.class 3KB OnlineChatServerPool.class 3KB DictionariesService.class 3KB Freemarker.class 3KB ObjectExcelRead.class 3KB ChatServerPool.class 3KB DaoSupport.class 3KB Dictionaries.class 3KB DepartmentService.class 3KB MenuService.class 3KB MapDistance.class 3KB Menu.class 3KB PathUtil.class 3KB AppuserService.class 3KB MailSenderInfo.class 3KB User.class 3KB startFilter.class 3KB SortUtil.class 3KB RoleService.class 3KB IntAppuserController.class 3KB Const.class 2KB FileZip.class 2KB FhsmsService.class 2KB PicturesService.class 2KB ImageAnd64Binary.class 2KB CommandService.class 2KB TextmsgService.class 2KB ImgmsgService.class 2KB Logger.class 2KB FhbuttonService.class 2KB FileUpload.class 2KB OnlineManagerController.class 2KB BaseController.class 2KB LoginHandlerInterceptor.class 2KB Role.class 2KB DelAllFile.class 2KB CreateCodeService.class 2KB ReflectHelper.class 2KB LatLonUtil.class 2KB ButtonrightsService.class 2KB FileDownload.class 2KB StringUtil.class 2KB RequestUtil.class 2KB MD5.class 2KB MyExceptionResolver.class 2KB RightsHelper.class 2KB ShiroRealm.class 2KB PublicUtil.class 1KB LoginFilter.class 1KB WeixinController$1.class 1KB ServiceHelper.class 1KB Constants.class 1KB UserManager.class 1KB WebAppContextListener.class 1KB AppuserManager.class 964B UuidUtil.class 906B MyX509TrustManager.class 901B RoleManager.class 825B TwoDimensionCodeImage.class 824B DictionariesManager.class 796B共 2000 条
- 1
- 2
- 3
- 4
- 5
- 6
- 20
资源评论
师哥帮忙2020-05-25不错，下载研究研究
zcl9167030652019-07-04数据库呢？
qq_320283152019-07-05在文件里呀- baidu_290912352018-09-13凑合着看吧 qq_320283152018-09-17兄弟，这套代码五颗星怎么能是凑合着看，难道不值得吗？
