registerdo.jsp

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

<%@ page contentType="text/html; charset=gb2312" %>
<%@ page import="myutil.*"%>
<%@ page import="java.applet.Applet" %>
<%@ page import="java.awt.*" %>
<%//request.setCharacterEncoding("GB2312");%>
<jsp:useBean id="company" class="myjob.Company" scope="request" />
<jsp:setProperty name="company" property="*"/>
<script Language="JavaScript" src="../js/ccheck.js"></script>
<%
    ShowErrorBox show=new ShowErrorBox();
    DealString str=new DealString();
/*************************************************************************
    company.setCusername(str.dbEncode(company.getCusername()));
    company.setAddress(str.dbEncode(company.getAddress()));
    company.setEmail(str.dbEncode(company.getEmail()));
    company.setManage(str.dbEncode(company.getManage()));
    company.setCtruename(str.dbEncode(company.getCtruename()));
    company.setPassword(str.dbEncode(company.getPassword()));
    company.setResume(str.dbEncode(company.getResume()));
    company.setTel(str.dbEncode(company.getTel()));
**************************************************************************/
    String Cusername=str.toGb(request.getParameter("cusername"));
    String Password =str.toGb(request.getParameter("password"));
    String Repassword =str.toGb(request.getParameter("rpassword"));
    String Ctruename=str.toGb(request.getParameter("ctruename"));
    String Comtype=str.toGb(request.getParameter("comtype"));
    String Linkmanname=str.toGb(request.getParameter("linkmanname"));
    String Tel=request.getParameter("tel");
    String Phone=request.getParameter("phone");
    String Manage=str.toGb(request.getParameter("manage"));
    String Province=str.toGb(request.getParameter("province"));
    String City=str.toGb(request.getParameter("city"));
    String Address=str.toGb(request.getParameter("address"));
    String Card=request.getParameter("card");
    String Email=request.getParameter("email");
    String HTTPmajor=request.getParameter("httpmajor");
    String Comintr=str.toGb(request.getParameter("comintr"));
    
    //int pro = atoi(Province);
   //Province = 
    //out.print(pro);
    
    int intT=0;
    DataBaseOperation data=new DataBaseOperation();
    intT = data.getRowCount("t_company WHERE cuserName='"+Cusername+"'");
    if(intT>0){
        out.print("<script>alert('该用户名已被注册！！');document.location='register.jsp';</script>");
        return;
    }else{
        DataBaseConn dbc=new DataBaseConn();
        try{
            java.sql.Statement st=dbc.getStmt();
            String sql="INSERT INTO t_company(cuserName,password,ctruename,comtype,linkmanname,tel,phone,manage,province,city,address,card,email,httpmajor,comintr) VALUES('"+
                    Cusername+"','"+Password+"','"+Ctruename+"','"+Comtype+"','"+Linkmanname+
                    "','"+Tel+"','"+Phone+"','"+Manage+
                    "','"+Province+"','"+City+
                    "','"+Address+"','"+Card+
                    "','"+Email+"','"+HTTPmajor+"','"+Comintr+"')";
            st.addBatch(sql);
            //out.println(sql);
            sql="insert into t_user (username,userpass,usertype)values('"+Cusername+"','"+Password+"','2')";
            st.addBatch(sql);
            //out.println(sql);
            st.executeBatch();
            out.print("<script>alert('注册成功！');document.location='../index.html';</script>");
            return;
        }catch(Exception e) {
            out.print(show.errorBox("注册失败，数据库错误!","错误信息"));
            //out.print("<script>alert('注册失败，数据库错误！');document.location='register.jsp';</script>");

        }
    }
    %>