Scanner and SortedSet

[harrell collins]

I am using a scanner to scan a text file and write out three fields to another text file. I need to sort the file based on the taxID and a deeper sort based on classcode. if the taxId is the same and the classcode is different then I need to increment the counter and print the line. If taxId and classcode is the same I simply need to put the acctNo in an array to be printed later. I am including my code. Any suggestions or help is appreciated.

 
import java.util.Scanner;
import java.util.*;
import java.io.*;
 
public class BearScanner {
 
      static int countToken =0;
 
        public static void main(String args[]) {
 
        try{
 
                File  file = new File("BEAR_STERNS_ACCOUNT_TOTAL.txt.DAT");
                File sortedFile = new File("sortedFile");
 
                Scanner freader = new Scanner(file).useDelimiter(",");
//              Scanner freader = new Scanner(file).useDelimiter("\\s*,\\s*");
                BufferedWriter writer = new BufferedWriter(new FileWriter("sortedFile.txt"));
                PrintWriter pw = new PrintWriter(writer);
                //... Loop as long as there are input lines.
                String  line;
                String rr;
                String date;
                String classCode;
                int clCde =0;
                boolean clCdeFnd = true;
                String taxID;
                String prevClassCode= null;
                String prevTaxId = null;
                String acctNo;
                countToken = 0;
                int cntMail =0;
                boolean fileHasInput = freader.hasNext();
                while (fileHasInput){
                        acctNo=freader.next();
 
                        date=freader.next();
                        rr=freader.next();
                        classCode=freader.next();
                        taxID=freader.next();
                        freader.nextLine();
                        writer.write(acctNo);
                        writer.write(",");
                        writer.write(classCode);
                        writer.write(",");
                        System.out.println(classCode);
                        writer.write(taxID);
//                        writer.write(",");
 

                                  SortedSet<Mailing> code = new TreeSet<Mailing>();
                                      code.add(acctNo);
                                      code.add(classCode);
                                      code.add(taxID);
                                      String[] array = (String[])code.toArray(new String[code.size()]);
                                       // Iterating over the elements in the set
                                       Iterator it = code.iterator();
                                       while (it.hasNext()) {
                                       // Get element
                                                Object element = it.next();
                                                if((element.toString() == taxID) && (element.toString() != classCode)) {
                                                      cntMail++;
                                        System.out.println("Tax Id number:" + taxID + "will have" + cntMail + "different mailings"); 
 
                                                }
                                       }
 

 

 

 

 

                        }
                        writer.newLine();   // Write system dependent end of line.
 

                //... Close reader and writer.
                freader.close();  // Close to unlock.
                writer.close();  // Close to unlock and flush to disk.
    }
     catch (IOException e) {
      System.out.println ("Input exception:" + e );
    }
}
public class Mailing implements Comparable<Mailing>{
 
        private final String acctNo, taxID, classCode;
 
        public Mailing(String acctNo, String taxID, String classCode) {
                if (taxID == null || classCode == null)
                    throw new NullPointerException();
                this.taxID = taxID;
                this.classCode = classCode;
                this.acctNo = acctNo;
        }
 
        public String taxID() { return taxID; }
        public String classCode() { return classCode; }
        public String acctNo() { return acctNo; }
 

        public boolean equals(Object o) {
              if (!(o instanceof Mailing))
                     return false;
 
                     Mailing m= (Mailing)o;
                     return m.taxID.equals(taxID) && m.classCode.equals(classCode) && m.acctNo.equals(acctNo);
        }
 
        public String toString(){
           return taxID + " " + classCode +  acctNo;
        }
 
        public int compareTo(Mailing m){
         int lastCmp = taxID.compareTo(m.taxID);
         return (lastCmp != 0 ? lastCmp :
            classCode.compareTo(m.classCode));
       }
 

}
 

 

 

 

 

 

 

}   
 

[Jean-Francois Briere]

You should do it in two passes.
First read the file and add all mail elements in the tree set.
Second iterate over the tree set to write to the second file.

// 1st: read the file and add all mail elements to the tree set.
Scanner freader = new Scanner(file).useDelimiter(",");
boolean fileHasInput = freader.hasNext();
SortedSet<Mailing> mailSet = new TreeSet<Mailing>();
while (fileHasInput) {
    String acctNo = freader.next();
    String date = freader.next();
    String rr = freader.next();
    String classCode = freader.next();
    String taxID = freader.next();
    freader.nextLine();
    Mailing mail = new Mailing(acctNo, taxID, classCode);
    mailSet.add(mail);
}
freader.close();
 
// 2nd: iterate over the tree set to write to the other file.
Iterator<Mailing> iterator = mailSet.iterator();
Mailing lastMail = iterator.next();
StringBuffer lineToWrite = new StringBuffer(lastMail.toString());
PrintWriter pw = new PrintWriter(new BufferedWriter(new FileWriter("sortedFile.txt")));
while (iterator.hasNext()) {
    Mailing mail = iterator.next();
    if ((mail.taxId() == lastMail.taxId()) && (mail.classCode() == lastMail.classCode())) {
        lineToWrite.append(' ').append(mail.acctNo());
    }
    else {
        pw.println(lineToWrite.toString());
        lineToWrite = new StringBuffer(mail.toString());
    }
    lastMail = mail;
}
pw.println(lineToWrite.toString());
pw.close();

Regards