IDEA搭建spring-boot druid mybatis(菜鸟从零开始)(三)(四)

﹏ヽ暗。殇╰゛Y 2022-05-20 09:21 124阅读 0赞

**(三)(四)spring boot 整合 mybatis + mybatis-generator**

pom.xml 加入依赖和插件

<dependency>
        <groupId>org.mybatis.spring.boot</groupId>
        <artifactId>mybatis-spring-boot-starter</artifactId>
        <version>1.2.1</version>
    </dependency>
    
    
    <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>

**再加入mybatis-generator的两个配置文件**  
**generatorConfig.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>
        <properties resource="generatorConfig.properties" />
        
        <classPathEntry location = "${ drive.class.path}" />
        <context id="mybatis" targetRuntime="MyBatis3">
            <commentGenerator>
                
                <property name="suppressAllComments" value="true" />
                
                <property name="suppressDate" value="false" />
            </commentGenerator>
    
            
            <jdbcConnection driverClass="${jdbc.driver}" connectionURL="${jdbc.url}" userId="${jdbc.username}" password="${jdbc.password}">
            </jdbcConnection>
    
            
            <javaTypeResolver>
                <property name="forceBigDecimals" value="false" />
            </javaTypeResolver>
    
            
            <javaModelGenerator targetPackage="${entity.targetProject}" targetProject="${entity.targetPackage}">
                
                <property name="enableSubPackages" value="false" />
                
                <property name="trimStrings" value="false" />
                
                
            </javaModelGenerator>
    
            
            <sqlMapGenerator targetPackage="${mapper.targetPackage}" targetProject="${mapper.targetProject}">
                
                <property name="enableSubPackages" value="false" />
            </sqlMapGenerator>
    
            
            <javaClientGenerator type="XMLMAPPER" targetPackage="${mapper.interface.targetPackage}" targetProject="${mapper.interface.targetProject}">
                
                <property name="enableSubPackages" value="false" />
            </javaClientGenerator>
    
            
            <table tableName="${table.name}" domainObjectName="${entity.name}" enableDeleteByExample="false" enableSelectByExample="false" enableCountByExample="false" enableUpdateByExample="false" enableUpdateByPrimaryKey="false">
                
                
                
            </table>
    
        </context>
    </generatorConfiguration>

generatorConfig.properties

#数据库驱动jar
    drive.class.path = D:/mavenWork/zhongyi/com/microsoft/sqlserver/mssql-jdbc/6.2.2.jre8/mssql-jdbc-6.2.2.jre8.jar
    
    # 数据库连接参数
    #jdbc.driver = com.microsoft.sqlserver.jdbc.SQLServerDriver
    #jdbc.url = jdbc:sqlserver://LANG/SQLEXPRESS:1433;DatabaseName=lang
    #jdbc.username = LangXuHao
    #jdbc.password= 123456
    jdbc.driver = com.microsoft.sqlserver.jdbc.SQLServerDriver
    jdbc.url = jdbc:sqlserver://10.10.1.38:1433;DatabaseName=gconline
    jdbc.username = isystem
    jdbc.password= isystem
    
    # 实体类路径
    #entity.abstract = com.sgai.sadp.core.base.entity.AbstractEntity
    entity.targetProject = com.lang.demo
    entity.targetPackage = src/main/java
    
    # mapper.xml路径
    mapper.targetProject = src/main/resources
    mapper.targetPackage = mapper
    
    # mapper interface
    mapper.interface.targetProject = src/main/java
    mapper.interface.targetPackage = com.lang.demo.mapper
    
    # 生成的表名和对应的实体类名
    table.name = wechat_test_prizes
    #table.primaryKey = select s_customer_history_version.nextval from dual
    entity.name = wechatTestPrizes

![这里写图片描述][70]

**下面用maven配置启动插件生成实体类，接口，和mapper.xml**  
![这里写图片描述][70 1]  
![这里写图片描述][70 2]  
![这里写图片描述][70 3]  
![这里写图片描述][70 4]  
启动插件  
控制台打印如下说明生成成功：

