Java SQLiteUtils类代码示例

OGeek|极客世界-中国程序员成长平台 › 门户 › 编程› Java›Java编程经验

原作者: [db:作者] 来自: [db:来源] 收藏邀请

本文整理汇总了Java中com.activeandroid.util.SQLiteUtils类的典型用法代码示例。如果您正苦于以下问题：Java SQLiteUtils类的具体用法？Java SQLiteUtils怎么用？Java SQLiteUtils使用的例子？那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。

SQLiteUtils类属于com.activeandroid.util包，在下文中一共展示了SQLiteUtils类的18个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于我们的系统推荐出更棒的Java代码示例。

示例1: executeCreateIndex

import com.activeandroid.util.SQLiteUtils; //导入依赖的package包/类
private void executeCreateIndex(SQLiteDatabase db) {
	db.beginTransaction();
	try {
		for (TableInfo tableInfo : Cache.getTableInfos()) {
			String[] definitions = SQLiteUtils.createIndexDefinition(tableInfo);

			for (String definition : definitions) {
				db.execSQL(definition);
			}
		}
		db.setTransactionSuccessful();
	}
	finally {
		db.endTransaction();
	}
}

开发者ID:weiwenqiang，项目名称:GitHub，代码行数:17，代码来源:DatabaseHelper.java

示例2: fixUpTable

import com.activeandroid.util.SQLiteUtils; //导入依赖的package包/类
private static void fixUpTable() {
    if (patched) return;
    final String[] patchup = {
            "CREATE TABLE BloodTest (_id INTEGER PRIMARY KEY AUTOINCREMENT);",
            "ALTER TABLE BloodTest ADD COLUMN timestamp INTEGER;",
            "ALTER TABLE BloodTest ADD COLUMN created_timestamp INTEGER;",
            "ALTER TABLE BloodTest ADD COLUMN state INTEGER;",
            "ALTER TABLE BloodTest ADD COLUMN mgdl REAL;",
            "ALTER TABLE BloodTest ADD COLUMN source TEXT;",
            "ALTER TABLE BloodTest ADD COLUMN uuid TEXT;",
            "CREATE UNIQUE INDEX index_Bloodtest_uuid on BloodTest(uuid);",
            "CREATE UNIQUE INDEX index_Bloodtest_timestamp on BloodTest(timestamp);",
            "CREATE INDEX index_Bloodtest_created_timestamp on BloodTest(created_timestamp);",
            "CREATE INDEX index_Bloodtest_state on BloodTest(state);"};

    for (String patch : patchup) {
        try {
            SQLiteUtils.execSql(patch);
            //  UserError.Log.e(TAG, "Processed patch should not have succeeded!!: " + patch);
        } catch (Exception e) {
            //  UserError.Log.d(TAG, "Patch: " + patch + " generated exception as it should: " + e.toString());
        }
    }
    patched = true;
}

开发者ID:NightscoutFoundation，项目名称:xDrip，代码行数:26，代码来源:BloodTest.java

示例3: fixUpTable

import com.activeandroid.util.SQLiteUtils; //导入依赖的package包/类
private static void fixUpTable() {
    if (patched) return;
    String[] patchup = {
            "CREATE TABLE PebbleMovement (_id INTEGER PRIMARY KEY AUTOINCREMENT);",
            "ALTER TABLE PebbleMovement ADD COLUMN timestamp INTEGER;",
            "ALTER TABLE PebbleMovement ADD COLUMN metric INTEGER;",
            "CREATE UNIQUE INDEX index_PebbleMovement_timestamp on PebbleMovement(timestamp);"};

    for (String patch : patchup) {
        try {
            SQLiteUtils.execSql(patch);
            //  UserError.Log.e(TAG, "Processed patch should not have succeeded!!: " + patch);
        } catch (Exception e) {
            //  UserError.Log.d(TAG, "Patch: " + patch + " generated exception as it should: " + e.toString());
        }
    }
    patched = true;
}

开发者ID:NightscoutFoundation，项目名称:xDrip，代码行数:19，代码来源:PebbleMovement.java

示例4: fixUpTable

