searchservlet.java

用jsp,servlet实现人力资源管理系统

package com.servlet;

import java.io.IOException;
import java.io.UnsupportedEncodingException;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.List;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import cn.com.search.JDBCTest1;

public class searchServlet extends HttpServlet{

	public void doGet(HttpServletRequest request,HttpServletResponse response){
		doPost(request,response);
	}
	public void doPost(HttpServletRequest request,HttpServletResponse response){
		try {
			request.setCharacterEncoding("gb2312");
			response.setCharacterEncoding("gb2312");
		} catch (UnsupportedEncodingException e2) {
			// TODO Auto-generated catch block
			e2.printStackTrace();
		}
	    
		String emp_name = request.getParameter("textfield5");
		String emp_sex = request.getParameter("select");
		String emp_state = request.getParameter("select2");
		String emp_degree = request.getParameter("textfield8");
		String emp_birth = request.getParameter("textfield");
		String emp_department = request.getParameter("textfield1");
		String emp_work = request.getParameter("textfield2");
		String emp_school = request.getParameter("textfield3");
		System.out.println("Info is:"+emp_name+emp_sex+emp_state
						+emp_degree+emp_birth+emp_department+emp_work+emp_school);
	
	
		JDBCTest1 jd = new JDBCTest1();
		List l = null;

				l = jd.getInfo(emp_name, emp_sex, emp_state, emp_degree, emp_birth, emp_department, emp_work, emp_school);
				
					request.setAttribute("infoSea", l);
//					String id = r.getString("EMP_ID");
//					String name = r.getString("EMP_NAME");
//					String sex = r.getString("EMP_SEX");
//					String birth = r.getString("EMP_BIRTH");
//					String idenfy = r.getString("EMP_IDENFY");
//					
//					request.setAttribute("id", id);
//					request.setAttribute("name", name);
//					request.setAttribute("sex", sex);
//					request.setAttribute("birth", birth);
//					request.setAttribute("idenfy", idenfy);				

		     jd.connClose();

			try {
				request.getRequestDispatcher("/form/information.jsp").forward(request,response);
			} catch (ServletException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			} catch (IOException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
            

		
	}

}