【JSP开源代码栏目提醒】:网学会员,鉴于大家对JSP开源代码十分关注,论文会员在此为大家搜集整理了“ladd.jsp”一文,供大家参考学习!
<%@ 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);
}
%>