import com.activeandroid.util.SQLiteUtils; //导入依赖的package包/类
private static void fixUpTable() {
    if (patched) return;
    String[] patchup = {
            "CREATE TABLE HeartRate (_id INTEGER PRIMARY KEY AUTOINCREMENT);",
            "ALTER TABLE HeartRate ADD COLUMN timestamp INTEGER;",
            "ALTER TABLE HeartRate ADD COLUMN bpm INTEGER;",
            "ALTER TABLE HeartRate ADD COLUMN accuracy INTEGER;",
            "CREATE UNIQUE INDEX index_HeartRate_timestamp on HeartRate(timestamp);"};

    for (String patch : patchup) {
        try {
            SQLiteUtils.execSql(patch);
            //  UserError.Log.e(TAG, "Processed patch should not have succeeded!!: " + patch);
        } catch (Exception e) {
            //  UserError.Log.d(TAG, "Patch: " + patch + " generated exception as it should: " + e.toString());
        }
    }
    patched = true;
}

开发者ID:NightscoutFoundation，项目名称:xDrip，代码行数:20，代码来源:HeartRate.java

示例5: fixUpTable

import com.activeandroid.util.SQLiteUtils; //导入依赖的package包/类
private static void fixUpTable() {
    if (patched) return;
    String[] patchup = {
            "CREATE TABLE Treatments (_id INTEGER PRIMARY KEY AUTOINCREMENT);",
            "ALTER TABLE Treatments ADD COLUMN timestamp INTEGER;",
            "ALTER TABLE Treatments ADD COLUMN uuid TEXT;",
            "ALTER TABLE Treatments ADD COLUMN eventType TEXT;",
            "ALTER TABLE Treatments ADD COLUMN enteredBy TEXT;",
            "ALTER TABLE Treatments ADD COLUMN notes TEXT;",
            "ALTER TABLE Treatments ADD COLUMN created_at TEXT;",
            "ALTER TABLE Treatments ADD COLUMN insulin REAL;",
            "ALTER TABLE Treatments ADD COLUMN carbs REAL;",
            "CREATE INDEX index_Treatments_timestamp on Treatments(timestamp);",
            "CREATE UNIQUE INDEX index_Treatments_uuid on Treatments(uuid);"};

    for (String patch : patchup) {
        try {
            SQLiteUtils.execSql(patch);
            //Log.e(TAG, "Processed patch should not have succeeded!!: " + patch);
        } catch (Exception e) {
            // Log.d(TAG, "Patch: " + patch + " generated exception as it should: " + e.toString());
        }
    }
    patched = true;
}

开发者ID:NightscoutFoundation，项目名称:xDrip，代码行数:26，代码来源:Treatments.java

示例6: execute

import com.activeandroid.util.SQLiteUtils; //导入依赖的package包/类
public <T extends Model> List<T> execute() {
	if (mQueryBase instanceof Select) {
		return SQLiteUtils.rawQuery(mType, toSql(), getArguments());
		
	} else {
		SQLiteUtils.execSql(toSql(), getArguments());
		Cache.getContext().getContentResolver().notifyChange(ContentProvider.createUri(mType, null), null);
		return null;
		
	}
}

开发者ID:weiwenqiang，项目名称:GitHub，代码行数:12，代码来源:From.java

示例7: executeSingle

import com.activeandroid.util.SQLiteUtils; //导入依赖的package包/类
public <T extends Model> T executeSingle() {
	if (mQueryBase instanceof Select) {
		limit(1);
		return (T) SQLiteUtils.rawQuerySingle(mType, toSql(), getArguments());
		
	} else {
		limit(1);
		SQLiteUtils.rawQuerySingle(mType, toSql(), getArguments()).delete();
		return null;
		
	}
}

开发者ID:weiwenqiang，项目名称:GitHub，代码行数:13，代码来源:From.java

示例8: executeCreate

import com.activeandroid.util.SQLiteUtils; //导入依赖的package包/类
private void executeCreate(SQLiteDatabase db) {
	db.beginTransaction();
	try {
		for (TableInfo tableInfo : Cache.getTableInfos()) {
			db.execSQL(SQLiteUtils.createTableDefinition(tableInfo));
		}
		db.setTransactionSuccessful();
	}
	finally {
		db.endTransaction();
	}
}

开发者ID:weiwenqiang，项目名称:GitHub，代码行数:13，代码来源:DatabaseHelper.java

示例9: cleanup

