JSP实现模糊查询,请问下我这个方法哪有问题
public static List getValues(String a)
{
List list = new ArrayList();
String sql = "select * from liuyan where content like '%"+"?"+"%'" ;
try{
ConnFactory cf = new ConnFactory();
conn = cf.getConnection();
ps=conn.prepareStatement(sql);
ps.setString(1, a);
rs = ps.executeQuery();
LYItem tmp;
while(rs.next())
{
tmp = new LYItem(rs.getString(1),rs.getString(2),rs.getString(3),rs.getString(4),rs.getString(5),rs.getDate(6));
list.add(tmp);
}
conn.close();
ps.close();
rs.close();
}catch(Exception e)
{
e.printStackTrace();
}
return list;
}
java.sql.SQLException: No parameters defined during prepareCall()id name
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:910)
at com.mysql.jdbc.ServerPreparedStatement.getBinding(ServerPreparedStatement.java:751)
at com.mysql.jdbc.ServerPreparedStatement.setString(ServerPreparedStatement.java:1857)
at com.zqxgsj.beans.LYManager.getValues(LYManager.java:54)
at com.zqxgsj.beans.LYManager.main(LYManager.java:126)
提示这个错误,我学的不精,不知道这个到底是哪错误了