Spring Boot 12-mybatis整合

佚名 6年前 (2019-05-08) 随笔 2049人围观抢沙发百度已收录

springboot整合mybatis。
首先pom文件引入springboot

　　　　 <!-- mybatis -->
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>1.1.1</version>
        </dependency>
        
        <!-- mysql -->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
        </dependency>

配置application.yml的数据库

mapper接口

package com.tzp.mybatis.dao;

import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import com.tzp.mybatis.model.User;

public interface UserMapper {

    @Select("select * from t_user where user_name = #{name}")
    User findByName(@Param("name") String name);
    
    @Select("select * from t_user")
    User findById(Integer id);

    // 用注解来简化xml配置的时候,@Param注解的作用是给参数命名,参数命名后就能根据名字得到参数值,正确的将参数传入sql语句中
    @Insert("insert into t_user (user_name,id) values(#{name},#{id})")
    int insert(@Param("name") String name, @Param("id") Integer id);

}

SRE实战互联网时代守护先锋，助力企业售后服务体系运筹帷幄！一键直达领取阿里云限量特价优惠。

测试

package com.tzp.mybatis;

import javax.annotation.Resource;

import org.junit.Test;
import org.junit.runner.RunWith;
import org.mybatis.spring.annotation.MapperScan;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;
import org.springframework.test.context.junit4.SpringRunner;

import com.tzp.mybatis.dao.UserMapper;
import com.tzp.mybatis.model.User;

@RunWith(SpringRunner.class)
@MapperScan(basePackages = "com.tzp.mybatis.dao")
@SpringBootTest
public class SpringbootMybatisApplicationTests {

    @Resource
    UserMapper userMapper;
    
    @Test
    public void contextLoads() {
        User user = userMapper.findByName("张三");
        System.out.println(user.getId());
    }

}

JDBC Connection [HikariProxyConnection@1020897892 wrapping com.mysql.cj.jdbc.ConnectionImpl@42b84286] will not be managed by Spring
==>  Preparing: select * from t_user where user_name = ? 
==> Parameters: 张三(String)
<==    Columns: id, user_name
<==        Row: 1, 张三
<==      Total: 1
Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@4b1a43d8]
1
2019-05-08 00:33:20.668  INFO 5768 --- [       Thread-3] o.s.s.concurrent.ThreadPoolTaskExecutor  : Shutting down ExecutorService 'applicationTaskExecutor'
2019-05-08 00:33:20.668  INFO 5768 --- [       Thread-3] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Shutdown initiated...
2019-05-08 00:33:20.683  INFO 5768 --- [       Thread-3] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Shutdown completed.