regdo.jsp

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

<%@page contentType="text/html"%>
<%@page pageEncoding="gb2312"%>
<%@ page import="myutil.*,javax.servlet.http.HttpServletRequest"%>
<% 
      request.setCharacterEncoding("gb2312");
      response.setContentType("text/html;charset=gb2312");
%>
<jsp:useBean id="jobSeeker" class="myjob.JobSeeker" scope="request" />
<!--构造jobSeeker类的对象 jobSeeker-->
<jsp:setProperty name="jobSeeker" property="*"/>
<!--设置对象jobSeeker的属性-->
<%
      ShowErrorBox show=new ShowErrorBox();
      DataBaseConn dbc=new DataBaseConn();
      try
      {
            java.sql.Statement st=dbc.getStmt();
            String sql="INSERT INTO t_jobSeeker(auserName,trueName,idCard,sex,age,birthyear,hkPro,hkCity," +
                    "inhabitPro,inhabitCity,telephone,email,address,postCode,field,major,diploma,school," +
                    "workPeriod,foreignLag,lagLevel,resume) VALUES('"+
                    jobSeeker.getuserid()+"','"+
                    jobSeeker.getname()+"','"+jobSeeker.getid_card()+"','"+jobSeeker.getgender()+"','"+
                    jobSeeker.getAge()+"','"+jobSeeker.getbirthdate()+"','"+
                    jobSeeker.getn_address1()+"','"+jobSeeker.getn_address2()+"','"+
                    jobSeeker.getcurr_address1()+"','"+jobSeeker.getcurr_address2()+"','"+
                    jobSeeker.getphone()+"','"+jobSeeker.getemail()+"','"+
                    jobSeeker.getcont_address()+"','"+
                    jobSeeker.getpostalcode()+"','"+jobSeeker.getmajor()+"','"+
                    jobSeeker.getmajor_input()+"','"+jobSeeker.getdegree()+"','"+
                    jobSeeker.getcollege()+"','"+jobSeeker.getyears()+"','"+
                    jobSeeker.getlanguage()+"','"+jobSeeker.getf_level()+"','"+
                    jobSeeker.getresume()+"')";
            System.out.println(sql);
            st.addBatch(sql);
            //添加一个sql语句进statement   


            sql="insert into t_user(userName,userPass,userType)values('"+
                    jobSeeker.getuserid()+"','"+jobSeeker.getPassword()+"','1')";

            st.addBatch(sql);
            //添加一个sql语句进statement
            st.executeBatch();
            //st.execute(sql);
            //批执行 上面添加的sql语句
            out.print("<script>alert('注册成功！');document.location='../index.html';</script>");
            return;
      }
      catch(Exception e)
      {
            out.print(show.errorBox("注册失败，数据库错误!","错误信息"));
      };
%>