Java Code Examples for android.database.sqlite.SQLiteStatement#bindString()

The following examples show how to use android.database.sqlite.SQLiteStatement#bindString() . These examples are extracted from open source projects. You can vote up the ones you like or vote down the ones you don't like, and go to the original project or source file by following the links above each example. You may check out the related API usage on the sidebar.

Example 1

Source Project: ClassSchedule File: CourseGroupDao.java License: Apache License 2.0

7 votes

@Override
protected final void bindValues(SQLiteStatement stmt, CourseGroup entity) {
    stmt.clearBindings();
 
    Long cgId = entity.getCgId();
    if (cgId != null) {
        stmt.bindLong(1, cgId);
    }
 
    String cgName = entity.getCgName();
    if (cgName != null) {
        stmt.bindString(2, cgName);
    }
 
    String cgSchool = entity.getCgSchool();
    if (cgSchool != null) {
        stmt.bindString(3, cgSchool);
    }
}

Example 2

Source Project: ml-authentication File: LetterDao.java License: Apache License 2.0

6 votes

@Override
protected final void bindValues(SQLiteStatement stmt, Letter entity) {
    stmt.clearBindings();
 
    Long id = entity.getId();
    if (id != null) {
        stmt.bindLong(1, id);
    }
    stmt.bindString(2, localeConverter.convertToDatabaseValue(entity.getLocale()));
 
    Calendar timeLastUpdate = entity.getTimeLastUpdate();
    if (timeLastUpdate != null) {
        stmt.bindLong(3, timeLastUpdateConverter.convertToDatabaseValue(timeLastUpdate));
    }
    stmt.bindLong(4, entity.getRevisionNumber());
    stmt.bindString(5, contentStatusConverter.convertToDatabaseValue(entity.getContentStatus()));
    stmt.bindString(6, entity.getText());
    stmt.bindLong(7, entity.getUsageCount());
}

Example 3

Source Project: CoolChat File: GroupUsersDao.java License: Apache License 2.0

6 votes

@Override
protected final void bindValues(SQLiteStatement stmt, GroupUsers entity) {
    stmt.clearBindings();
 
    Long id = entity.getId();
    if (id != null) {
        stmt.bindLong(1, id);
    }
    stmt.bindLong(2, entity.getUserId());
 
    String userName = entity.getUserName();
    if (userName != null) {
        stmt.bindString(3, userName);
    }
 
    String userAvatar = entity.getUserAvatar();
    if (userAvatar != null) {
        stmt.bindString(4, userAvatar);
    }
 
    String userSex = entity.getUserSex();
    if (userSex != null) {
        stmt.bindString(5, userSex);
    }
}

Example 4

Source Project: JianDan_OkHttp File: FreshNewsCacheDao.java License: Apache License 2.0

6 votes

/** @inheritdoc */
@Override
protected void bindValues(SQLiteStatement stmt, FreshNewsCache entity) {
    stmt.clearBindings();
 
    Long id = entity.getId();
    if (id != null) {
        stmt.bindLong(1, id);
    }
 
    String result = entity.getResult();
    if (result != null) {
        stmt.bindString(2, result);
    }
 
    Integer page = entity.getPage();
    if (page != null) {
        stmt.bindLong(3, page);
    }
 
    Long time = entity.getTime();
    if (time != null) {
        stmt.bindLong(4, time);
    }
}

Example 5

Source Project: MeiZiNews File: CollectEntityDao.java License: MIT License

6 votes

/** @inheritdoc */
@Override
protected void bindValues(SQLiteStatement stmt, CollectEntity entity) {
    stmt.clearBindings();
 
    Long id = entity.getId();
    if (id != null) {
        stmt.bindLong(1, id);
    }
 
    Long html_id = entity.getHtml_id();
    if (html_id != null) {
        stmt.bindLong(2, html_id);
    }
 
    String collect = entity.getCollect();
    if (collect != null) {
        stmt.bindString(3, collect);
    }
}

Example 6

Source Project: ml-authentication File: StoryBookDao.java License: Apache License 2.0

6 votes

