translate.java

源代码

/**
 *  Title  staff
 *  Filename:Translate.java
 **/

package staff.action;

import staff.database.DBConnect;
import staff.util.*;
import java.sql.*;
import java.util.*;


public class Translate 
{

	public String EmployeeID, PriorBranch,NextBranch,PriorDuty,NextDuty,HandleName,Remark;

	public java.sql.Date TranslateDate;
	
	public int TranslateNO;

	public Translate() 
	{};

	public String getEmployeeID() 
	{
		return EmployeeID;
	}

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

	public String getPriorBranch() 
	{
		return PriorBranch;
	}

	public void setPriorBranch(String s) 
	{
		this.PriorBranch = s;
	}

	public String getNextBranch() 
	{
		return NextBranch;
	}

	public void setNextBranch(String s) 
	{
		this.NextBranch = s;
	}

	public String getPriorDuty() 
	{
		return PriorDuty;
	}

	public void setPriorDuty(String s) 
	{
		this.PriorDuty = s;
	}

	public String getNextDuty() 
	{
		return NextDuty;
	}

	public void setNextDuty(String s) 
	{
		this.NextDuty = s;
	}
	
	public String getHandleName() 
	{
		return HandleName;
	}

	public void setHandleName(String s) 
	{
		this.HandleName = s;
	}
	
	public String getRemark() 
	{
		return Remark;
	}

	public void setRemark(String s) 
	{
		this.Remark = s;
	}
	
	public void setTranslateNO(int i) 
	{
		this.TranslateNO = i;
	}

	public String getTranslateNO() 
	{
		return DataConvert.IntToStr(TranslateNO);
	}
	
	public String getTranslateDate() 
	{
		if (this.TranslateDate != null)
			return DataConvert.sqlDateToStr(TranslateDate);
		else
			return "";
	}

	public void setTranslateDate(String str) 
	{
		if (str != null)
			this.TranslateDate = DataConvert.StrTosqlDate(str);
		else
			this.TranslateDate = null;
	}
	
	/*
	 * Find Translate by NO
	 */
	public static Translate FindByNO(String _TranslateNO) 
	{
		DBConnect dbc = null;
		Translate translate = new Translate();
		try 
		{
			dbc = new DBConnect();
			Connection conn =dbc.getDBConnection();
			Statement stmt = null;
			stmt=conn.createStatement();
			ResultSet rs = null;
			rs = stmt.executeQuery("SELECT * FROM translate WHERE TranslateNO='"+_TranslateNO+"'");
			
			if (rs.next()) 
			{
				translate.setTranslateNO(rs.getInt("TranslateNO"));
				translate.setEmployeeID(rs.getString("EmployeeID"));
				translate.setTranslateDate(rs.getString("TranslateDate"));
				translate.setPriorBranch(rs.getString("PriorBranch"));
				translate.setNextBranch(rs.getString("NextBranch"));
				translate.setPriorDuty(rs.getString("PriorDuty"));
				translate.setNextDuty(rs.getString("NextDuty"));
				translate.setHandleName(rs.getString("HandleName"));
				translate.setRemark(rs.getString("Remark"));
			} else {
				translate = null;
			}
		} catch (Exception e) 
		{
			System.err.println(e);
		} finally 
		{
			try {
				dbc.close();
			} catch (Exception e) 
			{
				e.printStackTrace();
				translate = null;
			}
		}
		return translate;

	}

