public static void ImportDataBookCopies(){
		try {
			   if(conn == null || conn.isClosed()){
			    conn = DatabaseConnection.getConnection();
			   }
			  } catch (SQLException e1) {
			   // TODO Auto-generated catch block
			   e1.printStackTrace();
			  }
        try{
        	conn.setAutoCommit(false);
            PreparedStatement pstm = null ;
          
	                String sql = "INSERT INTO BookCopies(book_id) SELECT book_id FROM Books WHERE book_id NOT IN (SELECT bc.book_id FROM BookCopies bc, Books b WHERE bc.book_id = b.book_id)";
	                
	                pstm = (PreparedStatement) conn.prepareStatement(sql);
	                pstm.executeUpdate();
            conn.commit();
            pstm.close();
            conn.close();
            System.out.println("Success import excel to mysql table");
            }catch(SQLException ex){
	            System.out.println(ex);
            }

		}