Org. hibernate. queryexception: Expected positional parameter count: 2, actual parameters: [] [from us

Error: org. hibernate. queryexception: Expected positional parameter count: 2, actual parameters: [] [from user where username =? And Password =?]

The error code is:

Query q = session. createquery ("from user where username =? And Password =? ");

Cause:

There are two placeholders "?" In the hql statement. In query. setparameter (), a relative bit must be passed in. Otherwise, the above exception will occur.

Solution:

Query q = session. createquery ("from user where username =? And Password =? ");
Q. setstring (0, username );
Q. setstring (1, password );

The index of the query class starts from 0. 0 indicates the first question mark, and 1 indicates the second question mark.