@Test
	public void testGetPublisher() throws Exception {
		Connection conn = DriverManager.getConnection("jdbc:mysql://localhost/librarysystem?user=admin&password=123456");
		Statement st = conn.createStatement();
		ResultSet rs = null;

		try {
			//Unmatched isbn
			ArrayList<Publisher> pubs = bh.getPublishers(0L, st, rs);
			assertTrue(pubs.size() == 0);

			//Matched isbn with one publisher
			pubs = bh.getPublishers(9780545139700L, st, rs);
			assertTrue(pubs.size() == 1);
		}catch (Exception e) {
			fail("Caught exception:" + e.getMessage());
		}
		finally
		{
			try {
				if(conn != null)
					conn.close();
				if(st != null)
					st.close();
				if(rs != null)
					rs.close();
			} catch (Exception e) {	}
		}
	}