/*Update Department method was created for Update a record from Department, folowing DepartmentID*/
  public static void updateDepartment(Department department)
      throws SQLException, ClassNotFoundException {
    Connection conn = EmpConnection.getConnection();
    StringBuilder query = new StringBuilder();
    query.append("use QLNS_JAVA2 UPDATE [dbo].[Departments] SET [DepartmentName] = ?");
    query.append(" WHERE [DepartmentID] = ?");

    PreparedStatement pStmt = conn.prepareStatement(query.toString());

    pStmt.setString(1, department.getDepartmentName());
    pStmt.setInt(2, department.getDepartmentID());

    pStmt.executeUpdate();

    EmpConnection.closePreparedStatement(pStmt);
    EmpConnection.closeConnection(conn);
  }
  public static int insertDepartment(Department department)
      throws ClassNotFoundException, SQLException {
    int result = 0;
    Connection conn = EmpConnection.getConnection();
    StringBuilder query = new StringBuilder();
    query.append("use QLNS_JAVA2 INSERT INTO  [dbo].[Departments]( [DepartmentName] ) VALUES(?) ");

    PreparedStatement pStmt = conn.prepareStatement(query.toString());
    pStmt.setString(1, department.getDepartmentName());
    pStmt.executeUpdate();

    // Get Max ID and Return/
    pStmt =
        conn.prepareStatement("use QLNS_JAVA2 SELECT MAX(DepartmentID) AS MaxID FROM Departments");
    ResultSet rs = pStmt.executeQuery();
    rs.next();
    result = rs.getInt("MaxID");

    EmpConnection.closePreparedStatement(pStmt);
    EmpConnection.closeConnection(conn);
    return result; // de minh chi cho ban cho ma chay bi loi ne
  }