Software Architecture in Java: Design & Development/

...

/

Develop the Data Access Tier

Develop the Data Access Tier

The data access tier is the second step in the process of developing a service.

We'll cover the following...

“Find all records” operation

We will begin with the test case for the “find all records” operation.

Press + to interact
@RunWith( SpringJUnit4ClassRunner.class )

@ContextConfiguration( locations = { "classpath:context.xml" } )

@TransactionConfiguration( defaultRollback = true )

@Transactional

public class EmployeeDaoImplTest {

	@Autowired

	private EmployeeDao dao ;



	@Test

	public void testGetAll() {

		Assert.assertEquals(0L, dao.getAll().size());

    }

}

We will then see how to write the corresponding data access operation of the above test.

Press + to interact
@Repository

@Transactional

public class EmployeeDaoImpl  implements EmployeeDao {

	@Autowired

	private SessionFactory sessionFactory ;



	@SuppressWarnings("unchecked")

	@Override

	public List<Employee> getAll() {

		return sessionFactory.getCurrentSession().createQuery("select employee from Employee employee order by employee.id desc").list();

	} 

}

Insert operation

...