moveto.jsp

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

<%@ include file="conn.jsp"%>
<%request.setCharacterEncoding("GB2312");
String id =request.getParameter("id");
String user_id1= (String) session.getValue("user_id"); 
String sql="select * from scott.back where id like '"+id+"' "; 
ResultSet rs_lar1=stmt.executeQuery(sql); 
if(rs_lar1.next()){
	stmt.executeUpdate("INSERT INTO scott.friend(id,for_id,user_id,netname,sex,home) VALUES(scott.friendid.nextval,'"+user_id1+"','"+rs_lar1.getString("user_id")+"','"+rs_lar1.getString("netname")+"','"+rs_lar1.getString("sex")+"','"+rs_lar1.getString("home")+"')");
}
stmt.executeUpdate("delete from scott.back where id='"+id+"'");

response.sendRedirect("your.jsp"); 

%>