employeesbean.java

很全面的 毕业设计 包括 论文 翻译 源代码 数据库

package employees;

import java.sql.*;
import java.util.*;
import javax.naming.*;
import javax.sql.*;

import employees.*;
import common.*;

public class EmployeesBean
{
 private ArrayList	Employees ;
 public boolean EmployeesInsert(Employees employees) throws Exception {
	DataBase database = new DataBase();
	boolean result = false;
    Connection con = null;
    PreparedStatement prepStmt = null;
    ResultSet rs=null;
    try {
      con = database.getConnection();                            
      String sql = "insert into Employees"
      +"(EmpId,DepId,EmpName,Sex,Nationality,Birth,Academic,Marital,Original,Id_Card,Mobile,Memo)"
      + "VALUES('"+employees.getEmpId()+"','"+employees.getDepId()+"','"+employees.getEmpName()+"','"+employees.getSex()
      + "','"+employees.getNationality()+"','"+employees.getBirth()+"','"+employees.getAcademic()+"','"+employees.getMarital()
      +"','"+employees.getOriginal()+"','"+employees.getId_Card()+"','"+employees.getMobile()+"','"+employees.getMemo()+"')";
 
      prepStmt = con.prepareStatement(sql);
      result = prepStmt.execute(sql);
        }
     catch( SQLException ex )
		{
			ex.printStackTrace( System.err );
			return false;
		}
       finally{
             database.closeResultSet(rs);
             database.closePrepStmt(prepStmt);
             database.closeConnection(con);
           }
        return result;
      }
//////－－－－－－－－－－－？？？？？？？？？？？？？？？？？删除员工的信息－－－
   public boolean EmployeesDelete(Employees employees) throws Exception {
	DataBase database = new DataBase();
	boolean result = false;
    Connection con = null;
    PreparedStatement prepStmt = null;
    ResultSet rs=null;
    try {
      con = database.getConnection();                            
      String sql = "delete from Employees where EmpId = '"+employees.getEmpId()+"'";
 
      prepStmt = con.prepareStatement(sql);
      result = prepStmt.execute(sql);
        }
     catch( SQLException ex )
		{
			ex.printStackTrace( System.err );
			return false;
		}
       finally{
             database.closeResultSet(rs);
             database.closePrepStmt(prepStmt);
             database.closeConnection(con);
           }
        return result;
      }
      
      
      
 ////－－－－－得到员工的详细信息－－－－－－－－－－－－－－－－－－－－－
 public Employees getEmployeesDetails(String EmpId) throws Exception {
	DataBase database = new DataBase();
	boolean result = false;
    Connection con = null;
    PreparedStatement prepStmt = null;
    ResultSet rs = null;
    try {
       con = database.getConnection(); 
       String sql = "select  EmpId, DepId, EmpName , Sex, Nationality, Birth, Academic, Marital,Original, Id_Card, Mobile, Memo "+"from  Employees where EmpId =?";                      
       prepStmt = con.prepareStatement(sql);
       prepStmt.setString(1,EmpId);
       rs = prepStmt.executeQuery();
       if(rs.next()){
      	Employees  employees = new Employees(rs.getString(1),rs.getString(2),rs.getString(3),
      	rs.getString(4),rs.getString(5),rs.getString(6),rs.getString(7),rs.getString(8),
      	rs.getString(9),rs.getString(10),rs.getString(11),rs.getString(12));
      	prepStmt.close();
      	return employees;
      	}
      	else{
      	return null;	
      	}
      	
       }
       finally{
             database.closeResultSet(rs);
             database.closePrepStmt(prepStmt);
             database.closeConnection(con);
          }
      }
 ////－－－－－－－－－－－－－－－－getEmployees()//得到员工的所有详细信息－－－－－－－－－－－－－－－
   public Collection getEmployees() throws Exception {  
	DataBase database = new DataBase();
	boolean result = false;
    Connection con = null;
    PreparedStatement prepStmt = null;
    ResultSet rs = null;
    Employees = new ArrayList();
    try {
       con = database.getConnection(); 
       String sql = "select EmpId, DepId, EmpName , Sex, Nationality, Birth, Academic, Marital,Original, Id_Card, Mobile, Memo "+"from  Employees ";                      
       prepStmt = con.prepareStatement(sql);
       rs = prepStmt.executeQuery();
       while(rs.next()){
      	Employees  bd = new Employees(rs.getString(1),rs.getString(2),rs.getString(3),
      	rs.getString(4),rs.getString(5),rs.getString(6),rs.getString(7),rs.getString(8),
      	rs.getString(9),rs.getString(10),rs.getString(11),rs.getString(12));
      	Employees.add(bd);
      	}	
       }
       finally{
             database.closeResultSet(rs);
             database.closePrepStmt(prepStmt);
             database.closeConnection(con);
          }
           Collections.sort(Employees);
          	return Employees;
      }
/////