Databases
StackOverflow2013
Postsdbo
POUsing comparable interface to sort through an array
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POUsing comparable interface to sort through an array
    primarykey
    data
    text
    <p>I am trying to rank/sort the diamonds by size of the carat. If the size is equal then I want to rank them by either the color or the clarity, whichever gives its the best ranking. I cannot get it to work properly. It runs, however it will only rank them according to the size of the carat</p> <pre><code>Crawford_Diamond[] stones = new Crawford_Diamond[16]; stones[0] = new Crawford_Diamond( "A1023", 1.0, "VS1", 'F', "brilliant"); stones[1] = new Crawford_Diamond( "A5911", 1.1, "VVS2", 'G', "rose"); stones[2] = new Crawford_Diamond( "C5427", 1.0, "VS1", 'D', "princess"); stones[3] = new Crawford_Diamond( "D8307", 1.6, "SI1", 'H', "brilliant"); stones[4] = new Crawford_Diamond( "B4825", 0.3, "I1", 'D', "rose"); stones[5] = new Crawford_Diamond( "A1844", 2.1, "VS2", 'D', "lozenge"); stones[6] = new Crawford_Diamond( "A3747", 3.1, "SI2", 'W', "baguette"); stones[7] = new Crawford_Diamond( "E6393", 2.3, "VS2", 'I', "brilliant"); stones[8] = new Crawford_Diamond( "C5619", 2.8, "VVS1", 'E', "pear"); stones[9] = new Crawford_Diamond( "E8348", 1.4, "VS2", 'G', "brilliant"); stones[10] = new Crawford_Diamond( "D2381", 1.7, "I3", 'G', "brilliant"); stones[11] = new Crawford_Diamond( "C9253", 1.3, "VS2", 'H', "baguette"); stones[12] = new Crawford_Diamond( "G3459", 2.1, "VS2", 'H', "rose"); stones[13] = new Crawford_Diamond( "B3598", 2.4, "VVS2", 'D', "pear"); stones[14] = new Crawford_Diamond( "D9836", 2.8, "IF", 'E', "princess"); stones[15] = new Crawford_Diamond( "E1046", 2.2, "FL", 'E', "rose"); Arrays.sort(stones); for ( int j=0; j&lt;stones.length; j++) System.out.println( stones[j].toString()); public class Crawford_Diamond implements Comparable&lt;Crawford_Diamond&gt; { private String stockNumber; //diamond stock number private double carot; //carrot size private String clarity; private char color; //color of the diamond. D=Best Z=Worst private String cut; //cut of the diamond private int diamondColor; private int diamondClarity; public Crawford_Diamond(String sN, double car, String clar, char col, String cutType) { stockNumber = sN; carot = car; clarity = clar; color = col; cut = cutType; } //gets the stock number of the diamond public String getStock(){return stockNumber; } //gets the carrot size of the diamond public double getCarot(){return carot;} //gets the clarity of the diamond public String getClarity(){return clarity;} //gets the color of the diamond public char getColor() { return color; } //gets the cut of the diamond public String getCut() {return cut;} public int compareClarity(String getClarity) { int diamondClarity=0; if (getClarity.equals("Fl")) diamondClarity = 10; else if (getClarity.equals("IF")) diamondClarity = 9; else if (getClarity.equals("VVS1")) diamondClarity = 8; else if (getClarity.equals("VVS2")) diamondClarity = 7; else if (getClarity.equals("VS1")) diamondClarity = 6; else if (getClarity.equals("VS2")) diamondClarity = 5; else if (getClarity.equals("SI1")) diamondClarity = 4; else if (getClarity.equals("SI2")) diamondClarity = 3; else if (getClarity.equals("I1")) diamondClarity = 2; else if (getClarity.equals("I2")) diamondClarity = 1; else if (getClarity.equals("I3")) diamondClarity = 0; return diamondClarity; } public int getRankD1( ) { int rankD1=0; if (this.diamondColor &gt; this.diamondClarity) rankD1 = diamondColor; else if (this.diamondColor &lt; this.diamondClarity) rankD1 = diamondClarity; return rankD1; } public int getRankD2() { int rankD2=0; if (this.diamondColor &gt; this.diamondClarity) rankD2 = diamondColor; else if (this.diamondColor &lt; this.diamondClarity) rankD2 = diamondClarity; return rankD2; } public int compareColor(char getColor) { int diamondColor=0; if (getColor=='D' || getColor=='E') diamondColor = 10; else if (getColor=='F' || getColor=='G') diamondColor = 9; else if (getColor=='H' || getColor=='I') diamondColor = 8; else if (getColor=='J' || getColor=='K') diamondColor = 7; else if (getColor=='L' || getColor=='M') diamondColor = 6; else if (getColor=='N' || getColor=='O') diamondColor = 5; else if (getColor=='P' || getColor=='Q') diamondColor = 4; else if (getColor=='R' || getColor=='S') diamondColor = 3; else if (getColor=='T' || getColor=='U') diamondColor = 2; else if (getColor=='V' || getColor=='W') diamondColor = 1; else if (getColor=='X' || getColor=='Y') diamondColor = 0; return diamondColor; } public int compareTo(Crawford_Diamond other) { if (this.carot &gt; other.getCarot()) { return -1; } else if (this.carot &lt; other.getCarot()) { return 1; } else if(this.getRankD1() &gt; other.getRankD2()) { return -1; } else if(this.getRankD1() &lt; other.getRankD2()) { return 1; } else return 0;} public String toString() { return "{stockNumber :: " +getStock() + " carot :: " +getCarot() + " clarity :: " +getClarity()+ " color :: " +getColor() + " cut :: " +getCut()+"}"; } } </code></pre>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USPatrick Kostjens
    1. USCorey Crawford
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. COYou really should use an `enum` instead of strings for your `clarity` field; it's simpler and type-safe, and you can eliminate the whole `switch`.
      singulars
      1. POUsing comparable interface to sort through an array
      1. USchrylis
    2. COUse custom comparators if you need to sort an object in multiple ways.
      singulars
      1. POUsing comparable interface to sort through an array
      1. USmre
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload