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

The following examples show how to use android.database.sqlite.SQLiteStatement#bindString() . 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 File: CourseGroupDao.java From ClassSchedule with 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 File: LetterDao.java From ml-authentication with 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 File: UseAreaDao.java From MyWeather with 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 4

Source File: GroupUsersDao.java From CoolChat with 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 5

Source File: JokeCacheDao.java From JianDan with 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 6

Source File: alloperatorsDao.java From RxJavaApp with 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 7

Source File: FreshNewsCacheDao.java From JianDan_OkHttp with 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 8

Source File: CollectEntityDao.java From MeiZiNews with 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 9

Source File: StoryBookDao.java From ml-authentication with 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 10

Source File: MessageDao.java From sctalk with 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 11

Source File: UserDao.java From android-orm-benchmark-updated with 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 12

Source File: WordDao.java From ml-authentication with 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 13

Source File: TraceDao.java From OpenHub with 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 14

Source File: CookieBeanDao.java From HaoReader with 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 File: MediaDownloadInfoDao.java From FimiX8-RE with 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 16

Source File: ForumDao.java From TLint with 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 File: RealWeatherDao.java From FoodOrdering with 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 18

Source File: AllophoneDao.java From ml-authentication with 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 19

Source File: Green_AccountBeanDao.java From iBeebo with 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 File: FileEntryDao.java From AppManager-for-Android with 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();
        }
    }
}