String date="2014-07-26";
String sql = "select * from tbloal where time<=? order by app,time LIMIT 0 , 1000";
java.sql.PreparedStatement st = conn.prepareStatement(sql, ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_UPDATABLE);
(1)st.setDate(1, java.sql.Date.valueOf(date));
(2) st.setString(1, date);
ResultSet rds = st.executeQuery(sql);
不管是(1)还是(2)都报错
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '? order by app,time LIMIT 0 , 1000' at line 1
请问是什么原因,要如果修改谢谢了。
------解决方案--------------------
ResultSet rds = st.executeQuery(sql);
改成
ResultSet rds = st.executeQuery();