Spinrg Boot框架教程09之整合MyBaits 配置文件XML方式
注解方式对sql语句是硬编码,对于后期扩展维护不方便,将上一节的注解方式更改为xml配置文件方式,把sql语句编写在配置文件中。
XML方式是在注解的方式基础上修改的,请查看SpringBoot整合MyBatis注解篇
玩转Spring Boot框架教程08之整合MyBatis注解方式
1、编写Mapper配置文件
在src/main/resources目录下新建com/itcodeschool/dao/UserMapper.xml文件
1、编写Mapper
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.itcodeschool.dao.UserDao">
<select id="findUser"resultType="User" parameterType="int">
selectid,name,age,sex,address from user where id = #{id}
</select>
<select id="findUserList"resultType="User">
select id,name,age,sex,address from user
</select>
<insert id="add"parameterType="User">
insertinto user(name, age, sex, address) values(#{name},#{age},#{sex},#{address})
</insert>
<update id="update"parameterType="User">
updateuser set name = #{name}, address = #{address} where id = #{id}
</update>
<delete id="delete">
deletefrom user where id = #{id}
</delete>
</mapper>
2、修改全局配置文件
mybatis:
configuration:
map-underscore-to-camel-case:true
mapper-locations: mybatis/com/itcodeschool/dao/*Mapper.xml
typeAliasesPackage: com.itcodeschool.domain
3、修改UserDao
去掉接口类上的注解和方法上的注解以及方法里面的注解
public interface UserDao {
int add( Useruser);
intupdate(User user);
intdelete(int id);
UserfindUser(int id);
List<User>findUserList();
}
4、运行测试
测试请参考