@Override
protected final void bindValues(SQLiteStatement stmt, StoryBook entity) {
    stmt.clearBindings();
 
    Long id = entity.getId();
    if (id != null) {
        stmt.bindLong(1, id);
    }
    stmt.bindString(2, localeConverter.convertToDatabaseValue(entity.getLocale()));
 
    Calendar timeLastUpdate = entity.getTimeLastUpdate();
    if (timeLastUpdate != null) {
        stmt.bindLong(3, timeLastUpdateConverter.convertToDatabaseValue(timeLastUpdate));
    }
    stmt.bindLong(4, entity.getRevisionNumber());
    stmt.bindString(5, contentStatusConverter.convertToDatabaseValue(entity.getContentStatus()));
    stmt.bindString(6, entity.getTitle());
    stmt.bindLong(7, entity.getCoverImageId());
    stmt.bindString(8, gradeLevelConverter.convertToDatabaseValue(entity.getGradeLevel()));
}

Example 7

Source Project: android-orm-benchmark-updated File: UserDao.java License: Apache License 2.0

6 votes

@Override
protected final void bindValues(SQLiteStatement stmt, User entity) {
    stmt.clearBindings();
 
    String last_name = entity.getLast_name();
    if (last_name != null) {
        stmt.bindString(1, last_name);
    }
 
    String first_name = entity.getFirst_name();
    if (first_name != null) {
        stmt.bindString(2, first_name);
    }
 
    Long id = entity.getId();
    if (id != null) {
        stmt.bindLong(3, id);
    }
}

Example 8

Source Project: ml-authentication File: WordDao.java License: Apache License 2.0

6 votes

@Override
protected final void bindValues(SQLiteStatement stmt, Word entity) {
    stmt.clearBindings();
 
    Long id = entity.getId();
    if (id != null) {
        stmt.bindLong(1, id);
    }
    stmt.bindString(2, localeConverter.convertToDatabaseValue(entity.getLocale()));
 
    Calendar timeLastUpdate = entity.getTimeLastUpdate();
    if (timeLastUpdate != null) {
        stmt.bindLong(3, timeLastUpdateConverter.convertToDatabaseValue(timeLastUpdate));
    }
    stmt.bindLong(4, entity.getRevisionNumber());
    stmt.bindString(5, contentStatusConverter.convertToDatabaseValue(entity.getContentStatus()));
    stmt.bindString(6, entity.getText());
    stmt.bindString(7, entity.getPhonetics());
    stmt.bindLong(8, entity.getUsageCount());
 
    SpellingConsistency spellingConsistency = entity.getSpellingConsistency();
    if (spellingConsistency != null) {
        stmt.bindString(9, spellingConsistencyConverter.convertToDatabaseValue(spellingConsistency));
    }
}

Example 9

Source Project: sctalk File: MessageDao.java License: Apache License 2.0

6 votes

/** @inheritdoc */
@Override
protected void bindValues(SQLiteStatement stmt, MessageEntity entity) {
    stmt.clearBindings();
 
    Long id = entity.getId();
    if (id != null) {
        stmt.bindLong(1, id);
    }
    stmt.bindLong(2, entity.getMsgId());
    stmt.bindLong(3, entity.getFromId());
    stmt.bindLong(4, entity.getToId());
    stmt.bindString(5, entity.getSessionKey());
    stmt.bindString(6, entity.getContent());
    stmt.bindLong(7, entity.getMsgType());
    stmt.bindLong(8, entity.getDisplayType());
    stmt.bindLong(9, entity.getStatus());
    stmt.bindLong(10, entity.getCreated());
    stmt.bindLong(11, entity.getUpdated());
}

Example 10

Source Project: RxJavaApp File: alloperatorsDao.java License: Apache License 2.0

6 votes

/** @inheritdoc */
@Override
protected void bindValues(SQLiteStatement stmt, alloperators entity) {
    stmt.clearBindings();
 
    Long id = entity.getId();
    if (id != null) {
        stmt.bindLong(1, id);
    }
    stmt.bindString(2, entity.getName());
    stmt.bindString(3, entity.getThread());
    stmt.bindString(4, entity.getDesc());
    stmt.bindString(5, entity.getImg());
    stmt.bindString(6, entity.getUrl());
 
    Long operators_id = entity.getOperators_id();
    if (operators_id != null) {
        stmt.bindLong(7, operators_id);
    }
}

Example 11

