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;
}