java自动生成全套代码项目，可直接生成页面

/* 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