MyBatis's mapper.xml files are also added to the file header.

<?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" >
<!--Write SQL statements--
<mapper namespace= "Com.itheima.mybatis.mapper.UserMapper" >
<!--query one user by ID--
<select id= "Finduserbyid" parametertype= "Integer" resulttype= "User" >
SELECT * from user where id = #{v}
</select>

<!--//Fuzzy query user list based on user name
#{} select * FROM user where id =? Placeholder? = = ' Five '
${} select * from user where username like '% five ' string concatenation

-
<select id= "Finduserbyusername" parametertype= "String" resulttype= "Com.itheima.mybatis.pojo.User" >
SELECT * from user where username like "%" #{haha} "%"
</select>

<!--adding users--
<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-
<update id= "Updateuserbyid" parametertype= "Com.itheima.mybatis.pojo.User" >
Update user
Set username = #{username},sex = #{sex},birthday = #{birthday},address = #{address}
WHERE id = #{id}
</update>

<!--removed-
<delete id= "Deleteuserbyid" parametertype= "Integer" >
Delete from user
WHERE id = #{vvvvv}
</delete>

</mapper>

MyBatis's mapper.xml files are also added to the file header.