import com.activeandroid.util.SQLiteUtils; //导入依赖的package包/类
public static void cleanup(long timestamp) {
    try {
        SQLiteUtils.execSql("delete from CalibrationRequest");
        List<Calibration> data = new Select()
                .from(BgReading.class)
                .where("timestamp < ?", timestamp)
                .orderBy("timestamp desc")
                .execute();
        if (data != null) Log.d(TAG, "cleanup Calibration size=" + data.size());
        new Calibration.Cleanup().execute(data);
    } catch (Exception e) {
        Log.e(TAG, "Got exception running cleanup " + e.toString());
    }
}

开发者ID:NightscoutFoundation，项目名称:xDrip，代码行数:15，代码来源:Calibration.java

示例10: fixUpTable

import com.activeandroid.util.SQLiteUtils; //导入依赖的package包/类
public static void fixUpTable() {
    if (patched) return;

    for (String patch : schema) {
        try {
            SQLiteUtils.execSql(patch);
        } catch (Exception e) {
            if (d)
                UserError.Log.d(TAG, "Patch: " + patch + " generated exception as it should: " + e.toString());
        }
    }
    patched = true;
}

开发者ID:NightscoutFoundation，项目名称:xDrip，代码行数:14，代码来源:UserNotification.java

示例11: fixUpTable

import com.activeandroid.util.SQLiteUtils; //导入依赖的package包/类
private static void fixUpTable() {
    if (patched) return;
    String[] patchup = {
            "CREATE TABLE Treatments (_id INTEGER PRIMARY KEY AUTOINCREMENT);",
            "ALTER TABLE Treatments ADD COLUMN timestamp INTEGER;",
            "ALTER TABLE Treatments ADD COLUMN systimestamp INTEGER;",
            "ALTER TABLE Treatments ADD COLUMN uuid TEXT;",
            "ALTER TABLE Treatments ADD COLUMN eventType TEXT;",
            "ALTER TABLE Treatments ADD COLUMN enteredBy TEXT;",
            "ALTER TABLE Treatments ADD COLUMN notes TEXT;",
            "ALTER TABLE Treatments ADD COLUMN created_at TEXT;",
            "ALTER TABLE Treatments ADD COLUMN insulin REAL;",
            "ALTER TABLE Treatments ADD COLUMN carbs REAL;",
            "CREATE INDEX index_Treatments_timestamp on Treatments(timestamp);",
            "CREATE INDEX index_Treatments_systimestamp on Treatments(systimestamp);",
            "CREATE UNIQUE INDEX index_Treatments_uuid on Treatments(uuid);"};

    for (String patch : patchup) {
        try {
            SQLiteUtils.execSql(patch);
            //Log.e(TAG, "Processed patch should not have succeeded!!: " + patch);
        } catch (Exception e) {
            // Log.d(TAG, "Patch: " + patch + " generated exception as it should: " + e.toString());
        }
    }
    patched = true;
}

开发者ID:NightscoutFoundation，项目名称:xDrip，代码行数:28，代码来源:Treatments.java

示例12: fixUpTable

import com.activeandroid.util.SQLiteUtils; //导入依赖的package包/类
protected synchronized static void fixUpTable(String[] schema) {
    if (patched) return;

    for (String patch : schema) {
        try {
            SQLiteUtils.execSql(patch);
        } catch (Exception e) {
            //
        }
    }
    patched = true;
}

开发者ID:NightscoutFoundation，项目名称:xDrip，代码行数:13，代码来源:PlusModel.java

示例13: updateDB

import com.activeandroid.util.SQLiteUtils; //导入依赖的package包/类
public static void updateDB(){
    String[] updates = new String[]{"ALTER TABLE BgReadings ADD COLUMN dg_mgdl REAL;", "ALTER TABLE BgReadings ADD COLUMN dg_slope REAL;", "ALTER TABLE BgReadings ADD COLUMN dg_delta_name TEXT;"};
    for (String patch:updates) {
        try {
            SQLiteUtils.execSql(patch);
        } catch (Exception e){
        }
    }

}

开发者ID:NightscoutFoundation，项目名称:xDrip，代码行数:11，代码来源:BgReading.java

示例14: deleteALL

