<select id= "Qryuser" resultclass= "Java.util.HashMap" parameterclass= "Java.util.HashMap" >select userId from Sys _user WHERE 1=1<isnotempty property= "userid" >and userid = "#userId #" </isNotEmpty></select>
The above statement is an error
Sqlmapclient operation; SQL []; \ n
---The error occurred while applying a parameter map. \ n
---Check the rolemanagersqlmap.qryuserauthorityids-inlineparametermap. \ n
---Check the parameter mapping for the ' UserId ' property. \ n
---Cause:java.sql.SQLException:Parameter index out of range (1 > number of parameters, which is 0).; Nested exception is com.ibatis.common.jdbc.exception.NestedSQLException: \ n
---The error occurred while applying a parameter map. \ n
---Check the rolemanagersqlmap.qryuserauthorityids-inlineparametermap. \ n
---Check the parameter mapping for the ' UserId ' property. \ n
---Cause:java.sql.SQLException:Parameter index out of range (1 > number of parameters, which is 0).
Looked for a long, originally because
<isnotempty property= "userid" >and userid = "#userId #" </isNotEmpty>
This #userid# outside the double quotation marks, the double quotation marks to remove the good
Ibatis Query Exception Parameter index out of range