public static String getMaxAithorID(){
        try {
             ResultSet rs=DB.myConnection().createStatement().executeQuery("select max(AuthorID) from author");
             while(rs.next()){
             max_Author_id=Integer.toString(rs.getInt(1)+1);                
            }
 
        } catch (ClassNotFoundException exception1) {
            JOptionPane.showMessageDialog(null, "Error @ LoadAuthor class not found exception");
        }catch(SQLException exception2){
            JOptionPane.showMessageDialog(null, "Error @ LoadAuthor SQL exception");
        }
        return max_Author_id;
    }