Mybatis启用逆向工程自动根据数据库信息生成mapper和pojo-----Mybatis框架

蔚落 2024-03-02 08:08 10阅读 0赞

>     连接数据库的用户名密码,动态生成数据库信息使用
>     正向是从java程序到数据库表,逆向就是指从数据库表逆推出java程序需要的内容
>     pojo类名,包名以及生成位置
>     mapper文件名以及生成位置
>     mapper接口名以及生成位置
>     连接数据库的信息
>     指定哪些表参与逆向工程
> 
>     连接数据库的用户名密码,动态生成数据库信息使用
>     正向是从java程序到数据库表,逆向就是指从数据库表逆推出java程序需要的内容
>     pojo类名,包名以及生成位置
>     mapper文件名以及生成位置
>     mapper接口名以及生成位置
>     连接数据库的信息
>     指定哪些表参与逆向工程

>     <?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>
>     
>         
>     
>         
>     
>         <context id="DB2Tables"  targetRuntime="MyBatis3">
>             
>             <plugin type="org.mybatis.generator.plugins.UnmergeableXmlMappersPlugin" />
>             
>     
>             
>     
>             
>     
>     
>             <commentGenerator>
>                 
>     
>                 
>                 <property name="suppressDate" value="true"/>
>                 
>                 <property name="suppressAllComments" value="true"/>
>                 
>     
>                 
>     
>                 
>     
>             </commentGenerator>
>     
>             
>             <jdbcConnection driverClass="com.mysql.cj.jdbc.Driver"
>                             connectionURL="jdbc:mysql://127.0.0.1:13306/powernode?useUnicode=true&characterEncoding=UTF-8"
>                             userId="root" password="abc123">
>             </jdbcConnection>
>     
>             
>     
>                 
>     
>     
>     
>             
>             <javaModelGenerator targetPackage="com.powernode.mybatis.pojo" targetProject="src/main/java">
>                 
>                 <property name="enableSubPackages" value="true"/>
>                 
>                 <property name="trimStrings" value="true"/>
>             </javaModelGenerator>
>     
>             
>             <sqlMapGenerator targetPackage="com.powernode.mybatis.mappers" targetProject="src/main/resources">
>                 <property name="enableSubPackages" value="true"/>
>             </sqlMapGenerator>
>     
>             
>             <javaClientGenerator type="xmlMapper" targetPackage="com.powernode.mybatis.mappers" targetProject="src/main/java">
>                 <property name="enableSubPackages" value="true"/>
>             </javaClientGenerator>
>     
>             
>             <table tableName="t_car" domainObjectName="Car">
>     
>     
>     
>     
>     
>             </table>
>     
>         </context>
>     </generatorConfiguration>
> 
>     <?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>
>     
>         
>     
>         
>     
>         <context id="DB2Tables"  targetRuntime="MyBatis3">
>             
>             <plugin type="org.mybatis.generator.plugins.UnmergeableXmlMappersPlugin" />
>             
>     
>             
>     
>             
>     
>     
>             <commentGenerator>
>                 
>     
>                 
>                 <property name="suppressDate" value="true"/>
>                 
>                 <property name="suppressAllComments" value="true"/>
>                 
>     
>                 
>     
>                 
>     
>             </commentGenerator>
>     
>             
>             <jdbcConnection driverClass="com.mysql.cj.jdbc.Driver"
>                             connectionURL="jdbc:mysql://127.0.0.1:13306/powernode?useUnicode=true&characterEncoding=UTF-8"
>                             userId="root" password="abc123">
>             </jdbcConnection>
>     
>             
>     
>                 
>     
>     
>     
>             
>             <javaModelGenerator targetPackage="com.powernode.mybatis.pojo" targetProject="src/main/java">
>                 
>                 <property name="enableSubPackages" value="true"/>
>                 
>                 <property name="trimStrings" value="true"/>
>             </javaModelGenerator>
>     
>             
>             <sqlMapGenerator targetPackage="com.powernode.mybatis.mappers" targetProject="src/main/resources">
>                 <property name="enableSubPackages" value="true"/>
>             </sqlMapGenerator>
>     
>             
>             <javaClientGenerator type="xmlMapper" targetPackage="com.powernode.mybatis.mappers" targetProject="src/main/java">
>                 <property name="enableSubPackages" value="true"/>
>             </javaClientGenerator>
>     
>             
>             <table tableName="t_car" domainObjectName="Car">
>     
>     
>     
>     
>     
>             </table>
>     
>         </context>
>     </generatorConfiguration>

