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)
提示这个错误,我学的不精,不知道这个到底是哪错误了
{
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)
提示这个错误,我学的不精,不知道这个到底是哪错误了
解决方案 »
- MVC的先后顺序
- 如何取list中固定值记录的条数?
- Struts2的奇怪现象
- web数据报表<修改,删除用户><都进来看看吧!!!!>
- java.net.SocketException: Connection reset --> when occurs, how to resolve
- Injection of resource dependencies failed
- 哪为大神做过cas+acegi单点登陆,求帮助!!
- 用汉字查询问题?
- 可以只用jswdk,代替tomcat吗?
- 能帮我一把吗?问题不难,可是我对jsp不属.
- hibernate开发错误
- java里读取excel摸板,写入数据以后导出
用 createStatement Statement
没不要用预处理。
改为这个看看
或者看看
rs.getString(1),rs.getString(2),rs.getString(3),rs.getString(4),rs.getString(5),rs.getDate(6)这些字段是不是越界了最重要的一点:
LYItem这个是不是一个bean,
如果是的话,看有没有
public LYItem(String a,String b,String c,String e,String f,String h){
this.a=a;
this.b=b;
this.c=c;
this.e=e;
this.f=f;
this.h=h;
}
this.a=a;
this.b=b;
this.c=c;
this.e=e;
this.f=f;
this.h=h;
}
在这个构造方法里面,少写了参数!
但是在MYSQL数据库里面查询就没有问题能出来,所以我想是不是用的PreparedStatement这块有问题。但是我不知道怎么写。
String sql = "select * from liuyan where content like '%"+"a"+"%'"这样应该就可以了
试一试吧