mybatis自己主動生成mapper,dao,映射檔案

一.先建立資料腳本，這裡用的mysql資料腳本

drop table VOTE_ITEM; 
drop table VOTE_OPTION; 
drop table VOTE_SUBJECT; 
drop table VOTE_USER; 
 
 
create table VOTE_USER 
( 
  VU_USER_ID   int(8) primary key,  
  VU_USER_NAME VARCHAR(20) not null,  
  VU_PASSWORD  VARCHAR(20) not null,  
  VU_STATUS    int(6) not null,  
  VU_VERSION   int(8) not null  
); 
   
create table VOTE_SUBJECT 
( 
  VS_ID    int(8) primary key, 
  VS_TITLE VARCHAR(200) not null, 
  VS_TYPE  int(6) not null 
); 
 
create table VOTE_OPTION 
( 
  VO_ID     int(8) primary key, 
   VS_ID     int(8) not null, 
  VO_OPTION VARCHAR(200) not null, 
  VO_ORDER  int(8) not null 
); 
 
create table VOTE_ITEM 
( 
  VI_ID      int(8) primary key, 
  VS_ID      int(8) not null, 
  VO_ID      int(8) not null, 
  VU_USER_ID int(8) not null 
); 
 
insert into VOTE_USER (VU_USER_ID, VU_USER_NAME, VU_PASSWORD, VU_STATUS, VU_VERSION) 
values (1001, 'ss', 'a', 1, 1); 
insert into VOTE_USER (VU_USER_ID, VU_USER_NAME, VU_PASSWORD, VU_STATUS, VU_VERSION) 
values (1002, 'admin', 'a', 2, 1); 
insert into VOTE_USER (VU_USER_ID, VU_USER_NAME, VU_PASSWORD, VU_STATUS, VU_VERSION) 
values (1003, 'zy', 'a', 1, 0); 
insert into VOTE_USER (VU_USER_ID, VU_USER_NAME, VU_PASSWORD, VU_STATUS, VU_VERSION) 
values (1004, 'yc', 'a', 2, 0); 
insert into VOTE_USER (VU_USER_ID, VU_USER_NAME, VU_PASSWORD, VU_STATUS, VU_VERSION) 
values (1005, 'yc1', 'a', 2, 1); 
insert into VOTE_USER (VU_USER_ID, VU_USER_NAME, VU_PASSWORD, VU_STATUS, VU_VERSION) 
values (1006, 'yc2', 'a', 2, 1); 
insert into VOTE_USER (VU_USER_ID, VU_USER_NAME, VU_PASSWORD, VU_STATUS, VU_VERSION) 
values (1007, 'yc3', 'a', 2, 1); 
insert into VOTE_USER (VU_USER_ID, VU_USER_NAME, VU_PASSWORD, VU_STATUS, VU_VERSION) 
values (1008, 'yc4', 'a', 2, 1); 
insert into VOTE_USER (VU_USER_ID, VU_USER_NAME, VU_PASSWORD, VU_STATUS, VU_VERSION) 
values (1009, 'yc5', 'a', 2, 1); 
insert into VOTE_USER (VU_USER_ID, VU_USER_NAME, VU_PASSWORD, VU_STATUS, VU_VERSION) 
values (1010, 'yc6', 'a', 1, 0); 
 
insert into VOTE_SUBJECT (VS_ID, VS_TITLE, VS_TYPE) 
values (103, '選出你心目中最好的下載下傳工具', 2); 
insert into VOTE_SUBJECT (VS_ID, VS_TITLE, VS_TYPE) 
values (104, '選出你心目中最好的輸入法', 1); 
insert into VOTE_SUBJECT (VS_ID, VS_TITLE, VS_TYPE) 
values (105, '選出你心目中最好的網絡聊天工具', 1); 
insert into VOTE_SUBJECT (VS_ID, VS_TITLE, VS_TYPE) 
values (440, '你最想區的地方', 1); 
insert into VOTE_SUBJECT (VS_ID, VS_TITLE, VS_TYPE) 
values (101, '選出你心目中最好的浏覽器', 1); 
insert into VOTE_SUBJECT (VS_ID, VS_TITLE, VS_TYPE) 
values (102, '選出你心目中最好的防毒軟體', 1); 
 
