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