society.java

帮助文档打开后可以阅读资源

/**
 *  Title  hrms
 *  @author: dzc
 *  Company: hust
 *  Copyright: Copyright (c) 2005
 *  @version 1.0
 *  Date  :   2006-04
 *  Filename:Society.java
 **/

package hrms.extra;

import hrms.database.DBConnect;
import hrms.util.*;

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

import hrms.util.*;

public class Society {

	public String EmployeeID, UserName, Realation, Company, Department, Duty,
			Telephone, Politics, Remark;

	public int SocietyNO;

	public Society() {
	};

	public String getEmployeeID() {
		return EmployeeID;
	}

	public void setEmployeeID(String s) {
		this.EmployeeID = s;
	}

	public String getUserName() {
		return UserName;
	}

	public void setUserName(String s) {
		this.UserName = s;
	}

	public String getRealation() {
		return Realation;
	}

	public void setRealation(String s) {
		this.Realation = s;
	}

	public String getCompany() {
		return Company;
	}

	public void setCompany(String s) {
		this.Company = s;
	}

	public String getDepartment() {
		return Department;
	}

	public void setDepartment(String s) {
		this.Department = s;
	}

	public String getDuty() {
		return Duty;
	}

	public void setDuty(String s) {
		this.Duty = s;
	}

	public String getTelephone() {
		return Telephone;
	}

	public void setTelephone(String s) {
		this.Telephone = s;
	}

	public String getPolitics() {
		return Politics;
	}

	public void setPolitics(String s) {
		this.Politics = s;
	}

	public String getRemark() {
		return Remark;
	}

	public void setRemark(String s) {
		this.Remark = s;
	}

	public void setSocietyNO(int i) {
		this.SocietyNO = i;
	}

	public String getSocietyNO() {
		return DataConvert.IntToStr(SocietyNO);
	}

	/*
	 * Find Society by No
	 */
	public static Society FindByNO(String _SocietyNO) {
		DBConnect dbc = null;
		Society society = new Society();
		try {
			dbc = new DBConnect();
			dbc.prepareStatement("SELECT * FROM society WHERE SocietyNO = ?");
			dbc.setString(1, _SocietyNO);
			ResultSet rs = dbc.executeQuery();
			if (rs.next()) {
				society.setSocietyNO(rs.getInt("SocietyNO"));
				society.setEmployeeID(rs.getString("EmployeeID"));
				society.setUserName(rs.getString("UserName"));
				society.setRealation(rs.getString("Realation"));
				society.setCompany(rs.getString("Company"));
				society.setDepartment(rs.getString("Department"));
				society.setDuty(rs.getString("Duty"));
				society.setTelephone(rs.getString("Telephone"));
				society.setPolitics(rs.getString("Politics"));
				society.setRemark(rs.getString("Remark"));
			} else {
				society = null;
			}
		} catch (Exception e) {
			System.err.println(e);
		} finally {
			try {
				dbc.close();
			} catch (Exception e) {
				e.printStackTrace();
				society = null;
			}
		}
		return society;

	}

	/*
	 * Add Society
	 */
	public static String Add(String _EmployeeID, String _UserName,
			String _Realation, String _Company, String _Department,
			String _Duty, String _Telephone, String _Politics, String _Remark) {
		DBConnect dbc = null;
		try {
			dbc = new DBConnect();
			dbc
					.prepareStatement("INSERT INTO society (EmployeeID,UserName,Realation,Company,Department,"
							+ "Duty,Telephone,Politics,Remark) VALUES (?,?,?,?,?,?,?,?,?)");
			dbc.setString(1, _EmployeeID);
			dbc.setString(2, _UserName);
			dbc.setString(3, _Realation);
			dbc.setString(4, _Company);
			dbc.setString(5, _Department);
			dbc.setString(6, _Duty);
			dbc.setString(7, _Telephone);
			dbc.setString(8, _Politics);
			dbc.setString(9, _Remark);
			dbc.executeUpdate();
			dbc.close();
			return "1";

		} catch (Exception e) {
			System.err.println(e);
			return e.toString();
		}

	}

	/*
	 * Modify Society
	 */

	public static String Modify(String _SocietyNO, String _UserName,
			String _Realation, String _Company, String _Department,
			String _Duty, String _Telephone, String _Politics, String _Remark) {
		DBConnect dbc = null;
		try {
			dbc = new DBConnect();
			dbc
					.prepareStatement("UPDATE society SET UserName=?,Realation=?,Company=?,Department=?,"
							+ "Duty=?,Telephone=?,Politics=?,Remark=? WHERE SocietyNO=?");
			dbc.setString(1, _UserName);
			dbc.setString(2, _Realation);
			dbc.setString(3, _Company);
			dbc.setString(4, _Department);
			dbc.setString(5, _Duty);
			dbc.setString(6, _Telephone);
			dbc.setString(7, _Politics);
			dbc.setString(8, _Remark);
			dbc.setInt(9, DataConvert.StrToInt(_SocietyNO));
			dbc.executeUpdate();
			dbc.close();
			return "1";
		} catch (Exception e) {
			e.printStackTrace();
			return e.toString();
		}
	}

	/*
	 * Delete Society
	 */
	public static String Delete(String _SocietyNO) {
		try {
			DBConnect dbc = new DBConnect();
			dbc.prepareStatement("DELETE FROM society WHERE SocietyNO=?");
			dbc.setInt(1, DataConvert.StrToInt(_SocietyNO));
			dbc.executeUpdate();
			dbc.close();
			return "1";
		} catch (Exception e) {
			e.printStackTrace();
			return e.toString();
		}
	}

	/*
	 * search Society by EmployeeID
	 */
	public Vector SearchByID(String _EmployeeID) {
		DBConnect dbc = null;
		Vector SocietyVector = new Vector();
		try {
			dbc = new DBConnect();
			dbc
					.prepareStatement("SELECT * FROM society WHERE EmployeeID=? ORDER BY UserName ASC");
			dbc.setString(1, _EmployeeID);
			ResultSet rs = dbc.executeQuery();
			while (rs.next()) {
				Society society = new Society();
				society.setSocietyNO(rs.getInt("SocietyNO"));
				society.setEmployeeID(rs.getString("EmployeeID"));
				society.setUserName(rs.getString("UserName"));
				society.setRealation(rs.getString("Realation"));
				society.setCompany(rs.getString("Company"));
				society.setDepartment(rs.getString("Department"));
				society.setDuty(rs.getString("Duty"));
				society.setTelephone(rs.getString("Telephone"));
				society.setPolitics(rs.getString("Politics"));
				society.setRemark(rs.getString("Remark"));
				SocietyVector.add(society);
			}
		} catch (Exception e) {
			System.err.println(e);
		} finally {
			try {
				dbc.close();
			} catch (Exception e) {
				e.printStackTrace();
			}
		}
		return SocietyVector;

	}

}