之前写了一个注解版开发的,现在在一个配置文件开发。我直接把代码贴下面
@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配置文件开发