尽管很简单,但是也存下来,以后直接粘过去就能用了。
public class DBHelper extends SQLiteOpenHelper {
private static final String DB_NAME = "lintest.db";
private static final String TBL_NAME = "lin";
private static final String CREATE_TBL = " create table "
+ " CollTbl(_id integer primary key autoincrement,name text,url text, desc text) ";
private SQLiteDatabase db;
DBHelper(Context c) {
super(c, DB_NAME, null, 2);
}
@Override
public void onCreate(SQLiteDatabase db) {
this.db = db;
db.execSQL(CREATE_TBL);
}
public void insert(ContentValues values) {
SQLiteDatabase db = getWritableDatabase();
db.insert(TBL_NAME, null, values);
db.close();
}
public Cursor query() {
SQLiteDatabase db = getWritableDatabase();
Cursor c = db.query(TBL_NAME, null, null, null, null, null, null);
return c;
}
public void del(int id) {
if (db == null)
db = getWritableDatabase();
db.delete(TBL_NAME, "_id=?", new String[] { String.valueOf(id) });
}
public void close() {
if (db != null)
db.close();
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
}
}
存入数据库内容
String name = "lin"
- String url = "http://www.cnblogs.com/CaptainLin"
- String desc = "test"
- ContentValues values = new ContentValues();
- values.put("name", name);
- values.put("url", url);
- values.put("desc", desc);
- DBHelper helper = new DBHelper(getApplicationContext());
- helper.insert(values);