<?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.chinacreator.video.mapper.ChannelDao" >
    <resultMap id="BaseResultMap" type="com.chinacreator.video.bean.ChannelBean" >
        <result column="id" property="id" jdbcType="VARCHAR" />
        <result column="password" property="password" jdbcType="VARCHAR" />
    </resultMap>
    
    <sql id="Base_Column_List" >
        id,password
    </sql>

    <select id="queryChannel" parameterType="string"  resultMap="BaseResultMap" >
       SELECT 
       <include refid="Base_Column_List" />
	   FROM  TB_CHANNEL_ORG where status=0 and id=#{id,jdbcType=VARCHAR}
    </select>
    
</mapper>