为什么在eclipse的文件资源管理器中看不到sqlite管理器的db结构？
当我在文件资源管理器中单击my db时，sqlite管理器按钮是disable。
我必须先从eclipse中提取一个db，然后用sqlite数据库浏览器打开它。
下面是我的create db代码：
private static final String DB_NAME = "uniDB_";
private static final String Memo_Table = "Memo";
private static final String Memo_ID = "_ID";
private static final String Memo_Name = "MemoName";
private static final String Memo_PW = "MemoPW";
private static final String Main_Type = "MainType";
private static final String Sec_Type = "SecType";
private static final String Main_ID = "MainID";
private static final String Sec_ID = "SecID";
private static final String Text_Table = "Txt";
private static final String Text_Name = "TxtMemoName";
private static final String Pic_Table = "Pic";
private static final String Pic_Name = "PicMemoName";
private static final String MemoDB_CREATE = "Create table Memo (_ID INTEGER PRIMARY KEY AUTOINCREMENT, MemoName TEXT, MemoPW TEXT, MainType TEXT, SecType TEXT, MainID TEXT, SecID TEXT)";
private static final String PicDB_CREATE = "Create table Pic (_ID INTEGER PRIMARY KEY AUTOINCREMENT, PicMemoName TEXT)";
private static final String TxtDB_CREATE = "Create table Txt (_ID INTEGER PRIMARY KEY AUTOINCREMENT, TxtMemoName TEXT)";
...
private static class DatabaseHelper extends SQLiteOpenHelper {
public DatabaseHelper(Context context) {
super(context, DB_NAME, null , 1); //call constructor's superclass
// TODO Auto-generated constructor stub
}
...
public void onCreate(SQLiteDatabase db) {
// TODO Auto-generated method stub
db.execSQL(MemoDB_CREATE);
db.execSQL(PicDB_CREATE);
db.execSQL(TxtDB_CREATE);
}
}
非常感谢你的帮助
最佳答案
作为您的代码，我看不到数据库的扩展，所以首先给出数据库的扩展
要查看数据库和数据的结构，必须为sqlite管理器安装插件
您可以从here获得插件
如果您想了解更多信息，请参见this
如果已经安装了插件，那么您必须做以下更改
可能是您的数据库扩展名是“.sqlite”，如果是，请用“.db”更改它