public static String getMemberID(){
        try {
 
            ResultSet rs=DB.myConnection().createStatement().executeQuery("select max(MemberID) from members");
            while(rs.next()){
                maxid=Integer.toString(rs.getInt(1)+1);                
            }
 
        } catch (ClassNotFoundException exception2) {
            JOptionPane.showMessageDialog(null, "Error @ GenerateMemberID class not found exception ");
        }catch(SQLException exception3){
            JOptionPane.showMessageDialog(null, "Error @ GenerateMemberID SQL exception ");
        }
        return maxid;
    }