Mybatis的mapper.xml檔案也是要加檔案頭的

標籤：birt   use   模糊查詢   enc   ima   rtu   ast   coding   value   

<?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">
<!-- 寫Sql語句 -->
<mapper namespace="com.itheima.mybatis.mapper.UserMapper">
<!-- 通過ID查詢一個使用者 -->
<select id="findUserById" parameterType="Integer" resultType="User">
select * from user where id = #{v}
</select>

<!-- //根據使用者名稱稱模糊查詢使用者列表
#{} select * from user where id = ？ 預留位置 ? == ‘五‘
${} select * from user where username like ‘%五%‘ 字串拼接

-->
<select id="findUserByUsername" parameterType="String" resultType="com.itheima.mybatis.pojo.User">
select * from user where username like "%"#{haha}"%"
</select>

<!-- 添加使用者 -->
<insert id="insertUser" parameterType="com.itheima.mybatis.pojo.User">
<selectKey keyProperty="id" resultType="Integer" order="AFTER">
select LAST_INSERT_ID()
</selectKey>
insert into user (username,birthday,address,sex)
values (#{username},#{birthday},#{address},#{sex})
</insert>

<!-- 更新 -->
<update id="updateUserById" parameterType="com.itheima.mybatis.pojo.User">
update user
set username = #{username},sex = #{sex},birthday = #{birthday},address = #{address}
where id = #{id}
</update>

<!-- 刪除 -->
<delete id="deleteUserById" parameterType="Integer">
delete from user
where id = #{vvvvv}
</delete>

</mapper>

Mybatis的mapper.xml檔案也是要加檔案頭的