<?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">
<!--namespace会和下面select的id一起在调用方法用到 -->
<mapper namespace="com.icss.mybaties.Pojo.UserDao">
<!--com.icss.mybaties.Pojo.User类名的完整路径 -->
<!--id="mybatiesClass"> 和下面的 resultMap要一致 -->
<!-- type是你要操作的bean包 -->
<resultMap type="com.icss.mybaties.Pojo.User" id="mybatiesClass">
<!-- 手工匹配java类中的变量名和数据库的变量名 property javabean文件里面的变量名匹配数据库的段名column -->
<result property="idd" column="id" />
<result property="user_name" column="user" />
</resultMap>
<!--起id后面在调用查询用到 -->
<select id="findAll" resultMap="mybatiesClass">
<!-- 查询语句 -->
select * from mybaties
</select>
<select id="findid" resultMap="mybatiesClass">
<!-- 查询语句 -->
select * from user WHERE user_name=#{user}
</select>
<!-- ********************** 动态查询 -->
<select id="findme" resultMap="mybatiesClass">
<!-- 查询语句 -->
select * from user
<where>
<choose>
<when test="flag == 1">
AND user_name = #{user}
</when>
<otherwise>
AND user_name like '%${user}%'
</otherwise>
</choose>
</where>
</select>
<!-- ********************** -->
<select id="forfind" resultMap="mybatiesClass">
select * from user where user_name in
<foreach collection="list" item="item" open="(" close=")"
separator=",">
#{item}
</foreach>
</select>
<!-- foreach -->
<insert id="add">
insert into user
(user_name,password,sex,age)
values
(#{user},#{password},#{sex},#{age})
</insert>
<!-- 接口注解 -->
<insert id="addone">
insert into user
(user_name,password,sex,age)
values
(#{user},#{password},#{sex},#{age})
</insert>
<update id="mod">
update user set
password=#{password},sex=#{sex},age=#{age}
where user_name=#{user}
</update>
<delete id="del">
delete from user where user_name=#{user}
</delete>
</mapper>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<!--namespace会和下面select的id一起在调用方法用到 -->
<mapper namespace="com.icss.mybaties.Pojo.UserDao">
<!--com.icss.mybaties.Pojo.User类名的完整路径 -->
<!--id="mybatiesClass"> 和下面的 resultMap要一致 -->
<!-- type是你要操作的bean包 -->
<resultMap type="com.icss.mybaties.Pojo.User" id="mybatiesClass">
<!-- 手工匹配java类中的变量名和数据库的变量名 property javabean文件里面的变量名匹配数据库的段名column -->
<result property="idd" column="id" />
<result property="user_name" column="user" />
</resultMap>
<!--起id后面在调用查询用到 -->
<select id="findAll" resultMap="mybatiesClass">
<!-- 查询语句 -->
select * from mybaties
</select>
<select id="findid" resultMap="mybatiesClass">
<!-- 查询语句 -->
select * from user WHERE user_name=#{user}
</select>
<!-- ********************** 动态查询 -->
<select id="findme" resultMap="mybatiesClass">
<!-- 查询语句 -->
select * from user
<where>
<choose>
<when test="flag == 1">
AND user_name = #{user}
</when>
<otherwise>
AND user_name like '%${user}%'
</otherwise>
</choose>
</where>
</select>
<!-- ********************** -->
<select id="forfind" resultMap="mybatiesClass">
select * from user where user_name in
<foreach collection="list" item="item" open="(" close=")"
separator=",">
#{item}
</foreach>
</select>
<!-- foreach -->
<insert id="add">
insert into user
(user_name,password,sex,age)
values
(#{user},#{password},#{sex},#{age})
</insert>
<!-- 接口注解 -->
<insert id="addone">
insert into user
(user_name,password,sex,age)
values
(#{user},#{password},#{sex},#{age})
</insert>
<update id="mod">
update user set
password=#{password},sex=#{sex},age=#{age}
where user_name=#{user}
</update>
<delete id="del">
delete from user where user_name=#{user}
</delete>
</mapper>