Android SQLite使用demo

Android SQLite使用demo

1.建立dbhelper类:
Context context;
public static int DB_VERSION = 1;
public static String DB_NAME = "d_weather.db";
public static String TABLE_NAME = "t_weather";

/**
* 构造方法
*
* @param context
* @param name
* @param factory
* @param version
*/
public SQLiteDataHelp(Context context, String name, CursorFactory factory,
int version) {
super(context, name, factory, version);
// SQLiteOpenHelper子类必须要的一个构造函数
}

/**
* 构造方法
*/
public SQLiteDataHelp(Context context) {
// 必须实现父类构造方法
this(context, DB_VERSION);
}

public SQLiteDataHelp(Context context, int version) {
// 必须实现父类构造方法
this(context, DB_NAME, null, DB_VERSION);
}

@Override
public void onCreate(SQLiteDatabase db) {
// 数据库初始化
db.execSQL("create table if not exists " + TABLE_NAME + "("
+ "w_id integer primary key," + "w_name varchar,"
+ "w_temp varchar)");
}

@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
// 当打开数据库时传入的版本号与当前的版本号不同时会调用该方法

}

public void insert(ContentValues contentValues) {
SQLiteDatabase db = getWritableDatabase();
db.insert(TABLE_NAME, null, contentValues);
db.close();
}

/**
*
* query
*
* @return
*/
public Cursor query() {
SQLiteDatabase db = getReadableDatabase();
// 获取Cursor
Cursor c = db.query(TABLE_NAME, null, null, null, null, null, null,
null);
return c;
}

//更新数据库的内容
public void update(ContentValues values, String whereClause, String[]whereArgs){
   SQLiteDatabase db = getWritableDatabase();
   db.update(TABLE_NAME, values, whereClause, whereArgs);
}

// 根据唯一标识_id 来删除数据
public void delete(int id) {
SQLiteDatabase db = getWritableDatabase();
db.delete(TABLE_NAME, "w_id=?", new String[] { String.valueOf(id) });
}

2.调用CRUD方法:
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);
// CRUD操作
// insert
SQLiteDataHelp dbhelp = new SQLiteDataHelp(MainActivity.this);
ContentValues contentValues = new ContentValues();
contentValues.put("w_name", "北京");
contentValues.put("w_temp", "22°C");
// dbhelp.insert(contentValues);
// delete
// dbhelp.delete(1);
// 修改
dbhelp.update(contentValues, "w_name='北京'", null);
// 查询
Cursor cursor = dbhelp.query();
if (cursor.getCount() == 0) {
GlobalConstant.i("no data!!");
} else {
while (cursor.moveToNext()) {
GlobalConstant.i("w_id--->"
+ cursor.getInt(cursor.getColumnIndex("w_id")));
GlobalConstant.i("w_name--->"
+ cursor.getString(cursor.getColumnIndex("w_name")));
GlobalConstant.i("w_temp--->"
+ cursor.getString(cursor.getColumnIndex("w_temp")));
GlobalConstant.i("-----------------");
}
}
}