PreparedStatement stat=con.prepareStatement("select * from t_factory where fac_address like '%?%'");
这个总是报错,
Exception in thread "main" java.sql.SQLException: No parameters defined during prepareCall()
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 demo.TestJDBC.main(TestJDBC.java:14)
怎么解决
不要说字符串拼接哦
[b]问题补充:[/b]
[quote]
你没给PreparedStatement 设置参数啊
这个sql不是有个“?”吗,
[/quote]
是有?的,好像是因为在 '%?%'这么用才引起的问题,