多个插入语句android sqlite [英] multiple insert statements android sqlite

问题描述

我从网络下载了 800 个 insert 语句，格式如下:

I have 800 insert statements downloaded from network in the following format:

insert into mytable(col1,..,coln) values(val1,..valn);insert into mytable col...

我听说过交易、ContentValues 和使用 union，但我不知道哪种更适合这种情况.

I have heard of transactions ,ContentValues , and using union but I can't figure out which one is better for this case.

截断mytable后将它们插入sqlite数据库的最佳方法是什么?

What is the best way to insert them in sqlite database after truncating mytable?

推荐答案

如果要运行多个查询，为了提高数据完整性和性能，应该使用事务.这是一段代码，可让您了解如何操作:

In case of multiple queries to run, in order to improve data integrity and performance, you should use transactions. This is a code to give you an idea how to do it:

    SQLiteDatabase db = sqlHelper.getWritableDatabase(); // get a writable database here
    db.beginTransaction();

    try {
        for (int insertQuery : listOfQueries) {  // loop through your records 
            db.insert(...);
        }

        db.setTransactionSuccessful();
    }
    finally {
        db.endTransaction();
    }

    db.close();

这篇关于多个插入语句android sqlite的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！