public static void insertBook(BookCopy 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("INSERT INTO Books(title, author, year, place_of_publication, publisher, genre, isbn)"
														+  "VALUES (?, ?, ?, ?, ?, ?, ?)");
			stmt.setString(3, StringDateSwitcher.dateToStringYear(b.getYearEdition()));
			stmt.setString(4, b.getPublicationPlace());
			stmt.setString(1, b.getTitle());
			stmt.setString(2, b.getAuthor());
			stmt.setString(7, b.getISBN());
			stmt.setString(5, b.getPublisher());
			stmt.setString(6, b.getGenre());
			
			stmt.execute();
			conn.commit();
			conn.setAutoCommit(true);
		
		}catch(SQLException e){
			System.out.println("insert fail!! - " + e);
		}
	}