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); }