springboot (一)集成tkmapper

Shihira 發(fā)布于2019-08-19 11:45 / 3692人閱讀

摘要：整合想著每次搭建新項(xiàng)目時(shí)框架都要從新搭建，基本常用的也就哪幾種，現(xiàn)在就來搭建一種常用的后臺(tái)框架，以后新開小項(xiàng)目可以直接拿來使用項(xiàng)目整體結(jié)構(gòu)圖新建空白項(xiàng)目，選中依賴略，也可以完全根據(jù)本人代碼操作文件依賴項(xiàng)展示

springboot整合tkMapper

想著每次搭建新項(xiàng)目時(shí)框架都要從新搭建，基本常用的也就哪幾種，現(xiàn)在就來搭建一種常用的springboot后臺(tái)框架，以后新開小項(xiàng)目可以直接拿來使用
項(xiàng)目整體結(jié)構(gòu)圖

1.新建springboot空白項(xiàng)目，選中web依賴（略，也可以完全根據(jù)本人代碼操作）
2.pom文件依賴項(xiàng)展示



    4.0.0
    
        org.springframework.boot
        spring-boot-starter-parent
        2.1.5.RELEASE
         
    
    com.cxt
    demo
    0.0.1-SNAPSHOT
    demo
    Demo project for Spring Boot

    
        1.8
    

    
        
            org.springframework.boot
            spring-boot-starter-web
        

        
            org.projectlombok
            lombok
            true
        
        
            org.springframework.boot
            spring-boot-starter-test
            test
        


        
        
            org.mybatis.spring.boot
            mybatis-spring-boot-starter
            1.3.2
        

        
        
            mysql
            mysql-connector-java
            8.0.16
            runtime
        
        
        
            tk.mybatis
            mapper-spring-boot-starter
            RELEASE
        
        
            tk.mybatis
            mapper
            3.4.5
        
        
        
            com.alibaba
            druid
            1.1.3
        
    

    
        
            
                org.springframework.boot
                spring-boot-maven-plugin
            
            
            
                org.mybatis.generator
                mybatis-generator-maven-plugin
                1.3.2
                
                    ${basedir}/src/main/resources/generator/generatorConfig.xml
                    true
                    true
                
                
                    
                        mysql
                        mysql-connector-java
                        8.0.16
                    
                    
                        tk.mybatis
                        mapper-generator
                        1.1.3

application.yml文件內(nèi)容

server:
  port: 8081

#數(shù)據(jù)源配置
spring:
  datasource:
    type: com.alibaba.druid.pool.DruidDataSource #Druid連接池
    url: jdbc:mysql://localhost:3306/springboot-demo?useUnicode=true&characterEncoding=UTF-8&zeroDateTimeBehavior=convertToNull&useSSL=true&nullCatalogMeansCurrent=true
    username: root #數(shù)據(jù)庫用戶名
    password: root #數(shù)據(jù)庫密碼
    driver-class-name: com.mysql.cj.jdbc.Driver #mysql驅(qū)動(dòng)
    initialSize: 10 #初始化連接池大小
    minIdle: 10 #初始化最小連接池?cái)?shù)量
    maxActive: 100 #初始化最大連接池?cái)?shù)量
    maxWait: 6000 #配置獲取連接等待超時(shí)的時(shí)間
    timeBetweenEvictionRunsMills: 6000 #配置間隔多久才進(jìn)行一次檢測(cè)，檢測(cè)需要關(guān)閉的空閑連接，單位是毫秒
    minEvictableIdleTimeMillis: 30000 #配置一個(gè)連接在池中最小生存的時(shí)間，單位是毫秒
    validationQuery: SELECT "x" #測(cè)試連接
mybatis:
  mapper-locations: classpath:/mapper/*.xml
  configuration:
    map-underscore-to-camel-case: true
    #打印sql
    #log-impl: org.apache.ibatis.logging.stdout.StdOutImpl
mapper:
  identity: MYSQL # 配置主鍵自動(dòng)增長(使用MYSQL原生方式)
logging:
  level:
    com.cxt.demo: debug
# 分頁插件
pagehelper:
  reasonable: true
  page-size-zero: true
  params: pageNum=start;pageSize=limit
  support-methods-arguments: true

新建MyBaseMapper，（ 注意此接口不能被掃描到 *）

package com.cxt.demo.tk;

import org.springframework.stereotype.Repository;
import tk.mybatis.mapper.common.ExampleMapper;
import tk.mybatis.mapper.common.Mapper;
import tk.mybatis.mapper.common.MySqlMapper;

/**
 * @author liBai
 * @Classname MyBaseMapper
 * @Description TODO base mapper 不能被掃描
 * @Date 2019-06-02 10:41
 */
