modireginfo.jsp

用JAVA自己编写的人才招聘网站

<%@ page contentType="text/html; charset=gb2312" %>
<%@ page import="myutil.*"%>
<%@ page import="java.sql.*"%>
<% request.setCharacterEncoding("gb2312");
response.setContentType("text/html;charset=gb2312");
%>
<jsp:useBean id="JobSeeker" class="myjob.JobSeeker" scope="request" />
<jsp:setProperty name="JobSeeker" property="*"/>
<%
ShowErrorBox show=new ShowErrorBox();
String strUserName=(String)session.getAttribute("usercode");
if(JobSeeker.getname()==null||JobSeeker.getemail()==null){
	 out.print("<script>alert('信息不完整，请重新输入！');document.location='reginfo.jsp';</script>");
}else{
     DataBaseConn dbc=new DataBaseConn();
     try
     {
          java.sql.Statement st=dbc.getStmt();
          String sql="UPDATE t_jobSeeker SET trueName='"+JobSeeker.getname()+"',"+
                  " idCard='"+JobSeeker.getid_card()+"',"+
                  " sex='"+JobSeeker.getgender()+"',"+
                  " age='"+JobSeeker.getAge()+"',"+
                  " birthYear='"+JobSeeker.getbirthdate()+"',"+
                  " hkPro='"+JobSeeker.getn_address1()+"',"+
                  " hkCity='"+JobSeeker.getn_address2()+"',"+
                  " inhabitPro='"+JobSeeker.getcurr_address1()+"',"+
                  " inhabitCity='"+JobSeeker.getcurr_address2()+"',"+
                  " telephone='"+JobSeeker.getphone()+"',"+
                  " email='"+JobSeeker.getemail()+"',"+
                  " address='"+JobSeeker.getcont_address()+"',"+
                  " postCode='"+JobSeeker.getpostalcode()+"',"+
                  " field='"+JobSeeker.getmajor()+"',"+
                  " major='"+JobSeeker.getmajor_input()+"',"+
                  " diploma='"+JobSeeker.getdegree()+"',"+
                  " school='"+JobSeeker.getcollege()+"',"+
                  " workPeriod='"+JobSeeker.getyears()+"',"+
                  " foreignLag='"+JobSeeker.getlanguage()+"',"+
                  " lagLevel='"+JobSeeker.getf_level()+"',"+
                  " resume='"+JobSeeker.getresume()+"'"+
                  " WHERE ausername='"+strUserName+"'";
          //out.print(sql);
          st.executeUpdate(sql);
          out.print("<script>alert('修改成功！');</script>");
        }catch(Exception e)
         {
              out.print(show.errorBox("修改失败，数据库错误!","错误信息"));

         }
}
%>