一个ibatis映射文件的例子(包含增删改单查,多查)
2024-08-29 10:03:54
<?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">
<mapper namespace="com.ZXC.lesson.dao.LessonUserDao"> <sql id="table">
user
</sql>
<sql id="insert_parm">
u_id,u_name,u_sex,u_age
</sql>
<sql id="query_parm">
u_id,u_name,u_sex,u_age,u_create_time,u_update_time
</sql> <resultMap id="id" type="com.ZXC.lesson.model.LessonUser">
<id column="u_id" property="ID"/>
<result column="u_name" property="Name"/>
<result column="u_sex" property="Sex"/>
<result column="u_age" property="Age"/>
</resultMap> <insert id="save" parameterType="com.ZXC.lesson.model.LessonUser"
useGeneratedKeys="true" keyProperty="id">
INSERT INTO <include refid="table"/>
(<include refid="insert_parm"/>)
VALUES
(#{ID},#{Name},#{Sex},#{Age})
</insert> <update id="update" parameterType="com.ZXC.lesson.model.LessonUser">
UPDATE <include refid="table"/>
<set>
<if test="Sex!=null">u_sex=#{Sex}</if>
<if test="Age!=null">u_age=#{age}</if>
</set>
</update> <update id="delete" parameterType="com.ZXC.lesson.model.LessonUser">
UPDATE <include refid="table" />
SET is_delete=1
WHERE u_id=#{ID}
</update> <select id="querybyid" parameterType="com.ZXC.lesson.model.LessonUser">
SELECT <include refid="query_parm"/>
FROM <include refid="table"/>
WHERE u_id=#{ID} AND is_delete=0
</select> <select id="querylist" parameterType="com.ZXC.lesson.model.LessonUser">
SELECT <include refid="query_parm"/>
FROM <include refid="table"/>
WHERE id IN
<foreach collection="uid_list" open="(" close=")" item="uid" separator=",">
#{ID}
</foreach>
AND is_delete=0
</select>
</mapper>
最新文章
- NSObject+YYModel.h
- git 撤销commit
- 第11章 Windows线程池(1)_传统的Windows线程池
- 学习记录012-NFS
- JS中关于JS文件的引用以及问题
- C# 多任务之 Task
- Ubuntu安装sar出错Please check if data collecting is enabled in /etc/default/sysstat
- 安卓天天练练(十五)改造BasicSyncAdapter
- CheckBox的触发
- 在word中批量制作条形码
- Materialized View in Oracle - Concepts and Architecture
- 小米2s刷机
- c++面向对象学习计划
- Mocks Aren&#39;t Stubs
- [Leetcode 376]摇摆序列 Wiggle Subsequence
- Django中的中间件(middleware)
- .NET C#错误:所生成项目的处理器框架“MSIL”与引用“wdapi_dotnet1021”的处理器架构“AMD64”不匹配
- VB学习之路基础(一)
- Mysql 更改编码方式
- Tomcat 去除项目名称