public List<Borrower> ListBorrower() throws Exception {
   ConnectionUtil c = new ConnectionUtil();
   Connection conn = c.createConnection();
   try {
     BorrowerDAO bdao = new BorrowerDAO(conn);
     List<Borrower> bor = bdao.readAll();
     conn.commit();
     return bor;
   } catch (Exception e) {
     e.printStackTrace();
     return null;
   } finally {
     conn.close();
   }
 }
  private Borrower showAllBorrowers() {
    Borrower bor = null;
    try {
      Connection conn = getConnection();
      BorrowerDAO borDAO = new BorrowerDAO(conn);
      List<Borrower> allBorrowers = borDAO.readAll();
      ArrayList<String> actions = new ArrayList<String>();
      actions.add("Cancel");
      int choice = getChoiceNumber(allBorrowers, actions);
      if (choice > 0 && choice <= allBorrowers.size()) {
        bor = allBorrowers.get(choice - 1);
      }
      conn.close();
    } catch (Exception e) {
      // TODO Auto-generated catch block
      e.printStackTrace();
    }

    return bor;
  }