String sql="select * from test where CONCAT(question,A,B,C,D) like %?%";//错String sql="select * from test where CONCAT(question,A,B,C,D) like '%'?'%'";//未得到结果String sql="select * from test where CONCAT(question,A,B,C,D) like CONCAT('%',?,'%')"//成功获得结果
后端查询函数部分代码:
QueryRunner queryRunner=newQueryRunner(dbutil.dataSource);String sql="select * from test where CONCAT(question,A,B,C,D) like CONCAT('%',?,'%')";Object[] params={keyword};
items=queryRunner.query(sql,newBeanListHandler<>(Test_item.class),params);if(items==null)System.out.println("什么也没查到");