@Repository
public interface MyBaseMapper  extends Mapper, MySqlMapper , ExampleMapper {
}

啟動(dòng)類添加掃描mapper

注意此處@MapperScan要引tk包下面的，否則會(huì)報(bào)錯(cuò)
（import tk.mybatis.spring.annotation.MapperScan;）

package com.cxt.demo;


import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
import tk.mybatis.spring.annotation.MapperScan;

/**
 * @author liBai
 * mapperscan 要引tk包下面的
 */
@SpringBootApplication
@MapperScan(basePackages = "com.cxt.demo.dao")
public class DemoApplication {

    public static void main(String[] args) {
        SpringApplication.run(DemoApplication.class, args);
    }

}

添加MybatisConfigurer配置類

package com.cxt.demo.config;

import org.apache.ibatis.session.SqlSessionFactory;
import org.mybatis.spring.SqlSessionFactoryBean;
import org.springframework.boot.SpringBootConfiguration;
import org.springframework.context.annotation.Bean;
import javax.annotation.Resource;
import javax.sql.DataSource;

/**
 * @author liBai
 * @Classname MybatisConfigurer
 * @Description TODO
 * @Date 2019-06-02 10:42
 */
@SpringBootConfiguration
public class MybatisConfigurer {
    @Resource
    private DataSource dataSource;

    @Bean
    public SqlSessionFactory sqlSessionFactoryBean() throws Exception {
        SqlSessionFactoryBean bean = new SqlSessionFactoryBean();
        bean.setDataSource(dataSource);
        bean.setTypeAliasesPackage("com.cxt.demo.bean");
        return bean.getObject();
    }

}

數(shù)據(jù)庫創(chuàng)建sql語句（測(cè)試tkmapper鏈接數(shù)據(jù)庫）

CREATE TABLE `test_sys` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(45) NOT NULL,
  PRIMARY KEY (`id`,`name`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

#插入數(shù)據(jù)
INSERT INTO `springboot-demo`.`test_sys` (`id`, `name`) VALUES ("1‘, "test1");
INSERT INTO `springboot-demo`.`test_sys` (`id`, `name`) VALUES ("2‘, "test2");
INSERT INTO `springboot-demo`.`test_sys` (`id`, `name`) VALUES ("3‘, "test3");

generator自動(dòng)生成bean，dao，mapper，generator配置內(nèi)容如下

點(diǎn)擊maven命令執(zhí)行生成相對(duì)應(yīng)的bean，dao，mapper

或者使用maven命令

mybatis-generator:generate –e

創(chuàng)建HelloController

package com.cxt.demo.controller;

import com.cxt.demo.service.HelloService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Repository;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

/**
 * @author liBai
 * @Classname HelloController
 * @Description TODO
 * @Date 2019-06-02 10:49
 */
@RestController
@RequestMapping("/test")
public class HelloController {
    @Autowired
    private HelloService helloService;
    @RequestMapping("/hello")
    public String hello(){
        return helloService.sayHello();
    }
}

創(chuàng)建HelloService

package com.cxt.demo.service;

/**
 * @author liBai
 * @Classname HelloService
 * @Description TODO
 * @Date 2019-06-02 10:49
 */
public interface HelloService {
    String sayHello();

}

創(chuàng)建HelloServiceImpl實(shí)現(xiàn)

package com.cxt.demo.service.impl;

import com.cxt.demo.bean.TestSys;
import com.cxt.demo.dao.TestSysMapper;
import com.cxt.demo.service.HelloService;
import lombok.extern.slf4j.Slf4j;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

/**
 * @author liBai
 * @Classname HelloServiceImpl
 * @Description TODO
 * @Date 2019-06-02 10:50
 */
@Service
@Slf4j
public class HelloServiceImpl implements HelloService {
    @Autowired
    private TestSysMapper testSysMapper;

    @Override
    public String sayHello() {
        TestSys testSys = testSysMapper.selectByPrimaryKey("1");
        log.debug("testSys  =  [{}]",testSys.toString());
        return testSys.getName();
    }
}

瀏覽器測(cè)試，url中輸入 http://localhost:8081/test/hello 顯示

到此為止，springboot整合通用mapper，使用mysql的demo就結(jié)束了，后續(xù)整合請(qǐng)關(guān)注后續(xù)博客

源碼地址 https://github.com/TianPuJun/...