apply.jsp

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

<%@ include file="conn.jsp"%>
<%request.setCharacterEncoding("GB2312");

 String user_id1= (String) session.getValue("user_id"); 
//叛断Session变量是否超时
if((user_id1==null)|(user_id1=="")){
response.sendRedirect("timeout.htm"); 
}

//叛断此用户是否已经入会
String user_id2="1";
if(user_id1.equals(user_id2)){
  response.sendRedirect("notreg.htm");
}
String user_id=request.getParameter("user_id");
String netname=request.getParameter("netname");

String sql="select * from scott.apply where (for_id='"+user_id1+"' and user_id='"+user_id+"') or (user_id='"+user_id1+"' and for_id='"+user_id+"')"; 
ResultSet rs_apply=stmt.executeQuery(sql); 
   if(rs_apply.next()){
 response.sendRedirect("read.asp?user_id="+user_id);
   }
   rs_apply.close();

sql="select * from scott.larchives where user_id='"+user_id1+"'"; 
ResultSet rs_lar=stmt.executeQuery(sql); 
   if(!rs_lar.next()){
 response.sendRedirect("notreg.htm");
   }else{
stmt.executeUpdate("INSERT INTO scott.apply(id,for_id,user_id,user_name,user_netname,user_sex,user_age,user_home) VALUES(scott.applyid.nextval,'"+user_id+"','"+user_id1+"','"+rs_lar.getString("name")+"','"+rs_lar.getString("netname")+"','"+rs_lar.getString("sex")+"','"+rs_lar.getString("age")+"','"+rs_lar.getString("home")+"')");
   }
   Statement stmt2=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_UPDATABLE); 
stmt2.executeUpdate("update scott.larchives set renqi=renqi+1 where user_id='"+user_id+"'");
 response.sendRedirect("read.jsp?user_id="+user_id);

%>