éè¿å½ä»¤è¡è¿è¡MyBatis Generator
åå¤æ°æ®è¡¨
ä¸¤å¼ è¡¨
oa_staff
CREATE TABLE `oa_staff` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(45) NOT NULL COMMENT 'åå',
`gender` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'æ§å«ï¼0->ç·ï¼1->女',
`birthday` date DEFAULT NULL,
`address` varchar(80) DEFAULT NULL COMMENT 'ä½å',
`native_place` varchar(80) DEFAULT NULL COMMENT 'ç±è´¯',
`hiredate` date DEFAULT NULL COMMENT 'å
¥èæ¥æ',
`gmt_create` datetime DEFAULT NULL,
`gmt_modified` datetime DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COMMENT='å工信æ¯'
oa_user
CREATE TABLE `oa_user` (
`id` bigint(20) unsigned NOT NULL,
`username` varchar(16) NOT NULL COMMENT 'ç¨æ·å',
`password` varchar(32) NOT NULL COMMENT 'å¯ç ',
`email` varchar(255) DEFAULT NULL COMMENT 'é®ç®±',
`gmt_create` datetime DEFAULT NULL,
`gmt_modified` datetime DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='oaç³»ç»ç¨æ·'
ä¸è½½ä¾èµçjarå
å¯ä»¥å» 以ä¸ç½ç«æç´¢
mybatis-generator-core
ã
mysql-connector-java
https://mvnrepository.com/
https://mvnrepository.com/
æ¯å¦ï¼
ä¸è½½å°åï¼
https://repo1.maven.org/maven2/org/mybatis/generator/mybatis-generator-core/1.4.0/mybatis-generator-core-1.4.0.jar
https://repo1.maven.org/maven2/mysql/mysql-connector-java/8.0.19/mysql-connector-java-8.0.19.jar
åå¤é ç½®æ件
<!DOCTYPE generatorConfiguration PUBLIC
"-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN"
"http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd">
<generatorConfiguration>
<context id="simple" targetRuntime="MyBatis3Simple">
<jdbcConnection driverClass="com.mysql.cj.jdbc.Driver"
connectionURL="jdbc:mysql://192.168.56.101:3306/db_example?characterEncoding=utf8&autoReconnect=true&serverTimezone=PRC"
userId="root" password="123456"/>
<javaModelGenerator targetPackage="com.example.model" targetProject="generate-files/java"/>
<sqlMapGenerator targetPackage="com.example.mapper" targetProject="generate-files/xml"/>
<javaClientGenerator type="XMLMAPPER" targetPackage="com.example.mapper" targetProject="generate-files/java"/>
<table tableName="oa_staff">
<generatedKey column="id" sqlStatement="MySql" />
</table>
<table tableName="oa_user" />
</context>
</generatorConfiguration>
è¿è¡çæ
å ¶ä¸
targetProject
æå®ç®å½å¿ é¡»å å建ï¼å¦åçæ失败ã
è¿è¡åï¼ç®å½ç»æå¦ä¸ï¼
E:\***\MBG-command>tree /F
å· æ°å å· çæ件夹 PATH å表
å·åºåå·ä¸º 5248-2E8E
E:.
â generatorConfig.xml
â mybatis-generator-core-1.4.0.jar
â mysql-connector-java-8.0.19.jar
â
ââgenerate-files
ââjava
ââxml
æ§è¡å½ä»¤ï¼
java -cp mybatis-generator-core-1.4.0.jar;mysql-connector-java-8.0.19.jar org.mybatis.generator.api.ShellRunner -configfile generatorConfig.xml
çæç®å½ç»æï¼
E:\***\MBG-command>tree /F
å· æ°å å· çæ件夹 PATH å表
å·åºåå·ä¸º 5248-2E8E
E:.
â generatorConfig.xml
â mybatis-generator-core-1.4.0.jar
â mysql-connector-java-8.0.19.jar
â
ââgenerate-files
ââjava
â ââcom
â ââexample
â ââmapper
â â OaStaffMapper.java
â â OaUserMapper.java
â â
â ââmodel
â OaStaff.java
â OaUser.java
â
ââxml
ââcom
ââexample
ââmapper
OaStaffMapper.xml
OaUserMapper.xml
å®æ´ä»£ç
https://gitee.com/tobybiao/MBG-examples