pool.java

纯jsp做的人事招聘系统

package com.db;

import java.sql.*;
import java.util.*;

public class Pool {

	Connection con;

	PreparedStatement ps;

	ResultSet rs;

	public Pool() {
	}

	public void adds(ArrayList arr) {

		con = DBPool.getConnection();

		String name = (String) arr.get(0);
		String password = (String) arr.get(1);
		String identify = (String) arr.get(2);
		try {
			String sql = "insert into employ values(?,?,?)";

			ps = con.prepareStatement(sql);

			ps.setString(1, name);
			ps.setString(2, password);
			ps.setString(3, identify);
			ps.executeUpdate();
		} catch (SQLException exc) {
		}
	}

	public boolean name_search(ArrayList arr) {

		con = DBPool.getConnection();

		String name = (String) arr.get(0);

		try {
			String sql = "select * from employ where name=?";

			ps = con.prepareStatement(sql);

			ps.setString(1, name);

			rs = ps.executeQuery();

			if (rs.next()) {
				DBPool.dbClose(con, ps, rs);
				return true;
			} else {
				DBPool.dbClose(con, ps, rs);
				return false;
			}
		} catch (SQLException exc) {
			return false;
		}
	}

	public boolean search(ArrayList arr) {

		con = DBPool.getConnection();

		String name = (String) arr.get(0);
		String password = (String) arr.get(1);
		String identify = (String) arr.get(2);

		try {
			String sql = "select * from employ where name=? and password=? and identify=?";

			ps = con.prepareStatement(sql);

			ps.setString(1, name);
			ps.setString(2, password);
			ps.setString(3, identify);

			rs = ps.executeQuery();

			if (rs.next()) {
				DBPool.dbClose(con, ps, rs);
				return true;
			} else {
				DBPool.dbClose(con, ps, rs);
				return false;
			}
		} catch (SQLException exc) {
			return false;
		}
	}

	public ResultSet getrs(String condition) {

		con = DBPool.getConnection();

		try {
			String sql = "select * from imploy_message where no like %?% or com_name like %?% or position like %?% or needs like %?% or quantity like %?%";

			ps = con.prepareStatement(sql);
			ps.setString(1, condition);
			ps.setString(2, condition);
			ps.setString(3, condition);
			ps.setString(4, condition);
			ps.setString(5, condition);

			rs = ps.executeQuery();
			return rs;
		} catch (SQLException exc) {
		}
		return rs;
	}
}