springboot+maven+mybatis+mysql实现增删查改1

客官°小女子只卖身不卖艺 2021-10-15 04:17 181阅读 0赞

## 1、搭建一个springboot项目 ##

new project---》spring initializr---》next

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxNTM0MTE1_size_16_color_FFFFFF_t_70][]

适当修改group和artifact，然后next

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxNTM0MTE1_size_16_color_FFFFFF_t_70 1][]

这个页面勾选自己需要的，不勾选也行，我这里是没勾选，依赖通过maven添加

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxNTM0MTE1_size_16_color_FFFFFF_t_70 2][]

点击finish，一个springboot项目就创建成功了

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxNTM0MTE1_size_16_color_FFFFFF_t_70 3][]

## 2、生成逆向工程 ##

创建目录

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxNTM0MTE1_size_16_color_FFFFFF_t_70 4][]

pom.xml文件

<?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>
        <parent>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-parent</artifactId>
            <version>1.5.18.RELEASE</version>
            <relativePath/> 
        </parent>
        <groupId>com.jie</groupId>
        <artifactId>book</artifactId>
        <version>0.0.1-SNAPSHOT</version>
        <name>book</name>
        <description>Demo project for Spring Boot</description>
    
        <properties>
            <java.version>1.8</java.version>
        </properties>
    
        <dependencies>
            
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-cache</artifactId>
            </dependency>
    
            
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-data-redis</artifactId>
            </dependency>
    
    
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-web</artifactId>
            </dependency>
    
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-test</artifactId>
                <scope>test</scope>
            </dependency>
    
            
            <dependency>
                <groupId>mysql</groupId>
                <artifactId>mysql-connector-java</artifactId>
                <version>5.1.46</version>
            </dependency>
    
            
            <dependency>
                <groupId>com.alibaba</groupId>
                <artifactId>fastjson</artifactId>
                <version>1.2.47</version>
            </dependency>
    
            <dependency>
                <groupId>net.sourceforge.nekohtml</groupId>
                <artifactId>nekohtml</artifactId>
                <version>1.9.22</version>
            </dependency>
    
            
            <dependency>
                <groupId>org.mybatis.generator</groupId>
                <artifactId>mybatis-generator-core</artifactId>
                <version>1.3.2</version>
            </dependency>
    
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-thymeleaf</artifactId>
            </dependency>
    
            <dependency>
                <groupId>org.mybatis.spring.boot</groupId>
                <artifactId>mybatis-spring-boot-starter</artifactId>
                <version>1.3.0</version>
            </dependency>
        </dependencies>
    
        <build>
            <plugins>
                <plugin>
                    <groupId>org.springframework.boot</groupId>
                    <artifactId>spring-boot-maven-plugin</artifactId>
                </plugin>
            </plugins>
        </build>
    
    </project>

application.properties文件