Source Project: JianDan File: JokeCacheDao.java License: Apache License 2.0

6 votes

/** @inheritdoc */
@Override
protected void bindValues(SQLiteStatement stmt, JokeCache entity) {
    stmt.clearBindings();
 
    Long id = entity.getId();
    if (id != null) {
        stmt.bindLong(1, id);
    }
 
    String result = entity.getResult();
    if (result != null) {
        stmt.bindString(2, result);
    }
 
    Integer page = entity.getPage();
    if (page != null) {
        stmt.bindLong(3, page);
    }
 
    Long time = entity.getTime();
    if (time != null) {
        stmt.bindLong(4, time);
    }
}

Example 12

Source Project: MyWeather File: UseAreaDao.java License: Apache License 2.0

6 votes

/** @inheritdoc */
@Override
protected void bindValues(SQLiteStatement stmt, UseArea entity) {
    stmt.clearBindings();
 
    String areaid = entity.getAreaid();
    if (areaid != null) {
        stmt.bindString(1, areaid);
    }
 
    String areaid2345 = entity.getAreaid2345();
    if (areaid2345 != null) {
        stmt.bindString(2, areaid2345);
    }
 
    String areaName = entity.getAreaName();
    if (areaName != null) {
        stmt.bindString(3, areaName);
    }
 
    Boolean main = entity.getMain();
    if (main != null) {
        stmt.bindLong(4, main ? 1L: 0L);
    }
}

Example 13

Source Project: FimiX8-RE File: MediaDownloadInfoDao.java License: MIT License

5 votes

public final void bindValues(SQLiteStatement stmt, MediaDownloadInfo entity) {
    stmt.clearBindings();
    Long id = entity.getId();
    if (id != null) {
        stmt.bindLong(1, id.longValue());
    }
    stmt.bindLong(2, entity.getStartPos());
    stmt.bindLong(3, entity.getEndPos());
    stmt.bindLong(4, entity.getCompeleteZize());
    String url = entity.getUrl();
    if (url != null) {
        stmt.bindString(5, url);
    }
}

Example 14

Source Project: HaoReader File: CookieBeanDao.java License: GNU General Public License v3.0

5 votes

@Override
protected final void bindValues(SQLiteStatement stmt, CookieBean entity) {
    stmt.clearBindings();
 
    String url = entity.getUrl();
    if (url != null) {
        stmt.bindString(1, url);
    }
 
    String cookie = entity.getCookie();
    if (cookie != null) {
        stmt.bindString(2, cookie);
    }
}

Example 15

Source Project: OpenHub File: TraceDao.java License: GNU General Public License v3.0

5 votes

@Override
protected final void bindValues(SQLiteStatement stmt, Trace entity) {
    stmt.clearBindings();
    stmt.bindString(1, entity.getId());
 
    String type = entity.getType();
    if (type != null) {
        stmt.bindString(2, type);
    }
 
    String userId = entity.getUserId();
    if (userId != null) {
        stmt.bindString(3, userId);
    }
 
    Long repoId = entity.getRepoId();
    if (repoId != null) {
        stmt.bindLong(4, repoId);
    }
 
    java.util.Date startTime = entity.getStartTime();
    if (startTime != null) {
        stmt.bindLong(5, startTime.getTime());
    }
 
    java.util.Date latestTime = entity.getLatestTime();
    if (latestTime != null) {
        stmt.bindLong(6, latestTime.getTime());
    }
 
    Integer traceNum = entity.getTraceNum();
    if (traceNum != null) {
        stmt.bindLong(7, traceNum);
    }
}

Example 16

Source Project: TLint File: ForumDao.java License: Apache License 2.0

4 votes

/**
 * @inheritdoc
 */
@Override
protected void bindValues(SQLiteStatement stmt, Forum entity) {
    stmt.clearBindings();

    Long id = entity.getId();
    if (id != null) {
        stmt.bindLong(1, id);
    }

    String fid = entity.getFid();
    if (fid != null) {
        stmt.bindString(2, fid);
    }

    String name = entity.getName();
    if (name != null) {
        stmt.bindString(3, name);
    }

    String logo = entity.getLogo();
    if (logo != null) {
        stmt.bindString(4, logo);
    }

    String description = entity.getDescription();
    if (description != null) {
        stmt.bindString(5, description);
    }

    String backImg = entity.getBackImg();
    if (backImg != null) {
        stmt.bindString(6, backImg);
    }

    String forumId = entity.getForumId();
    if (forumId != null) {
        stmt.bindString(7, forumId);
    }

    String categoryName = entity.getCategoryName();
    if (categoryName != null) {
        stmt.bindString(8, categoryName);
    }

    Integer weight = entity.getWeight();
    if (weight != null) {
        stmt.bindLong(9, weight);
    }
}

