Mybatis queries handle input errors _ MySQL

Mybatis queries handle bitsCN.com errors when passing parameters

Mybatis queries handle errors when passing parameters

Your own database is a mysql database, managed using mybatis, and the java background is the spring Framework,

Console:

1

There is no getter for property named 'xxxx' in 'Class java. lang. Integer

An error occurred. I checked it and thought there was an error in the SQL parameter type in xml. later I changed it. no, I 'd like to change it online:

SELECT id, name, login_name as loginName FROM sb_user where name like '% $ {_ parameter} %'

I changed the parameter of the original name to _ parameter. Another method is to change it in the interface defined by mapper:

By List SelectAllUserByName (String name); changed

List SelectAllUserByName (@ Param ("name") String name );

It can also solve the problem.

BitsCN.com