一條整的sql語句傳入報(bào)錯(cuò),想搞懂這個(gè)問題的原因，方法:public List<daily_defray_total> complexSqlQuery(String sql){ return ddtMapper.complexSqlQuery(sql);}這里傳入整條sql:String defrayTotalSql = " SELECT * FROM daily_defray_total ";
List<daily_defray_total> dailyDefrayTotalList = dailyDefrayTotalMapper.complexSqlQuery(defrayTotalSql);在xml文件里 ,1和2都試過1<select id="complexSqlQuery" resultMap="BaseResultMap"parameterType="String"> #{0}</select>2<select id="complexSqlQuery" resultMap="BaseResultMap" parameterType="java.lang.String"> #{sql,jdbcType=VARCHAR}</select>報(bào)錯(cuò)You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' SELECT * FROM daily_defray_total '' at line 1
2 回答
元芳怎么了
TA貢獻(xiàn)1798條經(jīng)驗(yàn) 獲得超7個(gè)贊
1.我沒有見過參數(shù)類型是String,貌似只有java.lang.String.
2.傳遞參數(shù)你要給用一個(gè)參數(shù)來接收.
largeQ
TA貢獻(xiàn)2039條經(jīng)驗(yàn) 獲得超8個(gè)贊
SQL語句不用*號(hào),用表的字段，
String defrayTotalSql = " SELECT u_id FROM daily_defray_total ";
<select id="complexSqlQuery"resultMap="BaseResultMap"parameterType="String">
${value}
</select>
添加回答
舉報(bào)
0/150
提交
取消