Question

如何在一个JSP页面执行2个SQL语句？先执行选择再进行删除操作。

<% { String h=request.getParameter("hname");
db dbc = new db();
Connection con = dbc.getCon();
Statement stmt = null;
ResultSet rs = null;
Statement stmt1 = null;
String sql = "";
String str="";
try {

sql = "delete from housedel where hname='"+h+"'";
stmt = con.createStatement();

rs = stmt.executeQuery(sql);//执行查询
while (rs.next()) {//如果记录集不空 访问记录集的每一条记录
String hname = rs.getString("hname");
String addr = rs.getString("addr");
int area = rs.getInt("area");
float price = rs.getFloat("price");
String no = rs.getString("no");
float lowprice = rs.getFloat("lowprice");
String pno = rs.getString("pno");
String category = rs.getString("category");
String towards = rs.getString("towards");
String state = rs.getString("state");
str="insert into house values("+hname+","+addr+","+area+","+price+","+no+","+lowprice+","+pno+","+category+","+towards+","+state+")";
}

stmt.close();
stmt1= con.createStatement();
int result = stmt1.executeUpdate(str);//执行查询
response.setHeader("refresh","2;URL=staff.jsp");
} catch (SQLException e) {
out.println(e.getMessage());
}
}
%>

想做还原操作 删除一个表的一条记录 加入另一张表
报错没有结果集

Answer 1

rs = stmt.executeQuery(sql);//执行查询

rs.next会有值么？？
sql不是删除么。还能返回多条记录啊。我觉得这里会有问题。

追问

额 好像是这个样子 这个该如何获得被删除的各项数据呢 想insert

追答

哪有这样的啊啊、、、
你先select

然后都保存在rs结果集了
然后再删除，用别的ResultSet

最后在登录，使用rs 就好了。