private void update(Path p, Controller.Importance i) throws Exception {
PreparedStatement _pstmt =
connect.prepareStatement(
"UPDATE hashwerte SET Hashwert = '"
+ Hashfunction.getSHA1Checksum(p.toString())
+ "', Datum = Date('now'), Uhrzeit = Time('now'), Importance = '"
+ i
+ "' WHERE File = '"
+ p
+ "';");
_pstmt.executeUpdate();
_pstmt.close();
}
private void insertInto(Path p, Controller.Importance i) throws Exception {
PreparedStatement _pstmt =
connect.prepareStatement(
"INSERT INTO hashwerte VALUES('"
+ p
+ "', '"
+ Hashfunction.getSHA1Checksum(p.toString())
+ "', Date('now'), Time('now'), '"
+ importance
+ "')");
_pstmt.executeUpdate();
_pstmt.close();
}