java导出sqlite_java-在Android上简单导出和导入SQLite数据库

这是将数据库导出到名为backup文件夹的简单方法，您可以根据需要对其命名，并且是从同一文件夹中导入数据库的简单方法。

public class ExportImportDB extends Activity {

@Override

protected void onCreate(Bundle savedInstanceState) {

// TODO Auto-generated method stub

super.onCreate(savedInstanceState);

//creating a new folder for the database to be backuped to

File direct = new File(Environment.getExternalStorageDirectory() + "/Exam Creator");

if(!direct.exists())

{

if(direct.mkdir())

{

//directory is created;

}

}

exportDB();

importDB();

}

//importing database

private void importDB() {

// TODO Auto-generated method stub

try {

File sd = Environment.getExternalStorageDirectory();

File data = Environment.getDataDirectory();

if (sd.canWrite()) {

String currentDBPath= "//data//" + "PackageName"

+ "//databases//" + "DatabaseName";

String backupDBPath = "/BackupFolder/DatabaseName";

File backupDB= new File(data, currentDBPath);

File currentDB = new File(sd, backupDBPath);

FileChannel src = new FileInputStream(currentDB).getChannel();

FileChannel dst = new FileOutputStream(backupDB).getChannel();

dst.transferFrom(src, 0, src.size());

src.close();

dst.close();

Toast.makeText(getBaseContext(), backupDB.toString(),

Toast.LENGTH_LONG).show();

}

} catch (Exception e) {

Toast.makeText(getBaseContext(), e.toString(), Toast.LENGTH_LONG)

.show();

}

}

//exporting database

private void exportDB() {

// TODO Auto-generated method stub

try {

File sd = Environment.getExternalStorageDirectory();

File data = Environment.getDataDirectory();

if (sd.canWrite()) {

String currentDBPath= "//data//" + "PackageName"

+ "//databases//" + "DatabaseName";

String backupDBPath = "/BackupFolder/DatabaseName";

File currentDB = new File(data, currentDBPath);

File backupDB = new File(sd, backupDBPath);

FileChannel src = new FileInputStream(currentDB).getChannel();

FileChannel dst = new FileOutputStream(backupDB).getChannel();

dst.transferFrom(src, 0, src.size());

src.close();

dst.close();

Toast.makeText(getBaseContext(), backupDB.toString(),

Toast.LENGTH_LONG).show();

}

} catch (Exception e) {

Toast.makeText(getBaseContext(), e.toString(), Toast.LENGTH_LONG)

.show();

}

}

}

不要忘记添加此权限以继续进行

请享用