DDM 2021-12-15

public ArrayList<MyContact> selectAllByNameAsc(){
        String q = String.format(
                "select %s from %s order by %s ASC",
                //"*",
                COL_ID+","+COL_NAME+","+COL_PHONE,
                TABLE_CONTACTS,
                COL_NAME
        );
        return selectByQuery (q);
    }//selectAllByNameAsc

    public ArrayList<MyContact> selectAllByNameDesc(){
        String q = String.format(
                "select %s from %s order by %s DESC",
                //"*",
                COL_ID+","+COL_NAME+","+COL_PHONE,
                TABLE_CONTACTS,
                COL_NAME
        );
        return selectByQuery (q);
    }//selectAllByNameDesc

    public ArrayList<MyContact> selectAllByPhoneAsc(){
        String q = String.format(
                "select %s from %s order by %s ASC",
                //"*",
                COL_ID+","+COL_NAME+","+COL_PHONE,
                TABLE_CONTACTS,
                COL_PHONE
        );
        return selectByQuery (q);
    }//selectAllByPhoneAsc

    public ArrayList<MyContact> selectAllByPhoneDesc(){
        String q = String.format(
                "select %s from %s order by %s DESC",
                //"*",
                COL_ID+","+COL_NAME+","+COL_PHONE,
                TABLE_CONTACTS,
                COL_PHONE
        );
        return selectByQuery (q);
    }//selectAllByPhoneDesc