Example 17

Source Project: ml-authentication File: AllophoneDao.java License: Apache License 2.0

4 votes

@Override
protected final void bindValues(SQLiteStatement stmt, Allophone entity) {
    stmt.clearBindings();
 
    Long id = entity.getId();
    if (id != null) {
        stmt.bindLong(1, id);
    }
    stmt.bindString(2, localeConverter.convertToDatabaseValue(entity.getLocale()));
 
    Calendar timeLastUpdate = entity.getTimeLastUpdate();
    if (timeLastUpdate != null) {
        stmt.bindLong(3, timeLastUpdateConverter.convertToDatabaseValue(timeLastUpdate));
    }
    stmt.bindLong(4, entity.getRevisionNumber());
    stmt.bindString(5, contentStatusConverter.convertToDatabaseValue(entity.getContentStatus()));
    stmt.bindString(6, entity.getValueIpa());
    stmt.bindString(7, entity.getValueSampa());
    stmt.bindLong(8, entity.getDiacritic() ? 1L: 0L);
 
    SoundType soundType = entity.getSoundType();
    if (soundType != null) {
        stmt.bindString(9, soundTypeConverter.convertToDatabaseValue(soundType));
    }
 
    VowelLength vowelLength = entity.getVowelLength();
    if (vowelLength != null) {
        stmt.bindString(10, vowelLengthConverter.convertToDatabaseValue(vowelLength));
    }
 
    VowelHeight vowelHeight = entity.getVowelHeight();
    if (vowelHeight != null) {
        stmt.bindString(11, vowelHeightConverter.convertToDatabaseValue(vowelHeight));
    }
 
    VowelFrontness vowelFrontness = entity.getVowelFrontness();
    if (vowelFrontness != null) {
        stmt.bindString(12, vowelFrontnessConverter.convertToDatabaseValue(vowelFrontness));
    }
 
    LipRounding lipRounding = entity.getLipRounding();
    if (lipRounding != null) {
        stmt.bindString(13, lipRoundingConverter.convertToDatabaseValue(lipRounding));
    }
 
    ConsonantType consonantType = entity.getConsonantType();
    if (consonantType != null) {
        stmt.bindString(14, consonantTypeConverter.convertToDatabaseValue(consonantType));
    }
 
    ConsonantPlace consonantPlace = entity.getConsonantPlace();
    if (consonantPlace != null) {
        stmt.bindString(15, consonantPlaceConverter.convertToDatabaseValue(consonantPlace));
    }
 
    ConsonantVoicing consonantVoicing = entity.getConsonantVoicing();
    if (consonantVoicing != null) {
        stmt.bindString(16, consonantVoicingConverter.convertToDatabaseValue(consonantVoicing));
    }
    stmt.bindLong(17, entity.getUsageCount());
}

Example 18

Source Project: FoodOrdering File: RealWeatherDao.java License: Apache License 2.0

4 votes

/** @inheritdoc */
@Override
protected void bindValues(SQLiteStatement stmt, RealWeather entity) {
    stmt.clearBindings();
 
    String areaid = entity.getAreaid();
    if (areaid != null) {
        stmt.bindString(1, areaid);
    }
 
    String areaName = entity.getAreaName();
    if (areaName != null) {
        stmt.bindString(2, areaName);
    }
 
    String weatherCondition = entity.getWeatherCondition();
    if (weatherCondition != null) {
        stmt.bindString(3, weatherCondition);
    }
 
    String fx = entity.getFx();
    if (fx != null) {
        stmt.bindString(4, fx);
    }
 
    String fj = entity.getFj();
    if (fj != null) {
        stmt.bindString(5, fj);
    }
 
    Integer temp = entity.getTemp();
    if (temp != null) {
        stmt.bindLong(6, temp);
    }
 
    Integer feeltemp = entity.getFeeltemp();
    if (feeltemp != null) {
        stmt.bindLong(7, feeltemp);
    }
 
    Integer shidu = entity.getShidu();
    if (shidu != null) {
        stmt.bindLong(8, shidu);
    }
 
    String sunrise = entity.getSunrise();
    if (sunrise != null) {
        stmt.bindString(9, sunrise);
    }
 
    String sundown = entity.getSundown();
    if (sundown != null) {
        stmt.bindString(10, sundown);
    }
 
    java.util.Date lastUpdate = entity.getLastUpdate();
    if (lastUpdate != null) {
        stmt.bindLong(11, lastUpdate.getTime());
    }
}

