如题, 代码片段如下String sql = "select top ? * from foodinfo where foodId not in(select top ? foodId from foodinfo order by foodId) order by foodId";conn = this.getConn();
try {
pst = conn.prepareStatement(sql);
pst.setInt(1, 5);
pst.setInt(2, 5);
rs = pst.executeQuery();
try {
pst = conn.prepareStatement(sql);
pst.setInt(1, 5);
pst.setInt(2, 5);
rs = pst.executeQuery();
在这里?占位符不起作用 你只能用连接字符串(报错)
String sql = "select top "+value+" * from foodinfo where foodId not in(select top"+value+" foodId from foodinfo order by foodId) order by foodId";