insert into VOTE_OPTION (VO_ID, VO_OPTION, VS_ID, VO_ORDER) 
values (397, '騰訊QQ', 105, 1); 
insert into VOTE_OPTION (VO_ID, VO_OPTION, VS_ID, VO_ORDER) 
values (398, 'MSN', 105, 2); 
insert into VOTE_OPTION (VO_ID, VO_OPTION, VS_ID, VO_ORDER) 
values (380, '迅雷', 103, 1); 
insert into VOTE_OPTION (VO_ID, VO_OPTION, VS_ID, VO_ORDER) 
values (399, '新浪UC', 105, 3); 
insert into VOTE_OPTION (VO_ID, VO_OPTION, VS_ID, VO_ORDER) 
values (400, '飛信', 105, 4); 
insert into VOTE_OPTION (VO_ID, VO_OPTION, VS_ID, VO_ORDER) 
values (401, 'Skype', 105, 5); 
insert into VOTE_OPTION (VO_ID, VO_OPTION, VS_ID, VO_ORDER) 
values (402, '阿裡旺旺', 105, 6); 
insert into VOTE_OPTION (VO_ID, VO_OPTION, VS_ID, VO_ORDER) 
values (403, '百度HI', 105, 7); 
insert into VOTE_OPTION (VO_ID, VO_OPTION, VS_ID, VO_ORDER) 
values (404, '微軟IE浏覽器', 101, 1); 
insert into VOTE_OPTION (VO_ID, VO_OPTION, VS_ID, VO_ORDER) 
values (405, '火狐（Firefox）浏覽器', 101, 2); 
insert into VOTE_OPTION (VO_ID, VO_OPTION, VS_ID, VO_ORDER) 
values (381, '網際快車', 103, 2); 
insert into VOTE_OPTION (VO_ID, VO_OPTION, VS_ID, VO_ORDER) 
values (382, '電驢', 103, 3); 
insert into VOTE_OPTION (VO_ID, VO_OPTION, VS_ID, VO_ORDER) 
values (383, '比特精靈', 103, 4); 
insert into VOTE_OPTION (VO_ID, VO_OPTION, VS_ID, VO_ORDER) 
values (384, '超級旋風', 103, 5); 
insert into VOTE_OPTION (VO_ID, VO_OPTION, VS_ID, VO_ORDER) 
values (385, '搜狗拼音', 104, 1); 
insert into VOTE_OPTION (VO_ID, VO_OPTION, VS_ID, VO_ORDER) 
values (386, '搜狗五筆', 104, 2); 
insert into VOTE_OPTION (VO_ID, VO_OPTION, VS_ID, VO_ORDER) 
values (387, 'QQ拼音', 104, 3); 
insert into VOTE_OPTION (VO_ID, VO_OPTION, VS_ID, VO_ORDER) 
values (388, 'QQ五筆', 104, 4); 
insert into VOTE_OPTION (VO_ID, VO_OPTION, VS_ID, VO_ORDER) 
values (389, '谷歌拼音', 104, 5); 
insert into VOTE_OPTION (VO_ID, VO_OPTION, VS_ID, VO_ORDER) 
values (390, '紫光拼音', 104, 6); 
insert into VOTE_OPTION (VO_ID, VO_OPTION, VS_ID, VO_ORDER) 
values (391, '智能ABC', 104, 7); 
insert into VOTE_OPTION (VO_ID, VO_OPTION, VS_ID, VO_ORDER) 
values (392, '微軟拼音', 104, 8); 
insert into VOTE_OPTION (VO_ID, VO_OPTION, VS_ID, VO_ORDER) 
values (393, '萬能拼音', 104, 9); 
insert into VOTE_OPTION (VO_ID, VO_OPTION, VS_ID, VO_ORDER) 
values (394, '萬能五筆', 104, 10); 
insert into VOTE_OPTION (VO_ID, VO_OPTION, VS_ID, VO_ORDER) 
values (395, '極品拼音', 104, 11); 
insert into VOTE_OPTION (VO_ID, VO_OPTION, VS_ID, VO_ORDER) 
values (396, '極品五筆', 104, 12); 
insert into VOTE_OPTION (VO_ID, VO_OPTION, VS_ID, VO_ORDER) 
values (406, '世界之窗浏覽器', 101, 3); 
insert into VOTE_OPTION (VO_ID, VO_OPTION, VS_ID, VO_ORDER) 
values (407, '360浏覽器', 101, 4); 
insert into VOTE_OPTION (VO_ID, VO_OPTION, VS_ID, VO_ORDER) 
values (408, '傲遊浏覽器', 101, 5); 
insert into VOTE_OPTION (VO_ID, VO_OPTION, VS_ID, VO_ORDER) 
values (409, '谷歌（Chrome）浏覽器', 101, 6); 
insert into VOTE_OPTION (VO_ID, VO_OPTION, VS_ID, VO_ORDER) 
values (410, '卡巴斯基', 102, 1); 
insert into VOTE_OPTION (VO_ID, VO_OPTION, VS_ID, VO_ORDER) 
values (411, '360殺毒', 102, 2); 
insert into VOTE_OPTION (VO_ID, VO_OPTION, VS_ID, VO_ORDER) 
values (412, 'McAfee', 102, 3); 
insert into VOTE_OPTION (VO_ID, VO_OPTION, VS_ID, VO_ORDER) 
values (413, 'AVG', 102, 4); 
insert into VOTE_OPTION (VO_ID, VO_OPTION, VS_ID, VO_ORDER) 
values (414, '諾頓殺毒', 102, 5); 
insert into VOTE_OPTION (VO_ID, VO_OPTION, VS_ID, VO_ORDER) 
values (415, '瑞星殺毒', 102, 6); 
insert into VOTE_OPTION (VO_ID, VO_OPTION, VS_ID, VO_ORDER) 
values (416, '金山毒霸', 102, 7); 
insert into VOTE_OPTION (VO_ID, VO_OPTION, VS_ID, VO_ORDER) 
values (417, '江民殺毒', 102, 8); 
insert into VOTE_OPTION (VO_ID, VO_OPTION, VS_ID, VO_ORDER) 
values (418, '微點防禦', 102, 9); 
insert into VOTE_OPTION (VO_ID, VO_OPTION, VS_ID, VO_ORDER) 
values (419, '趨勢殺毒', 102, 10); 
insert into VOTE_OPTION (VO_ID, VO_OPTION, VS_ID, VO_ORDER) 
values (441, '地域', 440, 1); 
insert into VOTE_OPTION (VO_ID, VO_OPTION, VS_ID, VO_ORDER) 
values (442, '天堂', 440, 2); 
 
