Spring Boot 通过Mybatis 连接数据库实现增删查改demo

秒速五厘米 2021-09-30 00:28 198阅读 0赞

今天实现Spring Boot 和 Mybatis 整合

首先在 pom.xml 里面添加一个 mybatis 自动生成entity mapper的 ![696030-20180821170638275-808929010.png][]

<plugin>
                    <groupId>org.mybatis.generator</groupId>
                    <artifactId>mybatis-generator-maven-plugin</artifactId>
                    <version>1.3.2</version>
                    <configuration>
                        <configurationFile>${basedir}/src/main/resources/generatorConfig.xml</configurationFile>
                        <overwrite>true</overwrite>
                        <verbose>true</verbose>
                    </configuration>
                </plugin>

接下来配置 对应的generatorConfig.xml

![696030-20180821170739379-1094455467.png][]

<?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:\soft\mysql-connector-java-5.1.44\mysql-connector-java-5.1.44\mysql-connector-java-5.1.44-bin.jar"/>
        <context id="DB2Tables"  targetRuntime="MyBatis3">
            <commentGenerator>
                <property name="suppressDate" value="true"/>
                
                <property name="suppressAllComments" value="true"/>
            </commentGenerator>
            
            <jdbcConnection driverClass="com.mysql.jdbc.Driver" connectionURL="jdbc:mysql://cdb-5gpzxh0r.gz.tencentcdb.com:10006/garfo" userId="root" password="xiaosi110">
            </jdbcConnection>
            <javaTypeResolver>
                <property name="forceBigDecimals" value="false"/>
            </javaTypeResolver>
            
            <javaModelGenerator targetPackage="com.garfo.entity" targetProject="src/main/java">
                <property name="enableSubPackages" value="true"/>
                <property name="trimStrings" value="true"/>
            </javaModelGenerator>
            
            <sqlMapGenerator targetPackage="mapping" targetProject="src/main/resources">
                <property name="enableSubPackages" value="true"/>
            </sqlMapGenerator>
            
            <javaClientGenerator type="XMLMAPPER" targetPackage="com.garfo.mapper" targetProject="src/main/java">
                <property name="enableSubPackages" value="true"/>
            </javaClientGenerator>
            
            <table tableName="t_user" domainObjectName="User" enableCountByExample="false" enableUpdateByExample="false" enableDeleteByExample="false" enableSelectByExample="false" selectByExampleQueryId="false"></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="mysql" defaultModelType="hierarchical" targetRuntime="MyBatis3Simple" > 
    
     <property name="autoDelimitKeywords" value="false"/> 
    
     <property name="javaFileEncoding" value="UTF-8"/>  
    
    <property name="javaFormatter" value="org.mybatis.generator.api.dom.DefaultJavaFormatter"/> 
    
     <property name="xmlFormatter" value="org.mybatis.generator.api.dom.DefaultXmlFormatter"/>
    
      
    
    <property name="beginningDelimiter" value="`"/> <property name="endingDelimiter" value="`"/> 
    
     
    
    <jdbcConnection driverClass="com.mysql.jdbc.Driver" connectionURL="jdbc:mysql:///pss" userId="root" password="admin"> 
    
     
    
    </jdbcConnection>
    
      
    
    <javaTypeResolver type="org.mybatis.generator.internal.types.JavaTypeResolverDefaultImpl"> 
    
     
    
    <property name="forceBigDecimals" value="false"/> 
    
    </javaTypeResolver> 
    
     
    
    <javaModelGenerator targetPackage="com._520it.mybatis.domain" targetProject="src/main/java">
    
      
    
    <property name="constructorBased" value="false"/>
    
     
    
     <property name="enableSubPackages" value="true"/> 
    
    
    
     <property name="immutable" value="false"/>
    
      
    
    <property name="rootClass" value="com._520it.mybatis.domain.BaseDomain"/> 
    
    
    
     <property name="trimStrings" value="true"/> </javaModelGenerator>
    
      
    
    <sqlMapGenerator targetPackage="com._520it.mybatis.mapper" targetProject="src/main/resources"> 
    
    
    
     <property name="enableSubPackages" value="true"/> 
    
    </sqlMapGenerator>
    
     
    
     <javaClientGenerator targetPackage="com._520it.mybatis.mapper" type="ANNOTATEDMAPPER" targetProject="src/main/java"> 
    
     
    
    <property name="enableSubPackages" value="true"/> 
    
    
    
     </javaClientGenerator>
    
      
    
    <table tableName="userinfo" > 
    
    
    
     <property name="constructorBased" value="false"/> 
    
    
    
     <property name="ignoreQualifiersAtRuntime" value="false"/>
    
      <property name="immutable" value="false"/>  <property name="modelOnly" value="false"/>       <property name="selectAllOrderByClause" value="age desc,username asc"/>  <property name="useActualColumnNames" value="false"/>    <columnOverride column="username">  <property name="property" value="userName"/>     </columnOverride>  </table> </context> </generatorConfiguration>
    
    
    作者：叩丁狼教育

