WebRoot/WEB-INF/classes/com/mapper/Health.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.HealthMapper">
		<resultMap type="Health" id="healthResult">
			<id property="id" column="id"/>
			<result property="sdate" column="sdate"/>
			<result property="name" column="name"/>
			<result property="danwei" column="danwei"/>
			<result property="xiangmu" column="xiangmu"/>
			<result property="jieguo" column="jieguo"/>
			<result property="cuoshi" column="cuoshi"/>
			<result property="beizhu" column="beizhu"/>
			<result property="uname" column="uname"/>
			<result property="zt" column="zt"/>
			<result property="yijian" column="yijian"/>
		</resultMap>
		<insert id="insert" parameterType="Health">
			insert into health
			<trim prefix="(" suffix=")" suffixOverrides=",">
			<if test="sdate != null">sdate,</if>
			<if test="name != null">name,</if>
			<if test="danwei != null">danwei,</if>
			<if test="xiangmu != null">xiangmu,</if>
			<if test="jieguo != null">jieguo,</if>
			<if test="cuoshi != null">cuoshi,</if>
			<if test="beizhu != null">beizhu,</if>
			<if test="uname != null">uname,</if>
			<if test="zt != null">zt,</if>
			<if test="yijian != null">yijian,</if>
			</trim>
			<trim prefix="values (" suffix=")" suffixOverrides=",">
			<if test="sdate != null">#{sdate},</if>
			<if test="name != null">#{name},</if>
			<if test="danwei != null">#{danwei},</if>
			<if test="xiangmu != null">#{xiangmu},</if>
			<if test="jieguo != null">#{jieguo},</if>
			<if test="cuoshi != null">#{cuoshi},</if>
			<if test="beizhu != null">#{beizhu},</if>
			<if test="uname != null">#{uname},</if>
			<if test="zt != null">#{zt},</if>
			<if test="yijian != null">#{yijian},</if>
			</trim>
		</insert>
		<update id="update" parameterType="Health">
			update health
			<trim prefix="set" suffixOverrides=",">
			<if test="sdate != null">sdate=#{sdate},</if>
			<if test="name != null">name=#{name},</if>
			<if test="danwei != null">danwei=#{danwei},</if>
			<if test="xiangmu != null">xiangmu=#{xiangmu},</if>
			<if test="jieguo != null">jieguo=#{jieguo},</if>
			<if test="cuoshi != null">cuoshi=#{cuoshi},</if>
			<if test="beizhu != null">beizhu=#{beizhu},</if>
			<if test="uname != null">uname=#{uname},</if>
			<if test="zt != null">zt=#{zt},</if>
			<if test="yijian != null">yijian=#{yijian},</if>
		</trim>