Assigning ranking numbers to String.format

[Dawesome]

Hey there. Ok i will try to explain.

My code is like this:

String text = "   Fist Name                  Last Name                                      Total Balance\n ";
text += "--------------------------------------------------------------------------------------------------------------\n";
					
						for(ScoreboardDTO scoreboard : score)
						 	{
						 text += String.format(" %20s | %20s | %50d \n", scoreboard.getFirst_name(), scoreboard.getLast_name(), scoreboard.getTot_saldo());

It gets first_name, last_name, tot_saldo from a database and the inputs like this:

 Fist Name                  Last Name                                      Total Balance
-------------------------------------------------------------------------------------------------------------

  user-name                user-lastname                                   user-total balance
  user-name2              user-lastname2                                  user-total balance2
  user-name3              user-lastname 3                                   user-total balance3
  user-name4              user-lastname4                                 user-total balance4
  user-name5              user-lastname4                                   user-total balance5

But the problem is that it's a scoreboard of the persons with highest total balance on the database. Therefore i want java to give me a ranking of the top 5 like this instead:

Fist Name                  Last Name                                      Total Balance
-------------------------------------------------------------------------------------------------------------

#1  user-name               user-lastname                                   user-total balance
#2 user-name2              user-lastname2                                  user-total balance2
#3 user-name3              user-lastname 3                                   user-total balance3
#4 user-name4              user-lastname4                                 user-total balance4
#5 user-name5              user-lastname4                                   user-total balance5

But im not quite sure how to do this. I hoped you guys could give me a little assistance :)

Regards
Dawesome

[Fubarable]

I've added [code] [/code] tags to the post above to try to help make it readable.

[Fubarable]

Does the for loop produce names in order desired? Or do you need to sort the output first?

[Dawesome]

I have a SQLQuery which produces my desired order from the database.

                        select u.first_name, u.last_name, max(h.tot_saldo) as tot_saldo from history_table h 
            		join user_table u on h.user_alias = u.user_alias 
            		join inst_table i on h.inst_id = i.inst_id
            		group by u.first_name, u.last_name
            		desc limit 5;

The only problem (with this function ;) ) is ranking them #1 - #5 so that it's more obvious that it's a scoreboard :)

[Fubarable]

I have a SQLQuery which produces my desired order from the database.

                        select u.first_name, u.last_name, max(h.tot_saldo) as tot_saldo from history_table h 
            		join user_table u on h.user_alias = u.user_alias 
            		join inst_table i on h.inst_id = i.inst_id
            		group by u.first_name, u.last_name
            		desc limit 5;

The only problem (with this function ;) ) is ranking them #1 - #5 so that it's more obvious that it's a scoreboard :)

Don't use a for-each loop, but rather a standard for loop. Use the loop index + 1 for your rank value and concatenate it to your String. Bingo.

[Dawesome]

Don't use a for-each loop, but rather a standard for loop. Use the loop index + 1 for your rank value and concatenate it to your String. Bingo.

Im actually using a while-loop. Is but can you give me an example ? :) I understand it but i'am not quite sure how to code it.

[Fubarable]

Im actually using a while-loop. Is but can you give me an example ? :) I understand it but i'am not quite sure how to code it.

I much prefer you to take my advice and try to code this yourself, and then showing us your attempt and any questions if you have a problem.

If you're using a while loop, then create an int counter variable before the loop, and increment it within the loop.

I'm sure you can do this, so please give it a try or ask another question if not clear.

[Dawesome]

Thx for the help.
I just made a simple counter like this.

int counter = 1;

and incrementet it in my

text.format

with

 counter ++

Made my function an important part better ;)

[Fubarable]

Good deal. Glad you've got it solved.