[INFO] Generating Record class for table wechat_test_prizes
    [INFO] Generating Mapper Interface for table wechat_test_prizes
    [INFO] Generating SQL Map for table wechat_test_prizes
    [INFO] Saving file wechatTestPrizesMapper.xml
    [INFO] Saving file wechatTestPrizes.java
    [INFO] Saving file wechatTestPrizesMapper.java
    [INFO] ------------------------------------------------------------------------
    [INFO] BUILD SUCCESS
    [INFO] ------------------------------------------------------------------------
    [INFO] Total time: 1.472 s
    [INFO] Finished at: 2018-07-16T16:14:18+08:00
    [INFO] Final Memory: 17M/199M
    [INFO] ------------------------------------------------------------------------
    
    Process finished with exit code 0

**生成后项目目录：**  
![这里写图片描述][70 5]

最后在application.yml 加入配置

mybatis:
      #实体类地址
      type-aliases-package: com.lang.springbootdemo.entity
      mapper-locations: classpath:mapper/*.xml

在启动类加上 @MapperScan 这样才能扫描到接口

import org.mybatis.spring.annotation.MapperScan;
    import org.springframework.boot.SpringApplication;
    import org.springframework.boot.autoconfigure.SpringBootApplication;
    import org.springframework.boot.web.servlet.ServletComponentScan;
    
    @SpringBootApplication
    @ServletComponentScan
    @MapperScan(value = "com.lang.springbootdemo.mapper")//扫面接口
    public class SpringBootDemoApplication {
    
        public static void main(String[] args) {
            SpringApplication.run(SpringBootDemoApplication.class, args);
        }
    }

别忘记了 在生成的接口上加上@Repository

import com.lang.springbootdemo.entity.WechatTestPrizes;
    import org.springframework.stereotype.Repository;
    
    @Repository
    public interface WechatTestPrizesMapper { 
        int deleteByPrimaryKey(Integer id);
    
        int insert(WechatTestPrizes record);
    
        int insertSelective(WechatTestPrizes record);
    
        WechatTestPrizes selectByPrimaryKey(Integer id);
    }

最后在之前的HelloController 测试下 我们添加一天数据

import com.lang.springbootdemo.entity.WechatTestPrizes;
    import com.lang.springbootdemo.mapper.WechatTestPrizesMapper;
    import javax.annotation.Resource;
    import org.springframework.web.bind.annotation.RequestMapping;
    import org.springframework.web.bind.annotation.RestController;
    
    /** * @Author: Xuhao * @Description: * @Date: Created in 11:20 2018/7/16 */
    @RestController
    public class HelloController { 
    
        @Resource
        private WechatTestPrizesMapper wechatTestPrizesMapper;
    
        @RequestMapping(value = "/hello")
        public String hello(){
            WechatTestPrizes wechatTestPrizes = new WechatTestPrizes();
            wechatTestPrizes.setAwardId(-1);
            wechatTestPrizes.setActivityCode("-1");
            wechatTestPrizes.setCdKey("hello");
            wechatTestPrizes.setIsconvert("a");
            int insert = wechatTestPrizesMapper.insert(wechatTestPrizes);
            System.out.println(insert);
    
            return "hello_spring_boot";
        }
    
    }

**学而不思则罔 思而不学则殆**

[70]: /images/20220520/5d569b3e7fb948fe88de1c18620fdac5.png
[70 1]: /images/20220520/4d4ef386b0a948c28ed170ae6722f163.png
[70 2]: /images/20220520/e81891852bcd44c995505473933e9e33.png
[70 3]: /images/20220520/f4440ac3024542a39a157a8067098c1b.png
[70 4]: /images/20220520/f5695cf145c540f8ae761cab000ae76d.png
[70 5]: /images/20220520/748157a77590482bb689467eb0e5ad48.png