insert into VOTE_ITEM (VI_ID, VO_ID, VS_ID, VU_USER_ID) 
values (422, 405, 101, 1005); 
insert into VOTE_ITEM (VI_ID, VO_ID, VS_ID, VU_USER_ID) 
values (423, 405, 101, 1006); 
insert into VOTE_ITEM (VI_ID, VO_ID, VS_ID, VU_USER_ID) 
values (424, 404, 101, 1007); 
insert into VOTE_ITEM (VI_ID, VO_ID, VS_ID, VU_USER_ID) 
values (425, 407, 101, 1008); 
insert into VOTE_ITEM (VI_ID, VO_ID, VS_ID, VU_USER_ID) 
values (426, 408, 101, 1009); 
insert into VOTE_ITEM (VI_ID, VO_ID, VS_ID, VU_USER_ID) 
values (427, 409, 101, 1004); 
insert into VOTE_ITEM (VI_ID, VO_ID, VS_ID, VU_USER_ID) 
values (445, 404, 101, 1003); 
insert into VOTE_ITEM (VI_ID, VO_ID, VS_ID, VU_USER_ID) 
values (367, 136, 135, 1002); 
insert into VOTE_ITEM (VI_ID, VO_ID, VS_ID, VU_USER_ID) 
values (420, 405, 101, 1002); 
insert into VOTE_ITEM (VI_ID, VO_ID, VS_ID, VU_USER_ID) 
values (421, 406, 101, 1001); 
 
