eadd.jsp

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

<%@ 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 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("update scott.larchives set user_id='"+user_id+"',name='"+name+"',sex='"+sex+"',britherday='"+britherday+"' ,home='"+home+"',education='"+education+"',job='"+job+"',company='"+company+"',postcalcode='"+postcalcode+"',tel='"+tel+"',fresume='"+fresume+"',homepage='"+homepage+"',email='"+email+"',netcall='"+netcall+"',chatroom='"+chatroom+"',sport='"+sport+"',book='"+book+"',music='"+music+"',people='"+people+"',interest='"+interest+"',adage='"+adage+"',character='"+character+"',ip='"+request.getRemoteAddr()+"',star='"+star+"' where user_id like '"+user_id+"'");

//rs_lar("user_id")      =session("user_id")
//rs_lar("name")         =name
//rs_lar("sex")          =sex
//rs_lar("britherday")   =byear & "-" & bmonth & "-" & bday
//rs_lar("age")          =datediff("yyyy",byear & "-" & bmonth & "-" & bday,date)
//rs_lar("home")         =home
//rs_lar("education")    =education
//rs_lar("job")          =job
//rs_lar("company")      =company
//rs_lar("postcalcode")  =postcalcode
//rs_lar("tel")          =tel
//rs_lar("fresume")      =fresume
//rs_lar("netname")      =netname
//rs_lar("homepage")     =homepage
//rs_lar("email")        =email
//rs_lar("netcall")      =netcall
//rs_lar("chatroom")     =chatroom
//rs_lar("sport")        =sport
//rs_lar("book")         =book
//rs_lar("music")        =music
//rs_lar("people")       =people
//rs_lar("interest")     =interest
//rs_lar("adage")        =adage
//rs_lar("character")    =character
//rs_lar("ip")           =request.ServerVariables("REMOTE_ADDR")
//rs_lar("date")         =date
//rs_lar("time")         =time
//rs_lar("star")         =star
//rs_lar.update
//rs_lar.close
   }
response.sendRedirect("read.jsp?user_id="+user_id);  
%>