the project spring-mybatis.i use @param annotation,but value can't pass it.
using following interface
findpage(@param("start") integer start, @param("pagesize") integer pagesize, @param("delflag") integer delflag);
the implement
findpage(@param("start") integer start, @param("pagesize") integer pagesize,@param("delflag")integer delflag) { return this.getsqlsession().selectlist(getns() + ".findpage"); }
mapper
<select id="findpage" parametertype="map" resultmap="sysuserrm"> select * sys_user del_falg = #{delflag,jdbctype=integer} limit #{start,jdbctype=integer},#{pagesize,jdbctype=integer}
errors
### error querying database. cause: com.mysql.jdbc.exceptions.jdbc4.mysqlsyntaxerrorexception: have error in sql syntax; check manual corresponds mysql server version right syntax use near 'where del_falg = null limit null,null' @ line 6
why can't receive inputs?
in order params names passed mybatis executor, must no write own implementation of mapper interface let mybatis generate proxy using:
yourmapper yourmapper = this.getsqlsession().getmapper(yourmapper.class); yourpage yourpage = yourmapper.findpage(....);
Comments
Post a Comment