@Test
	public void testGetSearchGenre() 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<SearchGenre> auths = bh.getSearchGenres(0L, st, rs);
			assertTrue(auths.size() == 0);

			//Matched isbn with one search genre
			auths = bh.getSearchGenres(9780439064873L, st, rs);
			assertTrue(auths.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) {	}
		}
	}