Thread: Ready to Program: Help Please!

Hello everyone,

I'm a new programmer and thus still suck, I do not even know if I should be posting this here or be able to receive any help.

However, my issue is the following: (Note: I'm using Ready to Program to code)

I've wrote a gaming database and I'm calling them using the following rs statement:

if (eve.getSource () == mybtn)
{
try
{
String sql = "Select * from Games Order by Genre";
 
int cnt = 0;
rs = stmt.executeQuery (sql);
 
 
 
while (rs.next ())
{
 
 
String Genre = rs.getString ("Genre");
String Popularity = rs.getString ("Popularity");
String HighestScore = rs.getString ("HighestScore"); // I would like to modify this value
String Rating = rs.getString ("Rating");
String PlayerName = rs.getString ("PlayerName");
String TournamentAvailable = rs.getString ("TournamentAvailable");
String Game = rs.getString ("Game");
 
 
data [cnt] [0] = Genre;
data [cnt] [1] = Popularity;
data [cnt] [2] = HighestScore; // I would like to modify this value
data [cnt] [3] = Rating;
data [cnt] [4] = PlayerName;
data [cnt] [5] = TournamentAvailable;
data [cnt] [6] = Game;
 
cnt++;
 
table.updateUI ();
 
 
}
 
}
 
 
catch (Exception e)
{
System.out.println ("Vraag 1 onsuksesvol");
e.printStackTrace ();
}
}

Question:

I would like to modify the value of HighestScore by replacing it with a random generated number, using the following code: double y = (Math.random () * 5001) + 1; (which generates random numbers between 1-5000)

Then, I need to take the random generated value and import it back into my JTabel.

Could anyone assist me?
Thanks in advance
Shanse

Hello.
Do you want to update the database table or just the gui table in which you are displaying the data?
If it is just the display table then directly you can use the following statement:
data [cnt] [2] = (Math.random () * 5001) + 1;
If the value you want is integer just do the typecast.

Thanks,
Syed.

Hello, Syed

When I Implement the code:

data [cnt] [2] = (Math.random () * 5001) + 1;

It throws out the following error:

You cannot assign a "double" expression to a "java.lang.String" variable

now, I need to cast this using the "" double.toString() ""-workaround right?
however I'm unsure how to do this.

When I try:

data [cnt] [2] = double.toString (HighestScore);

Error Occurs: DoubleLiteral expected instead of this token

Please advise.
Shanse
Thanks

Originally Posted by Shanse

double y = (Math.random () * 5001) + 1; (which generates random numbers between 1-5000)

I don't think so.

How did you set the values in the table the first time? Do the same thing using the value y (from your example) instead of what ever value you used the last time.
If this is of no help I am afraid I do not understand the question

Edit: I fixed the issue

However I'm getting decimal answers now with the coding:

double HighestScore = (Math.random () * 5001) + 1;
data [cnt] [2] = Double.toString (HighestScore);

Question:

Is there a way to round-off the answers (i.e if 2560.81 to 2561)
or
not show the decimals at all?

Thanks in advance,
Shanse

1. See java.util.Random.nextInt(int n)
2. I do not understand what trouble you are having in setting a variable to some value, in this case the random number. Please post a specific question

Nevermind, I managed to fix my issue by using math.round.

Thanks alot for the quick response & answers to my query.



Later,
Shanse