import org.apache.ibatis.annotations.Select;
public interface UserMapper {
@Select("SELECT * FROM table01 WHERE id = #{id}")
User selectUser(int id);
}
在XML中配置SQL:
<?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="mybatisModule.UserMapper">
<select id="xmlSelectUser" parameterType="int" resultType="User">
select name,password from table01 where id = #{id}
</select>
<select id="xmlSelectUsers" resultType="User">
select * from table01 order by id
</select>
</mapper>
于是我们就有了三句SQL,可以通过下面的方式执行这三句SQL: