主要介绍springBoot如何整合Mybatis,其实很简单最重要的是引入maven的依赖和一个扫描注解:@MapperScan("com.yarm.mybatis.mapper")这个扫描mapper的包名。
1.引入依赖
<!--Mybatis-->
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>1.3.2</version>
</dependency>
2.application.properties的配置
#连接数据库
spring.datasource.url=jdbc:mysql://127.0.0.1/test
spring.datasource.username=root
spring.datasource.password=123456
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
#mybatis的配置
mybatis.typeAliasesPackage=com.yarm.base.pojo #mapper对应的实体类别名
mybatis.mapperLocations=classpath:mapper/*.xml #Mapper的sql文件
3.mapper.java代码
package com.yarm.mybatis.mapper;
import java.util.List;
import com.yarm.base.pojo.User;
public interface UserMapper {
/**
* 新增一条用户
* @return
*/
public List<User> insertUser();
/**
* 删除一条数据
* @param id
* @return
*/
public List<User> deleteUserById(int id);
/**
* 通过ID修改一条用户数据
* @param id
* @return
*/
public List<User> updateUserById(int id);
/**
* 查询用户列表
* @return
*/
public List<User> selectUser();
}
4.Mapper的xml
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.yarm.mybatis.mapper.UserMapper">
<resultMap id="userMap" type="com.yarm.base.pojo.User">
<id property="id" column="id" />
<result property="userId" column="user_id" />
<result property="userName" column="user_name" />
</resultMap>
<insert id="insertUser">
</insert>
<delete id="deleteUserById">
</delete>
<update id="updateUserById">
</update>
<select id="selectUser" resultMap="userMap">
select id,user_id,user_name from user
</select>
</mapper>
5.启动项目main入口
package com.yarm;
import org.mybatis.spring.annotation.MapperScan;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
import org.springframework.boot.web.support.SpringBootServletInitializer;
@SpringBootApplication
@MapperScan("com.yarm.mybatis.mapper")
public class Application extends SpringBootServletInitializer {
public static void main(String[] args) {
SpringApplication.run(Application.class, args);
}
}
注意:@MapperScan("com.yarm.mybatis.mapper")是扫描mapper的注解
6.项目地址