/** * 绑定参数 Author: hyl Time: 2015-8-17上午10:42:43 * * @param statement * @param position * @param args */ private void bindArgs(SQLiteStatement statement, int position, Object args) { int type = FieldTypeManager.getValueType(args); switch (type) { case FieldTypeManager.VALUE_TYPE_NULL: statement.bindNull(position); break; case FieldTypeManager.BASE_TYPE_BYTE_ARRAY: statement.bindBlob(position, (byte[]) args); break; case FieldTypeManager.BASE_TYPE_CHAR: case FieldTypeManager.BASE_TYPE_STRING: statement.bindString(position, args.toString()); break; case FieldTypeManager.BASE_TYPE_DATE: statement.bindString(position, DateUtil.formatDatetime((Date) args)); break; case FieldTypeManager.BASE_TYPE_DOUBLE: case FieldTypeManager.BASE_TYPE_FLOAT: statement.bindDouble(position, Double.parseDouble(args.toString())); break; case FieldTypeManager.BASE_TYPE_INT: case FieldTypeManager.BASE_TYPE_LONG: case FieldTypeManager.BASE_TYPE_SHORT: statement.bindLong(position, Long.parseLong(args.toString())); break; case FieldTypeManager.NOT_BASE_TYPE: throw new IllegalArgumentException("未知参数类型,请检查绑定参数"); } }
/** @inheritdoc */ @Override protected void bindValues(SQLiteStatement stmt, DBCover entity) { stmt.clearBindings(); Long id = entity.getId(); if (id != null) { stmt.bindLong(1, id); } String urlSmall = entity.getUrlSmall(); if (urlSmall != null) { stmt.bindString(2, urlSmall); } Integer height = entity.getHeight(); if (height != null) { stmt.bindLong(3, height); } String url = entity.getUrl(); if (url != null) { stmt.bindString(4, url); } Integer width = entity.getWidth(); if (width != null) { stmt.bindLong(5, width); } }
/** @inheritdoc */ @Override protected void bindValues(SQLiteStatement stmt, Place entity) { stmt.clearBindings(); Long id = entity.getId(); if (id != null) { stmt.bindLong(1, id); } String label = entity.getLabel(); if (label != null) { stmt.bindString(2, label); } String name = entity.getName(); if (name != null) { stmt.bindString(3, name); } String pinyin = entity.getPinyin(); if (pinyin != null) { stmt.bindString(4, pinyin); } String province = entity.getProvince(); if (province != null) { stmt.bindString(5, province); } }
/** * Called by the ManageLocations screen to update a location in the database * * @param id * @param locationName * @param coordinates * @param description * @return */ public boolean updateLocationData( int id, String locationName, String coordinates, String description) { boolean success = false; SQLiteDatabase db = getReadableDatabase(); String sql = "UPDATE locations SET locationName = ?, coordinates = ?, description = ? where _id = ?"; SQLiteStatement sqlStatement = db.compileStatement(sql); sqlStatement.bindString(1, locationName); sqlStatement.bindString(2, coordinates); sqlStatement.bindString(3, description); sqlStatement.bindLong(4, id); db.beginTransaction(); try { sqlStatement.execute(); db.setTransactionSuccessful(); success = true; } catch (SQLException ex) { ex.printStackTrace(); } finally { db.endTransaction(); sqlStatement.close(); db.close(); } return success; }
/** * Adds or updates room. * * @param account * @param room * @param nickname * @param password * @param join */ void write(String account, String room, String nickname, String password, boolean join) { synchronized (writeLock) { if (writeStatement == null) { SQLiteDatabase db = databaseManager.getWritableDatabase(); writeStatement = db.compileStatement( "INSERT OR REPLACE INTO " + NAME + " (" + Fields.ACCOUNT + ", " + Fields.ROOM + ", " + Fields.NICKNAME + ", " + Fields.PASSWORD + ", " + Fields.NEED_JOIN + ") VALUES (?, ?, ?, ?, ?);"); } writeStatement.bindString(1, account); writeStatement.bindString(2, room); writeStatement.bindString(3, nickname); writeStatement.bindString(4, password); writeStatement.bindLong(5, join ? 1 : 0); writeStatement.execute(); } }
@MediumTest public void testSimpleQuery() throws Exception { mDatabase.execSQL("CREATE TABLE test (num INTEGER NOT NULL, str TEXT NOT NULL);"); mDatabase.execSQL("INSERT INTO test VALUES (1234, 'hello');"); SQLiteStatement statement1 = mDatabase.compileStatement("SELECT num FROM test WHERE str = ?"); SQLiteStatement statement2 = mDatabase.compileStatement("SELECT str FROM test WHERE num = ?"); try { statement1.bindString(1, "hello"); long value = statement1.simpleQueryForLong(); assertEquals(1234, value); statement1.bindString(1, "world"); statement1.simpleQueryForLong(); fail("shouldn't get here"); } catch (SQLiteDoneException e) { // expected } try { statement2.bindLong(1, 1234); String value = statement1.simpleQueryForString(); assertEquals("hello", value); statement2.bindLong(1, 5678); statement1.simpleQueryForString(); fail("shouldn't get here"); } catch (SQLiteDoneException e) { // expected } statement1.close(); statement2.close(); }
/** update the level and count for the given flashcard in the database. */ private void updateFlashcard(Flashcard fc) { openDB(); _curDB.beginTransaction(); try { // Delete old entry if any. SQLiteStatement dStmt = getCompiledStatement(SQL_DELETE_FCS); dStmt.bindString(1, fc.getLang1Str()); dStmt.execute(); // insert new state entry. SQLiteStatement iStmt = getCompiledStatement(SQL_INSERT_FCS); iStmt.bindString(1, fc.getLang1Str()); iStmt.bindLong(2, fc.getLevel()); iStmt.bindLong(3, fc.getRightGuessCount()); iStmt.execute(); _curDB.setTransactionSuccessful(); } catch (SQLException e) { MsgDispatcher.sendMessageToUI( MsgType.MSG_SHOW_ERROR_MSG, 0, 0, "unable to update id=" + fc.getID()); } finally { _curDB.endTransaction(); } // this flashcard is no longer used by anyone so release it. fc.release(); }
public void addTerms(ArrayList<Terms> termList, User usr) { System.out.println("Terms StartUp : " + System.currentTimeMillis()); if (!isTermsAvailableForCompany(usr.getCompanyId())) { deleteTerms(); SQLiteDatabase db = this.getWritableDatabase(); try { db.beginTransaction(); SQLiteStatement statement = db.compileStatement(this.TERMS_QUERY); for (Terms terms : termList) { statement.bindString(1, terms.description); statement.bindLong(2, terms.languageId); statement.bindString(3, terms.term); statement.bindString(4, usr.getCompanyId()); statement.execute(); statement.clearBindings(); } db.setTransactionSuccessful(); } catch (Exception e) { // TODO: handle exception } finally { db.endTransaction(); db.close(); } } System.out.println("Terms End : " + System.currentTimeMillis()); }
@Override public void onCreate(SQLiteDatabase db) { db.beginTransaction(); try { SQLiteStatement stmt; db.execSQL("create table capitals (prefecture text primary key, capital text not null);"); stmt = db.compileStatement("insert into capitals values (?, ?);"); for (String[] capital : CAPITALS) { stmt.bindString(1, capital[0]); stmt.bindString(2, capital[1]); stmt.executeInsert(); } db.execSQL( "create table local_dishes (prefecture text not null, local_dish text not null);"); stmt = db.compileStatement("insert into local_dishes values (?, ?);"); for (String[] localDish : LOCAL_DISHES) { stmt.bindString(1, localDish[0]); stmt.bindString(2, localDish[1]); stmt.executeInsert(); } db.setTransactionSuccessful(); } finally { db.endTransaction(); } }
/** @inheritdoc */ @Override protected void bindValues(SQLiteStatement stmt, ThirdGameDownInfo entity) { stmt.clearBindings(); Long id = entity.getId(); if (id != null) { stmt.bindLong(1, id); } String gameURLId = entity.getGameURLId(); if (gameURLId != null) { stmt.bindString(2, gameURLId); } String url = entity.getUrl(); if (url != null) { stmt.bindString(3, url); } Integer downToken = entity.getDownToken(); if (downToken != null) { stmt.bindLong(4, downToken); } String remark = entity.getRemark(); if (remark != null) { stmt.bindString(5, remark); } String logoUrl = entity.getLogoUrl(); if (logoUrl != null) { stmt.bindString(6, logoUrl); } stmt.bindString(7, entity.getGameId()); }
/** @inheritdoc */ @Override protected void bindValues(SQLiteStatement stmt, NoticeBean entity) { stmt.clearBindings(); Long id = entity.getId(); if (id != null) { stmt.bindLong(1, id); } String noticeTitle = entity.getNoticeTitle(); if (noticeTitle != null) { stmt.bindString(2, noticeTitle); } String noticeContent = entity.getNoticeContent(); if (noticeContent != null) { stmt.bindString(3, noticeContent); } String noticeTime = entity.getNoticeTime(); if (noticeTime != null) { stmt.bindString(4, noticeTime); } String noticePublisher = entity.getNoticePublisher(); if (noticePublisher != null) { stmt.bindString(5, noticePublisher); } }
/** @inheritdoc */ @Override protected void bindValues(SQLiteStatement stmt, MunkaKep entity) { stmt.clearBindings(); Long munkaKepID = entity.getMunkaKepID(); if (munkaKepID != null) { stmt.bindLong(1, munkaKepID); } String munkaKepPath = entity.getMunkaKepPath(); if (munkaKepPath != null) { stmt.bindString(2, munkaKepPath); } String munkaKepDate = entity.getMunkaKepDate(); if (munkaKepDate != null) { stmt.bindString(3, munkaKepDate); } Boolean munkaKepIsUploaded = entity.getMunkaKepIsUploaded(); if (munkaKepIsUploaded != null) { stmt.bindLong(4, munkaKepIsUploaded ? 1l : 0l); } Boolean munkaKepIsActive = entity.getMunkaKepIsActive(); if (munkaKepIsActive != null) { stmt.bindLong(5, munkaKepIsActive ? 1l : 0l); } Long munkaID = entity.getMunkaID(); if (munkaID != null) { stmt.bindLong(6, munkaID); } }
private long getTagId(Tag tag) { if (myGetTagIdStatement == null) { myGetTagIdStatement = myDatabase.compileStatement("SELECT tag_id FROM Tags WHERE parent_id = ? AND name = ?"); myCreateTagIdStatement = myDatabase.compileStatement("INSERT OR IGNORE INTO Tags (parent_id,name) VALUES (?,?)"); } { final Long id = myIdByTag.get(tag); if (id != null) { return id; } } if (tag.Parent != null) { myGetTagIdStatement.bindLong(1, getTagId(tag.Parent)); } else { myGetTagIdStatement.bindNull(1); } myGetTagIdStatement.bindString(2, tag.Name); long id; try { id = myGetTagIdStatement.simpleQueryForLong(); } catch (SQLException e) { if (tag.Parent != null) { myCreateTagIdStatement.bindLong(1, getTagId(tag.Parent)); } else { myCreateTagIdStatement.bindNull(1); } myCreateTagIdStatement.bindString(2, tag.Name); id = myCreateTagIdStatement.executeInsert(); } myIdByTag.put(tag, id); myTagById.put(id, tag); return id; }
protected void saveBookSeriesInfo(long bookId, SeriesInfo seriesInfo) { if (myGetSeriesIdStatement == null) { myGetSeriesIdStatement = myDatabase.compileStatement("SELECT series_id FROM Series WHERE name = ?"); myInsertSeriesStatement = myDatabase.compileStatement("INSERT OR IGNORE INTO Series (name) VALUES (?)"); myInsertBookSeriesStatement = myDatabase.compileStatement( "INSERT OR REPLACE INTO BookSeries (book_id,series_id,book_index) VALUES (?,?,?)"); myDeleteBookSeriesStatement = myDatabase.compileStatement("DELETE FROM BookSeries WHERE book_id = ?"); } if (seriesInfo == null) { myDeleteBookSeriesStatement.bindLong(1, bookId); myDeleteBookSeriesStatement.execute(); } else { long seriesId; try { myGetSeriesIdStatement.bindString(1, seriesInfo.Name); seriesId = myGetSeriesIdStatement.simpleQueryForLong(); } catch (SQLException e) { myInsertSeriesStatement.bindString(1, seriesInfo.Name); seriesId = myInsertSeriesStatement.executeInsert(); } myInsertBookSeriesStatement.bindLong(1, bookId); myInsertBookSeriesStatement.bindLong(2, seriesId); SQLiteUtil.bindString( myInsertBookSeriesStatement, 3, seriesInfo.Index != null ? seriesInfo.Index.toString() : null); myInsertBookSeriesStatement.execute(); } }
protected void saveBookAuthorInfo(long bookId, long index, Author author) { if (myGetAuthorIdStatement == null) { myGetAuthorIdStatement = myDatabase.compileStatement( "SELECT author_id FROM Authors WHERE name = ? AND sort_key = ?"); myInsertAuthorStatement = myDatabase.compileStatement("INSERT OR IGNORE INTO Authors (name,sort_key) VALUES (?,?)"); myInsertBookAuthorStatement = myDatabase.compileStatement( "INSERT OR REPLACE INTO BookAuthor (book_id,author_id,author_index) VALUES (?,?,?)"); } long authorId; try { myGetAuthorIdStatement.bindString(1, author.DisplayName); myGetAuthorIdStatement.bindString(2, author.SortKey); authorId = myGetAuthorIdStatement.simpleQueryForLong(); } catch (SQLException e) { myInsertAuthorStatement.bindString(1, author.DisplayName); myInsertAuthorStatement.bindString(2, author.SortKey); authorId = myInsertAuthorStatement.executeInsert(); } myInsertBookAuthorStatement.bindLong(1, bookId); myInsertBookAuthorStatement.bindLong(2, authorId); myInsertBookAuthorStatement.bindLong(3, index); myInsertBookAuthorStatement.execute(); }
protected void bindValues(SQLiteStatement sqlitestatement, FoodLocale foodlocale) { long l1 = 1L; sqlitestatement.clearBindings(); Object obj = foodlocale.getId(); if (obj != null) { sqlitestatement.bindLong(1, ((Long) (obj)).longValue()); } obj = foodlocale.getValue(); if (obj != null) { sqlitestatement.bindString(2, ((String) (obj))); } obj = foodlocale.getLabel(); if (obj != null) { sqlitestatement.bindString(3, ((String) (obj))); } obj = foodlocale.getSupportsLookupByBarCode(); long l; if (obj != null) { if (((Boolean) (obj)).booleanValue()) { l = 1L; } else { l = 0L; } sqlitestatement.bindLong(4, l); } foodlocale = foodlocale.getImageUpload(); if (foodlocale != null) { if (foodlocale.booleanValue()) { l = l1; } else { l = 0L; } sqlitestatement.bindLong(5, l); } }
public long save(int id_sesion, int id_moderador) { // TODO Auto-generated method stub insertStatement.clearBindings(); insertStatement.bindString(1, String.valueOf(id_sesion)); insertStatement.bindString(2, String.valueOf(id_moderador)); return insertStatement.executeInsert(); }
/** @inheritdoc */ @Override protected void bindValues(SQLiteStatement stmt, TokensBD entity) { stmt.clearBindings(); Long id = entity.getId(); if (id != null) { stmt.bindLong(1, id); } Long expiresIn = entity.getExpiresIn(); if (expiresIn != null) { stmt.bindLong(2, expiresIn); } Long expiresAt = entity.getExpiresAt(); if (expiresAt != null) { stmt.bindLong(3, expiresAt); } String tokenType = entity.getTokenType(); if (tokenType != null) { stmt.bindString(4, tokenType); } String refreshToken = entity.getRefreshToken(); if (refreshToken != null) { stmt.bindString(5, refreshToken); } String accessToken = entity.getAccessToken(); if (accessToken != null) { stmt.bindString(6, accessToken); } }
/** @inheritdoc */ @Override protected void bindValues(SQLiteStatement stmt, Person entity) { stmt.clearBindings(); Long id = entity.getId(); if (id != null) { stmt.bindLong(1, id); } stmt.bindString(2, entity.getName()); Integer age = entity.getAge(); if (age != null) { stmt.bindLong(3, age); } Integer height = entity.getHeight(); if (height != null) { stmt.bindLong(4, height); } String introduction = entity.getIntroduction(); if (introduction != null) { stmt.bindString(5, introduction); } }
/** @inheritdoc */ @Override protected void bindValues(SQLiteStatement stmt, Comment entity) { stmt.clearBindings(); Long id = entity.getId(); if (id != null) { stmt.bindLong(1, id); } String content = entity.getContent(); if (content != null) { stmt.bindString(2, content); } String userId = entity.getUserId(); if (userId != null) { stmt.bindString(3, userId); } String postId = entity.getPostId(); if (postId != null) { stmt.bindString(4, postId); } Long idCatPost = entity.getIdCatPost(); if (idCatPost != null) { stmt.bindLong(5, idCatPost); } }
/** * Called by ManageLocations screen to add a location to the database * * @param locationName * @param coordinates * @param description * @return */ public boolean addLocationData(String locationName, String coordinates, String description) { boolean success = false; SQLiteDatabase db = getReadableDatabase(); SQLiteStatement sqlStatement = db.compileStatement( "INSERT INTO locations (locationName, coordinates, description) VALUES (?, ?, ?)"); sqlStatement.bindString(1, locationName); sqlStatement.bindString(2, coordinates); sqlStatement.bindString(3, description); db.beginTransaction(); try { sqlStatement.execute(); db.setTransactionSuccessful(); success = true; } catch (SQLException ex) { ex.printStackTrace(); } finally { db.endTransaction(); sqlStatement.close(); db.close(); } return success; }
/** @inheritdoc */ @Override protected void bindValues(SQLiteStatement stmt, Trip entity) { stmt.clearBindings(); String id = entity.getId(); if (id != null) { stmt.bindString(1, id); } stmt.bindString(2, entity.getRouteId()); }
/** @inheritdoc */ @Override protected void bindValues(SQLiteStatement stmt, Channel entity) { stmt.clearBindings(); Long id = entity.getId(); if (id != null) { stmt.bindLong(1, id); } stmt.bindString(2, entity.getTitle()); stmt.bindString(3, entity.getURL()); }
/** @inheritdoc */ @Override protected void bindValues(SQLiteStatement stmt, DbGroupUserMappingVo entity) { stmt.clearBindings(); Long id = entity.getId(); if (id != null) { stmt.bindLong(1, id); } stmt.bindLong(2, entity.getGroupId()); stmt.bindString(3, entity.getUserId()); stmt.bindString(4, entity.getAuth()); }
/** @inheritdoc */ @Override protected void bindValues(SQLiteStatement stmt, Category entity) { stmt.clearBindings(); Long id = entity.getId(); if (id != null) { stmt.bindLong(1, id); } stmt.bindString(2, entity.getTitle()); stmt.bindString(3, entity.getDescription()); stmt.bindString(4, entity.getImage()); }
private void insertDeletedPerson(Cursor c, SQLiteStatement insert) { String account = c.getString(DeletedPeopleQuery._SYNC_ACCOUNT); if (account == null) { return; } insert.bindString(DeletedRawContactInsert.ACCOUNT_NAME, account); insert.bindString(DeletedRawContactInsert.ACCOUNT_TYPE, DEFAULT_ACCOUNT_TYPE); insert.bindString(DeletedRawContactInsert.SOURCE_ID, c.getString(DeletedPeopleQuery._SYNC_ID)); insert.bindLong(DeletedRawContactInsert.DELETED, 1); insert.bindLong( DeletedRawContactInsert.AGGREGATION_MODE, RawContacts.AGGREGATION_MODE_DISABLED); insert(insert); }
/** @inheritdoc */ @Override protected void bindValues(SQLiteStatement stmt, Incidente entity) { stmt.clearBindings(); Long id = entity.getId(); if (id != null) { stmt.bindLong(1, id); } String idServidor = entity.getIdServidor(); if (idServidor != null) { stmt.bindString(2, idServidor); } stmt.bindString(3, entity.getTitulo()); String descripcion = entity.getDescripcion(); if (descripcion != null) { stmt.bindString(4, descripcion); } Integer zona = entity.getZona(); if (zona != null) { stmt.bindLong(5, zona); } Integer gravedad = entity.getGravedad(); if (gravedad != null) { stmt.bindLong(6, gravedad); } Double latitud = entity.getLatitud(); if (latitud != null) { stmt.bindDouble(7, latitud); } Double longitud = entity.getLongitud(); if (longitud != null) { stmt.bindDouble(8, longitud); } java.util.Date fechaCreacion = entity.getFechaCreacion(); if (fechaCreacion != null) { stmt.bindLong(9, fechaCreacion.getTime()); } String usuarioCreacion = entity.getUsuarioCreacion(); if (usuarioCreacion != null) { stmt.bindString(10, usuarioCreacion); } }
/** @inheritdoc */ @Override protected void bindValues(SQLiteStatement stmt, VedioDownload entity) { stmt.clearBindings(); Long id = entity.getId(); if (id != null) { stmt.bindLong(1, id); } String vedioid = entity.getVedioid(); if (vedioid != null) { stmt.bindString(2, vedioid); } String vedioName = entity.getVedioName(); if (vedioName != null) { stmt.bindString(3, vedioName); } String VUri = entity.getVUri(); if (VUri != null) { stmt.bindString(4, VUri); } String projId = entity.getProjId(); if (projId != null) { stmt.bindString(5, projId); } String instruction = entity.getInstruction(); if (instruction != null) { stmt.bindString(6, instruction); } String author = entity.getAuthor(); if (author != null) { stmt.bindString(7, author); } String pubDate = entity.getPubDate(); if (pubDate != null) { stmt.bindString(8, pubDate); } String VPickUri = entity.getVPickUri(); if (VPickUri != null) { stmt.bindString(9, VPickUri); } String flag = entity.getFlag(); if (flag != null) { stmt.bindString(10, flag); } }
private boolean insertCity( long id, @NonNull String name, @NonNull String country, double latitude, double longitude) { insertStatement.bindLong(1, id); insertStatement.bindString(2, name); insertStatement.bindString(3, country); insertStatement.bindDouble(4, latitude); insertStatement.bindDouble(5, longitude); long rowId = insertStatement.executeInsert(); if (rowId < 0) { Log.w(LOG_TAG, "Failed to insert city: id=" + id + " name=" + name); return false; } return true; }
public long save(InstalledRecord entity) { insertStatement.clearBindings(); // nov21 // Log.i("installedread","save installed"); insertStatement.bindString(1, entity.getPkgName()); insertStatement.bindString(2, entity.getAppName()); insertStatement.bindString(3, entity.getDate()); insertStatement.bindLong(4, entity.getMiliSeconds()); insertStatement.bindString(5, String.valueOf(entity.getLogitude())); insertStatement.bindString(6, String.valueOf(entity.getLatitude())); // insertStatement.bindDouble(5, entity.getLogitude()); // insertStatement.bindDouble(6, entity.getLatitude()); insertStatement.bindLong(7, entity.getNumber()); return insertStatement.executeInsert(); }