dimanche 20 septembre 2015

Not able to access sqlite database from alarm service

I want to access my sqlite database from alarm service.Also wanna add new records to database.I tried a lot but getting exception. Please help me guys..You can find the code below

super.onStart(intent, startId);
        d = DateFormat.getDateInstance();
        obj = new RestClient((android.app.Activity) context);
        try {

            String stat = "signed in";
            ArrayList<DataRecord>autoList = database.executeQuery("select employee_Id from attendance where date='" + d.format(new Date()) + "' and status = '" + stat + "'");

            int size = autoList.size();
            for (int i = 0; i < size; i++) {

                      id = autoList.get(i).getInt("employee_Id");
    ArrayList<DataRecord> list = database.executeQuery("select status from attendance where employee_Id ='" + id + "'and date='" + d.format(new Date()) + "'");
                    int n = list.size();
                    if (list.get(n - 1).equals("signed in")) {

                    ArrayList<DataRecord> list1 = database.executeQuery("select employee_name from employee where employee_Id ='" + id + "'");
                    ename = list1.get(0).getString("employee_name");
                    methodemployee(id, ename);

                }
            }
        }catch(NullPointerException e){
                e.printStackTrace();
        } catch(Exception e){
            e.printStackTrace();
        }

Aucun commentaire:

Enregistrer un commentaire