jdbcTemplate异常：like模糊查询报错(Parameter index out of range (1 > number of parameters)

http://cuisuqiang.iteye.com/blog/1480525

 

模糊查询like要这样写

注意Object参数和like语法

 

public static void main(String[] args) {
    Object[] para = new Object[]{"%c%"};
    List<Object[]> list = excuteQuery("select * from s_user t where t.userName like ?",para);
    for (Object[] o : list) {
        for (Object ob : o) {
            System.out.print(ob + "-");
        }
        System.out.println();
    }
}

来自为知笔记(Wiz)