public static ArrayList<CardAccount> getAll(){
        SQLiteJDBC db = new SQLiteJDBC();
        ArrayList<CardAccount> card_accounts = new ArrayList<CardAccount>();
        
        String sql = "SELECT account_num FROM card_accounts";
        ResultSet resultSet = db.query(sql);
        
        try {            
            while(resultSet.next()){
                CardAccount card_account = new CardAccount(resultSet.getInt("account_num"));
                card_accounts.add(card_account);
            }
            db.close();
        }catch(Exception e) {
            System.err.println( e.getClass().getName() + ": " + e.getMessage() );
            System.exit(0);
        }
        
        return card_accounts;
    }