Mybatis select statement mapping with multiple inputs -


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