public class DBManager {
private final int BUFFER_SIZE = 400000;
public static final String DB_NAME = "gsl.db"; //保存的数据库文件名
public static final String PACKAGE_NAME = "com.example.gslxt";
public static final String DB_PATH = "/data"
+ Environment.getDataDirectory().getAbsolutePath() + "/"
+ PACKAGE_NAME; //在手机里存放数据库的位置(/data/data/com.cssystem.activity/cssystem.db)
private SQLiteDatabase database;
private Context context;
public DBManager(Context context) {
this.context = context;
}
public SQLiteDatabase getDatabase() {
return database;
}
public void setDatabase(SQLiteDatabase database) {
this.database = database;
}
public void openDatabase() {
System.out.println(DB_PATH + "/" + DB_NAME);
this.database = this.openDatabase(DB_PATH + "/" + DB_NAME);
}
private SQLiteDatabase openDatabase(String dbfile) {
try {
if (!(new File(dbfile).exists())) {
InputStream is = this.context.getResources().openRawResource(
R.raw.gsl); //欲导入的数据库
FileOutputStream fos = new FileOutputStream(dbfile);
byte[] buffer = new byte[BUFFER_SIZE];
int count = 0;
while ((count = is.read(buffer)) > 0) {
fos.write(buffer, 0, count);
}
fos.close();
is.close();
}
SQLiteDatabase db = SQLiteDatabase.openOrCreateDatabase(dbfile,null);
return db;
} catch (FileNotFoundException e) {
Log.e("Database", "File not found");
e.printStackTrace();
} catch (IOException e) {
Log.e("Database", "IO exception");
e.printStackTrace();
}
return null;
}
public void closeDatabase() {
this.database.close();
}
}
在另外一个类引用数据库时运行报错 no such table 。我打开DeviceFileExporer,找到data/data/包名/ 的位置确实多了一个gsl.db。但是打开一看,结果和我放在raw文件里的gsl.db内容不一样,就是一张空表。
不知道怎么版
问题到底出现在哪里,我第一次导入sqpllite也出现了这个问题,但我不知道怎么捣鼓搞好了,现在又出现这问题,这次搞不好了,真是烦心