Example 19

Source Project: iBeebo File: Green_AccountBeanDao.java License: GNU General Public License v3.0

4 votes

/**
 * @inheritdoc
 */
@Override
protected void bindValues(SQLiteStatement stmt, Green_AccountBean entity) {
    stmt.clearBindings();

    Long uid = entity.getUid();
    if (uid != null) {
        stmt.bindLong(1, uid);
    }

    String user_name = entity.getUser_name();
    if (user_name != null) {
        stmt.bindString(2, user_name);
    }

    String user_password = entity.getUser_password();
    if (user_password != null) {
        stmt.bindString(3, user_password);
    }

    String cookie = entity.getCookie();
    if (cookie != null) {
        stmt.bindString(4, cookie);
    }

    String oauth_token = entity.getOauth_token();
    if (oauth_token != null) {
        stmt.bindString(5, oauth_token);
    }

    Long oauth_token_expires_time = entity.getOauth_token_expires_time();
    if (oauth_token_expires_time != null) {
        stmt.bindLong(6, oauth_token_expires_time);
    }

    String access_token_hack = entity.getAccess_token_hack();
    if (access_token_hack != null) {
        stmt.bindString(7, access_token_hack);
    }

    Long expires_time_hack = entity.getExpires_time_hack();
    if (expires_time_hack != null) {
        stmt.bindLong(8, expires_time_hack);
    }

    String g_sid = entity.getG_sid();
    if (g_sid != null) {
        stmt.bindString(9, g_sid);
    }

    Integer navigation_position = entity.getNavigation_position();
    if (navigation_position != null) {
        stmt.bindLong(10, navigation_position);
    }

    String user_info_json = entity.getUser_info_json();
    if (user_info_json != null) {
        stmt.bindString(11, user_info_json);
    }
}

Example 20

Source Project: AppManager-for-Android File: FileEntryDao.java License: Apache License 2.0

4 votes

public void create(final FileEntry entity) {
    if (entity == null) {
        return;
    }
    SQLiteDatabase db = null;
    SQLiteStatement statement = null;
    try {
        DbHelper helper = new DbHelper(getContext());
        db = helper.getWritableDatabase();
        StringBuilder sb = new StringBuilder();
        sb.append("INSERT INTO file_entries (");
        sb.append(" name, ");
        sb.append(" url, ");
        sb.append(" basic_auth_user, ");
        sb.append(" basic_auth_password, ");
        sb.append(" created_at, ");
        sb.append(" updated_at");
        sb.append(") VALUES (");
        sb.append(" ?, "); // name
        sb.append(" ?, "); // url
        if (entity.basicAuthUser != null) {
            sb.append(" ?, "); // basic_auth_user
        }
        if (entity.basicAuthPassword != null) {
            sb.append(" ?, "); // basic_auth_password
        }
        sb.append("DATETIME('now', 'localtime'), "); // created_at
        sb.append("DATETIME('now', 'localtime')"); // updated_at
        sb.append(");");
        statement = db.compileStatement(sb.toString());
        int index = 1;
        statement.bindString(index++, entity.name);
        statement.bindString(index++, entity.url);
        if (entity.basicAuthUser != null) {
            statement.bindString(index++, entity.basicAuthUser);
        }
        if (entity.basicAuthPassword != null) {
            statement.bindString(index++, entity.basicAuthPassword);
        }
        statement.executeInsert();
    } finally {
        if (statement != null) {
            statement.close();
        }
        if (db != null) {
            db.close();
        }
    }
}