コード例 #1
0
 public List<LibBranch> ListBranches() throws Exception {
   ConnectionUtil c = new ConnectionUtil();
   Connection conn = c.createConnection();
   try {
     LibBranchDAO lib = new LibBranchDAO(conn);
     List<LibBranch> branches = lib.readAll();
     conn.commit();
     return branches;
   } catch (Exception e) {
     e.printStackTrace();
     return null;
   } finally {
     conn.close();
   }
 }
コード例 #2
0
  /** *************************************************************************************** */
  public LibBranch ListOneBranche(int branchId) throws Exception {

    ConnectionUtil c = new ConnectionUtil();
    Connection conn = c.createConnection();

    try {

      LibBranchDAO lib = new LibBranchDAO(conn);
      LibBranch branch = lib.readOne(branchId);
      return branch;

    } catch (Exception e) {
      // TODO: handle exception
      e.printStackTrace();
      return null;
    } finally {
      conn.close();
    }
  }
コード例 #3
0
 /** *************************************************************************************** */
 public void DeleteLibBranch(LibBranch branch) throws Exception {
   ConnectionUtil c = new ConnectionUtil();
   Connection conn = c.createConnection();
   try {
     if (branch == null
         || branch.getLibraryBranchName() == null
         || branch.getLibraryBranchName().length() == 0
         || branch.getLibraryBranchName().length() > 45
         || branch.getLibraryBranchAddress() == null
         || branch.getLibraryBranchAddress().length() == 0
         || branch.getLibraryBranchAddress().length() > 45) {
       throw new Exception("The Book cannot be null");
     } else {
       LibBranchDAO lib = new LibBranchDAO(conn);
       lib.delete(branch);
       conn.commit();
     }
   } catch (Exception e) {
     e.printStackTrace();
     conn.rollback();
   } finally {
     conn.close();
   }
 }