search.java

纯jsp做的人事招聘系统

package com.db;
import java.sql.*;
import java.util.ArrayList;

import com.page.Employ;
import com.page.Pagebean;

public class Search {
	
	public Search(){}
	
	static Connection dbConn, conn;
	static PreparedStatement ps,ps1,psm;
	static ResultSet rs,rs1,rsm;
	static ArrayList arr;

	public static ArrayList getpost(Pagebean pagebean){
		int pageNum = pagebean.getpageNum();
		int currPage = pagebean.getcurrPage();
		String condition = pagebean.getcondition();
		
		int start = currPage * pageNum;
		int end = start + pageNum;
		
		String sql, sql1;
		
		if(condition.equals("")){
			sql1 = "select count(*) from employ_message";
			sql = "select * from employ_message";
		}else{
			sql1 = "select count(*) from employ_message where no like '%"+condition+"%' or com_name like '%"+condition+"%'" +
					"or position like '%"+condition+"%' or  needs like '%"+condition+"%'";
			sql = "select * from employ_message where no like '%"+condition+"%'or com_name like '%"+condition+"%'" +
					"or position like '%"+condition+"%' or  needs like '%"+condition+"%'";
		}

		ArrayList result = new ArrayList();
		try{
			conn = DBPool.getConnection();
			ps1 = conn.prepareStatement(sql1);
			rs1 = ps1.executeQuery();
			
			while(rs1.next()) 
				Pagebean.setRecordNum(rs1.getInt(1));		
			
			rs1.close();
			ps1.close();
			ps = conn.prepareStatement(sql);
			rs = ps.executeQuery();
			int rowNum = 1;
			
			while(rs.next()){
				if((rowNum > start)&&(rowNum <= end)){
					Employ info = new Employ();
					info.setNo(rs.getString(1));
					info.setCom_name(rs.getString(2));
					info.setPosition(rs.getString(3));
					info.setNeeds(rs.getString(4));
					info.setQuantity(rs.getInt(5));
					result.add(info);
				}
				rowNum++;				
			}
			Pagebean.setRecordNum(rowNum);
			rs.close();
			ps.close();
			conn.close();			
		}catch(Exception e){
			System.out.println(e.getMessage());
		}
		return result;		
	}
	
	public static Employ information(String no){
		String sql = "";
		Employ info = new Employ();
		sql = "select * from employ_message where no =" + no;
		conn = DBPool.getConnection();
		try {
			psm = conn.prepareStatement(sql);
			rsm = psm.executeQuery();	
			while(rsm.next()){	
				info.setNo(rsm.getString(1));
				info.setCom_name(rsm.getString(2));
				info.setPosition(rsm.getString(3));
				info.setNeeds(rsm.getString(4));
				info.setQuantity(rsm.getInt(5));
				}	
			rsm.close();
			psm.close();
			conn.close();
		} catch (SQLException e) {System.out.println("adsadasdsadsa");
		System.out.println(e.getMessage());
			// TODO 自动生成 catch 块
			e.printStackTrace();
		}		
		return info;	
	}	
	
	public static ArrayList upName(String com_name){
		String sql;
		
		ArrayList result = new ArrayList();
		sql = "select * from fileurl where post_name =?";
		try{
			conn = DBPool.getConnection();	
			ps = conn.prepareStatement(sql);
			ps.setString(1, com_name);
			rs = ps.executeQuery();

			while(rs.next()){
				result.add(rs.getString(2));	
			}
			rs.close();
			ps.close();
			conn.close();			
		}catch(Exception e){
		}
		return result;		
	}
	
		
	
}