@Override public void bindAllArgsAsStrings(String[] bindArgs) { statement.bindAllArgsAsStrings(bindArgs); }
public void bindAllArgsAsStrings(String[] bindArgs) { statement.bindAllArgsAsStrings(bindArgs); }
public int delete() { int[] ids = new int[] {1,2,3,4,6,7,8,9,10}; String[] args = new String[ids.length]; StringBuilder query = new StringBuilder(); query.append("delete from table where column_id not in ("); SQLiteStatement stmt = null; for (int i = 0; i < ids.length; i++) { args[i] = String.valueOf(ids[i]); query.append("?"); if (i < ids.length - 1) { query.append(","); } } query.append(")"); stmt = db.compileStatement(query.toString()); stmt.bindAllArgsAsStrings(args); return stmt.executeUpdateDelete(); }
public void log(String url, String req, String resp) { SQLiteDatabase db = null; SQLiteStatement statement; long timestamp; try { db = getWritableDatabase(); db.beginTransaction(); statement = db.compileStatement("INSERT INTO ".concat(packetlog_table_name).concat(" (timestamp, url, type, data) values (?, ?, ?, ?)")); timestamp = System.currentTimeMillis(); statement.bindAllArgsAsStrings(new String[]{String.valueOf(timestamp), url, REQUEST, req}); statement.execute(); timestamp = System.currentTimeMillis(); statement.bindAllArgsAsStrings(new String[]{String.valueOf(timestamp), url, RESPONSE, resp}); statement.execute(); statement.close(); db.setTransactionSuccessful(); } catch (RuntimeException e) { e.printStackTrace(); } finally { if (db != null) { db.endTransaction(); } } }
protected int insert(String query, String[] parameter) throws SQLiteConstraintException, SQLiteException { int rowCount = -1; SQLiteStatement statement = mSqldb.compileStatement(query); mSqldb.beginTransaction(); try { statement.bindAllArgsAsStrings(parameter); statement.execute(); statement.clearBindings(); rowCount = parameter.length; } finally { mSqldb.setTransactionSuccessful(); mSqldb.endTransaction(); } return rowCount; }
stmt.bindAllArgsAsStrings(colums); stmt.execute();
/** * insert the bulk data into database * * @param query to insert data into table * @param parameter data to be inserted into table * @return number of rows got inserted */ protected int insertBulk(String query, String[][] parameter) throws SQLiteConstraintException, SQLiteException { int rowCount = -1; SQLiteStatement statement = mSqldb.compileStatement(query); mSqldb.beginTransaction(); try { for (int index = 0; index < parameter.length; index++) { statement.bindAllArgsAsStrings(parameter[index]); statement.execute(); statement.clearBindings(); } rowCount = parameter.length; } finally { mSqldb.setTransactionSuccessful(); mSqldb.endTransaction(); } return rowCount; }