spring-boot-mybatis配置文件开发

之前写了一个注解版开发的，现在在一个配置文件开发。我直接把代码贴下面

@Mapper
public interface OrdersMapper {

    //根据id查询单个信息
    public Orders getOrders(Integer id);

    //添加单个信息
    public void  insertOrder(Orders orders);

}

 

在resources中新建俩个文件夹（mybatis）（mapper）

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>
    <!--别名配置-->
    <typeAliases>
        <package name="com.hhh.springbootmybatis.bean"/>
    </typeAliases>
</configuration>

 

OrdersMapper.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.hhh.springbootmybatis.mapper.OrdersMapper">
    <select id="getOrders" resultType="orders">
      select * from orders where id=#{id}
    </select>

    <insert id="insertOrder">
      insert  into orders(user_id,number,oreatetime,note)values (#{user_id},#{number},#{oreatetime},#{note})
    </insert>
</mapper>

spring-boot里面我使用的是yml文件

mybatis:
  config-location: classpath:mybatis/mybatis-config.xml
# *.xml代表mapper包下的所有xml文件
  mapper-locations: classpath:mybatis/mapper/*.xml

Controller

@RestController
public class UserController {
    
    
    @Autowired
    OrdersMapper ordersMapper;
    
    
    @GetMapping("/orders/{id}")
    public Orders getOrders(@PathVariable("id") Integer id){
        return ordersMapper.getOrders(id);
    }


    @GetMapping("/orders")
    public Orders insertOrders(Orders orders){
        ordersMapper.insertOrder(orders);
        return orders;
    }

}

这就是一个简单spring-boot的mybatis配置文件开发