MyBatis Error: Parameter ' * ' not found. Available parameters are [1, 0, param1, param2]

methods in the Mapper Proxy interface:

Public User Login (String loginid,string loginpwd) throws Exception;

code in Mapper.xml:

<select id= "Login" parametertype= "String" resulttype= "User" >
SELECT * from ' user ' WHERE loginid= ' #{loginid} ' and loginpwd= ' #{loginpwd} ' and role=2
</select>

Parameter ' loginID ' not found appears when calling login () . Available parameters are [1, 0, param1, param2] error.

Solution:

　When you pass only one parameter to the SQL statement, you can write the parameter name directly, which should be written when multiple arguments are passed (multiple arguments have been #{0}):?

1	Public User Login (String loginid,string loginpwd) throws Exception;

?

1 2 3

<select id= "Loginbyteacher" parametertype= "String" resulttype= "User" > select * from ' user ' WHERE loginid=#{ 0} and loginpwd=#{1} and role= 2 </select>

　　

Reference: http://www.2cto.com/database/201409/338155.html