ladd.jsp

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

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

 String user_id= (String) session.getValue("user_id"); 
//叛断Session变量是否超时
if((user_id==null)|(user_id=="")){
response.sendRedirect("timeout.htm"); 
}
//判断是否已经填写档案
String sql="select * from scott.larchives where user_id='"+user_id+"'"; 
ResultSet rs_lar=stmt.executeQuery(sql); 
   if(rs_lar.next()){
	  out.print("您已经建立了档案!");
   }else{
String name=request.getParameter("name");
String sex=request.getParameter("sex");
String byear =request.getParameter("Byear");
String bmonth=request.getParameter("Bmonth");
String bday=request.getParameter("Bday");

String britherday=byear+"-"+bmonth+"-"+bday;
String province=request.getParameter("province");
String home=request.getParameter("home");
 home=province+home;
String education=request.getParameter("education");
String job=request.getParameter("job");
String company=request.getParameter("company");
String postcalcode=request.getParameter("postcalcode");
String tel=request.getParameter("tel");
String fresume=request.getParameter("fresume");
String netname=request.getParameter("netname");
String homepage=request.getParameter("homepage");
String email=request.getParameter("email");
String netcall=request.getParameter("netcall");
String netcallcode=request.getParameter("netcallcode");
String chatroom=request.getParameter("chatroom");
String sport=request.getParameter("sport");
String book=request.getParameter("book");
String music=request.getParameter("music");
String people=request.getParameter("people");
String interest=request.getParameter("interest");
String adage=request.getParameter("adage");
String character=request.getParameter("character");
String star= "山羊座";
%>


<%

stmt.executeUpdate("INSERT INTO scott.larchives(lar_id,user_id,name,sex,britherday,home,education,job,company,postcalcode,tel,fresume,netname,homepage,email,chatroom,sport,book,music,people,interest,adage,character,ip,star) VALUES(scott.larchivesid.nextval,'"+user_id+"', '"+name+"','"+sex+"','"+britherday+"','"+home+"','"+education+"','"+job+"','"+company+"','"+postcalcode+"','"+tel+"','"+fresume+"','"+netname+"','"+homepage+"','"+email+"','"+chatroom+"','"+sport+"','"+book+"','"+music+"','"+people+"','"+interest+"','"+adage+"','"+character+"','"+request.getRemoteAddr()+"','"+star+"')");

response.sendRedirect("read.jsp?user_id="+user_id);  
   }
%>