插入大量数据到Android的SQLite数据库？ [英] Inserting large amount of data into android sqlite database?

问题描述

我有大量的数据，我想导入到一个SQLite数据库。 4column和150行。目前的数据是在一个excel US preadsheet。

I have a large amount of data i want to import into one sqlite database. 4column and 150 rows. Currently the data is in a excel spreadsheet.

我怎样才能将其导入到我的Andr​​oid应用程序？

How can i import it into my android application?

    String SQL = "create table " + TABLE + "( " 
        + BaseColumns._ID
        + " integer primary key, " 
        + Column1+ " text, "
        + Column2+ " text, "
        + Column3+ " text, " 
        + Column4+ " text);";
        db.execSQL(SQL);        

        ContentValues values = new ContentValues();
        values.put(DBAdapter.Column1,  "HP");
        values.put(DBAdapter.Column2,  "qw");
        values.put(DBAdapter.Column3,  "5280");
        values.put(DBAdapter.Column4,  "345, 546");
        db.insert(DBAdapter.TABLE, null, values);

        ContentValues values2 = new ContentValues();
        values2.put(DBAdapter.Column1,  "P");
        values2.put(DBAdapter.Column2,  "other");
        values2.put(DBAdapter.Column3,  "other");
        values2.put(DBAdapter.Column4,  "345");

} 

这是我如何插入两行到我的数据库，但我不希望有这样做的150？

This is how i have inserted two rows into my DB, but i dont want to have to do this for 150?

推荐答案

您可以存储在一个CSV文件中的信息，然后读取该文件，每一行存放在sqlite的。

You could store the information on a CSV file, then read the file and store each row in sqlite.

这篇关于插入大量数据到Android的SQLite数据库？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！