public static String getMaxPublisherID(){
        try {

            ResultSet rs=DB.myConnection().createStatement().executeQuery("select max(PublisherID) from publisher");
            String x="x";
            while(rs.next()){
            x="y";

            int publisherId=Integer.parseInt(rs.getString(1))+1;
            max_publisher_id=Integer.toString(publisherId);

                                
            }

        } catch (ClassNotFoundException e) {
            JOptionPane.showMessageDialog(null, "Error @ Loadpublisher 63 class not found exception");
        }catch(SQLException exception2){
            JOptionPane.showMessageDialog(null, "Error @ Loadpublisher 65 SQL exception");
        }
        return max_publisher_id;
    }