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

			//Delete any test books
			assertTrue(bh.deleteBook(-1));

			//Add a test book to be deleted and ensure it is added
			bh.addBook(b);
			assertTrue(bh.keywordSearch("Test").get(0).getIsbn() == -1);

			//Delete book and ensure that the relationships were deleted
			bh.deleteBook(-1);
			assertTrue(bh.keywordSearch("Test").size() == 0);
			assertTrue(bh.getAuthors(-1, st, rs).size() == 0);
			assertTrue(bh.getPublishers(-1, st, rs).size() == 0);
			assertTrue(bh.getSearchGenres(-1, st, rs).size() == 0);
			
			//Don't allow deletes that leave publishers without a book
			assertTrue(!bh.deleteBook(9780545139700L));

			//Don't allow deletes that leave authors without a book
			assertTrue(!bh.deleteBook(9780321834843L));
		}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) {	}
		}
	}