sqlite 数据库简单封装示例,使用记事本数据库表进行示例。
首先继承SQLiteOpenHelper 使用sql语句进行创建一张表。
public class noteDBHelper extends SQLiteOpenHelper {
public noteDBHelper(Context context, String name, SQLiteDatabase.CursorFactory factory, int version) {
super(context, name, factory, version);
}
@Override
public void onCreate(SQLiteDatabase sqLiteDatabase) {
String sql="create table if not exists note_data(" +
"note_id integer primary key autoincrement," +
"note_tittle varchar,"+
"note_content varchar,"+
"note_type varchar,"+
"createTime varchar,"+
"updateTime varchar,"