android SQLite
1.编写DataBaseOpenHelper 继承SQLiteOpenHelper
完成创建、打开数据库及各种数据库操作。 |
public class DataBaseOpenHelper extends SQLiteOpenHelper {
public DataBaseOpenHelper(Context context, String name,
CursorFactory factory, int version) {
super(context, name, factory, version);
}
@Override
public void onCreate(SQLiteDatabase db) {
db.execSQL("create table if not exists person("
+ "id integer primary key,"
+ "name varchar(20),"
+ "brith DateTime)");
db.execSQL("create table if not exists teacher("
+ "id integer primary key,"
+ "name varchar(20),"
+ "course varchar(20))");
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
}
}
2.TeacherDaoImpl teacher表的数据库访问类 ,完成数据的相关操作。
package com.fullwisdom.sqllite.dao;
import android.content.ContentValues;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import com.fullwisdom.sqllite.DataBaseOpenHelper;
import com.fullwisdom.sqllite.beans.Teacher;
public class TeacherDaoImpl {
private DataBaseOpenHelper databaseHelper;
public TeacherDaoImpl(DataBaseOpenHelper databaseHelper){
this.databaseHelper = databaseHelper;
}
public long save(Teacher t){
SQLiteDatabase db = databaseHelper.getWritableDatabase();
ContentValues values = new ContentValues();
values.put("name", t.getName());
values.put("course", t.getCourse());
long rowid = db.insert("teacher", null, values);
return rowid;
}
public Teacher find(int id){
SQLiteDatabase db = databaseHelper.getReadableDatabase();
Cursor cursor = db.query(true, "teacher", new String[]{"id","name","course"},"id=?",
new String[]{id+""}, null, null, null, null);
if(!cursor.moveToFirst()){
return null;
}
int pid = cursor.getInt(cursor.getColumnIndex("id"));
String pname = cursor.getString(cursor.getColumnIndex("name"));
Teacher t = new Teacher();
t.setId(pid);
t.setName(pname);
return t;
}
}
3.执行数据库操作 DataBaseOpenHelper dataBaseOpenHelper = new DataBaseOpenHelper(this, "liu.db", null, 1); PersonDaoImpl personDao = new PersonDaoImpl(dataBaseOpenHelper); Person p = new Person(); p.setName("liuzhiquan"); long id = personDao.save(p); System.out.println("id-----:"+id); Person p1 = personDao.find(1); System.out.println(p1); Teacher t = new Teacher(); t.setName("wuhaibo"); t.setCourse("computer"); TeacherDaoImpl teacherDao= new TeacherDaoImpl(dataBaseOpenHelper); teacherDao.save(t); System.out.println(teacherDao.find(1));更多相关文章
- 【Android學習專題】数据存储篇:SQLite
- 图片压缩保存读取操作
- android使用CheckedTextView搭配listview完成选择列表
- Android(安卓)数据库操作 创建 添加 删除 查询
- android SQLite
- android gallery相关操作
- Android(安卓)如何使用GPU硬件加速
- 利用Android中的SQLite进行CRUD
- Android(安卓)AsyncTask 使用