Retrieving data from sql database

ppwr11

Retrieving data from sql database

in Contributed Library Questions • 1 year ago

Hi, I am creating a score board for my game. The score board consists of just the name and score. I have the database set up and the connection made. The problem im having is that when the data is returned from the database it only appears in the console, how do i get it to appear in the game screen?

Replies(3)

tfguy44

Re: Retrieving data from sql database

1 year ago

How are you making it show up in your console? Could you please post your code (be sure to leave out connection-details if you like!)?

ppwr11

Re: Retrieving data from sql database

1 year ago

This is what i have so far, the println is making it show up on the console:

import de.bezier.data.sql.*;

List<String>p;

MySQL dbconnection;

void setup()

{

size( 400, 400 );

paul = new ArrayList<String>();

connectDB();

println(p);

}

void connectDB()

{

String user = "";

String pass = "";

String database = "scores";

String table = "top10";

dbconnection = new MySQL( this, "", database, user, pass );

if ( dbconnection.connect() )

{

dbconnection.query( "SELECT * FROM top10 WHERE score > 10");

while(dbconnection.next()){

p.add(dbconnection.getString("name"));

p.add(dbconnection.getString("score"));

}

void draw()

{

for(String s : p){

text( s,200,200);

}

PhiLho

Re: Retrieving data from sql database

1 year ago

You have your data in your array list, in the form of strings. I see you tried to display it in draw. That's the spirit. Just have a counter to update the y position (and x if you want names to face scores) on each entry.
And you better have a small class to wrap up name and score, instead of having them separate in the list.
Don't forget to have background() at the start of draw().

Top Reply