>     <?xml version="1.0" encoding="UTF-8"?>
>     <project xmlns="http://maven.apache.org/POM/4.0.0"
>              xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
>              xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
>         <modelVersion>4.0.0</modelVersion>
>     
>         <groupId>com.powernode</groupId>
>         <artifactId>mybatis-012-generator1</artifactId>
>         <version>1.0-SNAPSHOT</version>
>         <packaging>jar</packaging>
>         <dependencies>
>             <dependency>
>                 <groupId>mysql</groupId>
>                 <artifactId>mysql-connector-java</artifactId>
>                 <version>8.0.33</version>
>             </dependency>
>             <dependency>
>                 <groupId>org.mybatis</groupId>
>                 <artifactId>mybatis</artifactId>
>                 <version>3.5.10</version>
>             </dependency>
>             <dependency>
>                 <groupId>ch.qos.logback</groupId>
>                 <artifactId>logback-classic</artifactId>
>                 <version>1.2.11</version>
>             </dependency>
>     
>         </dependencies>
>         <properties>
>             <maven.compiler.source>17</maven.compiler.source>
>             <maven.compiler.target>17</maven.compiler.target>
>             <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
>         </properties>
>     
>         <build>
>     
>             <plugins>
>                 <plugin>
>     
>                     <groupId>org.mybatis.generator</groupId>
>                     <artifactId>mybatis-generator-maven-plugin</artifactId>
>                     <version>1.4.2</version>
>     
>                     <configuration>
>                         <overwrite>true</overwrite>
>                     </configuration>
>                     <dependencies>
>                         <dependency>
>                             <groupId>mysql</groupId>
>                             <artifactId>mysql-connector-java</artifactId>
>                             <version>8.0.33</version>
>                         </dependency>
>                     </dependencies>
>                 </plugin>
>             </plugins>
>         </build>
>     </project>
> 
>     <?xml version="1.0" encoding="UTF-8"?>
>     <project xmlns="http://maven.apache.org/POM/4.0.0"
>              xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
>              xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
>         <modelVersion>4.0.0</modelVersion>
>     
>         <groupId>com.powernode</groupId>
>         <artifactId>mybatis-012-generator1</artifactId>
>         <version>1.0-SNAPSHOT</version>
>         <packaging>jar</packaging>
>         <dependencies>
>             <dependency>
>                 <groupId>mysql</groupId>
>                 <artifactId>mysql-connector-java</artifactId>
>                 <version>8.0.33</version>
>             </dependency>
>             <dependency>
>                 <groupId>org.mybatis</groupId>
>                 <artifactId>mybatis</artifactId>
>                 <version>3.5.10</version>
>             </dependency>
>             <dependency>
>                 <groupId>ch.qos.logback</groupId>
>                 <artifactId>logback-classic</artifactId>
>                 <version>1.2.11</version>
>             </dependency>
>     
>         </dependencies>
>         <properties>
>             <maven.compiler.source>17</maven.compiler.source>
>             <maven.compiler.target>17</maven.compiler.target>
>             <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
>         </properties>
>     
>         <build>
>     
>             <plugins>
>                 <plugin>
>     
>                     <groupId>org.mybatis.generator</groupId>
>                     <artifactId>mybatis-generator-maven-plugin</artifactId>
>                     <version>1.4.2</version>
>     
>                     <configuration>
>                         <overwrite>true</overwrite>
>                     </configuration>
>                     <dependencies>
>                         <dependency>
>                             <groupId>mysql</groupId>
>                             <artifactId>mysql-connector-java</artifactId>
>                             <version>8.0.33</version>
>                         </dependency>
>                     </dependencies>
>                 </plugin>
>             </plugins>
>         </build>
>     </project>