コード例 #1
0
 public List<Skill> getEmployeeSkills(int employeeId) {
   open();
   Cursor c =
       myDatabase.rawQuery(
           "SELECT * FROM "
               + EMPLOYEE_SKILL_TABLE
               + " LEFT JOIN "
               + SKILL_TABLE
               + " USING ("
               + SKILL_ID
               + ") WHERE "
               + EMPLOYEE_ID
               + " = ? ORDER BY "
               + SKILL_NAME
               + " ASC",
           new String[] {Integer.toString(employeeId)});
   List<Skill> skills = new ArrayList<Skill>();
   int rId = c.getColumnIndex(SKILL_ID);
   int rName = c.getColumnIndex(SKILL_NAME);
   int rSkillGroup = c.getColumnIndex(SKILL_GROUP_ID);
   if (c != null) {
     for (c.moveToFirst(); !c.isAfterLast(); c.moveToNext()) {
       Skill s = new Skill();
       s.setId(c.getInt(rId));
       s.setName(c.getString(rName));
       s.setSkillGroupId(c.getInt(rSkillGroup));
       skills.add(s);
     }
   }
   close();
   return skills;
 }
コード例 #2
0
 public void removeEmployeeSkill(Employee employee, Skill skill) {
   open();
   ContentValues cv = new ContentValues();
   cv.put(EMPLOYEE_ID, employee.getId());
   cv.put(SKILL_ID, skill.getId());
   myDatabase.delete(
       EMPLOYEE_SKILL_TABLE,
       EMPLOYEE_ID + " =? AND " + SKILL_ID + " =?",
       new String[] {Integer.toString(employee.getId()), Integer.toString(skill.getId())});
   close();
 }
コード例 #3
0
 public void addEmployeeSkill(Employee employee, Skill skill) {
   open();
   ContentValues cv = new ContentValues();
   cv.put(EMPLOYEE_ID, employee.getId());
   cv.put(SKILL_ID, skill.getId());
   myDatabase.insert(EMPLOYEE_SKILL_TABLE, null, cv);
   close();
 }