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...

Now let’s turn to the data access tier. We will start with the test case for the get all records procedure.

Find all records operation

Press + to interact
@RunWith( SpringJUnit4ClassRunner.class )

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

@TransactionConfiguration( defaultRollback = true )

@Transactional

public class StudentDaoImplTest {

	@Autowired

	private StudentDao dao ;

	@Test

	public void testGetAll() {

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

	}

}

For the test above, let’s look at the corresponding data access operation. The Hibernate 4 Session.createQuery method is used with SQL to retrieve all the records from the Student entity.

Press + to interact
@Repository

@Transactional

public class StudentDaoImpl implements StudentDao{

	@Autowired

	private SessionFactory sessionFactory ;

	@Override

	public List<Student> getAll() {

		return (List<Student>)sessionFactory.getCurrentSession().

				createQuery("select student from Student student").list();

	}

}

Insert operation

...