这是userMapper.xml中的查询语句
<select id="queryUserByWhere" resultType="User" parameterType="User">
select id,username,birthday,sex,address from user
where sex = #{sex} and username like '%${username}%'
</select>
这是UserMapper接口
public interface UserMapper {
public List<User> queryUserByWhere(User u);
}
这是测试方法
UserMapper userMapper = sqlSession.getMapper(UserMapper.class);
User user = new User();
user.setSex("1");
user.setUsername("明");
List<User> users = userMapper.queryUserByWhere(user);
for (User user2 : users) {
System.out.println(user2);
}
执行后,输出的结果:
DEBUG [main] - Setting autocommit to false on JDBC Connection [com.mysql.jdbc.JDBC4Connection@3e57cd70]
DEBUG [main] - ==> Preparing: select id,username,birthday,sex,address from user where sex = ? and username like '%root%'
DEBUG [main] - ==> Parameters: 1(String)
DEBUG [main] - <== Total: 0
username like '%root%' 这里,里面的内容怎么变成root了?不应该是
username like '%明%' 吗?