/** * Execute an insert statement * * @param query */ public long insert(String query) { if (PreciousStones.getInstance().getSettingsManager().isDebugsql()) { PreciousStones.getLog().info(query); } try { Statement statement = getConnection().createStatement(); ResultSet keys = null; try { statement.executeUpdate(query); keys = statement.executeQuery("SELECT last_insert_rowid()"); } finally { if (keys != null) { if (keys.next()) { return keys.getLong(1); } } statement.close(); return 0; } } catch (SQLException ex) { if (!ex.toString().contains("not return ResultSet")) { log.severe("Error at SQL INSERT Query: " + ex); log.severe("Query: " + query); } } return 0; }
/** * Execute a statement * * @param query * @return */ public Boolean execute(String query) { if (PreciousStones.getInstance().getSettingsManager().isDebugsql()) { PreciousStones.getLog().info(query); } try { Statement statement = getConnection().createStatement(); Boolean result = false; try { result = statement.execute(query); } finally { statement.close(); return result; } } catch (SQLException ex) { log.severe(ex.getMessage()); log.severe("Query: " + query); return false; } }
/** * Execute a delete statement * * @param query */ public void delete(String query) { if (PreciousStones.getInstance().getSettingsManager().isDebugsql()) { PreciousStones.getLog().info(query); } try { Statement statement = getConnection().createStatement(); try { statement.executeQuery(query); } finally { statement.close(); } } catch (SQLException ex) { if (!ex.toString().contains("not return ResultSet")) { log.severe("Error at SQL DELETE Query: " + ex); log.severe("Query: " + query); } } }
/** * @param log * @param dbName * @param dbLocation */ public SQLiteCore(String dbName, String dbLocation) { this.dbName = dbName; this.dbLocation = dbLocation; this.log = PreciousStones.getLog(); }