src/com/mapper/User.xml

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

<?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.mapper.UserMapper">
		<resultMap type="User" id="userResult">
			<id property="id" column="id"/>
			<result property="name" column="name"/>
			<result property="sex" column="sex"/>
			<result property="sdate" column="sdate"/>
			<result property="tel" column="tel"/>
			<result property="xueli" column="xueli"/>
			<result property="addr" column="addr"/>
			<result property="username" column="username"/>
			<result property="pwd" column="pwd"/>
		</resultMap>
		<insert id="insert" parameterType="User">
			insert into user
			<trim prefix="(" suffix=")" suffixOverrides=",">
			<if test="name != null">name,</if>
			<if test="sex != null">sex,</if>
			<if test="sdate != null">sdate,</if>
			<if test="tel != null">tel,</if>
			<if test="xueli != null">xueli,</if>
			<if test="addr != null">addr,</if>
			<if test="username != null">username,</if>
			<if test="pwd != null">pwd,</if>
			</trim>
			<trim prefix="values (" suffix=")" suffixOverrides=",">
			<if test="name != null">#{name},</if>
			<if test="sex != null">#{sex},</if>
			<if test="sdate != null">#{sdate},</if>
			<if test="tel != null">#{tel},</if>
			<if test="xueli != null">#{xueli},</if>
			<if test="addr != null">#{addr},</if>
			<if test="username != null">#{username},</if>
			<if test="pwd != null">#{pwd},</if>
			</trim>
		</insert>
		<update id="update" parameterType="User">
			update user
			<trim prefix="set" suffixOverrides=",">
			<if test="name != null">name=#{name},</if>
			<if test="sex != null">sex=#{sex},</if>
			<if test="sdate != null">sdate=#{sdate},</if>
			<if test="tel != null">tel=#{tel},</if>
			<if test="xueli != null">xueli=#{xueli},</if>
			<if test="addr != null">addr=#{addr},</if>
			<if test="username != null">username=#{username},</if>
			<if test="pwd != null">pwd=#{pwd},</if>
		</trim>
			where id=#{id}
		</update>
		<delete id="delete" parameterType="User">
			delete from user where id= #{id}
		</delete>
		<select id="list" resultType="User" resultMap="userResult">
			select * from  user where 1=1 ${where} order by id desc
			</select>