尽管很简单,但是也存下来,以后直接粘过去就能用了。
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);