public static void removeBook(Book b){
		
		try {
			   if(conn == null || conn.isClosed()){
			    conn = DatabaseConnection.getConnection();
			   }
			  } catch (SQLException e1) {
			   // TODO Auto-generated catch block
			   e1.printStackTrace();
			  }
		
		try{
			conn.setAutoCommit(false);
			PreparedStatement stmt = conn.prepareStatement("DELETE FROM Books WHERE book_id = ?");
			stmt.setInt(1, b.getBookID());
			stmt.execute();
			conn.commit();
			conn.setAutoCommit(true);
		}catch(SQLException e){
				System.out.println(e);
			
		}
	}