运行 run-> Edit Configurations..

![696030-20180821170934306-806473037.png][]

没有maven 点击加号 选择Maven

![696030-20180821171040668-1758377928.png][]

在空白处添加对应的内容。apply run

![696030-20180821171006499-1869319666.png][]

运行 ，生成对应文件，注意 请提前新建对应的文件夹等内容。**注意：请不要相同表请不要运行多次**

![696030-20180821163157600-455917813.png][]

![696030-20180821170146077-109793739.png][]

<?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="mysql" defaultModelType="hierarchical" targetRuntime="MyBatis3Simple" >  
        <property name="autoDelimitKeywords" value="false"/>        <property name="javaFileEncoding" value="UTF-8"/>        <property name="javaFormatter" value="org.mybatis.generator.api.dom.DefaultJavaFormatter"/>        <property name="xmlFormatter" value="org.mybatis.generator.api.dom.DefaultXmlFormatter"/>            <property name="beginningDelimiter" value="\`"/>    <property name="endingDelimiter" value="\`"/>            <jdbcConnection driverClass="com.mysql.jdbc.Driver" connectionURL="jdbc:mysql:///pss" userId="root" password="admin">            </jdbcConnection>            <javaTypeResolver type="org.mybatis.generator.internal.types.JavaTypeResolverDefaultImpl">                <property name="forceBigDecimals" value="false"/>    </javaTypeResolver>                <javaModelGenerator targetPackage="com.\_520it.mybatis.domain" targetProject="src/main/java">                <property name="constructorBased" value="false"/>                        <property name="enableSubPackages" value="true"/>                        <property name="immutable" value="false"/>                        <property name="rootClass" value="com.\_520it.mybatis.domain.BaseDomain"/>                        <property name="trimStrings" value="true"/>    </javaModelGenerator>                <sqlMapGenerator targetPackage="com.\_520it.mybatis.mapper" targetProject="src/main/resources">                <property name="enableSubPackages" value="true"/>    </sqlMapGenerator>                <javaClientGenerator targetPackage="com.\_520it.mybatis.mapper" type="ANNOTATEDMAPPER" targetProject="src/main/java">                <property name="enableSubPackages" value="true"/>                    </javaClientGenerator>            <table tableName="userinfo" >                        <property name="constructorBased" value="false"/>                        <property name="ignoreQualifiersAtRuntime" value="false"/>                        <property name="immutable" value="false"/>                        <property name="modelOnly" value="false"/>                                                                                                         <property name="selectAllOrderByClause" value="age desc,username asc"/>                        <property name="useActualColumnNames" value="false"/>                                                                            <columnOverride column="username">                        <property name="property" value="userName"/>                                                                                                           </columnOverride>                      </table>    </context>  
</generatorConfiguration>

转载于:https://www.cnblogs.com/xiaosisong/p/9512721.html

[696030-20180821170638275-808929010.png]: /images/20210725/0a64d6eaba2e492c85a00089cea6fba9.png
[696030-20180821170739379-1094455467.png]: /images/20210725/4b760b444ee542c59e83a0d6e169387f.png
[696030-20180821170934306-806473037.png]: /images/20210725/a5c0bb64d9ea4c7199ef794846cf66be.png
[696030-20180821171040668-1758377928.png]: /images/20210725/c3403c17ab8045f1b62ab4d59f64dc05.png
[696030-20180821171006499-1869319666.png]: /images/20210725/594c9e6b63c04cd09111619a19b4fcb8.png
[696030-20180821163157600-455917813.png]: /images/20210725/d178bbe2838b46afb36625b137da413e.png
[696030-20180821170146077-109793739.png]: /images/20210725/4e05174e7bf346c5acb582098c096378.png