當前位置：首頁 > 编程资源 > 编程问答 >内容正文

编程问答

核心类生成-Mybatis Generator的使用

發布時間：2025/7/25 编程问答 19 豆豆

生活随笔收集整理的這篇文章主要介紹了核心类生成-Mybatis Generator的使用小編覺得挺不錯的,現在分享給大家,幫大家做個參考.

總結一下Generator的使用，首先要設計好數據表，然后修改generator.xml中的配制，接著直接運行命令就可以了。

第一步：數據庫設計：

?生成數據表代碼：

1 /* 2 Navicat MySQL Data Transfer 3 4 Source Server : localhost_3306 5 Source Server Version : 50722 6 Source Host : localhost:3306 7 Source Database : test1 8 9 Target Server Type : MYSQL 10 Target Server Version : 50722 11 File Encoding : 65001 12 13 Date: 2019-04-12 17:03:56 14 */ 15 16 SET FOREIGN_KEY_CHECKS=0; 17 18 -- ---------------------------- 19 -- Table structure for permission 20 -- ---------------------------- 21 DROP TABLE IF EXISTS `permission`; 22 CREATE TABLE `permission` ( 23 `pid` int(11) NOT NULL AUTO_INCREMENT, 24 `name` varchar(255) NOT NULL DEFAULT '', 25 `url` varchar(255) DEFAULT '', 26 PRIMARY KEY (`pid`) 27 ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8; 28 29 -- ---------------------------- 30 -- Records of permission 31 -- ---------------------------- 32 INSERT INTO `permission` VALUES ('1', 'add', ''); 33 INSERT INTO `permission` VALUES ('2', 'delete', ''); 34 INSERT INTO `permission` VALUES ('3', 'edit', ''); 35 INSERT INTO `permission` VALUES ('4', 'query', ''); 36 37 -- ---------------------------- 38 -- Table structure for permission_role 39 -- ---------------------------- 40 DROP TABLE IF EXISTS `permission_role`; 41 CREATE TABLE `permission_role` ( 42 `rid` int(11) NOT NULL, 43 `pid` int(11) NOT NULL, 44 KEY `idx_rid` (`rid`), 45 KEY `idx_pid` (`pid`) 46 ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 47 48 -- ---------------------------- 49 -- Records of permission_role 50 -- ---------------------------- 51 INSERT INTO `permission_role` VALUES ('1', '1'); 52 INSERT INTO `permission_role` VALUES ('1', '2'); 53 INSERT INTO `permission_role` VALUES ('1', '3'); 54 INSERT INTO `permission_role` VALUES ('1', '4'); 55 INSERT INTO `permission_role` VALUES ('2', '1'); 56 INSERT INTO `permission_role` VALUES ('2', '4'); 57 58 -- ---------------------------- 59 -- Table structure for role 60 -- ---------------------------- 61 DROP TABLE IF EXISTS `role`; 62 CREATE TABLE `role` ( 63 `rid` int(11) NOT NULL AUTO_INCREMENT, 64 `rname` varchar(255) NOT NULL DEFAULT '', 65 PRIMARY KEY (`rid`) 66 ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8; 67 68 -- ---------------------------- 69 -- Records of role 70 -- ---------------------------- 71 INSERT INTO `role` VALUES ('1', 'admin'); 72 INSERT INTO `role` VALUES ('2', 'customer'); 73 74 -- ---------------------------- 75 -- Table structure for sys_acl 76 -- ---------------------------- 77 DROP TABLE IF EXISTS `sys_acl`; 78 CREATE TABLE `sys_acl` ( 79 `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '權限id', 80 `code` varchar(20) NOT NULL DEFAULT '' COMMENT '權限碼', 81 `name` varchar(20) NOT NULL DEFAULT '' COMMENT '權限名稱', 82 `acl_module_id` int(11) NOT NULL DEFAULT '0' COMMENT '權限所在的權限模塊id', 83 `url` varchar(100) NOT NULL DEFAULT '' COMMENT '請求的url, 可以填正則表達式', 84 `type` int(11) NOT NULL DEFAULT '3' COMMENT '類型，1：菜單，2：按鈕，3：其他', 85 `status` int(11) NOT NULL DEFAULT '1' COMMENT '狀態，1：正常，0：凍結', 86 `seq` int(11) NOT NULL DEFAULT '0' COMMENT '權限在當前模塊下的順序，由小到大', 87 `remark` varchar(200) DEFAULT '' COMMENT '備注', 88 `operator` varchar(20) NOT NULL DEFAULT '' COMMENT '操作者', 89 `operate_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '最后一次更新時間', 90 `operate_ip` varchar(20) NOT NULL DEFAULT '' COMMENT '最后一個更新者的ip地址', 91 PRIMARY KEY (`id`) 92 ) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4; 93 94 -- ---------------------------- 95 -- Records of sys_acl 96 -- ---------------------------- 97 INSERT INTO `sys_acl` VALUES ('1', '20171015095130_26', '進入產品管理界面', '1', '/sys/product/product.page', '1', '1', '1', '', 'Admin', '2017-10-15 09:51:30', '0:0:0:0:0:0:0:1'); 98 INSERT INTO `sys_acl` VALUES ('2', '20171015095322_14', '查詢產品列表', '1', '/sys/product/page.json', '2', '1', '2', '', 'Admin', '2017-10-15 09:53:22', '0:0:0:0:0:0:0:1'); 99 INSERT INTO `sys_acl` VALUES ('3', '20171015095350_69', '產品上架', '1', '/sys/product/online.json', '2', '1', '3', '', 'Admin', '2017-10-15 09:53:51', '0:0:0:0:0:0:0:1'); 100 INSERT INTO `sys_acl` VALUES ('4', '20171015095420_7', '產品下架', '1', '/sys/product/offline.json', '2', '1', '4', '', 'Admin', '2017-10-15 10:11:28', '0:0:0:0:0:0:0:1'); 101 INSERT INTO `sys_acl` VALUES ('5', '20171015212626_63', '進入訂單頁', '2', '/sys/order/order.page', '1', '1', '1', '', 'Admin', '2017-10-15 21:26:27', '0:0:0:0:0:0:0:1'); 102 INSERT INTO `sys_acl` VALUES ('6', '20171015212657_12', '查詢訂單列表', '2', '/sys/order/list.json', '2', '1', '2', '', 'Admin', '2017-10-15 21:26:57', '0:0:0:0:0:0:0:1'); 103 INSERT INTO `sys_acl` VALUES ('7', '20171015212907_36', '進入權限管理頁', '7', '/sys/aclModule/acl.page', '1', '1', '1', '', 'Admin', '2017-10-15 21:29:07', '0:0:0:0:0:0:0:1'); 104 INSERT INTO `sys_acl` VALUES ('8', '20171015212938_27', '進入角色管理頁', '8', '/sys/role/role.page', '1', '1', '1', '', 'Admin', '2017-10-16 17:49:38', '0:0:0:0:0:0:0:1'); 105 INSERT INTO `sys_acl` VALUES ('9', '20171015213009_0', '進入用戶管理頁', '9', '/sys/dept/dept.page', '1', '1', '1', '', 'Admin', '2017-10-15 21:30:09', '0:0:0:0:0:0:0:1'); 106 INSERT INTO `sys_acl` VALUES ('10', '20171016230429_8', '進入權限更新記錄頁面', '11', '/sys/log/log.page', '1', '1', '1', '', 'Admin', '2017-10-16 23:04:49', '0:0:0:0:0:0:0:1'); 107 108 -- ---------------------------- 109 -- Table structure for sys_acl_module 110 -- ---------------------------- 111 DROP TABLE IF EXISTS `sys_acl_module`; 112 CREATE TABLE `sys_acl_module` ( 113 `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '權限模塊id', 114 `name` varchar(20) NOT NULL DEFAULT '' COMMENT '權限模塊名稱', 115 `parent_id` int(11) NOT NULL DEFAULT '0' COMMENT '上級權限模塊id', 116 `level` varchar(200) NOT NULL DEFAULT '' COMMENT '權限模塊層級', 117 `seq` int(11) NOT NULL DEFAULT '0' COMMENT '權限模塊在當前層級下的順序，由小到大', 118 `status` int(11) NOT NULL DEFAULT '1' COMMENT '狀態，1：正常，0：凍結', 119 `remark` varchar(200) DEFAULT '' COMMENT '備注', 120 `operator` varchar(20) NOT NULL DEFAULT '' COMMENT '操作者', 121 `operate_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '最后一次操作時間', 122 `operate_ip` varchar(20) NOT NULL DEFAULT '' COMMENT '最后一次更新操作者的ip地址', 123 PRIMARY KEY (`id`) 124 ) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC; 125 126 -- ---------------------------- 127 -- Records of sys_acl_module 128 -- ---------------------------- 129 INSERT INTO `sys_acl_module` VALUES ('1', '產品管理', '0', '0', '1', '1', 'product', 'Admin', '2017-10-14 21:13:15', '0:0:0:0:0:0:0:1'); 130 INSERT INTO `sys_acl_module` VALUES ('2', '訂單管理', '0', '0', '2', '1', '', 'Admin', '2017-10-14 20:17:11', '0:0:0:0:0:0:0:1'); 131 INSERT INTO `sys_acl_module` VALUES ('3', '公告管理', '0', '0', '3', '1', '', 'Admin', '2017-10-14 20:17:21', '0:0:0:0:0:0:0:1'); 132 INSERT INTO `sys_acl_module` VALUES ('4', '出售中產品管理', '1', '0.1', '1', '1', '', 'Admin', '2017-10-14 21:13:39', '0:0:0:0:0:0:0:1'); 133 INSERT INTO `sys_acl_module` VALUES ('5', '下架產品管理', '1', '0.1', '2', '1', '', 'Admin', '2017-10-14 20:18:02', '0:0:0:0:0:0:0:1'); 134 INSERT INTO `sys_acl_module` VALUES ('6', '權限管理', '0', '0', '4', '1', '', 'Admin', '2017-10-15 21:27:37', '0:0:0:0:0:0:0:1'); 135 INSERT INTO `sys_acl_module` VALUES ('7', '權限管理', '6', '0.6', '1', '1', '', 'Admin', '2017-10-15 21:27:57', '0:0:0:0:0:0:0:1'); 136 INSERT INTO `sys_acl_module` VALUES ('8', '角色管理', '6', '0.6', '2', '1', '', 'Admin', '2017-10-15 21:28:22', '0:0:0:0:0:0:0:1'); 137 INSERT INTO `sys_acl_module` VALUES ('9', '用戶管理', '6', '0.6', '2', '1', '', 'Admin', '2017-10-15 21:28:36', '0:0:0:0:0:0:0:1'); 138 INSERT INTO `sys_acl_module` VALUES ('10', '運維管理', '0', '0', '6', '1', '', 'Admin', '2017-10-16 23:03:37', '0:0:0:0:0:0:0:1'); 139 INSERT INTO `sys_acl_module` VALUES ('11', '權限更新記錄管理', '6', '0.6', '4', '1', '', 'Admin', '2017-10-16 23:04:07', '0:0:0:0:0:0:0:1'); 140 141 -- ---------------------------- 142 -- Table structure for sys_dept 143 -- ---------------------------- 144 DROP TABLE IF EXISTS `sys_dept`; 145 CREATE TABLE `sys_dept` ( 146 `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '部門id', 147 `name` varchar(20) NOT NULL DEFAULT '' COMMENT '部門名稱', 148 `parent_id` int(11) NOT NULL DEFAULT '0' COMMENT '上級部門id', 149 `level` varchar(200) NOT NULL DEFAULT '' COMMENT '部門層級', 150 `seq` int(11) NOT NULL DEFAULT '0' COMMENT '部門在當前層級下的順序，由小到大', 151 `remark` varchar(200) DEFAULT '' COMMENT '備注', 152 `operator` varchar(20) NOT NULL DEFAULT '' COMMENT '操作者', 153 `operate_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '最后一次操作時間', 154 `operate_ip` varchar(20) NOT NULL DEFAULT '' COMMENT '最后一次更新操作者的ip地址', 155 PRIMARY KEY (`id`) 156 ) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4; 157 158 -- ---------------------------- 159 -- Records of sys_dept 160 -- ---------------------------- 161 INSERT INTO `sys_dept` VALUES ('1', '技術部', '0', '0', '1', '技術部', 'system', '2017-10-11 07:21:40', '127.0.0.1'); 162 INSERT INTO `sys_dept` VALUES ('2', '后端開發', '1', '0.1', '1', '后端', 'system-update', '2017-10-12 07:56:16', '127.0.0.1'); 163 INSERT INTO `sys_dept` VALUES ('3', '前端開發', '1', '0.1', '2', '', 'system-update', '2017-10-14 11:29:45', '127.0.0.1'); 164 INSERT INTO `sys_dept` VALUES ('4', 'UI設計', '1', '0.1', '3', '', 'system', '2017-10-12 07:55:43', '127.0.0.1'); 165 INSERT INTO `sys_dept` VALUES ('11', '產品部', '0', '0', '2', '', 'Admin', '2017-10-16 22:52:29', '0:0:0:0:0:0:0:1'); 166 INSERT INTO `sys_dept` VALUES ('12', '客服部', '0', '0', '4', '', 'Admin', '2017-10-17 00:22:55', '0:0:0:0:0:0:0:1'); 167 168 -- ---------------------------- 169 -- Table structure for sys_log 170 -- ---------------------------- 171 DROP TABLE IF EXISTS `sys_log`; 172 CREATE TABLE `sys_log` ( 173 `id` int(11) NOT NULL AUTO_INCREMENT, 174 `type` int(11) NOT NULL DEFAULT '0' COMMENT '權限更新的類型，1：部門，2：用戶，3：權限模塊，4：權限，5：角色，6：角色用戶關系，7：角色權限關系', 175 `target_id` int(11) NOT NULL COMMENT '基于type后指定的對象id，比如用戶、權限、角色等表的主鍵', 176 `old_value` text COMMENT '舊值', 177 `new_value` text COMMENT '新值', 178 `operator` varchar(20) NOT NULL DEFAULT '' COMMENT '操作者', 179 `operate_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '最后一次更新的時間', 180 `operate_ip` varchar(20) NOT NULL DEFAULT '' COMMENT '最后一次更新者的ip地址', 181 `status` int(11) NOT NULL DEFAULT '0' COMMENT '當前是否復原過，0：沒有，1：復原過', 182 PRIMARY KEY (`id`) 183 ) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8mb4; 184 185 -- ---------------------------- 186 -- Records of sys_log 187 -- ---------------------------- 188 INSERT INTO `sys_log` VALUES ('2', '1', '12', '', '{\"id\":12,\"name\":\"客服部\",\"parentId\":0,\"level\":\"0\",\"seq\":3,\"operator\":\"Admin\",\"operateTime\":1508166002610,\"operateIp\":\"0:0:0:0:0:0:0:1\"}', 'Admin', '2017-10-16 23:00:03', '0:0:0:0:0:0:0:1', '1'); 189 INSERT INTO `sys_log` VALUES ('3', '1', '12', '{\"id\":12,\"name\":\"客服部\",\"parentId\":0,\"level\":\"0\",\"seq\":3,\"operator\":\"Admin\",\"operateTime\":1508166003000,\"operateIp\":\"0:0:0:0:0:0:0:1\"}', '{\"id\":12,\"name\":\"客服部\",\"parentId\":0,\"level\":\"0\",\"seq\":4,\"operator\":\"Admin\",\"operateTime\":1508166009313,\"operateIp\":\"0:0:0:0:0:0:0:1\"}', 'Admin', '2017-10-16 23:00:09', '0:0:0:0:0:0:0:1', '1'); 190 INSERT INTO `sys_log` VALUES ('4', '2', '4', '', '{\"id\":4,\"username\":\"Kate\",\"telephone\":\"13144445555\",\"mail\":\"kate@qq.com\",\"password\":\"25D55AD283AA400AF464C76D713C07AD\",\"deptId\":1,\"status\":1,\"operator\":\"Admin\",\"operateTime\":1508166166297,\"operateIp\":\"0:0:0:0:0:0:0:1\"}', 'Admin', '2017-10-16 23:02:46', '0:0:0:0:0:0:0:1', '1'); 191 INSERT INTO `sys_log` VALUES ('5', '2', '4', '{\"id\":4,\"username\":\"Kate\",\"telephone\":\"13144445555\",\"mail\":\"kate@qq.com\",\"password\":\"25D55AD283AA400AF464C76D713C07AD\",\"deptId\":1,\"status\":1,\"operator\":\"Admin\",\"operateTime\":1508166166000,\"operateIp\":\"0:0:0:0:0:0:0:1\"}', '{\"id\":4,\"username\":\"Kate\",\"telephone\":\"13144445555\",\"mail\":\"kate@qq.com\",\"deptId\":1,\"status\":1,\"remark\":\"sss\",\"operator\":\"Admin\",\"operateTime\":1508166171320,\"operateIp\":\"0:0:0:0:0:0:0:1\"}', 'Admin', '2017-10-16 23:02:51', '0:0:0:0:0:0:0:1', '1'); 192 INSERT INTO `sys_log` VALUES ('6', '3', '10', '', '{\"id\":10,\"name\":\"運維管理\",\"parentId\":0,\"level\":\"0\",\"seq\":5,\"status\":1,\"operator\":\"Admin\",\"operateTime\":1508166212527,\"operateIp\":\"0:0:0:0:0:0:0:1\"}', 'Admin', '2017-10-16 23:03:33', '0:0:0:0:0:0:0:1', '1'); 193 INSERT INTO `sys_log` VALUES ('7', '3', '10', '{\"id\":10,\"name\":\"運維管理\",\"parentId\":0,\"level\":\"0\",\"seq\":5,\"status\":1,\"operator\":\"Admin\",\"operateTime\":1508166213000,\"operateIp\":\"0:0:0:0:0:0:0:1\"}', '{\"id\":10,\"name\":\"運維管理\",\"parentId\":0,\"level\":\"0\",\"seq\":6,\"status\":1,\"operator\":\"Admin\",\"operateTime\":1508166217376,\"operateIp\":\"0:0:0:0:0:0:0:1\"}', 'Admin', '2017-10-16 23:03:37', '0:0:0:0:0:0:0:1', '1'); 194 INSERT INTO `sys_log` VALUES ('8', '3', '11', '', '{\"id\":11,\"name\":\"權限更新記錄管理\",\"parentId\":6,\"level\":\"0.6\",\"seq\":4,\"status\":1,\"operator\":\"Admin\",\"operateTime\":1508166246805,\"operateIp\":\"0:0:0:0:0:0:0:1\"}', 'Admin', '2017-10-16 23:04:07', '0:0:0:0:0:0:0:1', '1'); 195 INSERT INTO `sys_log` VALUES ('9', '4', '10', '', '{\"id\":10,\"code\":\"20171016230429_8\",\"name\":\"進入權限更新記錄頁面\",\"aclModuleId\":1,\"url\":\"/sys/log/log.page\",\"type\":1,\"status\":1,\"seq\":1,\"operator\":\"Admin\",\"operateTime\":1508166269419,\"operateIp\":\"0:0:0:0:0:0:0:1\"}', 'Admin', '2017-10-16 23:04:29', '0:0:0:0:0:0:0:1', '1'); 196 INSERT INTO `sys_log` VALUES ('10', '4', '10', '{\"id\":10,\"code\":\"20171016230429_8\",\"name\":\"進入權限更新記錄頁面\",\"aclModuleId\":1,\"url\":\"/sys/log/log.page\",\"type\":1,\"status\":1,\"seq\":1,\"operator\":\"Admin\",\"operateTime\":1508166269000,\"operateIp\":\"0:0:0:0:0:0:0:1\"}', '{\"id\":10,\"name\":\"進入權限更新記錄頁面\",\"aclModuleId\":11,\"url\":\"/sys/log/log.page\",\"type\":1,\"status\":1,\"seq\":1,\"operator\":\"Admin\",\"operateTime\":1508166288589,\"operateIp\":\"0:0:0:0:0:0:0:1\"}', 'Admin', '2017-10-16 23:04:49', '0:0:0:0:0:0:0:1', '1'); 197 INSERT INTO `sys_log` VALUES ('11', '5', '5', '', '{\"id\":5,\"name\":\"運維管理員\",\"type\":1,\"status\":1,\"operator\":\"Admin\",\"operateTime\":1508166301130,\"operateIp\":\"0:0:0:0:0:0:0:1\"}', 'Admin', '2017-10-16 23:05:01', '0:0:0:0:0:0:0:1', '1'); 198 INSERT INTO `sys_log` VALUES ('12', '5', '5', '{\"id\":5,\"name\":\"運維管理員\",\"type\":1,\"status\":1,\"operator\":\"Admin\",\"operateTime\":1508166301000,\"operateIp\":\"0:0:0:0:0:0:0:1\"}', '{\"id\":5,\"name\":\"運維管理員\",\"type\":1,\"status\":1,\"remark\":\"運維\",\"operator\":\"Admin\",\"operateTime\":1508166307317,\"operateIp\":\"0:0:0:0:0:0:0:1\"}', 'Admin', '2017-10-16 23:05:07', '0:0:0:0:0:0:0:1', '1'); 199 INSERT INTO `sys_log` VALUES ('13', '6', '4', '[7,8,9]', '[7,8,9,10]', 'Admin', '2017-10-16 23:34:39', '0:0:0:0:0:0:0:1', '1'); 200 INSERT INTO `sys_log` VALUES ('14', '7', '4', '[1]', '[1,4]', 'Admin', '2017-10-16 23:34:44', '0:0:0:0:0:0:0:1', '1'); 201 INSERT INTO `sys_log` VALUES ('15', '2', '5', '', '{\"id\":5,\"username\":\"服務員A\",\"telephone\":\"18677778888\",\"mail\":\"service@qq.com\",\"password\":\"25D55AD283AA400AF464C76D713C07AD\",\"deptId\":12,\"status\":1,\"operator\":\"Admin\",\"operateTime\":1508170918338,\"operateIp\":\"0:0:0:0:0:0:0:1\"}', 'Admin', '2017-10-17 00:21:58', '0:0:0:0:0:0:0:1', '1'); 202 INSERT INTO `sys_log` VALUES ('16', '2', '5', '{\"id\":5,\"username\":\"服務員A\",\"telephone\":\"18677778888\",\"mail\":\"service@qq.com\",\"password\":\"25D55AD283AA400AF464C76D713C07AD\",\"deptId\":12,\"status\":1,\"operator\":\"Admin\",\"operateTime\":1508170918000,\"operateIp\":\"0:0:0:0:0:0:0:1\"}', '{\"id\":5,\"username\":\"服務員B\",\"telephone\":\"18677778888\",\"mail\":\"service@qq.com\",\"deptId\":12,\"status\":1,\"operator\":\"Admin\",\"operateTime\":1508170924698,\"operateIp\":\"0:0:0:0:0:0:0:1\"}', 'Admin', '2017-10-17 00:22:05', '0:0:0:0:0:0:0:1', '1'); 203 INSERT INTO `sys_log` VALUES ('17', '2', '5', '{\"id\":5,\"username\":\"服務員B\",\"telephone\":\"18677778888\",\"mail\":\"service@qq.com\",\"password\":\"25D55AD283AA400AF464C76D713C07AD\",\"deptId\":12,\"status\":1,\"operator\":\"Admin\",\"operateTime\":1508170925000,\"operateIp\":\"0:0:0:0:0:0:0:1\"}', '{\"id\":5,\"username\":\"服務員A\",\"telephone\":\"18677778888\",\"mail\":\"service@qq.com\",\"password\":\"25D55AD283AA400AF464C76D713C07AD\",\"deptId\":12,\"status\":1,\"operator\":\"Admin\",\"operateTime\":1508170934791,\"operateIp\":\"0:0:0:0:0:0:0:1\"}', 'Admin', '2017-10-17 00:22:15', '0:0:0:0:0:0:0:1', '1'); 204 INSERT INTO `sys_log` VALUES ('18', '1', '12', '{\"id\":12,\"name\":\"客服部\",\"parentId\":0,\"level\":\"0\",\"seq\":4,\"operator\":\"Admin\",\"operateTime\":1508166009000,\"operateIp\":\"0:0:0:0:0:0:0:1\"}', '{\"id\":12,\"name\":\"客服部A\",\"parentId\":0,\"level\":\"0\",\"seq\":4,\"operator\":\"Admin\",\"operateTime\":1508170966051,\"operateIp\":\"0:0:0:0:0:0:0:1\"}', 'Admin', '2017-10-17 00:22:46', '0:0:0:0:0:0:0:1', '1'); 205 INSERT INTO `sys_log` VALUES ('19', '1', '12', '{\"id\":12,\"name\":\"客服部A\",\"parentId\":0,\"level\":\"0\",\"seq\":4,\"operator\":\"Admin\",\"operateTime\":1508170966000,\"operateIp\":\"0:0:0:0:0:0:0:1\"}', '{\"id\":12,\"name\":\"客服部\",\"parentId\":0,\"level\":\"0\",\"seq\":4,\"operator\":\"Admin\",\"operateTime\":1508170975242,\"operateIp\":\"0:0:0:0:0:0:0:1\"}', 'Admin', '2017-10-17 00:22:55', '0:0:0:0:0:0:0:1', '1'); 206 INSERT INTO `sys_log` VALUES ('20', '5', '5', '{\"id\":5,\"name\":\"運維管理員\",\"type\":1,\"status\":1,\"remark\":\"運維\",\"operator\":\"Admin\",\"operateTime\":1508166307000,\"operateIp\":\"0:0:0:0:0:0:0:1\"}', '{\"id\":5,\"name\":\"運維管理員A\",\"type\":1,\"status\":1,\"remark\":\"運維\",\"operator\":\"Admin\",\"operateTime\":1508170997531,\"operateIp\":\"0:0:0:0:0:0:0:1\"}', 'Admin', '2017-10-17 00:23:18', '0:0:0:0:0:0:0:1', '1'); 207 INSERT INTO `sys_log` VALUES ('21', '5', '5', '{\"id\":5,\"name\":\"運維管理員A\",\"type\":1,\"status\":1,\"remark\":\"運維\",\"operator\":\"Admin\",\"operateTime\":1508170998000,\"operateIp\":\"0:0:0:0:0:0:0:1\"}', '{\"id\":5,\"name\":\"運維管理員\",\"type\":1,\"status\":1,\"remark\":\"運維\",\"operator\":\"Admin\",\"operateTime\":1508171007651,\"operateIp\":\"0:0:0:0:0:0:0:1\"}', 'Admin', '2017-10-17 00:23:28', '0:0:0:0:0:0:0:1', '1'); 208 INSERT INTO `sys_log` VALUES ('22', '7', '4', '[1,4]', '[1,4,2,3,5]', 'Admin', '2017-10-17 00:23:53', '0:0:0:0:0:0:0:1', '1'); 209 INSERT INTO `sys_log` VALUES ('23', '7', '4', '[1,4,2,3,5]', '[1,4]', 'Admin', '2017-10-17 00:24:04', '0:0:0:0:0:0:0:1', '1'); 210 INSERT INTO `sys_log` VALUES ('24', '6', '5', '[]', '[7,8,9,10]', 'Admin', '2017-10-17 00:24:23', '0:0:0:0:0:0:0:1', '1'); 211 INSERT INTO `sys_log` VALUES ('25', '6', '5', '[7,8,9,10]', '[]', 'Admin', '2017-10-17 00:24:34', '0:0:0:0:0:0:0:1', '1'); 212 213 -- ---------------------------- 214 -- Table structure for sys_role 215 -- ---------------------------- 216 DROP TABLE IF EXISTS `sys_role`; 217 CREATE TABLE `sys_role` ( 218 `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '角色id', 219 `name` varchar(20) NOT NULL, 220 `type` int(11) NOT NULL DEFAULT '1' COMMENT '角色的類型，1：管理員角色，2：其他', 221 `status` int(11) NOT NULL DEFAULT '1' COMMENT '狀態，1：可用，0：凍結', 222 `remark` varchar(200) DEFAULT '' COMMENT '備注', 223 `operator` varchar(20) NOT NULL DEFAULT '' COMMENT '操作者', 224 `operate_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '最后一次更新的時間', 225 `operate_ip` varchar(20) NOT NULL DEFAULT '' COMMENT '最后一次更新者的ip地址', 226 PRIMARY KEY (`id`) 227 ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4; 228 229 -- ---------------------------- 230 -- Records of sys_role 231 -- ---------------------------- 232 INSERT INTO `sys_role` VALUES ('1', '產品管理員', '1', '1', '', 'Admin', '2017-10-15 12:42:47', '0:0:0:0:0:0:0:1'); 233 INSERT INTO `sys_role` VALUES ('2', '訂單管理員', '1', '1', '', 'Admin', '2017-10-15 12:18:59', '0:0:0:0:0:0:0:1'); 234 INSERT INTO `sys_role` VALUES ('3', '公告管理員', '1', '1', '', 'Admin', '2017-10-15 12:19:10', '0:0:0:0:0:0:0:1'); 235 INSERT INTO `sys_role` VALUES ('4', '權限管理員', '1', '1', '', 'Admin', '2017-10-15 21:30:36', '0:0:0:0:0:0:0:1'); 236 INSERT INTO `sys_role` VALUES ('5', '運維管理員', '1', '1', '運維', 'Admin', '2017-10-17 00:23:28', '0:0:0:0:0:0:0:1'); 237 238 -- ---------------------------- 239 -- Table structure for sys_role_acl 240 -- ---------------------------- 241 DROP TABLE IF EXISTS `sys_role_acl`; 242 CREATE TABLE `sys_role_acl` ( 243 `id` int(11) NOT NULL AUTO_INCREMENT, 244 `role_id` int(11) NOT NULL COMMENT '角色id', 245 `acl_id` int(11) NOT NULL COMMENT '權限id', 246 `operator` varchar(20) NOT NULL DEFAULT '' COMMENT '操作者', 247 `operate_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '最后一次更新的時間', 248 `operate_ip` varchar(200) NOT NULL DEFAULT '' COMMENT '最后一次更新者的ip', 249 PRIMARY KEY (`id`) 250 ) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4; 251 252 -- ---------------------------- 253 -- Records of sys_role_acl 254 -- ---------------------------- 255 INSERT INTO `sys_role_acl` VALUES ('9', '4', '7', 'Admin', '2017-10-16 23:34:39', '0:0:0:0:0:0:0:1'); 256 INSERT INTO `sys_role_acl` VALUES ('10', '4', '8', 'Admin', '2017-10-16 23:34:39', '0:0:0:0:0:0:0:1'); 257 INSERT INTO `sys_role_acl` VALUES ('11', '4', '9', 'Admin', '2017-10-16 23:34:39', '0:0:0:0:0:0:0:1'); 258 INSERT INTO `sys_role_acl` VALUES ('12', '4', '10', 'Admin', '2017-10-16 23:34:39', '0:0:0:0:0:0:0:1'); 259 260 -- ---------------------------- 261 -- Table structure for sys_role_user 262 -- ---------------------------- 263 DROP TABLE IF EXISTS `sys_role_user`; 264 CREATE TABLE `sys_role_user` ( 265 `id` int(11) NOT NULL AUTO_INCREMENT, 266 `role_id` int(11) NOT NULL COMMENT '角色id', 267 `user_id` int(11) NOT NULL COMMENT '用戶id', 268 `operator` varchar(20) NOT NULL DEFAULT '' COMMENT '操作者', 269 `operate_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '最后一次更新的時間', 270 `operate_ip` varchar(20) NOT NULL DEFAULT '' COMMENT '最后一次更新者的ip地址', 271 PRIMARY KEY (`id`) 272 ) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4; 273 274 -- ---------------------------- 275 -- Records of sys_role_user 276 -- ---------------------------- 277 INSERT INTO `sys_role_user` VALUES ('16', '4', '1', 'Admin', '2017-10-17 00:24:04', '0:0:0:0:0:0:0:1'); 278 INSERT INTO `sys_role_user` VALUES ('17', '4', '4', 'Admin', '2017-10-17 00:24:04', '0:0:0:0:0:0:0:1'); 279 280 -- ---------------------------- 281 -- Table structure for sys_user 282 -- ---------------------------- 283 DROP TABLE IF EXISTS `sys_user`; 284 CREATE TABLE `sys_user` ( 285 `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '用戶id', 286 `username` varchar(20) NOT NULL DEFAULT '' COMMENT '用戶名稱', 287 `telephone` varchar(13) NOT NULL DEFAULT '' COMMENT '手機號', 288 `mail` varchar(20) NOT NULL DEFAULT '' COMMENT '郵箱', 289 `password` varchar(40) NOT NULL DEFAULT '' COMMENT '加密后的密碼', 290 `dept_id` int(11) NOT NULL DEFAULT '0' COMMENT '用戶所在部門的id', 291 `status` int(11) NOT NULL DEFAULT '1' COMMENT '狀態，1：正常，0：凍結狀態，2：刪除', 292 `remark` varchar(200) DEFAULT '' COMMENT '備注', 293 `operator` varchar(20) NOT NULL DEFAULT '' COMMENT '操作者', 294 `operate_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '最后一次更新時間', 295 `operate_ip` varchar(20) NOT NULL DEFAULT '' COMMENT '最后一次更新者的ip地址', 296 PRIMARY KEY (`id`) 297 ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4; 298 299 -- ---------------------------- 300 -- Records of sys_user 301 -- ---------------------------- 302 INSERT INTO `sys_user` VALUES ('1', 'Admin', '18612344321', 'admin@qq.com', '25D55AD283AA400AF464C76D713C07AD', '1', '1', 'admin', 'system', '2017-10-13 08:46:16', '127.0.0.1'); 303 INSERT INTO `sys_user` VALUES ('2', 'Jimin', '13188889999', 'jimin@qq.com', '25D55AD283AA400AF464C76D713C07AD', '1', '1', 'jimin.zheng', 'Admin', '2017-10-14 14:45:19', '127.0.0.1'); 304 INSERT INTO `sys_user` VALUES ('3', 'Jimmy', '13812344311', 'jimmy@qq.com', '25D55AD283AA400AF464C76D713C07AD', '2', '1', '', 'Admin', '2017-10-16 12:57:35', '0:0:0:0:0:0:0:1'); 305 INSERT INTO `sys_user` VALUES ('4', 'Kate', '13144445555', 'kate@qq.com', '25D55AD283AA400AF464C76D713C07AD', '1', '1', 'sss', 'Admin', '2017-10-16 23:02:51', '0:0:0:0:0:0:0:1'); 306 INSERT INTO `sys_user` VALUES ('5', '服務員A', '18677778888', 'service@qq.com', '25D55AD283AA400AF464C76D713C07AD', '12', '1', '', 'Admin', '2017-10-17 00:22:15', '0:0:0:0:0:0:0:1'); 307 308 -- ---------------------------- 309 -- Table structure for user 310 -- ---------------------------- 311 DROP TABLE IF EXISTS `user`; 312 CREATE TABLE `user` ( 313 `uid` int(11) NOT NULL AUTO_INCREMENT, 314 `username` varchar(255) NOT NULL DEFAULT '', 315 `password` varchar(255) NOT NULL DEFAULT '', 316 PRIMARY KEY (`uid`) 317 ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8; 318 319 -- ---------------------------- 320 -- Records of user 321 -- ---------------------------- 322 INSERT INTO `user` VALUES ('1', 'admin', '123'); 323 INSERT INTO `user` VALUES ('2', 'demo', '123'); 324 325 -- ---------------------------- 326 -- Table structure for user_role 327 -- ---------------------------- 328 DROP TABLE IF EXISTS `user_role`; 329 CREATE TABLE `user_role` ( 330 `uid` int(11) NOT NULL, 331 `rid` int(11) NOT NULL, 332 KEY `idx_uid` (`uid`), 333 KEY `idx_rid` (`rid`) 334 ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 335 336 -- ---------------------------- 337 -- Records of user_role 338 -- ---------------------------- 339 INSERT INTO `user_role` VALUES ('1', '1'); 340 INSERT INTO `user_role` VALUES ('2', '2'); View Code

第二步：把Generator工具包導入到項目中

數據庫設計好以后，接下來開始導入Generator工具包到項目中。下載地址generator包我放到自己的csdn中，下載地址https://download.csdn.net/download/longyanchen/11110218

第三步：修改generator.xml

1.數據庫驅動包位置

2.數據庫鏈接URL、用戶名、密碼（案例mysql,數據庫）

1  2 <jdbcConnection driverClass="com.mysql.jdbc.Driver" connectionURL="jdbc:mysql://localhost:3306/test1?characterEncoding=utf8" userId="root" password="123456">  3 </jdbcConnection> View Code

3.生成模型的包名和位置

1   2 <javaModelGenerator targetPackage="com.mmall.model" targetProject="D:/IDEAProject/CYL/generator/src"> 3 <property name="enableSubPackages" value="true" /> 4 <property name="trimStrings" value="true" /> 5 </javaModelGenerator> View Code

4.生成的映射文件包名和位置

1   2 <sqlMapGenerator targetPackage="com.mmall.mapper" targetProject="D:/IDEAProject/CYL/generator/src"> 3 <property name="enableSubPackages" value="true" /> 4 </sqlMapGenerator> View Code

5.生成DAO的包名和位置

1   2 <javaClientGenerator type="XMLMAPPER" targetPackage="com.mmall.dao" targetProject="D:/IDEAProject/CYL/generator/src"> 3 <property name="enableSubPackages" value="true" /> View Code

6.要生成那些表(更改tableName和domainObjectName（注意：tableName與domainObjectName的對應關系）

1  2 <table tableName="sys_user" domainObjectName="SysUser" enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false" enableSelectByExample="false" selectByExampleQueryId="false" /> 3 <table tableName="sys_dept" domainObjectName="SysDept" enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false" enableSelectByExample="false" selectByExampleQueryId="false" /> 4 <table tableName="sys_acl" domainObjectName="SysAcl" enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false" enableSelectByExample="false" selectByExampleQueryId="false" /> 5 <table tableName="sys_acl_module" domainObjectName="SysAclModule" enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false" enableSelectByExample="false" selectByExampleQueryId="false" /> 6 <table tableName="sys_role" domainObjectName="SysRole" enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false" enableSelectByExample="false" selectByExampleQueryId="false" /> 7 <table tableName="sys_role_acl" domainObjectName="SysRoleAcl" enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false" enableSelectByExample="false" selectByExampleQueryId="false" /> 8 <table tableName="sys_role_user" domainObjectName="SysRoleUser" enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false" enableSelectByExample="false" selectByExampleQueryId="false" /> 9 <table tableName="sys_log" domainObjectName="SysLog" enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false" enableSelectByExample="false" selectByExampleQueryId="false" /> View Code

第四步：生成核心代碼

打開IDEA的Terminal，輸入命令如下圖所示

生成核心代碼，將會出現你做配制的路徑下。

轉載于:https://www.cnblogs.com/chenyanlong/p/10697447.html

總結

以上是生活随笔為你收集整理的核心类生成-Mybatis Generator的使用的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。