急急急！！！！！在线等

Question

String sql = "select * from cropT where locus =? and field1 = ?";
PreparedStatement smt=conn.prepareStatement(sql);
smt.setstring(province);
smt.setstring(city);
rs = state.executeQuery(sql);
while(rs.next()){.......................这样试试 不行再说

Answer 1

String sql = "select * from cropT where locus =? and field1 = ?";
PreparedStatement smt=conn.prepareStatement(sql);
smt.setstring(1,province);
smt.setstring(2,city);
rs = state.executeQuery(sql);
while(rs.next()){.......................发错了 一点 这样才对 这样试试

Answer 2

String sql = "select * from cropT where locus =? and field1 = ?";
PreparedStatement smt=conn.prepareStatement(sql);
smt.setstring(1,province);
smt.setstring(2,city);
rs = smt.executeQuery(sql);
while(rs.next()){.......................晕 发现上面的还是不对 这样才是 不好意思

Answer 3

把最上面的CropTPO cpo = new CropTPO();
改為CropTPO cpo  = null;試試