// query
SQLQuery query = new SQLQuery(connection, configuration);
assertEquals(Gender.MALE, query.from(person).where(person.id.eq(10)).uniqueResult(person.gender));
// update
SQLUpdateClause update = new SQLUpdateClause(connection, configuration, person);
update.set(person.gender, Gender.FEMALE);
update.set(person.firstname, "Jane");
update.where(person.id.eq(10));
update.execute();
// query
query = new SQLQuery(connection, configuration);
assertEquals(Gender.FEMALE, query.from(person).where(person.id.eq(10)).uniqueResult(person.gender));
}