commit; 
 
select * from VOTE_USER; 
select * from VOTE_SUBJECT; 
select * from VOTE_OPTION; 
select * from VOTE_ITEM;

Linux下操作指令:

create database vote  character set utf8;
use vote;
source 全路徑下的腳本檔案位址

generator.xml檔案

<?xml version="1.0" encoding="UTF-8"?

> <!DOCTYPE generatorConfiguration PUBLIC "-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN" "http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd"> <generatorConfiguration>   <classPathEntry location="/home/a/workspace/MavenRepository/mysql/mysql-connector-java/5.1.36/mysql-connector-java-5.1.36.jar" /> <context id="DB2Tables" targetRuntime="MyBatis3"> <commentGenerator> <property name="suppressAllComments" value="true" /> </commentGenerator>   <jdbcConnection driverClass="com.mysql.jdbc.Driver" connectionURL="jdbc:mysql://localhost:3306/vote" userId="root" password="a"> </jdbcConnection> <javaTypeResolver> <property name="forceBigDecimals" value="false" /> </javaTypeResolver>  <javaModelGenerator targetPackage="com.yc.vote.entity" targetProject="/usr/local/mybatisutil/src"> <property name="enableSubPackages" value="true" /> <property name="trimStrings" value="true" /> </javaModelGenerator>  <sqlMapGenerator targetPackage="mapper" targetProject="/usr/local/mybatisutil/src"> <property name="enableSubPackages" value="true" /> </sqlMapGenerator>  <javaClientGenerator type="XMLMAPPER" targetPackage="com.yc.vote.mapper" targetProject="/usr/local/mybatisutil/src"> <property name="enableSubPackages" value="true" /> </javaClientGenerator>  <table tableName="VOTE_ITEM" domainObjectName="Item" enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false" enableSelectByExample="false" selectByExampleQueryId="false" /> <table tableName="VOTE_OPTION" domainObjectName="Option" enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false" enableSelectByExample="false" selectByExampleQueryId="false" /> <table tableName="VOTE_SUBJECT" domainObjectName="Subject" enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false" enableSelectByExample="false" selectByExampleQueryId="false" /> <table tableName="VOTE_USER" domainObjectName="User" enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false" enableSelectByExample="false" selectByExampleQueryId="false" /> </context> </generatorConfiguration>

要改動的地方，驅動包的路徑，mysql包的路徑。連結資料庫的配置。生成包的路徑，還所最後凝視上說的

<!-- 要生成那些表(更改tableName和domainObjectName就能夠) -->

最後寫個執行腳本，window下建立bat字尾檔案,Linub下建立sh字尾檔案

@echo '開始'

java -jar mybatis-generator-core-1.3.2.jar -configfile generator.xml -overwrite

@echo '結束'
@pause

上面的認為麻煩就直接輸入中間那一行代碼就能夠跑起來了

mybatis自己主動生成mapper,dao,映射檔案

繼續閱讀

27 Best Free Eclipse Plug-ins for Java Developer to be ProductiveCode Quality PluginsText Editor PluginsDependency ManagementVersion Control Integration PluginsFramework Development Continuous Integration Related PluginsOther Utility Plugins

Java String.format方法的簡單使用

neo4j之cypher使用文檔

GitHub連夜封殺！這份阿裡 10W 字内部 Java 字面試手冊到底有多強？

spark/scala關于【資源檔案】加載方法概述外部檔案加載方案測試資源檔案打包入jar包中小結

NOSQL安全攻擊

mybatis_入門程式Mybatis入門

AOP程式設計_Android優雅權限架構(1)概念基礎，2021金三銀四前言正文大綱正文

登入plsql 報錯 the account is locked --使用者被鎖

Effective Java 8:通用程式設計

SequoiaDB巨杉資料庫C++驅動概述

OOM三種類型

工廠模式-三種類型

【遞歸】高效率求2的n次幂

win10本地scala和spark安裝安裝scala安裝spark

scala (3) Function 和 Method