/**
* 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();
}
