SQLibrary instert data in table
in
Contributed Library Questions
•
1 year ago
I checked out the mysql_timestamp example.
Share your processing sketches online: http://www.opensketches.org
My question is, how can i insert data in a table?
I tried this:
import de.bezier.data.sql.*;
/*
CREATE TABLE `test` (
`id` int(10) NOT NULL auto_increment,
`time` timestamp NOT NULL default CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
)
*/
MySQL msql;
MySQL ms;
java.sql.Timestamp last_ts;
String database = "androidtest", user = "androidtest", pass = "XXXXXXX";
void setup ()
{
ms = new MySQL( this, "localhost", database, user, pass );
last_ts = new java.sql.Timestamp( 0 );
if ( ms.connect() )
{
ms.query( "SELECT * FROM test ORDER BY time ASC LIMIT 1" );
ms.next();
last_ts = ms.getTimestamp("time");
}
}
void draw ()
{
if ( ms.connect() )
{
ms.execute( " INSERT INTO androidtest (id, time) VALUES ('', 'TEST')); " );
ms.query( "SELECT * FROM test WHERE time > '"+last_ts+"' ORDER BY time ASC" );
while( ms.next() )
{
println( ms.getInt( "id" ) );
last_ts = ms.getTimestamp( "time" );
}
}
}
Share your processing sketches online: http://www.opensketches.org
1
