mybatis-初级篇-UserMapper.xml

<?xml version="1.0" encoding="UTF-8" ?>
<!-- 引入dtd -->
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">




<!-- namespace就是接口的包名加类名 -->
<mapper namespace="cn.dao.UserMapper">








<!-- 查个数 -->
<!-- id是一个方法，id是唯一的 -->
<!-- resaultType是返回值类型 -->
<select id="count" resultType="int">
<!-- 写SQL语句 -->
select count(1) from user
</select>



<!-- =============================================== -->

<!-- 增加 -->
<!-- parameterType:增加的时候传进来的是User对象 -->
<insert id="add" parameterType="User">
insert into user(userCode, userName, userPassword)
values (#{userCode},#{userName},#{userPassword})
</insert>

<!-- =============================================== -->

<!-- 修改 -->
<update id="update" parameterType="User">
update user set userCode=#{userCode}, userName=#{userName},
userPassword=#{userPassword} where id=#{id}
</update>

<!-- =============================================== -->
<!-- 删除 -->
<delete id="delete" parameterType="User">
delete from user where id=#{id}
</delete>

<!-- =============================================== -->
<!-- 查询-->
<select id="getUserList" resultType="User">
select * from user
</select>
</mapper>