import com.activeandroid.util.SQLiteUtils; //导入依赖的package包/类
public static void deleteALL() {
    try {
        SQLiteUtils.execSql("delete from BgSendQueue");
        SQLiteUtils.execSql("delete from BgReadings");
        Log.d(TAG, "Deleting all BGReadings");
    } catch (Exception e) {
        Log.e(TAG, "Got exception running deleteALL " + e.toString());
    }
}

开发者ID:NightscoutFoundation，项目名称:xDrip，代码行数:10，代码来源:BgReading.java

示例15: cleanup

import com.activeandroid.util.SQLiteUtils; //导入依赖的package包/类
public static void cleanup(long timestamp) {
    try {
    SQLiteUtils.execSql("delete from BgSendQueue");
    List<BgReading> data = new Select()
            .from(BgReading.class)
            .where("timestamp < ?", timestamp)
            .orderBy("timestamp desc")
            .execute();
    if (data != null) Log.d(TAG, "cleanup BgReading size=" + data.size());
    new Cleanup().execute(data);
    } catch (Exception e) {
        Log.e(TAG, "Got exception running cleanup " + e.toString());
    }
}

开发者ID:NightscoutFoundation，项目名称:xDrip，代码行数:15，代码来源:BgReading.java

示例16: fixUpTable

import com.activeandroid.util.SQLiteUtils; //导入依赖的package包/类
protected synchronized static void fixUpTable(String[] schema) {
    if (patched) return;
    for (String patch : schema) {
        try {
            SQLiteUtils.execSql(patch);
        } catch (Exception e) {
            //
        }
    }
    patched = true;
}

开发者ID:NightscoutFoundation，项目名称:xDrip，代码行数:12，代码来源:Reminder.java

示例17: fixUpTable

import com.activeandroid.util.SQLiteUtils; //导入依赖的package包/类
protected synchronized static boolean fixUpTable(String[] schema, boolean patched) {
    if (patched) return true;

    for (String patch : schema) {
        try {
            SQLiteUtils.execSql(patch);
        } catch (Exception e) {
            //
        }
    }
    return true;
}

开发者ID:NightscoutFoundation，项目名称:xDrip，代码行数:13，代码来源:PlusModel.java

示例18: fixUpTable

import com.activeandroid.util.SQLiteUtils; //导入依赖的package包/类
private static void fixUpTable() {
    if (patched) return;

    for (String patch : schema) {
        try {
            SQLiteUtils.execSql(patch);
        } catch (Exception e) {
            if (d)
                UserError.Log.d(TAG, "Patch: " + patch + " generated exception as it should: " + e.toString());
        }
    }
    patched = true;
}

开发者ID:NightscoutFoundation，项目名称:xDrip，代码行数:14，代码来源:UploaderQueue.java

注：本文中的com.activeandroid.util.SQLiteUtils类示例整理自Github/MSDocs等源码及文档管理平台，相关代码片段筛选自各路编程大神贡献的开源项目，源码版权归原作者所有，传播和使用请参考对应项目的License；未经允许，请勿转载。

鲜花

握手

雷人

路过

鸡蛋

该文章已有0人参与评论

请发表评论

全部评论

专题导读

More+

