accept.jsp

JSP+ORACLE网站开发实例（下）.rar

<%@ 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")+"','已接受')");
}


Statement stmt3=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE); 
sql="select * from scott.larchives where user_id='"+user_id+"' "; 
ResultSet rs_lar1=stmt3.executeQuery(sql); 
if(rs_lar1.next()){
	Statement stmt2=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE); 
stmt2.executeUpdate("INSERT INTO scott.friend(id,for_id,user_id,netname,sex,home) VALUES(scott.friendid.nextval,'"+user_id1+"','"+user_id+"','"+rs_lar1.getString("netname")+"','"+rs_lar1.getString("sex")+"','"+rs_lar1.getString("home")+"')");
}

response.sendRedirect("your.jsp"); 

%>