private void setupTable() {
String statement =
"CREATE TABLE IF NOT EXISTS "
+ table
+ " "
+ "(name VARCHAR(16) not NULL, "
+ " time INTEGER not NULL, "
+ " modified TIMESTAMP not NULL, "
+ " PRIMARY KEY ( name ))";
sql.execute(statement);
}
private void setDBTime() {
String statement =
"INSERT INTO "
+ table
+ " VALUES ('"
+ syncingName
+ "', "
+ syncingTime
+ ", CURRENT_TIMESTAMP) "
+ "ON DUPLICATE KEY UPDATE "
+ "time="
+ syncingTime;
sql.execute(statement);
}