private StateDao stateDao;
@Test
public void doTestQuery() {
State state_alabania = stateDao.getStateByName("Albania");
State state_alabania_lower = stateDao.getStateByName("albaNia");
assertTrue(state_alabania != null);
assertTrue(state_alabania_lower != null);
assertTrue(state_alabania.getState_id().equals(3L));
assertTrue(state_alabania_lower.getState_id().equals(3L));
assertTrue(state_alabania.getState_id().equals(state_alabania_lower.getState_id()));
}