public List<Employee> getEmployeeList() {
open();
String[] columns = new String[] {EMPLOYEE_NAME, EMPLOYEE_ID};
Cursor c = myDatabase.query(EMPLOYEE_TABLE, columns, null, null, null, null, null);
List<Employee> employees = new ArrayList<Employee>();
int iTableID = c.getColumnIndex(EMPLOYEE_ID);
int iId = c.getColumnIndex(EMPLOYEE_NAME);
if (c != null) {
for (c.moveToFirst(); !c.isAfterLast(); c.moveToNext()) {
Employee e = new Employee();
e.setId(c.getInt(iTableID));
e.setName(c.getString(iId));
employees.add(e);
}
}
close();
return employees;
}
public Employee getEmployee(int id) {
open();
Employee e = new Employee();
Cursor c =
myDatabase.rawQuery(
"SELECT * FROM "
+ EMPLOYEE_TABLE
+ " WHERE "
+ EMPLOYEE_ID
+ " = ? ORDER BY "
+ EMPLOYEE_NAME
+ " ASC",
new String[] {Integer.toString(id)});
int iTableId = c.getColumnIndex(EMPLOYEE_ID);
int iId = c.getColumnIndex(EMPLOYEE_NAME);
if (c != null) {
c.moveToFirst();
e.setId(c.getInt(iTableId));
e.setName(c.getString(iId));
}
close();
return e;
}