refuse.jsp

来自「JSP+ORACLE网站开发实例（下）.rar」· JSP 代码 · 共 15 行

<%@ include file="conn.jsp"%>
<%request.setCharacterEncoding("GB2312");
String id =request.getParameter("id");
String user_id =request.getParameter("user_id");
String user_id1= (String) session.getValue("user_id"); 
stmt.executeUpdate("delete from scott.apply where id='"+id+"'");

String sql="select * from scott.larchives where user_id='"+user_id1+"' "; 
ResultSet rs_lar=stmt.executeQuery(sql); 
if(rs_lar.next()){
stmt.executeUpdate("INSERT INTO scott.back(id,user_id,for_id,name,sex,netname,home,result) VALUES(scott.backid.nextval,'"+user_id1+"','"+user_id+"','"+rs_lar.getString("name")+"','"+rs_lar.getString("sex")+"','"+rs_lar.getString("netname")+"','"+rs_lar.getString("home")+"','已拒绝')");
}

response.sendRedirect("your.jsp"); 
%>