10-27 六六分期app的软件客服如何联系？(六六分期

11-06 可心卡盟:win10系统火狐flash插件崩溃怎么

11-06 亲亲特价:怎么删除回收站图标

11-06 济南大学虚拟社区:鲁大师节能降温的具体办

11-06 xlueops.exe:无线网络安装向导

11-06 女斗合众国:win7系统cf与主机连接不稳定怎

11-06 0xc000022-[cf烟雾头]cf怎么调烟雾头

11-06 qizideyouhuo:应用程序无法正常启动0xc0000

11-06 ipz-185:win7系统vcf文件怎么打开

11-06 傻哥蹦迪:win10系统s4怎么打开usb调试

11-06 八神浩树gtaste:回收站清空了怎么恢复

11-06 妖尾之黑色守护:win10系统电脑没有1440x900

11-06 校园至尊魔王小说:win7系统浏览网页时字体

11-06 女斗合众国:win10系统访问共享文件夹提示请

11-06 tokyo hot n0654:恢复win7系统默认字体一招

11-06 雨酷仙境:设置win7系统转移临时文件夹腾出

11-06 阿穆纳伊之杖:win7系统开始菜单在右边还原

11-06 tunespotting:win10系统火狐flash插件总是

11-06 甘尔葛分析师：计谋网站seo关键词暴涨有什

11-06 蔡贵霖: 计谋网站seo关键词暴涨有什么秘密

11-06 博益网首页:ao3网页版进入不了解决方法

11-06 漏斗子专栏: 网站数据分析小白易懂精华篇

11-06 见证双虹怎么做:win7系统开启telnet命令的

11-06 颾狐蝶蜋:系统资源不足无法完成请求的服务

11-06 国光中学校歌:提交网站到alexa查询详细步骤

11-06 西安有情天:静态网页和动态网页的区别

11-06 红木雅尚斋:外部链接构造对网站的好处

11-06 前官礼遇：防止域名劫持–增强域安全性的10

11-06 密传二转答案: 中文分词算法有哪些

11-06 金泉家园邮编:百度快照劫持的表现及应对方

Java ConnectionStyle类代码示例发布时间：2022-05-22

Java IContext类代码示例发布时间：2022-05-22

剪的笔顺,诠释剪的笔画,认识剪的部首

1 六六分期app的软件客服如何联系？(六六分期

六六分期app的软件客服如何联系？不知道吗？加qq群【895510560】即可！标题：六六分期

阅读：18279|2023-10-27

2 可心卡盟:win10系统火狐flash插件崩溃怎么

今天小编告诉大家如何处理win10系统火狐flash插件总是崩溃的问题，可能很多用户都不知

阅读：9678|2022-11-06

3 亲亲特价:怎么删除回收站图标

今天小编告诉大家如何对win10系统删除桌面回收站图标进行设置，可能很多用户都不知道

阅读：8180|2022-11-06

4 济南大学虚拟社区:鲁大师节能降温的具体办

今天小编告诉大家如何对win10系统电脑设置节能降温的设置方法，想必大家都遇到过需要

阅读：8549|2022-11-06

5 xlueops.exe:无线网络安装向导

我们在使用xp系统的过程中,经常需要对xp系统无线网络安装向导设置进行设置，可能很多

阅读：8458|2022-11-06

6 女斗合众国:win7系统cf与主机连接不稳定怎

今天小编告诉大家如何处理win7系统玩cf老是与主机连接不稳定的问题，可能很多用户都不

阅读：9393|2022-11-06

7 0xc000022-[cf烟雾头]cf怎么调烟雾头

电脑对日常生活的重要性小编就不多说了，可是一旦碰到win7系统设置cf烟雾头的问题，很

阅读：8431|2022-11-06

8 qizideyouhuo:应用程序无法正常启动0xc0000

我们在日常使用电脑的时候，有的小伙伴们可能在打开应用的时候会遇见提示应用程序无法

阅读：7865|2022-11-06

9 ipz-185:win7系统vcf文件怎么打开

今天小编告诉大家如何对win7系统打开vcf文件进行设置，可能很多用户都不知道怎么对win

阅读：8416|2022-11-06

10 傻哥蹦迪:win10系统s4怎么打开usb调试

今天小编告诉大家如何对win10系统s4开启USB调试模式进行设置，可能很多用户都不知道怎

阅读：7394|2022-11-06

客服电话

电子邮件

Java SQLiteUtils类代码示例

示例1: executeCreateIndex

示例2: fixUpTable

示例3: fixUpTable

示例4: fixUpTable

示例5: fixUpTable

示例6: execute

示例7: executeSingle

示例8: executeCreate

示例9: cleanup

示例10: fixUpTable

示例11: fixUpTable

示例12: fixUpTable

示例13: updateDB

示例14: deleteALL

示例15: cleanup

示例16: fixUpTable

示例17: fixUpTable

示例18: fixUpTable

请发表评论

全部评论

上一篇：

下一篇：

solegalli/feature-selection-for-machine-

lunasoldstuff/bridge: mastodon bridge

win7系统重装系统初始设置的操作方法

钱可通神的意思?钱可通神成语典故

CVE-2022-35629

剪的笔顺,诠释剪的笔画,认识剪的部首

六六分期app的软件客服如何联系？(六六分期

florent37/ViewAnimator: A fluent Android

florent37/Shrine-MaterialDesign2: implem

CVE-2020-36276

SimpleSoftwareIO/simple-sms: Send and re

关于我们

产品与服务

解决方案

139-2527-9053