Android:带.sqlite扩展名的数据库资产文件夹sqlite数据库文件

gc0ot86w  于 11个月前  发布在  Android
关注(0)|答案(7)|浏览(113)

如何在我的Android应用程序中从.sqlite扩展名为.sqliteres/assets/文件夹中的sqlite数据库文件读取数据?

4ioopgfo

4ioopgfo1#

试试这个代码:

public class DataBaseHelper extends SQLiteOpenHelper {
    private Context mycontext;

    //private String DB_PATH = mycontext.getApplicationContext().getPackageName()+"/databases/";
    private static String DB_NAME = "(datbasename).sqlite";//the extension may be .sqlite or .db
    public SQLiteDatabase myDataBase;
    /*private String DB_PATH = "/data/data/"
                        + mycontext.getApplicationContext().getPackageName()
                        + "/databases/";*/

    public DataBaseHelper(Context context) throws IOException {
        super(context,DB_NAME,null,1);
        this.mycontext=context;
        boolean dbexist = checkdatabase();
        if (dbexist) {
            //System.out.println("Database exists");
            opendatabase(); 
        } else {
            System.out.println("Database doesn't exist");
            createdatabase();
        }
    }

    public void createdatabase() throws IOException {
        boolean dbexist = checkdatabase();
        if(dbexist) {
            //System.out.println(" Database exists.");
        } else {
            this.getReadableDatabase();
            try {
                copydatabase();
            } catch(IOException e) {
                throw new Error("Error copying database");
            }
        }
    }   

    private boolean checkdatabase() {
        //SQLiteDatabase checkdb = null;
        boolean checkdb = false;
        try {
            String myPath = DB_PATH + DB_NAME;
            File dbfile = new File(myPath);
            //checkdb = SQLiteDatabase.openDatabase(myPath,null,SQLiteDatabase.OPEN_READWRITE);
            checkdb = dbfile.exists();
        } catch(SQLiteException e) {
            System.out.println("Database doesn't exist");
        }
        return checkdb;
    }

    private void copydatabase() throws IOException {
        //Open your local db as the input stream
        InputStream myinput = mycontext.getAssets().open(DB_NAME);

        // Path to the just created empty db
        String outfilename = DB_PATH + DB_NAME;

        //Open the empty db as the output stream
        OutputStream myoutput = new FileOutputStream("/data/data/(packagename)/databases   /(datbasename).sqlite");

        // transfer byte to inputfile to outputfile
        byte[] buffer = new byte[1024];
        int length;
        while ((length = myinput.read(buffer))>0) {
            myoutput.write(buffer,0,length);
        }

        //Close the streams
        myoutput.flush();
        myoutput.close();
        myinput.close();
    }

    public void opendatabase() throws SQLException {
        //Open the database
        String mypath = DB_PATH + DB_NAME;
        myDataBase = SQLiteDatabase.openDatabase(mypath, null, SQLiteDatabase.OPEN_READWRITE);
    }

    public synchronized void close() {
        if(myDataBase != null) {
            myDataBase.close();
        }
        super.close();
    }

}

字符串

qeeaahzv

qeeaahzv2#

将旧数据库(old.db)放入资产文件夹。在Activity的onCreate()中键入以下内容:

public void onCreate(Bundle savedInstanceState) {
    super.onCreate(savedInstanceState);
....

//=======Code For copying Existing Database file to system folder for use====//
    // Copying Existing Database into system folder
        try {

            String destPath = "/data/data/" + getPackageName()
                    + "/databases/data.db";

            File f = new File(destPath);
            if(!f.exists()){
            Log.v(TAG,"File Not Exist");
            InputStream in = getAssets().open("old.db");
            OutputStream out = new FileOutputStream(destPath);

            byte[] buffer = new byte[1024];
            int length;
            while ((length = in.read(buffer)) > 0) {
                out.write(buffer, 0, length);
            }
            in.close();
            out.close();
            }

        } catch (FileNotFoundException e) {
            e.printStackTrace();
        } catch (IOException e) {
            Log.v("TAG","ioexeption");
            e.printStackTrace();
        }

        DBManager dbManager =  new DBManager(this);
        Log.v(TAG,"Database is there with version: "+dbManager.getReadableDatabase().getVersion());
        String sql = "select * from prizes";

        SQLiteDatabase db = dbManager.getReadableDatabase();
        Cursor cursor = db.rawQuery(sql, null);
        Log.v(TAG,"Query Result:"+cursor);

        cursor.close();
        db.close();
        dbManager.close();

....

}

字符串
现在你需要创建一个DBManager类,它是SQLiteOpenHelper的子类。插入抽象方法和构造函数。不要忘记在dbHelper的super()中输入正确的数据库名称。

public class DBManager extends SQLiteOpenHelper {

private static final int DATABASE_VERSION = 1;
private static final String TAG = "DATABASES";

public DBManager(Context context) {
    super(context, "data.db", null, DATABASE_VERSION);

}

@Override
public void onCreate(SQLiteDatabase db) {
    Log.v(TAG,"On create Called:"+db.getPath());
}

@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
}
}


现在你可以通过示例化DBManager来访问数据库。

SQLiteDatabase db = dbManager.getReadableDatabase();
Cursor cursor = db.rawQuery(sql, null);
...


不要忘记关闭数据库,否则你会得到一个SQLiteDatabaseNotClosed异常。

db.close();
dbManager.close();

jyztefdp

jyztefdp3#

重要的是,在本教程中,当您调用文件时,请确保传递应用程序上下文getApplicationContext(),以便您可以访问正确的资产,否则您可能会获得FileNotFound异常。

gwo2fgha

gwo2fgha4#

你会想尝试android sqlite asset helper,它让打开一个预先存在的数据库对我来说是小菜一碟。
我真的有它的工作在大约半个小时后,花了3个小时试图做这一切手动。有趣的是,我以为我在做同样的事情图书馆为我做的,但有些东西不见了!

relj7zay

relj7zay5#

您需要将.sqlite数据库转换为.db以适应Android。
安装后首次启动应用时

SuperDatabase database=new SuperDatabase(getApplicationContext(),"foods.db", AssetDatabaseMode.COPY_TO_SYSTEM);

字符串
在以后启动时

SuperDatabase database=new SuperDatabase(getApplicationContext(),"foods.db", AssetDatabaseMode.READ_FROM_DEVICE);


只需执行SQL查询

database.sqlInject("INSERT INTO food VALUES('Banana','Vitamin A');");


在CSV、JSON、XML格式的数组中获取结果

ArrayList<String> rows=new ArrayList<String>();
rows=database.sqlEjectCSV("SELECT * FROM food;");
for (int i=0;i<rows.size();i++)
{
    //Do stuffs with each row
}


你需要把我的图书馆包括进来。文档在这里:
https://github.com/sangeethnandakumar/TestTube

xkrw2x1b

xkrw2x1b6#

如果您计划创建一个新的SQLite数据库,那么请重写并实现onCreate()方法,如教程所示。
但是,如果您使用的SQLite数据库是由另一个外部源创建的,并且您打算将其拉下,那么将onCreate()方法留空。

w9apscun

w9apscun7#

您只能从资产文件夹中读取数据库,因为资源文件夹是只读的。如果您需要执行更多操作,如创建,更新,删除,您可以做一个技巧。将数据库从资产文件夹复制到存储,然后您可以做任何您想要的。
下面是一个Working with Android Pre Built Database.的快速示例
有一个易于使用的库也从资产文件夹访问数据库。你可以检查Android SQLiteAssetHelper(https://github.com/jgilfelt/android-sqlite-asset-helper)。祝你好运!

相关问题