Mybatis querying a SQL spelling instance of a parameter

1, in the corresponding ***mapper.java write the corresponding method (focus on the parameters)

Java.util.list<com.thunisoft.sjzljc.pojo.ttjfxwsgz> selectzjxqlist (@Param ("Cbhgzdy") String Cbhgzdy , @Param ("Cropid") String cropid);

2, the corresponding ***mapper.xml in the spelling of SQL

<select id= "selectzjxqlist" resultmap= "Baseresultmap" >
Select C_ah,c_wsmc,c_bh_ws
from {Db.t_tjfx_wsgz}
where c_bh_gzdy = #{cbhgzdy}
<if test= "Cropid!=null" >
and C_BH_DW3 in (${cropid})
</if>
ORDER BY C_ah
</select>

Note: The parameter is preceded by the # sign and the $ symbol, the difference is that, #号有防止SQL注入的功能, the parameters will be processed, but the $ symbol is to get the value of your original pass.

Mybatis querying a SQL spelling instance of a parameter