springboot集成mybatis

关键代码如下：

1，添加pom引用

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

2 application.properties

mybatis.config-locations=classpath:mybatis/mybatis-config.xmlmybatis.mapper-locations=classpath:mybatis/mapper/*.xmlmybatis.type-aliases-package=com.kerry.model spring.datasource.driverClassName = com.mysql.jdbc.Driverspring.datasource.url = jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf-8spring.datasource.username = rootspring.datasource.password = 123456

3 在resource目录下创建mybatis目录并创建mybatis-config.xml文件

<?xml version="1.0" encoding="UTF-8" ?><!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "http://mybatis.org/dtd/mybatis-3-config.dtd"><configuration> <settings> <setting name="callSettersOnNulls" value="true"/> <setting name="cacheEnabled" value="true"/> <setting name="lazyLoadingEnabled" value="true"/> <setting name="aggressiveLazyLoading" value="true"/> <setting name="multipleResultSetsEnabled" value="true"/> <setting name="useColumnLabel" value="true"/> <setting name="useGeneratedKeys" value="false"/> <setting name="autoMappingBehavior" value="PARTIAL"/> <setting name="defaultExecutorType" value="SIMPLE"/> <setting name="mapUnderscoreToCamelCase" value="true"/> <setting name="localCacheScope" value="SESSION"/> <setting name="jdbcTypeForNull" value="NULL"/> </settings> <typeAliases> <typeAlias alias="Integer" type="java.lang.Integer" /> <typeAlias alias="Long" type="java.lang.Long" /> <typeAlias alias="HashMap" type="java.util.HashMap" /> <typeAlias alias="LinkedHashMap" type="java.util.LinkedHashMap" /> <typeAlias alias="ArrayList" type="java.util.ArrayList" /> <typeAlias alias="LinkedList" type="java.util.LinkedList" /> </typeAliases></configuration>

mybatis目录下创建mapper目录存放mapper类接口文件

package com.kerry.mapper; import java.util.List; import com.kerry.model.User; public interface UserMapper { List<User> getAll(); User getOne(Integer id); void insert(User user); void update(User user); void delete(Integer id); }

model类文件

package com.kerry.mapper; import java.util.List;import com.kerry.model.User; public interface UserMapper { List<User> getAll(); User getOne(Integer id); void insert(User user); void update(User user); void delete(Integer id);}

userMapper.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.kerry.mapper.UserMapper" > <resultMap id="BaseResultMap" type="com.kerry.model.User" > <id column="id" property="id" jdbcType="INTEGER" /> <result column="name" property="name" jdbcType="VARCHAR" /> <result column="age" property="age" jdbcType="VARCHAR" /> <result column="address" property="address" jdbcType="VARCHAR"/> </resultMap> <sql id="Base_Column_List" > id, name, age, address </sql> <select id="getAll" resultMap="BaseResultMap" > SELECT <include refid="Base_Column_List" /> FROM user </select> <select id="getOne" parameterType="java.lang.Integer" resultMap="BaseResultMap" > SELECT <include refid="Base_Column_List" /> FROM user WHERE id = #{id} </select> <insert id="insert" parameterType="com.kerry.model.User" > INSERT INTO user (id,name,age,address) VALUES (#{id},#{name}, #{age}, #{address}) </insert> <update id="update" parameterType="com.kerry.model.User" > UPDATE user SET <if test="name != null">name = #{name},</if> <if test="age != null">age = #{age},</if> address = #{address} WHERE id = #{id} </update> <delete id="delete" parameterType="java.lang.Integer" > DELETE FROM user WHERE id =#{id} </delete> </mapper>

controller：

package com.kerry.web;import java.util.List;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.web.bind.annotation.PathVariable;import org.springframework.web.bind.annotation.RequestMapping;import org.springframework.web.bind.annotation.RestController; import com.kerry.model.User;import com.kerry.mapper.UserMapper; @RestControllerpublic class UserController { @Autowired private UserMapper userMapper; @RequestMapping("/getUsers") public List<User> getUsers() { List<User> users=userMapper.getAll(); return users; } @RequestMapping("/getUser") public User getUser(Integer id) { User user=userMapper.getOne(id); return user; } @RequestMapping("/add") public void save(User user) { userMapper.insert(user); } @RequestMapping(value="update") public void update(User user) { userMapper.update(user); } @RequestMapping(value="/delete/{id}") public void delete(@PathVariable("id") Integer id) { userMapper.delete(id); } }

最后在启动类上加上 扫描maper interface注解

@SpringBootApplication@MapperScan("com.kerry.mapper")public class Application { public static void main(String[] args) { SpringApplication.run(Application.class, args); }}

或者在每个XXMapper类上加上@mapper注解也行 二选一即可

比如

package com.kerry.mapper; import java.util.List;import org.apache.ibatis.annotations.Mapper;import com.kerry.model.User; @Mapperpublic interface UserMapper { List<User> getAll(); User getOne(Integer id); void insert(User user); void update(User user); void delete(Integer id); }

个人建议使用直接在启动类上application上@MapperScan方便，一次搞定，不必每写一个mapper类都加上@mapper注解

附上项目结构目录 选中的类以及文件

以上就是本文的全部内容，希望对大家的学习有所帮助，也希望大家多多支持。