Android_小账本_筛选功能的实现

概述昨天对小账本的相关功能做了完善，新增了筛选功能。  支持对类型、收支项、日期进行修改。 但暂时尚不完善，只能针对相关小项进行筛选，无法连续对小项的结果进行筛选。这一功能预计在本周三进行完善。相关代码publicString[]readCord_select(){SQLiteUserChag

昨天对小账本的相关功能做了完善，新增了筛选功能。

 

 支持对类型、收支项、日期进行修改。

 但暂时尚不完善，只能针对相关小项进行筛选，无法连续对小项的结果进行筛选。这一功能预计在本周三进行完善。

相关代码

 public String[] readCord_select() {        sqliteUserChager sqliteUserChager = new sqliteUserChager(getContext(), "Userr", null, 1);        sqliteDatabase sqliteDatabase = sqliteUserChager.getReadableDatabase();        number=0;        if (group.length() < 3) {            Cursor cursor;            if (Integer.parseInt(group) == 1) {                cursor = sqliteDatabase.rawquery("select * from Cord where inout=? and username=?", new String[]{select[1][Integer.parseInt(item)],Nowusername});            } else {                cursor = sqliteDatabase.rawquery("select * from Cord where type=? and username=?", new String[]{select[2][Integer.parseInt(item)],Nowusername});            }            String[] strings = new String[count = cursor.getCount()];            int i = 0;            if (cursor.movetoNext())                do {                    number+=Double.parseDouble(cursor.getString(cursor.getColumnIndex("number")));                    String[] strings1 = new String[7];                    strings1[0] = cursor.getString(cursor.getColumnIndex("date"));                    strings1[1] = cursor.getString(cursor.getColumnIndex("type"));                    strings1[2] = cursor.getString(cursor.getColumnIndex("inout"));                    strings1[3] = cursor.getString(cursor.getColumnIndex("number"));                    strings1[4] = cursor.getString(cursor.getColumnIndex("info"));                    strings1[5] = cursor.getString(cursor.getColumnIndex("username"));                    strings1[6] = cursor.getString(cursor.getColumnIndex("ID"));                    arr.add(strings1);                    strings[i] = "我" + cursor.getString(cursor.getColumnIndex("date")) +                            " 在" + cursor.getString(cursor.getColumnIndex("type")) +                            "上" + cursor.getString(cursor.getColumnIndex("inout")) +                            "了" + cursor.getString(cursor.getColumnIndex("number")) + "元";                    i++;                } while (cursor.movetoNext());            cursor.close();            sqliteDatabase.close();            sqliteUserChager.close();            tv_sum.setText("总收支："+number);            return strings;        } else {                                                                                     //dateselect            String[] min = group.split("/");            String[] max = item.split("/");            Log.d("----max", max[0] + "/" + max[1] + "/" + max[2]);            Log.d("----min", min[0] + "/" + min[1] + "/" + min[2]);            Cursor cursor = sqliteDatabase.rawquery("select * from Cord where username=?", new String[]{Nowusername});            String[] strings = new String[cursor.getCount() + 8000];            while (cursor.movetoNext()) {                String date = cursor.getString(cursor.getColumnIndex("date"));                String[] dats = date.split("/");                if (Integer.parseInt(dats[0]) > Integer.parseInt(min[0]) && Integer.parseInt(dats[0]) < Integer.parseInt(max[0])) {                    String[] strings1 = new String[7];                    number+=Double.parseDouble(cursor.getString(cursor.getColumnIndex("number")));                    strings1[0] = cursor.getString(cursor.getColumnIndex("date"));                    strings1[1] = cursor.getString(cursor.getColumnIndex("type"));                    strings1[2] = cursor.getString(cursor.getColumnIndex("inout"));                    strings1[3] = cursor.getString(cursor.getColumnIndex("number"));                    strings1[4] = cursor.getString(cursor.getColumnIndex("info"));                    strings1[5] = cursor.getString(cursor.getColumnIndex("username"));                    strings1[6] = cursor.getString(cursor.getColumnIndex("ID"));                    arr.add(strings1);                    strings[i] = "我" + cursor.getString(cursor.getColumnIndex("date")) +                            " 在" + cursor.getString(cursor.getColumnIndex("type")) +                            "上" + cursor.getString(cursor.getColumnIndex("inout")) +                            "了" + cursor.getString(cursor.getColumnIndex("number")) + "元";                    i++;                } else if (Integer.parseInt(dats[0]) == Integer.parseInt(min[0])) {                    if (Integer.parseInt(dats[1]) > Integer.parseInt(min[1]) && Integer.parseInt(dats[1]) < Integer.parseInt(max[1])) {                        String[] strings1 = new String[7];                        number+=Double.parseDouble(cursor.getString(cursor.getColumnIndex("number")));                        strings1[0] = cursor.getString(cursor.getColumnIndex("date"));                        strings1[1] = cursor.getString(cursor.getColumnIndex("type"));                        strings1[2] = cursor.getString(cursor.getColumnIndex("inout"));                        strings1[3] = cursor.getString(cursor.getColumnIndex("number"));                        strings1[4] = cursor.getString(cursor.getColumnIndex("info"));                        strings1[5] = cursor.getString(cursor.getColumnIndex("username"));                        strings1[6] = cursor.getString(cursor.getColumnIndex("ID"));                        arr.add(strings1);                        strings[i] = "我" + cursor.getString(cursor.getColumnIndex("date")) +                                " 在" + cursor.getString(cursor.getColumnIndex("type")) +                                "上" + cursor.getString(cursor.getColumnIndex("inout")) +                                "了" + cursor.getString(cursor.getColumnIndex("number")) + "元";                        i++;                    } else if (Integer.parseInt(dats[1]) == Integer.parseInt(min[1])) {                        if ((Integer.parseInt(dats[2]) >= Integer.parseInt(min[2]) && Integer.parseInt(dats[1]) < Integer.parseInt(max[1])) || (Integer.parseInt(dats[2]) >= Integer.parseInt(min[2]) && Integer.parseInt(dats[2]) <= Integer.parseInt(max[2]))) {                            String[] strings1 = new String[7];                            number+=Double.parseDouble(cursor.getString(cursor.getColumnIndex("number")));                            strings1[0] = cursor.getString(cursor.getColumnIndex("date"));                            strings1[1] = cursor.getString(cursor.getColumnIndex("type"));                            strings1[2] = cursor.getString(cursor.getColumnIndex("inout"));                            strings1[3] = cursor.getString(cursor.getColumnIndex("number"));                            strings1[4] = cursor.getString(cursor.getColumnIndex("info"));                            strings1[5] = cursor.getString(cursor.getColumnIndex("username"));                            strings1[6] = cursor.getString(cursor.getColumnIndex("ID"));                            arr.add(strings1);                            strings[i] = "我" + cursor.getString(cursor.getColumnIndex("date")) +                                    " 在" + cursor.getString(cursor.getColumnIndex("type")) +                                    "上" + cursor.getString(cursor.getColumnIndex("inout")) +                                    "了" + cursor.getString(cursor.getColumnIndex("number")) + "元";                            i++;                        }                    } else if (Integer.parseInt(dats[1]) == Integer.parseInt(max[1])) {                        if ((Integer.parseInt(dats[2]) <= Integer.parseInt(max[2]) && Integer.parseInt(dats[1]) > Integer.parseInt(min[1])) || (Integer.parseInt(dats[2]) >= Integer.parseInt(min[2]) && Integer.parseInt(dats[2]) <= Integer.parseInt(max[2]))) {                            String[] strings1 = new String[7];                            number+=Double.parseDouble(cursor.getString(cursor.getColumnIndex("number")));                            strings1[0] = cursor.getString(cursor.getColumnIndex("date"));                            strings1[1] = cursor.getString(cursor.getColumnIndex("type"));                            strings1[2] = cursor.getString(cursor.getColumnIndex("inout"));                            strings1[3] = cursor.getString(cursor.getColumnIndex("number"));                            strings1[4] = cursor.getString(cursor.getColumnIndex("info"));                            strings1[5] = cursor.getString(cursor.getColumnIndex("username"));                            strings1[6] = cursor.getString(cursor.getColumnIndex("ID"));                            arr.add(strings1);                            strings[i] = "我" + cursor.getString(cursor.getColumnIndex("date")) +                                    " 在" + cursor.getString(cursor.getColumnIndex("type")) +                                    "上" + cursor.getString(cursor.getColumnIndex("inout")) +                                    "了" + cursor.getString(cursor.getColumnIndex("number")) + "元";                            i++;                        }                    }                } else if (Integer.parseInt(dats[0]) == Integer.parseInt(max[0])) {                    if (Integer.parseInt(dats[1]) < Integer.parseInt(max[1])) {                        String[] strings1 = new String[7];                        number+=Double.parseDouble(cursor.getString(cursor.getColumnIndex("number")));                        strings1[0] = cursor.getString(cursor.getColumnIndex("date"));                        strings1[1] = cursor.getString(cursor.getColumnIndex("type"));                        strings1[2] = cursor.getString(cursor.getColumnIndex("inout"));                        strings1[3] = cursor.getString(cursor.getColumnIndex("number"));                        strings1[4] = cursor.getString(cursor.getColumnIndex("info"));                        strings1[5] = cursor.getString(cursor.getColumnIndex("username"));                        strings1[6] = cursor.getString(cursor.getColumnIndex("ID"));                        arr.add(strings1);                        strings[i] = "我" + cursor.getString(cursor.getColumnIndex("date")) +                                " 在" + cursor.getString(cursor.getColumnIndex("type")) +                                "上" + cursor.getString(cursor.getColumnIndex("inout")) +                                "了" + cursor.getString(cursor.getColumnIndex("number")) + "元";                        i++;                    } else if (Integer.parseInt(dats[1]) == Integer.parseInt(max[1])) {                        if (Integer.parseInt(dats[2]) <= Integer.parseInt(max[2])) {                            String[] strings1 = new String[7];                            number+=Double.parseDouble(cursor.getString(cursor.getColumnIndex("number")));                            strings1[0] = cursor.getString(cursor.getColumnIndex("date"));                            strings1[1] = cursor.getString(cursor.getColumnIndex("type"));                            strings1[2] = cursor.getString(cursor.getColumnIndex("inout"));                            strings1[3] = cursor.getString(cursor.getColumnIndex("number"));                            strings1[4] = cursor.getString(cursor.getColumnIndex("info"));                            strings1[5] = cursor.getString(cursor.getColumnIndex("username"));                            strings1[6] = cursor.getString(cursor.getColumnIndex("ID"));                            arr.add(strings1);                            strings[i] = "我" + cursor.getString(cursor.getColumnIndex("date")) +                                    " 在" + cursor.getString(cursor.getColumnIndex("type")) +                                    "上" + cursor.getString(cursor.getColumnIndex("inout")) +                                    "了" + cursor.getString(cursor.getColumnIndex("number")) + "元";                            i++;                        }                    }                }            }            cursor.close();            sqliteDatabase.close();            sqliteUserChager.close();            ArrayList<String> arrayList = new ArrayList<>();            for (int i = 0; i < strings.length; i++) {                if (strings[i] != null) {                    arrayList.add(strings[i]);                }            }            String[] strings2 = new String[arrayList.size()];            for (int i = 0; i < arrayList.size(); i++) {                strings2[i] = arrayList.get(i);            }            Log.d("-----gropuitem", group + "+" + item);            tv_sum.setText("总收支："+number);            return strings2;        }    }

　　

 

总结

以上是内存溢出为你收集整理的Android_小账本_筛选功能的实现全部内容，希望文章能够帮你解决Android_小账本_筛选功能的实现所遇到的程序开发问题。

如果觉得内存溢出网站内容还不错，欢迎将内存溢出网站推荐给程序员好友。