<select id="selectPageTblSfFiles" parameterType="TblSfFile" resultMap="TblSfFileResult">
SELECT
<include refid="TblSfFile_columns" />
FROM TBL_SF_FILE
WHERE MERID =#{merid}
</select>
sql 日志
SELECT
TR_SSN ,BATCHNO ,FILENAME ,PARENT_BATCHNO ,PARENT_FILENAME ,LEVELS ,INCHNNLCODE ,CHNNLBANKCODE ,DATA_TYPE ,TRANS_TYPE ,MERID ,BUSITYPE ,SETTDAY ,ALLCOUNT ,ALLCOUNTSUM ,CURRENCY ,RETURNCOUNT ,PROCSTATUS ,TRANSTATUS ,INTRANSCODE ,TRANS_NUM ,VERSION ,MISC1 ,MISC2 ,MISC3 ,ADDUSER ,SUBMITTIME ,SUBMITRETTIME ,REVTIME ,SENDTIME ,SENDRETTIME ,SENDNUMBER ,CONFIRMTIME ,LAST_UPD_TS
FROM
TBL_SF_FILE
WHERE
MERID ='9999000012' {executed in 32 msec}]
这里是SSSSSSS查询出来的数据0