	/*
	 * Add Translate
	 */
	public static String Add(String _EmployeeID, String _TranslateDate,
			String _PriorBranch, String _NextBranch, String _PriorDuty,
			String _NextDuty,String _HandleName,String _Remark) {
		DBConnect dbc = null;
		try 
		{
			int i=0;
			dbc = new DBConnect();
			Connection conn =dbc.getDBConnection();
			Statement stmt1 = null;
			Statement stmt2 = null;
			stmt1=conn.createStatement();
			stmt2=conn.createStatement();
			ResultSet rs=null;
			rs=stmt1.executeQuery("SELECT TranslateNO FROM translate");
			
			while(rs.next()) 
			{   
				i=rs.getInt("TranslateNO");
			}
			i++;
			
			stmt2.executeUpdate("INSERT INTO Translate (TranslateNO,EmployeeID,TranslateDate,PriorBranch,NextBranch,"
			+ "PriorDuty,NextDuty,HandleName,Remark) VALUES ("+i+",'"+_EmployeeID+"','"+_TranslateDate+"','"+_PriorBranch+"','"+_NextBranch+"','"+_PriorDuty+"','"+_NextDuty+"','"+_HandleName+"','"+_Remark+"')");
							
			dbc.close();
			return "1";

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

	}

	/*
	 * Modify Translate
	 */

	public static String Modify(String _TranslateNO,String _EmployeeID, String _TranslateDate,
			String _PriorBranch, String _NextBranch, String _PriorDuty,
			String _NextDuty,String _HandleName,String _Remark) {
		DBConnect dbc = null;
		try 
		{
			dbc = new DBConnect();
			Connection conn =dbc.getDBConnection();
			Statement stmt = null;
			stmt=conn.createStatement();
			
			stmt.executeUpdate("UPDATE translate SET EmployeeID='"+_EmployeeID+"',TranslateDate='"+_TranslateDate+"',PriorBranch='"+_PriorBranch+"',NextBranch='"+_NextBranch+"',"
							+ "PriorDuty='"+_PriorDuty+"',NextDuty='"+_NextDuty+"',HandleName='"+_HandleName+"',Remark='"+_Remark+"' WHERE TranslateNO='"+_TranslateNO+"'");
			
			
			dbc.close();
			return "1";
		} catch (Exception e) 
		{
			e.printStackTrace();
			return e.toString();
		}
	}

	/*
	 * Delete Translate
	 */
	public static String Delete(String _TranslateNO) 
	{
		try 
		{
			DBConnect dbc = new DBConnect();
			Connection conn =dbc.getDBConnection();
			Statement stmt = null;
			stmt=conn.createStatement();
			
			stmt.executeUpdate("DELETE FROM translate WHERE TranslateNO='"+_TranslateNO+"'");
			
			
			dbc.close();
			return "1";
		} catch (Exception e) 
		{
			e.printStackTrace();
			return e.toString();
		}
	}

	/*
	 * search Translate by EmployeeID
	 */
	public static Vector SearchByID(String _EmployeeID) 
	{
		DBConnect dbc = null;
		Vector TranslateVector = new Vector();
		try 
		{
			dbc = new DBConnect();
			Connection conn =dbc.getDBConnection();
			Statement stmt = null;
			stmt=conn.createStatement();
			ResultSet rs = null;
			rs = stmt.executeQuery("SELECT * FROM translate WHERE EmployeeID='"+_EmployeeID+"' ORDER BY TranslateDate ASC");
			
			while (rs.next()) 
			{
				Translate translate = new Translate();
				translate.setTranslateNO(rs.getInt("TranslateNO"));
				translate.setEmployeeID(rs.getString("EmployeeID"));
				translate.setTranslateDate(rs.getString("TranslateDate"));
				translate.setPriorBranch(rs.getString("PriorBranch"));
				translate.setNextBranch(rs.getString("NextBranch"));
				translate.setPriorDuty(rs.getString("PriorDuty"));
				translate.setNextDuty(rs.getString("NextDuty"));
				translate.setHandleName(rs.getString("HandleName"));
				translate.setRemark(rs.getString("Remark"));
				TranslateVector.add(translate);
			}
		} catch (Exception e) 
		{
			System.err.println(e);
		} finally {
			try {
				dbc.close();
			} catch (Exception e) 
			{
				e.printStackTrace();
			}
		}
		return TranslateVector;

	}

	/*
	 * List All Translate
	 */
	public static Vector ListAll() 
	{
		DBConnect dbc = null;
		Vector TranslateVector = new Vector();

		String strSQL = "SELECT * FROM translate ORDER BY EmployeeID,TranslateDate ASC";

		try 
		{
			dbc = new DBConnect();
			Connection conn =dbc.getDBConnection();
			Statement stmt = null;
			stmt=conn.createStatement();
			ResultSet rs = null;
			rs = stmt.executeQuery(strSQL);
			
			while (rs.next()) 
			{
				Translate translate = new Translate();
				translate.setTranslateNO(rs.getInt("TranslateNO"));
				translate.setEmployeeID(rs.getString("EmployeeID"));
				translate.setTranslateDate(rs.getString("TranslateDate"));
				translate.setPriorBranch(rs.getString("PriorBranch"));
				translate.setNextBranch(rs.getString("NextBranch"));
				translate.setPriorDuty(rs.getString("PriorDuty"));
				translate.setNextDuty(rs.getString("NextDuty"));
				translate.setHandleName(rs.getString("HandleName"));
				translate.setRemark(rs.getString("Remark"));
				TranslateVector.add(translate);
			}
		} catch (Exception e) 
		{
			System.err.println(e);
		} finally 
		{
			try {
				dbc.close();
			} catch (Exception e) 
			{
				e.printStackTrace();
			}
		}
		return TranslateVector;

	}

}