1. 首先 我见了一个School.db 内含 Students的表,如下图
2. 我把这个School.db 通过FileExplore 添加到 项目下的databases目录下
问题是, 取不到里面的数据!! 主要的code 都贴在下面了,sql 语句没有什么问题的!
求各位帮看看 感激不尽!
public class DataBaseOpenHelper extends SQLiteOpenHelper{ private static String dbname ="School.db";
private static int version = 1; public DataBaseOpenHelper(Context context) {
super(context, dbname, null, version);
} @Override
public void onCreate(SQLiteDatabase db) {
db.execSQL("CREATE TABLE IF NOT EXISTS students(id integer primary key" +
" autoincrement,Sno varchar(10), Sname varchar(10),Ssex char(2),Sphoto BLOB)");
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
db.execSQL("DROP TABLE IF EXISTS students");
onCreate(db);
}
}public class DataBaseService { private DataBaseOpenHelper dbOpenHelper; public DataBaseService(Context context){
dbOpenHelper = new DataBaseOpenHelper(context);
}
//查询表students中的所有数据,返回一个cursor
public Cursor getAllData(){
SQLiteDatabase database = dbOpenHelper.getReadableDatabase();
Cursor cursor = database.rawQuery("select id as _id ,Sno,Sname,Ssex,Sphoto from students",null);
return cursor;
}
}public class Students1Activity extends Activity{ @Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.students);
ListView mListView = (ListView)findViewById(R.id.studentslistView);
DataBaseService mDataBaseService = new DataBaseService(this);
Cursor cursor = mDataBaseService.getAllData();
SimpleCursorAdapter adapter = new SimpleCursorAdapter(
Students1Activity.this,
R.layout.students_listview,
cursor,
new String[]{"Sno","Sname","Ssex",},
new int[]{R.id.Sno,R.id.Sname,R.id.Ssex});
mListView.setAdapter(adapter);
cursor.close();
}
}
2. 我把这个School.db 通过FileExplore 添加到 项目下的databases目录下
问题是, 取不到里面的数据!! 主要的code 都贴在下面了,sql 语句没有什么问题的!
求各位帮看看 感激不尽!
public class DataBaseOpenHelper extends SQLiteOpenHelper{ private static String dbname ="School.db";
private static int version = 1; public DataBaseOpenHelper(Context context) {
super(context, dbname, null, version);
} @Override
public void onCreate(SQLiteDatabase db) {
db.execSQL("CREATE TABLE IF NOT EXISTS students(id integer primary key" +
" autoincrement,Sno varchar(10), Sname varchar(10),Ssex char(2),Sphoto BLOB)");
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
db.execSQL("DROP TABLE IF EXISTS students");
onCreate(db);
}
}public class DataBaseService { private DataBaseOpenHelper dbOpenHelper; public DataBaseService(Context context){
dbOpenHelper = new DataBaseOpenHelper(context);
}
//查询表students中的所有数据,返回一个cursor
public Cursor getAllData(){
SQLiteDatabase database = dbOpenHelper.getReadableDatabase();
Cursor cursor = database.rawQuery("select id as _id ,Sno,Sname,Ssex,Sphoto from students",null);
return cursor;
}
}public class Students1Activity extends Activity{ @Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.students);
ListView mListView = (ListView)findViewById(R.id.studentslistView);
DataBaseService mDataBaseService = new DataBaseService(this);
Cursor cursor = mDataBaseService.getAllData();
SimpleCursorAdapter adapter = new SimpleCursorAdapter(
Students1Activity.this,
R.layout.students_listview,
cursor,
new String[]{"Sno","Sname","Ssex",},
new int[]{R.id.Sno,R.id.Sname,R.id.Ssex});
mListView.setAdapter(adapter);
cursor.close();
}
}
解决方案 »
- 请问 kill phone 进程为什么不能成功呢?
- android 自定义dialog,老报错! 请高手指教
- 帮忙看看这个代码有什么问题
- 求教视频播放器UI全屏问题
- 关于ViewPager的滑动的动画效果
- android 如何去掉状态栏上的两个SIM卡图标。。。
- libffmpeg.so在Android4.0.3可用,在2.3.3崩溃
- 请问关于发帖子中的显示图片问题
- 请教各位大神,我通过listFiles()获取目录下的文件列表却始终为空
- android expandablelistview,网络数据加载。
- 那位大侠给写个使用万普广告平台的广告条代码?
- 求教!如何获取android的status bar的height???
如下图
"/data/data/com.xxx.xxxx/databases/School.db";
SD卡我还没有接触到,我是很新很新的新手 嘻嘻