<?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.CpSpDao" >
    <resultMap id="BaseResultMap" type="com.chinacreator.video.bean.CpSpBean" >
        <result column="cpid" property="cpid" jdbcType="VARCHAR" />
        <result column="spid" property="spid" jdbcType="VARCHAR" />
         <result column="netpwd" property="pwd" jdbcType="VARCHAR" />
        <result column="vacproductid" property="vacproductid" jdbcType="VARCHAR" />
        <result column="spcode" property="spcode" jdbcType="VARCHAR" />
        <result column="type" property="type" jdbcType="VARCHAR" />
        <result column="mutex" property="mutex" jdbcType="VARCHAR" />
        <result column="mobtype" property="mobtype" jdbcType="VARCHAR" />
        <result column="mutextype" property="mutextype" jdbcType="VARCHAR" />
    </resultMap>
    
    <sql id="Base_Column_List" >
        b.cpid, b.spid,netpwd,vacproductid,spcode,b.type,mutex,mobtype,mutextype
    </sql>

    <select id="getCpSp" parameterType="string"  resultMap="BaseResultMap" >
       SELECT 
       <include refid="Base_Column_List" />
	   FROM  TB_CP_ACCOUNT_CONFIG a, tb_sp_info b where a.cpid=b.cpid and b.cpid=#{cpid} and b.spid=#{spid}
    </select>
    
</mapper>