<?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.gyee.frame.mapper.custom.TsysDatasDao" >
  <resultMap id="BaseResultMap" type="com.gyee.frame.model.auto.TsysDatas" >
    <id column="id" property="id" jdbcType="VARCHAR" />
    <result column="file_path" property="filePath" jdbcType="VARCHAR" />
    <result column="file_absolute_path" property="fileAbsolutePath" jdbcType="VARCHAR" />
    <result column="file_suffix" property="fileSuffix" jdbcType="VARCHAR" />
    <result column="file_type" property="fileType" jdbcType="VARCHAR" />
  </resultMap>
  

  <sql id="Base_Column_List" >
    id, file_path, file_absolute_path, file_suffix, file_type
  </sql>

  <select id="selectByPrimaryKeys" resultMap="BaseResultMap" parameterType="java.util.List" >
    SELECT s.* from t_sys_file f
	LEFT JOIN t_sys_file_data d on f.id=d.file_id
	LEFT JOIN t_sys_datas s on s.id=d.data_id
	where f.id in
	<foreach item="item" collection="ids" open="(" separator="," close=")">
         #{item,jdbcType=VARCHAR}
    </foreach>
  </select>
 
</mapper>