为什么我不能在文件浏览器看到DB结构由SQLite的经理 [英] Why I can't see DB structure by SQLite Manager in file explorer
问题描述
为什么我不能在Eclipse文件浏览器看到DB结构由SQLite的经理?结果
当我点击文件浏览器SQLite的经理我的数据库按钮关闭。结果
我不得不拉出来DB的Eclipse第一和SQLite数据库浏览器中打开它。
Why I can't see DB structure by SQLite Manager in file explorer in Eclipse?
When I click my DB in file explorer SQLite Manager button is disable.
I have to pull a DB out of Eclipse first and open it with SQLite Database Browser.
下面是我创建DB code:
Here is my create DB code:
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);
}
}
非常感谢你的帮助。
Thank you very much for your help
推荐答案
随着你的code,我不能看到数据库的扩展,使先给数据库的扩展
As your code I can't see the extension of the database so first give the extension of database
要查看数据库和数据,你必须安装SQLite的经理插件的结构
你可以从这里 插件
To see the structure of the database and data you have to install plugins for SQLite Manager you can get plugins from here
如果你想看到更多的信息,然后查看这个
If you want to see the more information then see this
如果已安装的插件,那么你必须做下面的变化
可能是你的数据库的扩展名是.sqlite如果它再与.db的
If already install plugins then you have to do below change May be your database extension is ".sqlite" if it is then change it with ".db"
这篇关于为什么我不能在文件浏览器看到DB结构由SQLite的经理的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!