Posted By

flashmac on 03/29/14

Tagged

Versions (?)

Last Edited at 03/29/14 03:30am

Statistics

Viewed 514 times

Favorited by 0 user(s)

Related snippets

JUNIT - testing for an exception

/ Published in: Java

example where you need to test for an exception

Highlighted TextExpand

/** JUNIT TEST **/

inside XDAOTest.class

@Test
	public void testUpdateDcrWithForcedexception()
	{
		ICmsDcrDAO cmsDcrDAO = LSDAOFactory.getFactory().getCmsDcrDAO();
		String fakeSelect = "This is a fake Select to provoque SQLException ?";
		ReflectionTestUtils.setField(cmsDcrDAO, "UPDATE_DCR", fakeSelect);
		CmsDcr dcr = new CmsDcr();
		boolean testUpdate = cmsDcrDAO.updateDcr(dcr);
		assertFalse(testUpdate);
	}

/** DAO CLASS **/
inside XDAO.class

private static String UPDATE_DCR = "UPDATE seo_audit_data.cms_dcr SET dcr_path = ?, countPages = ?, date_last_updated = ?, isDeleted = ? WHERE id = ?";

public boolean updateDcr(CmsDcr dcr) {
		conn = getDBConnection();
		boolean returnval = false;
		try {
			PreparedStatement preparedStatement = conn.prepareStatement(UPDATE_DCR);
			preparedStatement.setString(1, dcr.getDcrPath());
            preparedStatement.setInt(2, dcr.getCountPages());
            preparedStatement.setDate(3, dcr.getDateLastUpdated());
            preparedStatement.setInt(4, dcr.getIsDeleted());
            preparedStatement.setInt(5, dcr.getId());
            int rowsAffected = preparedStatement.executeUpdate();
            conn.close();
            
            if(rowsAffected > 0) {
            	returnval = true;
            }
            else{
                System.out.println("Unable to update dcr in seo_audit_data.cms_dcr table.");
            }
        }catch (SQLException e) {
        	System.out.println("Database error trying to update the DCR in table seo_audit_data.cms_dcr." + e);
        }
        return returnval;
	}

Report this snippet Tweet

Comments

Subscribe to comments

Comment:

You need to login to post a comment.