I have a question that sorts data from a car report of txt file.
The question is: How do I listed cars sorted by their MAKE (Ford, Chevy ..etc). They only need the MAKE to be sorted so they can be all FORD cars under each other, then Chevy, DODGE .. so on and so forth like this:
And this is what I have so far:
Here’s my source code:
JavaScript
x
public class CustomerSale { // Details of reports private String zipCodeExtension; private int customerNumber; private String customerName; private int purchaseDate; private String make; private int purchasePrice; private int yearOfVehicle; private int satisfactionRating; // Create constructor argument public CustomerSale(String zipCodeExtension, int customerNumber, String customerName, int purchaseDate, String make, int purchasePrice, int yearOfVehicle, int satisfactionRating) { this.zipCodeExtension = zipCodeExtension; this.customerNumber = customerNumber; this.customerName = customerName; this.purchaseDate = purchaseDate; this.make = make; this.purchasePrice = purchasePrice; this.yearOfVehicle = yearOfVehicle; this.satisfactionRating = satisfactionRating; } // Create getters and setters public String getMake() { return make; } public void setMake(String make) { this.make = make; } public String getZipCodeExtension() { return zipCodeExtension; } public void setZipCodeExtension(String zipCodeExtension) { this.zipCodeExtension = zipCodeExtension; } public int getCustomerNumber() { return customerNumber; } public void setCustomerNumber(int customerNumber) { this.customerNumber = customerNumber; } public String getCustomerName() { return customerName; } public void setCustomerName(String customerName) { this.customerName = customerName; } public int getPurchaseDate() { return purchaseDate; } public void setPurchaseDate(int purchaseDate) { this.purchaseDate = purchaseDate; } public double getPurchasePrice() { return purchasePrice; } public void setPurchasePrice(int purchasePrice) { this.purchasePrice = purchasePrice; } public int getYearOfVehicle() { return yearOfVehicle; } public void setYearOfVehicle(int yearOfVehicle) { this.yearOfVehicle = yearOfVehicle; } public int getSatisfactionRating() { return satisfactionRating; } public void setSatisfactionRating(int satisfactionRating) { this.satisfactionRating = satisfactionRating; }}JavaScript
import java.io.*;import java.text.DecimalFormat;import java.util.*;public class SortByMake { public static void main(String[] args) throws FileNotFoundException { File carsInfo = new File("src/custsale.txt"); Scanner carsScanner = new Scanner(carsInfo); String format = "%-20s%-14s%-21s%-16s%-19s$%-17s%-14s%-20sn"; while (carsScanner.hasNextLine()) { // Read the carsScanner String zipCodeExtension = carsScanner.nextLine(); int customerNumber = Integer.parseInt(carsScanner.nextLine()); String customerName = carsScanner.nextLine(); int purchaseDate = Integer.parseInt(carsScanner.nextLine()); String make = carsScanner.nextLine(); int purchasePrice = Integer.parseInt(carsScanner.nextLine()); int yearOfVehicle = Integer.parseInt(carsScanner.nextLine()); int satisfactionRating = Integer.parseInt(carsScanner.nextLine()); CustomerSale custsale = new CustomerSale(zipCodeExtension, customerNumber, customerName, purchaseDate, make, purchasePrice, yearOfVehicle, satisfactionRating); // Display the report DecimalFormat df = new DecimalFormat("#,#####"); System.out.printf(format, custsale.getZipCodeExtension(), custsale.getCustomerNumber(), custsale.getCustomerName(), custsale.getPurchaseDate(), custsale.getMake(), df.format(custsale.getPurchasePrice()), custsale.getYearOfVehicle(), custsale.getSatisfactionRating()); } ArrayList<CustomerSale> carMake = new ArrayList<>(); Collections.sort(carMake, Comparator.comparing(CustomerSale::getMake)); final int pageSize = 30; int carCounter = 0; for(CustomerSale car : carMake){ if (carCounter % pageSize == 0) { printPageHeader(carCounter / pageSize + 1); } // Increment the car counter carCounter++; } carsScanner.close(); } private static void printPageHeader(int i) { System.out.println( "-------------------------------------------------ABC USED CARS----------------------------------------------------------------"); System.out.println( "-------------------------------------------------------" + "PAGE " + i + "-----------------------------------------------------------------"); System.out.printf("%-19s%-15s%-21s%-15s%-20s%-17s%-12s%-20sn", "|ZIP CODE-EXT|", "|CUST No.|", "|CUSTOMER NAME|", "|DoP|", "|MAKE|", "|PRICE|", "|YEAR|", "|RATE|"); System.out.println( "------------------------------------------------------------------------------------------------------------------------------"); }}Here’s text file report:
JavaScript
46410-12341001ALBERT, CARL T.08252001FORD02550001991246307-12011003ANDREWS, ROBERT08262001CHEVROLET07000001958046423-23111008ANZIO, RAFELINO09012001CHEVROLET04560501978046424-01211010ASHLEY, WILLIAM B.09022001PIERCE-ARROW12400001932246375-31101015ATKINSON, MARK08272001STUDEBAKER00500001958146405-12911025AVERY, ALFRED A.08292001HUDSON02300001954146301-12341031BEZZMEK, JENNIFER08272001FORD04550001995246303-12011033BLAKE, DONALD08292001FORD07220501989146413-23111041BLONDELL, BONNIE09042001CHEVROLET03560501988146404-01211045BONADIO, JAMES09032001PIERCE-ARROW11500001935246307-31101055BUCKO, ONIEDA08282001STUDEBAKER02450001964146410-12911056BYMANN, FREDRICK08292001FORD03300001994146342-12341061CALBERT, RONALD09052001FORD03550001993246307-12111063CHELSEA, MARTHA S.08302001DODGE BROS.03500001935046410-23111067CLAFLIN, WAYNE R.09012001CHEVROLET04560501990246410-01211070COLE, CHARLES C.09022001PIERCE-ARROW10500001929246305-31111075COLEMAN, THOMAS08272001STUDEBAKER01670501961146410-12211076COLWELL, RICHARD L.08292001HUDSON04300001940146414-12311080COOPER, JOHNATHAN09052001FORD12560001996246307-12012002COREY, SARAH D.08272001CHEVROLET06500501994046421-23112004CRACKLIN, GOODMAN09012001CHEVROLET14560501996046323-01212011CRAWFORD, TIMOTHY09012001PIERCE-ARROW10400001931246315-31102012CURRIE, RAYMOND08282001STUDEBAKER01500251956146425-12912024CYBORG, IZORE M.09052001HUDSON01300001949146410-12342031DALTON, DAVID P.08252001FORD02340001990246307-12012043DAVIES, RALPH O.08262001CHEVROLET03330001989046423-23112048DENNICK, DONNA09012001CHEVROLET06560251995046424-01212050DERBIN, DEANNA09022001PIERCE-ARROW16400251937246375-31102065DONNEHUE, PHILLIP09042001STUDEBAKER00540001966146405-12912085DOPPLER, RADAR O.08302001HUDSON03110001951146310-12342091DUNLOP, RITA08252001FORD14500451996246303-12013003DYKES, CYNTHIA08262001FORD04100501987146413-23113011EATON, ESTER B.09012001CHEVROLET13560501996046404-01213015EFFLEY, BAILY09022001PIERCE-ARROW14460451933246307-31103025EGGERTON, AMANDA08292001STUDEBAKER03350001965146410-12913026EPPLEY, DAVID08282001FORD04140001995146342-12343031ERKLE, ROSA09032001FORD03550201993246307-12113043FARNSWORTH, WESLEY09052001DODGE BROS.11500001996046410-23113047FLANNERY, JAMES09012001CHEVROLET04500501992046410-01213050FOREMAN, OTTO J.09022001PIERCE-ARROW09400001927246305-31113055FOWLER, KATHLEEN08272001STUDEBAKER02670501964146410-12213056FURNACE, DAVID08292001HUDSON05300001948146414-12313061GALLAGHER, CLARENCE09042001FORD10060001992246307-12013062GENNERRO, TONY S.08302001CHEVROLET03200501989046421-23113066GOEBEL, NANCY K.09022001CHEVROLET06430501990046323-01213072GUNTHER, FREDERICK09032001PIERCE-ARROW12600001930246315-31103080HAINES, MARSHALL08292001STUDEBAKER02500251959146425-12913094HANCOCK, JONATHON09032001HUDSON03300001953146423-23113098HARTNETT, ROBERTO09052001CHEVROLET03260401988046424-01214005HENNING, SONIA09052001PIERCE-ARROW13050001928246375-31104009HORNSBY, ROGERS08252001STUDEBAKER01675001962146405-12914012HYATT, JANET F.08302001HUDSON01550001951146301-12344021IDZIOR, RAYMOND09012001FORD14600001996246303-12014022JENNINGS, WILLIAM08262001FORD06120401992146410-23114024JOHNSON, JACK09032001CHEVROLET02560501985046404-01214032KULKA, ROBERT C.09042001PIERCE-ARROW09700001934246307-31104035KURTZ, DONALD08302001STUDEBAKER03450001966146410-12914038LEVANDOWSKI, JILL08282001DODGE BROS.04300001988146342-12344044METZ, ARNOLD E.09012001FORD13230001996246307-12114046NORRIS, CHARLES S.09052001CHEVROLET08440001992046410-23114047NOWAKOWSKI, ALFRED09012001DODGE BROS.06560501994146410-01214053O'BOYLE, NIEL09032001PIERCE-ARROW15500001938246305-31114056O'BRIAN, PATRICK08302001STUDEBAKER03470501962146410-12214059PATTERSON, LENNI R.08292001HUDSON02500001946146414-12314061PERRY, SHAMUS09052001FORD08950001994246307-12014066REED, ROBERT B.08272001CHEVROLET07400501996046421-23114067RODRIGUEZ, ALONZO09052001DODGE BROS.10500501995046323-01214073SANCHEZ, HENRY09012001PIERCE-ARROW08300001925246315-31104081SWARTZ, HECTOR08282001STUDEBAKER00750251954146301-12344084TORREZ, MARTIN08272001FORD05650001994246303-12014090TUTTLE, MARK08292001FORD07100501996146413-23114094WARNER, JACK09042001CHEVROLET08560501996046404-01214115YACKLEY, YOURTO09042001PIERCE-ARROW100000019302Advertisement
Answer
it’s pretty straightforward :
read all element and put them in a list:
JavaScriptArrayList<CustomerSale> sales = new ArrayList<>();while(){sales.add(custsale);}sort the elements (I’m using streams, but probably
Collections.sortmight be less memory expensive since is in-place, e.g.Comparator.comparing(CustomerSale::getMake), thanks @Thomas):JavaScriptList<CustomerSale> sorted = sales.stream().sorted((f,s) -> {return f.getMake().compareTo(s.getMake());}).collect(Collectors.toList());and only at the end, print the output:
JavaScriptfor(int i = 0; i < sorted.size(); i++){CustomerSale custsale = sorted.get(i);if (i % pageSize == 0) {printPageHeader(i / pageSize + 1);}DecimalFormat df = new DecimalFormat("#,#####");System.out.printf(format, custsale.getZipCodeExtension(), custsale.getCustomerNumber(),custsale.getCustomerName(), custsale.getPurchaseDate(), custsale.getMake(),df.format(custsale.getPurchasePrice()), custsale.getYearOfVehicle(),custsale.getSatisfactionRating());};