public static ArrayList<Customer> showAll() {
            ArrayList<Customer> customers = new ArrayList<Customer>();
            Database db = dbconnect();
            try {
		db.prepare("SELECT * FROM customer WHERE bDeleted = 0 ORDER BY CID");
		ResultSet rs = db.executeQuery();   
		while(rs.next()) {
                   customers.add(CustomerObject(rs));
		}
	           db.close();      

            } catch (SQLException e) {
                Error_Frame.Error(e.toString());
            } 
                return customers;
	}