pubjobdo1.jsp

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

<%@ page contentType="text/html; charset=GB2312"%>
<%@ page import="myutil.*"%>
<%@ page import="java.sql.*"%>
<%//request.setCharacterEncoding("GB2312");%>

<%
 //DataBaseOperation data=new DataBaseOperation();使用封装对数据库操作无效，必须内部加载驱动。
  ShowErrorBox show=new ShowErrorBox();
  DealString str=new DealString();
    String Kind=request.getParameter("kind");
    String Vocation1=request.getParameter("vocation1");
    String Vocation2=request.getParameter("vocation2");
    String Position=request.getParameter("position");
    String Major=request.getParameter("major");
    String Major_input=request.getParameter("major_input");
    String Degree=request.getParameter("degree");
    String Gender=request.getParameter("gender");
    String Age1=request.getParameter("age1");
    String Age2=request.getParameter("age2");
    String Years=request.getParameter("years");
    String Salary=request.getParameter("salary");
    String Salarymax=request.getParameter("salarymax");
    String Limitdate=request.getParameter("limitdate");
    String N_address1=request.getParameter("n_address1");
    String N_address2=request.getParameter("n_address2");
    String W_address1=request.getParameter("w_address1");
    String W_address2=request.getParameter("w_address2");
    String Number=request.getParameter("number");
    String Other=request.getParameter("other");
  if(Vocation1==""||Vocation2==""&&Position==""&&Major==""&&Major_input==""&&Salary==""&&Salarymax==""&&Limitdate==""&&W_address1==""&&W_address2==""&&Number==""){out.print("<script>alert('请把必填项填写完整');document.location='pubJob1.html';</script>");}
   int intT=0;
          String strName=(String)session.getAttribute("usercode");
    try{  String sql="INSERT INTO t_pubjob(cuserName,jobkind,positionkind,positionkind1,detailposition,majorruquir,detailmajorruquir,knowledge,sex,age0,age1,worktime,salary,salaryin,endtime,peopleplace,peoplecity,workplace,workplacecity,number,other) VALUES('"+strName+"','"+
		str.toGb(Kind)+"','"+str.toGb(Vocation1)+"','"+str.toGb(Vocation2)+"','"+str.toGb(Position)+"','"+
		str.toGb(Major)+"','"+str.toGb(Major_input)+"','"+str.toGb(Degree)+"','"+str.toGb(Gender)+"','"+Age1+"','"+
                  Age2+"','"+str.toGb(Years)+"','"+str.toGb(Salary)+"','"+Salarymax+"','"+str.toGb(Limitdate)+"','"
                  +str.toGb(N_address1)+"','"+str.toGb( N_address2)+"','"+str.toGb(W_address1)+"','"+str.toGb(W_address2)+"','"+Number+"','"+str.toGb(Other)+"')";
      
          //intT=data.insert("INSERT INTO t_pubjob(cuserName,jobkind,positionkind,positionkind1,detailposition,majorruquair,detailmajorruquir,knowledge,sex,age0,age1,worktime,salary,salaryin,endtime,peopleplace,peoplecity,workplace,workplacecity,number,other) VALUES('"+strName+"','"+
	  //	str.toGb(Kind)+"','"+str.toGb(Vocation1)+"','"+str.toGb(Vocation2)+"','"+str.toGb(Position)+"','"+
	  //	str.toGb(Major)+"','"+str.toGb(Major_input)+"','"+str.toGb(Degree)+"','"+str.toGb(Gender)+"','"+Age1+"','"+
          //         Age2+"','"+str.toGb(Years)+"','"+str.toGb(Salary)+"','"+Salarymax+"','"+str.toGb(Limitdate)+"','"
          //        +str.toGb(N_address1)+"','"+str.toGb( N_address2)+"','"+str.toGb(W_address1)+"','"+str.toGb(W_address2)+"','"+Number+"','"+str.toGb(Other)+"')");   
                       
                String drivername = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
                String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=xiaoyujob;user=sa;password=sa;";
                Statement stmt=null;
                Connection con=null;
               
                Class.forName(drivername).newInstance();
                con = DriverManager.getConnection(url);
                stmt = con.createStatement();
                intT = stmt.executeUpdate(sql);
      
	if(intT<=0){
		out.print(show.errorBox("发布失败，数据库错误!","错误信息"));
	
    return;	
	}else{
		out.print("<script>alert('发布成功！');document.location='delJobSelect.jsp';</script>");
	}
    }catch(Exception e){
        
    }

%>