public static void clearTable() {
connectDb();
String sql = "delete from " + tablename + ";";
try {
query.executeUpdate(sql);
} catch (SQLException e) {
System.out.println("SQL Exception: " + e);
System.exit(1);
}
System.out.println("Table Cleared Successfully");
}
public static void createTable() {
connectDb();
String dataField = "";
for (int i = 0; i < AM_HEADER_LENGTH + TOSH_DATA_LENGTH + CRC_LENGTH; i++) {
dataField = dataField + ", " + "b" + Integer.toString(i) + " smallint";
}
String sql =
"create table "
+ tablename
+ " (time timestamp without time zone, packetid serial"
+ dataField;
sql += ", primary key (packetid) );";
try {
query.executeUpdate(sql);
} catch (SQLException e) {
System.out.println("SQL Exception: " + e);
System.exit(1);
}
System.out.println("Initialise Table Successfully");
}
static void logPacket(byte[] packet) {
Date date = new Date();
Timestamp ts = new Timestamp(date.getTime());
String dataField = "time";
String dataValue = "'" + ts + "'";
int[] intPacket = new int[packet.length];
for (int i = 0; i < packet.length; i++) {
if (packet[i] < 0) intPacket[i] = (int) packet[i] + 256;
else intPacket[i] = (int) packet[i];
}
for (int i = 0; i < intPacket.length; i++) {
dataField += ", " + "b" + Integer.toString(i);
dataValue += ", '" + intPacket[i] + "'";
}
String queryString = "insert into " + tablename + " (" + dataField + ") VALUES ( ";
queryString += dataValue + ");";
try {
query.executeUpdate(queryString);
} catch (SQLException e) {
System.out.println("Query no good; " + e.getErrorCode() + "; " + queryString);
}
}