SQLite query to Textlist

technochr..

in Contributed Library Questions • 2 years ago

Im a noob to programming anything, so here it goes.... Im attempting to display the last 10 entries of a column in a database table. I need the text to display in a list in the app window. Im getting stuck on the part after Line31, I dont have any idea on how to populate a List with the data queried. After mousePressed the list needs to update to redisplay the latest 10 element query.

The code i have below only shows the last line recieved, where i need to show all lines.

the data base is simple:

Column 1 my KEY, and is a Int, Primary Key that Auto increments with new line added.

Column 2 is ColString, and is text.

Data: with the "|" as the separator between column 1 and 2

1 | DATALINE1

2 | DATALINE2

3 | DATALINE3

4 | DATALINE4

5 | DATALINE5

6 | DATALINE6

import de.bezier.data.sql.*;
SQLite db;
void setup()
{
size( 500, 200 );
db = new SQLite( this, "test.db" ); // open database file
if ( db.connect() )
{
// list table names
db.query( "SELECT name as \"Name\" FROM SQLITE_MASTER where type=\"table\"" );
while (db.next())
{
println( db.getString("Name"));
}
// read all in table "table_one"
}
}
void draw() {
// text(DbRead, 10,10);
}
void mousePressed()
{
db.query( "SELECT ColString,KEY FROM SystemRead ORDER BY KEY Desc LIMIT 10" );
while (db.next())
{
String DbRead = (String) db.getString("ColString") ;
println(DbRead);
background(0);
text(DbRead,10,10,500,200);
}
}

Please Help me.

Replies(2)

PhiLho

Re: SQLite query to Textlist

2 years ago

You have a good start already.
Note: unless SQLite has a specific syntax, don't use double quotes in SQL requests, use simple quotes. It is more standard and avoids the use of backslashes...

You need to create a global array list:
ArrayList<String> items = new ArrayList<String>();

Then when reading the database:
while (db.next())
{
int key = db.getInt("KEY"); // Untested! Check the method name...
String data = db.getString("ColString");
items.add(key + "|' + data);
}

and in draw():
y = 30;
for (String line : items)
{
text(line, 10, y);
y += 30; // Adjust
}

technochr..

Re: SQLite query to Textlist

2 years ago

THANK YOU PHI.LHO!!!!

Im not sure how i could simplify my code, But i would like to learn Object Oriented Programming and implement it into my sketch.

So basiclly this program reads from the serial port, and changes the Color of a Rectangle that recieves a certian string.

Right now i only have 1 rectangle drawn on the screen, and it works fine and updates accordingly, but my code is a MESS! Is it possible to create these objects and have them still update when the string is recieved. I would also like to make the rectangle flash the color instead of just appearing solid, or even alternate between 2 colors. I have ideas to implement the color changes, buti didnt want to complicate things if i could apply these rectangles to objects..

ITS A MESS, I KNOW!

My code is too long to post so heres a .txt file.

http://dl.dropbox.com/u/8039619/MyCode.txt

THANKS AGAIN ALL!

Top Reply