<?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="devInfoMapper">
<resultMap id="BaseResultMap" type="com.allcam.system.manager.dev.bean.DevInfo">
<id column="ID" property="id" jdbcType="INTEGER" />
<result column="CUSID" property="cusId" jdbcType="VARCHAR" />
<result column="DEVID" property="devId" jdbcType="VARCHAR" />
<result column="DEVNAME" property="devName" jdbcType="VARCHAR" />
<result column="DEVSN" property="devSN" jdbcType="VARCHAR" />
</resultMap>
<sql id="Base_Column_List">
ID, CUSID, DEVID, DEVNAME, DEVSN
</sql>
<delete id="deleteByDevId" parameterType="java.lang.String">
delete from
TBL_DEV_INFO
where DEVID = #{devId}
</delete>
<insert id="insertDevInfo" parameterType="map">
insert into TBL_DEV_INFO
<trim prefix="(" suffix=")" suffixOverrides=",">
<if test="cusId != null and !"".equals(cusId.trim())">
CUSID,
</if>
<if test="devId != null and !"".equals(devId.trim())">
DEVID,
</if>
<if test="devSN != null and !"".equals(devSN.trim())">
DEVSN,
</if>
<if test="devName != null and !"".equals(devName.trim())">
DEVNAME,
</if>
</trim>
<trim prefix="values (" suffix=")" suffixOverrides=",">
<if test="cusId != null and !"".equals(cusId.trim())">
#{cusId,jdbcType=VARCHAR},
</if>
<if test="devId != null and !"".equals(devId.trim())">
#{devId,jdbcType=VARCHAR},
</if>
<if test="devSN != null and !"".equals(devSN.trim())">
#{devSN,jdbcType=VARCHAR},
</if>
<if test="devName != null and !"".equals(devName.trim())">
#{devName,jdbcType=VARCHAR},
</if>
</trim>
</insert>
<insert id="replaceDevInfo" parameterType="map">
REPLACE INTO TBL_DEV_INFO
<trim prefix="(" suffix=")" suffixOverrides=",">
<if test="cusId != null and !"".equals(cusId.trim())">
CUSID,
</if>
<if test="devId != null and !"".equals(devId.trim())">
DEVID,
</if>
<if test="devSN != null and !"".equals(devSN.trim())">
DEVSN,
</if>
<if test="devName != null and !"".equals(devName.trim())">
DEVNAME,
</if>
</trim>
<trim prefix="values (" suffix=")" suffixOverrides=",">
<if test="cusId != null and !"".equals(cusId.trim())">
#{cusId,jdbcType=VARCHAR},
</if>
<if test="devId != null and !"".equals(devId.trim())">
#{devId,jdbcType=VARCHAR},
</if>
<if test="devSN != null and !"".equals(devSN.trim())">
#{devSN,jdbcType=VARCHAR},
</if>
<if test="devName != null and !"".equals(devName.trim())">
#{devName,jdbcType=VARCHAR},
</if>
</trim>
</insert>
<select id="getDevInfoByLensId" resultMap="BaseResultMap"
parameterType="map">
SELECT t1.ID, t1.CUSID, t1.DEVID, t1.DEVNAME, t1.DEVSN
FROM
TBL_DEV_INFO t1, TBL_LENS_INFO t2
WHERE
t1.DEVID = t2.DEVID AND
t2.LENSID = #{lensId}
</select>
<select id="qryDevListByDevList" resultMap="BaseResultMap"
parameterType="map">
SELECT t1.ID, t1.CUSID, t1.DEVID, t1.DEVNAME, t1.DEVSN
FROM
TBL_DEV_INFO t1, TBL_LENS_INFO t2
WHERE
t1.DEVID = t2.DEVID AND
(
<foreach collection="list" item="item" index="index"
separator="or">
(t2.DEVID=#{item.devId})
</foreach>
)
</select>
<update id="updateDevInfo" parameterType="map">
update TBL_DEV_INFO
<set>
<if test="cusId != null">
CUSID = #{cusId},
</if>
<if test="devSN != null">
DEVSN = #{devSN},
</if>
<if test="devName != null">
DEVNAME = #{devName},
</if>
</set>
where DEVID = #{devId}
</update>
<select id="checkDevSnIsExistedSys" resultMap="BaseResultMap"
parameterType="map">
select * from TBL_DEV_INFO WHERE DEVSN = #{devSn} and
CUSID != #{cusId}
</select>
</mapper>
=================================================