spring.datasource.platform=mysql
    spring.datasource.url=jdbc:mysql://localhost/books
    spring.datasource.username=root
    spring.datasource.password=970817
    spring.datasource.driverClassName=com.mysql.jdbc.Driver
    
    server.port=8080
    server.session-timeout=30
    server.tomcat.uri-encoding=UTF-8
    
    #####springboot 整合 mybatis
    mybatis.mapper-locations=classpath:/com/jie/book/mapper/*Mapper.xml
    mybatis.config-location=classpath:/com/jie/book/mapper/config/mybatis-config.xml
    #####定义别名
    mybatis.type-aliases-package=com.jie.book.domain
    
    ###Thymeleaf配置
    spring.thymeleaf.prefix=classpath:/views/
    spring.thymeleaf.suffix=.html
    spring.thymeleaf.cache=false
    spring.thymeleaf.encoding=UTF-8
    spring.thymeleaf.mode=LEGACYHTML5
    ###过滤中文乱码
    spring.http.encoding.force=true
    spring.http.encoding.charset=UTF-8
    spring.http.encoding.enabled=true

添加逆向工程所需的文件

mybatis-config.xml文件

<?xml version="1.0" encoding="UTF-8" ?>
    <!DOCTYPE configuration
            PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
            "http://mybatis.org/dtd/mybatis-3-config.dtd">
    <configuration>
        <settings>
            
            <setting name="cacheEnabled" value="false"/>
            
            <setting name="lazyLoadingEnabled" value="true"/>
            
            
            <setting name="multipleResultSetsEnabled" value="true"/>
            <setting name="useColumnLabel" value="true"/>
            <setting name="useGeneratedKeys" value="true"/>
            <setting name="autoMappingBehavior" value="PARTIAL"/>
            <setting name="autoMappingUnknownColumnBehavior" value="WARNING"/>
            <setting name="defaultExecutorType" value="SIMPLE"/>
            <setting name="defaultStatementTimeout" value="25"/>
            <setting name="defaultFetchSize" value="100"/>
            <setting name="safeRowBoundsEnabled" value="false"/>
            
            <setting name="mapUnderscoreToCamelCase" value="true"/>
            <setting name="localCacheScope" value="SESSION"/>
            <setting name="jdbcTypeForNull" value="OTHER"/>
            <setting name="lazyLoadTriggerMethods" value="equals,clone,hashCode,toString"/>
        </settings>
    
        <typeAliases>
            
            
            
            
            <package name="com.jie.book.domain"></package>
        </typeAliases>
    
        
        
        
        
        
    
    
    </configuration>

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="D:\MySQL\mysql-connector-java-5.1.46\mysql-connector-java-5.1.46.jar" />
        <context id="mysql2Beans" targetRuntime="MyBatis3">
            <commentGenerator>
                
                <property name="suppressAllComments" value="true" />
                
                <property name="suppressDate" value="true" />
            </commentGenerator>
    
            <jdbcConnection driverClass="com.mysql.jdbc.Driver"
                            connectionURL="jdbc:mysql://localhost:3306/books?useSSL=false"
                            userId="root"
                            password="970817" />
    
            <javaTypeResolver>
                <property name="forceBigDecimals" value="false" />
            </javaTypeResolver>
    
            
            <javaModelGenerator targetPackage="com.jie.book.domain" targetProject="D:\WorkSpace\springbootTest\src\main\java">
                <property name="enableSubPackages" value="true" />
                <property name="trimStrings" value="true" />
            </javaModelGenerator>
    
    
    
            <sqlMapGenerator targetPackage="com.jie.book.mapper" targetProject="D:\WorkSpace\springbootTest\src\main\resources">
                <property name="enableSubPackages" value="true" />
            </sqlMapGenerator>
    
            
            <javaClientGenerator type="XMLMAPPER"
                                 targetPackage="com.jie.book.mapper"
                                 targetProject="D:\WorkSpace\springbootTest\src\main\java">
                
                <property name="enableSubPackages" value="false" />
            </javaClientGenerator>
    
            
            
            
            
            
    
    
            <table  tableName="book" domainObjectName="Book" enableCountByExample="false" enableUpdateByExample="false"
            enableDeleteByExample="false" enableSelectByExample="false" selectByExampleQueryId="false">
            </table>
    
    
    
        </context>
    </generatorConfiguration>

MyBatisGeneratorUtils.java文件

package com.jie.book.util;
    
    import org.mybatis.generator.api.MyBatisGenerator;
    import org.mybatis.generator.config.Configuration;
    import org.mybatis.generator.config.xml.ConfigurationParser;
    import org.mybatis.generator.exception.InvalidConfigurationException;
    import org.mybatis.generator.exception.XMLParserException;
    import org.mybatis.generator.internal.DefaultShellCallback;
    
    import java.io.File;
    import java.io.IOException;
    import java.sql.SQLException;
    import java.util.ArrayList;
    import java.util.List;
    
    public class MyBatisGeneratorUtils {
        public static void main(String[] args) {
            try {
                System.out.println("start generator ...");
                List<String> warnings = new ArrayList<String>();
                boolean overwrite = true;
                File configFile = new File(MyBatisGeneratorUtils.class.getResource("/generator.xml").getFile());
                ConfigurationParser cp = new ConfigurationParser(warnings);
                Configuration config = cp.parseConfiguration(configFile);
                DefaultShellCallback callback = new DefaultShellCallback(overwrite);
                MyBatisGenerator myBatisGenerator = new MyBatisGenerator(config, callback, warnings);
                myBatisGenerator.generate(null);
                System.out.println("end generator!");
            } catch (IOException e) {
                e.printStackTrace();
            } catch (XMLParserException e) {
                e.printStackTrace();
            } catch (InvalidConfigurationException e) {
                e.printStackTrace();
            } catch (SQLException e) {
                e.printStackTrace();
            } catch (InterruptedException e) {
                e.printStackTrace();
            }
        }
    }

运行MyBatisGeneratorUtils，生成

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxNTM0MTE1_size_16_color_FFFFFF_t_70 5][]

接下来就是写代码了，后面有空了在写！

完善后的代码请看[https://blog.csdn.net/qq\_41534115/article/details/99679186][https_blog.csdn.net_qq_41534115_article_details_99679186]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxNTM0MTE1_size_16_color_FFFFFF_t_70]: /images/20211015/0d76cbee57bf42fa8ea054144b3d2d5b.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxNTM0MTE1_size_16_color_FFFFFF_t_70 1]: /images/20211015/371a66fb9b974716a05b6e0bf76b5cfe.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxNTM0MTE1_size_16_color_FFFFFF_t_70 2]: /images/20211015/e96af7e950504137b43aa831c75cdf41.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxNTM0MTE1_size_16_color_FFFFFF_t_70 3]: /images/20211015/63012026fd924497bb9f8fc35025ff9d.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxNTM0MTE1_size_16_color_FFFFFF_t_70 4]: /images/20211015/228d5e98150540a3be5e60370f44e472.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxNTM0MTE1_size_16_color_FFFFFF_t_70 5]: /images/20211015/0a01af9bfb284268be8008ac653c98e5.png
[https_blog.csdn.net_qq_41534115_article_details_99679186]: https://blog.csdn.net/qq_41534115/article/details/99679186