<?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.devplatform.equipment.modules.liresourcecamera.dao.LiResourceCameraDao">
  <!-- Result Map -->
  <resultMap id="BaseResultMap" type="com.devplatform.equipment.modules.liresourcecamera.bean.LiResourceCamera">
    <result column="id" property="id"/>
    <result column="resource_id" property="resourceId"/>
    <result column="camera_id" property="cameraId"/>
    <result column="sys_sign" property="sysSign"/>
  </resultMap>

  <!-- li_resource_camera table all fields -->
  <sql id="Base_Column_List">
		id,resource_id,camera_id,sys_sign
	</sql>

  <!-- 公共查询条件 -->
  <sql id="Example_Where_Clause">
    where deleted=0
    <if test="id!=null and id!=''">and id = #{id}</if>
    <if test="resourceId!=null and resourceId!=''">and resource_id = #{resourceId}</if>
    <if test="cameraId!=null and cameraId!=''">and camera_id = #{cameraId}</if>
    <if test="sysSign!=null and sysSign!=''">and sys_sign = #{sysSign}</if>
  </sql>
  <select id="getByResourceId"
    resultType="com.devplatform.equipment.modules.liresourcecamera.bean.LiResourceCamera">
		select *
		from li_resource_camera lrc
		where lrc.resource_id = #{resourceId}
	</select>


</mapper>


