springboot创建项目并使用mybatis generator生成实体类

最新推荐文章于 2023-06-26 14:52:29 发布

重装系统20块谢谢

最新推荐文章于 2023-06-26 14:52:29 发布

阅读量354

点赞数

分类专栏：后端 springboot maven

本文链接：https://blog.youkuaiyun.com/qq_37828633/article/details/86759709

版权

后端同时被 3 个专栏收录

12 篇文章

订阅专栏

springboot

9 篇文章

订阅专栏

maven

1 篇文章

订阅专栏

本文介绍了如何使用Eclipse和Maven快速创建一个SpringBoot Web项目，并结合MyBatis Generator来生成数据库对应的实体类。详细步骤包括配置数据库连接、设置MyBatis Generator的XML文件、配置`application.properties`以及修改`pom.xml`以添加相关依赖。通过运行Maven目标，可以自动生成UserDo和UserPasswordDo等实体类。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

使用eclispe配合maven快速创建一个web项目，并且为其建立一个数据库

然后可以找到src文件夹下的main文件夹

打开main文件夹里面的java文件夹

新建dao文件夹、dataobject文件夹。

回退到main文件夹下面新建resources文件夹

resources文件夹下面在新建一个 mapping 文件夹、一个叫 application.properties的 file文件、一个叫 mybatis-generator.xml的xml文件

mybatis-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>

<context id="infoGuardian">

<commentGenerator >
<property name="suppressAllComments" value="false"/>
<property name="suppressDate" value="true" /> 
</commentGenerator>

<jdbcConnection driverClass="com.mysql.jdbc.Driver"
connectionURL="jdbc:mysql://127.0.0.1:3306/miaosha" userId="root"
password="" />

<javaTypeResolver>

<property name="forceBigDecimals" value="false"/>
</javaTypeResolver>

<javaModelGenerator targetPackage="com.miaoshaproject.dataobject"
targetProject="src/main/java" >

<property name="enableSubPackages" value="false"/>

<property name="trimStrings" value="true"/>
</javaModelGenerator>

<sqlMapGenerator targetPackage="mapping"
targetProject="src/main/resources" >

<property name="enableSubPackages" value="true" />
</sqlMapGenerator>

<javaClientGenerator targetPackage="com.miaoshaproject.dao"
targetProject="src/main/java" type="XMLMAPPER" >

<property name="enableSubPackages" value="true" />
</javaClientGenerator>

<table tableName="user_info" domainObjectName="UserDo" enableCountByExample="false"
enableUpdateByExample="false" enableDeleteByExample="false"
enableSelectByExample="false" selectByExampleQueryId="false"></table>
<table tableName="user_password" domainObjectName="UserPasswordDo" enableCountByExample="false"
enableUpdateByExample="false" enableDeleteByExample="false"
enableSelectByExample="false" selectByExampleQueryId="false"></table>

</context>
</generatorConfiguration>

application.properties内容

server.port=8081
mybatis.mapperLocations=classpath:mapping/*.xml

spring.datasource.name=miaosha
spring.datasource.url=jdbc:mysql://127.0.0.1:3306/miaosha
spring.datasource.username=root
spring.datasource.password=

#use druid data source
spring.datasource.type=com.alibaba.druid.pool.DruidDataSource
spring.datasource.driverClassName=com.mysql.jdbc.Driver

找到pom.xml文件，修改内容

<groupId>com.miaoshaproject</groupId>
<artifactId>miaosha</artifactId>
<version>0.0.1-SNAPSHOT</version>
<packaging>jar</packaging>


<parent>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-parent</artifactId>
<version>2.0.5.RELEASE</version>
</parent>

<name>miaosha</name>
<url>http://maven.apache.org</url>

<dependencies>

   
   <dependency>
   <groupId>org.springframework.boot</groupId>
   <artifactId>spring-boot-starter-web</artifactId>
   </dependency>

   
       <dependency>
           <groupId>mysql</groupId>
           <artifactId>mysql-connector-java</artifactId>
           <version>5.1.41</version>
       </dependency>

   
       <dependency>
           <groupId>com.alibaba</groupId>
           <artifactId>druid</artifactId>
           <version>1.1.3</version>
       </dependency>

   
       <dependency>
           <groupId>org.mybatis.spring.boot</groupId>
           <artifactId>mybatis-spring-boot-starter</artifactId>
           <version>1.3.1</version>
       </dependency>

<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>3.8.1</version>
<scope>test</scope>
</dependency>
</dependencies>



   <build>
       <plugins>
           
           <plugin>
               <groupId>org.mybatis.generator</groupId>
               <artifactId>mybatis-generator-maven-plugin</artifactId>
   <version>1.3.5</version>
   <dependencies>
       <dependency>
       <groupId>org.mybatis.generator</groupId>
               <artifactId>mybatis-generator-core</artifactId>
               <version>1.3.5</version>
       </dependency>
       <dependency>
       <groupId>mysql</groupId>
               <artifactId>mysql-connector-java</artifactId>
               <version>5.1.41</version>
       </dependency>
   </dependencies>
   <executions>
       <execution>
           <id>mybatis generator</id>
           <phase>package</phase>
           <goals>
           <goal>generate</goal>
           </goals>
       </execution>
   </executions>

   <configuration>
       
       <verbose>true</verbose>
       
       <overwrite>true</overwrite>
       <configurationFile>src/main/resources/mybatis-generator.xml</configurationFile>
   </configuration>
           </plugin>
       </plugins>
   </build>
</project>