public MetadataBlob[] select(String selectString) { PreparedStatement stmt = null; try { stmt = conn.prepareStatement( "select writingKey, mapkey, blobdata from metadatablobs " + selectString + ";"); ResultSet rs = stmt.executeQuery(); List<MetadataBlob> list = new ArrayList<MetadataBlob>(); while (rs.next()) { MetadataBlob f = new MetadataBlob( rs.getString("writingkey"), rs.getString("mapkey"), rs.getString("blobdata")); list.add(f); } return list.toArray(new MetadataBlob[0]); } catch (SQLException sqe) { System.err.println("Error selecting: " + selectString); sqe.printStackTrace(); return null; } finally { if (stmt != null) try { stmt.close(); } catch (SQLException sqe2) { sqe2.printStackTrace(); } } }
public boolean delete(String table, String deleteString) { Statement stmt = null; try { stmt = conn.createStatement(); stmt.executeUpdate("delete from " + table + " where " + deleteString + ";"); return true; } catch (SQLException sqe) { sqe.printStackTrace(); return false; } finally { if (stmt != null) try { stmt.close(); } catch (SQLException sqe2) { sqe2.printStackTrace(); } } }
public boolean delete() { Statement stmt = null; try { stmt = conn.createStatement(); stmt.executeUpdate(deleteStatement()); return true; } catch (SQLException sqe) { System.err.println(deleteStatement()); sqe.printStackTrace(); return false; } finally { if (stmt != null) try { stmt.close(); } catch (SQLException sqe2) { sqe2.printStackTrace(); } } }
public boolean insert() { PreparedStatement stmt = null; try { stmt = conn.prepareStatement(insertStatement()); stmt.setString(1, this.name); stmt.setString(2, this.b64string); stmt.executeUpdate(); return true; } catch (SQLException sqe) { sqe.printStackTrace(); return false; } finally { if (stmt != null) try { stmt.close(); } catch (SQLException sqe2) { sqe2.printStackTrace(); } } }
public boolean delete() { PreparedStatement stmt = null; try { stmt = conn.prepareStatement("DELETE from metadatablobs where writingkey=? AND mapkey=?"); stmt.setString(1, this.b64WritingKey); stmt.setString(2, this.b64mapkey); stmt.executeUpdate(); return true; } catch (SQLException sqe) { sqe.printStackTrace(); return false; } finally { if (stmt != null) try { stmt.close(); } catch (SQLException sqe2) { sqe2.printStackTrace(); } } }
public boolean insert() { PreparedStatement stmt = null; try { stmt = conn.prepareStatement( "INSERT OR REPLACE INTO staticdata (name, staticdata) VALUES(?, ?)"); stmt.setString(1, this.name); stmt.setString(2, this.b64string); stmt.executeUpdate(); return true; } catch (SQLException sqe) { sqe.printStackTrace(); return false; } finally { if (stmt != null) try { stmt.close(); } catch (SQLException sqe2) { sqe2.printStackTrace(); } } }
public RowData[] select() { PreparedStatement stmt = null; try { stmt = conn.prepareStatement(selectStatement()); ResultSet rs = stmt.executeQuery(); List<RowData> list = new ArrayList<>(); while (rs.next()) { String username = rs.getString("name"); String b64string = rs.getString(b64DataName()); list.add(new UserData(username, b64string)); } return list.toArray(new RowData[0]); } catch (SQLException sqe) { sqe.printStackTrace(); return null; } finally { if (stmt != null) try { stmt.close(); } catch (SQLException sqe2) { sqe2.printStackTrace(); } } }
public boolean insert() { PreparedStatement stmt = null; try { stmt = conn.prepareStatement( "INSERT OR REPLACE INTO metadatablobs (writingkey, mapkey, blobdata) VALUES(?, ?, ?)"); stmt.setString(1, this.b64WritingKey); stmt.setString(2, this.b64mapkey); stmt.setString(3, this.b64blobdata); stmt.executeUpdate(); return true; } catch (SQLException sqe) { sqe.printStackTrace(); return false; } finally { if (stmt != null) try { stmt.close(); } catch (SQLException sqe2) { sqe2.printStackTrace(); } } }