/** Find one Person by Id */ public PersonalData getPersonById(long id) { String sql = "SELECT * FROM " + SalaryContract.PersonalData.TABLE_PERSONALDATA + " WHERE " + SalaryContract.PersonalData.KEY_ID + " = " + id; Cursor cursor = this.db.rawQuery(sql, null); cursor.moveToFirst(); PersonalData personalData = new PersonalData(); personalData.setName( cursor.getString(cursor.getColumnIndex(SalaryContract.PersonalData.KEY_NAME))); personalData.setLastname( cursor.getString(cursor.getColumnIndex(SalaryContract.PersonalData.KEY_LASTNAME))); personalData.setAddress( cursor.getString(cursor.getColumnIndex(SalaryContract.PersonalData.KEY_ADDRESS))); personalData.setBirthdate( cursor.getString(cursor.getColumnIndex(SalaryContract.PersonalData.KEY_BIRTHDATE))); personalData.setCivilStatus( cursor.getString(cursor.getColumnIndex(SalaryContract.PersonalData.KEY_CIVILSTATUS))); personalData.setNbChildren( cursor.getInt(cursor.getColumnIndex(SalaryContract.PersonalData.KEY_NBCHILDREN))); personalData.setNationality( cursor.getString(cursor.getColumnIndex(SalaryContract.PersonalData.KEY_NATIONALITY))); personalData.setPermit( cursor.getString(cursor.getColumnIndex(SalaryContract.PersonalData.KEY_PERMIT))); personalData.setBank( cursor.getString(cursor.getColumnIndex(SalaryContract.PersonalData.KEY_BANK))); personalData.setPassword( cursor.getString(cursor.getColumnIndex(SalaryContract.PersonalData.KEY_PASSWORD))); personalData.setPostId( cursor.getInt(cursor.getColumnIndex(SalaryContract.PersonalData.KEY_POSTID))); personalData.setContractBegin( cursor.getString(cursor.getColumnIndex(SalaryContract.PersonalData.KEY_CONTRACT_BEGIN))); personalData.setPercentage( cursor.getInt(cursor.getColumnIndex(SalaryContract.PersonalData.KEY_PERCENTAGE))); personalData.setHollidayLeft( cursor.getInt(cursor.getColumnIndex(SalaryContract.PersonalData.KEY_HOLLIDAY_LEFT))); return personalData; }