【JSP开源代码栏目提醒】:本文主要为网学会员提供apply.jsp,希望对需要apply.jsp网友有所帮助,学习一下!
<%@ 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);
%>
上一篇:
application_submit.jsp
下一篇:
计算机实践报告论文