<?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"><mappernamespace="cn.water.dao.UserDao"><!-- 添加用户 --><!-- 参数类型 JavaBean,占位符 = 成员变量名的小写形式 --><selectid="add"parameterType="cn.water.domain.User">
INSERT INTO user VALUES ( #{id}, #{username}, #{birthday}, #{sex}, #{address} ) ;
</select><!-- 更新用户 --><selectid="update"parameterType="cn.water.domain.User">
UPDATE user SET
username = #{username},
birthday = #{birthday},
sex = #{sex},
address = #{address}
WHERE
id = #{id} ;
</select><!-- 删除用户 --><!-- 参数类型 基本类型,占位符 = 方法参数名称 --><selectid="delete"parameterType="INT">
DELETE FROM user WHERE id = #{id};
</select><!-- 查询所有 --><selectid="findAll"resultType="cn.water.domain.User">
SELECT * FROM user;
</select><!-- 查询单个用户 --><selectid="findOne"parameterType="INT"resultType="cn.water.domain.User">
SELECT * FROM user WHERE id = #{id} ;
</select><!-- 根据姓名模糊查询 --><selectid="findByName"parameterType="java.lang.String"resultType="cn.water.domain.User">
SELECT * FROM user WHERE username LIKE #{name};
</select><selectid="findByName"parameterType="java.lang.String"resultType="cn.water.domain.User">
SELECT * FROM user WHERE username LIKE '% {value} %';
</select><!-- 查询所有用户的数量 --><selectid="findTotal"resultType="INT">
SELECT COUNT(*) FROM user;
</select></mapper>
<selectid="add"parameterType="cn.water.domain.User">
INSERT INTO user VALUES ( #{id}, #{username}, #{birthday}, #{sex}, #{address} ) ;
</select>
更新用户
持久层接口
voidupdate(User user);
映射配置文件
<selectid="update"parameterType="cn.water.domain.User">
UPDATE user SET
username = #{username},
birthday = #{birthday},
sex = #{sex},
address = #{address}
WHERE
id = #{id} ;
</select>
删除用户
持久层接口
voiddelete(Integer id);
映射配置文件
<selectid="delete"parameterType="INT">
DELETE FROM user WHERE id = #{id};
</select>
查找所有用户
持久层接口
User findOne(Integer id);
映射配置文件
<selectid="findAll"resultType="cn.water.domain.User">
SELECT * FROM user;
</select>
查询单个用户
持久层接口
List<User>findAll();
映射配置文件
<selectid="findOne"parameterType="INT"resultType="cn.water.domain.User">
SELECT * FROM user WHERE id = #{id} ;
</select>
<selectid="findByName01"parameterType="java.lang.String"resultType="cn.water.domain.User">
SELECT * FROM user WHERE username LIKE #{username};
</select><selectid="findByName02"parameterType="java.lang.String"resultType="cn.water.domain.User">
SELECT * FROM user WHERE username LIKE '%${value}%';
</select>
查询所有用户数量
持久层接口
Integer findTotal();
映射配置文件
<selectid="findTotal"resultType="INT">
SELECT COUNT(*) FROM user;
</select>
package cn.water.domain;publicclassQueryVo{/* 成员变量 */private User user;/* 构造方法 */publicQueryVo(User user){this.user = user;}/* Getter Setter */public User getUser(){return user;}publicvoidsetUser(User user){this.user = user;}}
持久层接口
List<User>findByQueryVO(QueryVo queryVo);
映射配置文件
<selectid="findByQueryVo"parameterType="cn.water.domain.QueryVo"resultType="cn.water.domain.User">
SELECT * FROM user WHERE username LIKE #{user.username};
</select>