<?xml version="1.0" encoding="gbk" ?><!DOCTYPEmapperPUBLIC"-//mybatis.org//DTD Mapper 3.0//EN""http://mybatis.org/dtd/mybatis-3-mapper.dtd"><!--namespace=绑定一个对应的Mapper接口--><mappernamespace="com.yyt.dao.IPO_NSHARES_RFQ_PF_Mapper"><!--id名为接口的方法名 --><selectid="getAllList"resultType="com.yyt.resultBean.IPO_NSHARES_RFQ_PF"parameterType="map">
SELECT * FROM TEST
</select><selectid="getListBySecCode"resultType="com.yyt.resultBean.IPO_NSHARES_RFQ_PF"parameterType="java.lang.String">
SELECT * FROM TEST WHERE SEC_CODE=#{SEC_CODE}
</select><selectid="getListByMap"resultType="com.yyt.resultBean.IPO_NSHARES_RFQ_PF"parameterType="java.lang.String">
SELECT * FROM TEST WHERE SEC_CODE=#{SEC_CODE} AND PRD_ID=#{PRD_ID}
</select><selectid="getProductName"resultType="com.yyt.resultBean.XJJG_PRODUCT_NAME"parameterType="map">
SELECT T1.SEC_CODE, T1.PRD_ID, T2.PRODUCT_NAME
FROM IPO_NSHARES_RFQ_PF T1
LEFT JOIN PR_PRODUCT T2
ON T1.PRD_ID = T2.ID
WHERE T1.SEC_CODE = #{SEC_CODE}
AND T1.PRD_ID = #{PRD_ID}
</select></mapper>