regdo.jsp

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

<%@ page contentType="text/html; charset=gb2312" %>
<%@ page import="myutil.*"%>
<%request.setCharacterEncoding("GB2312");%>
<jsp:useBean id="company" class="myjob.Company" scope="request" />
<jsp:setProperty name="company" property="*"/>
<% request.setCharacterEncoding("utf-8");
response.setContentType("text/html;charset=UTF-8");
%>
<%
ShowErrorBox show=new ShowErrorBox();
DealString str=new DealString();
/*
company.setCname(str.dbEncode(company.getCname()));
company.setAddress(str.dbEncode(company.getAddress()));
company.setEmail(str.dbEncode(company.getEmail()));
company.setManage(str.dbEncode(company.getManage()));
company.setName(str.dbEncode(company.getName()));
company.setPassword(str.dbEncode(company.getPassword()));
company.setResume(str.dbEncode(company.getResume()));
company.setTel(str.dbEncode(company.getTel()));
*/
if(company.getPassword().equals("")||company.getEmail().equals("")){
        out.print(show.errorBox("请添写完整信息!","错误信息"));
        return;
}else{
        if(company.getCusername().compareTo("z")>0||company.getCusername().compareTo("0")<0){
                out.print(show.errorBox("注册用户名不允许为特殊字符和汉字！","错误信息"));
                return;
        }
       int intT=0;
        DataBaseOperation data=new DataBaseOperation();
        intT=data.getRowCount("tb_company WHERE cname='"+company.getCusername()+"'");
        if(intT>0){
            out.print(show.errorBox("该用户名已被注册！","注册信息"));
            return;
        }else{            
		DataBaseConn dbc=new DataBaseConn();
        try
        {
	java.sql.Statement st=dbc.getStmt();
        String sql="INSERT INTO t_company(cuserName,ctruename,email,tel,manage,address,resume) VALUES('"+
                company.getCusername()+"','"+company.getCtruename()+"','"+company.getEmail()+"','"+
                company.getTel()+"','"+company.getManage()+"','"+company.getAddress()+"','"+company.getResume()+"')";
        st.addBatch(sql);
		//out.println(sql);把操作的SQL输出 
        sql="insert into t_user (username,userpass,usertype)values('"+company.getCusername()+"','"+company.getPassword()+"','2')";
       st.addBatch(sql);
	  // out.println(sql);把操作的SQL输出
       st.executeBatch();
	out.print("<script>alert('注册成功！');document.location='../index.jsp';</script>");
                return;
        }catch(Exception e)
         {
              out.print(show.errorBox("注册失败，数据库错误!","错误信息"));

         }
		 }
}
%>