Question

mysql问题

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 '?0' at line 1
这是我写的代码，求看看是哪里的错误，万分感谢
public ResultSet getStock_ID(Stock stock) {
ResultSet ID;
Connection conn = null;
PreparedStatement ps = null;
ResultSet rs = null;
try {
conn = JdbcUtils.getConnection();
String sql = "select stock_id from gpxx where stock_name=?" + stock.getstock_id();
ps = conn.prepareStatement(sql);
//ps.setString(1, stock.getstock_name());
ID = ps.executeQuery(sql);
} catch (SQLException e) {
throw new exception(e.getMessage(), e);
} finally {
JdbcUtils.free(rs, ps, conn);
}
return ID;

Answer 1

哥们，记混了吧，，，，，String sql = "select stock_id from gpxx where stock_name= 【?】" + stock.getstock_id();，，，，，这句话貌似不能有？吧。。。。多看看prepareStatement和statement的区别。。。

Answer 2

你把 ？ 去了