android database

import android.content.Context;
import android.database.SQLException;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteDatabase.CursorFactory;
import android.database.sqlite.SQLiteOpenHelper;


public class DemoDatabaseHelper extends SQLiteOpenHelper {
private static final String DB_NAME = "demo_record.db";
private static final int DB_VERSION = 1;
private String SQL_CREATE_TABLE_DEMO_RECORD = "CREATE TABLE IF NOT EXISTS game_record (" 
+ "'_id' INTEGER  PRIMARY KEY AUTOINCREMENT NOT NULL," 
+ "'propsid' TEXT  NOT NULL," 
+ "'ptype' TEXT NOT NULL,"
+ "'price' TEXT NOT NULL,"
+ "'pnum' TEXT NOT NULL);";
public DemoDatabaseHelper(Context context) {
super(context, DB_NAME, null, DB_VERSION);
}
@Override
public void onCreate(SQLiteDatabase db) {
db.beginTransaction();
try {
db.execSQL(SQL_CREATE_TABLE_DEMO_RECORD);
db.setTransactionSuccessful();
} catch (SQLException exception){
exception.printStackTrace();
} finally {
db.endTransaction();
}
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
}

}

使用

import android.database.sqlite.SQLiteDatabase;
import android.database.Cursor;
public class HelloWorld
{
public static void main(String[] args)
{
// System.out.println("hello");
SQLiteDatabase db = null;
Cursor cursor = null;
DemoDatabaseHelper dbHelper = new DemoDatabaseHelper(mContext);
try {
db = dbHelper.getWritableDatabase();
if(db != null){
db.beginTransaction();
String selectSql = "select pnum from game_record where propsid = ?";
cursor = db.rawQuery(selectSql, new String[]{"1"});
if(cursor != null){
cursor.moveToFirst();
if (cursor.getCount() > 0) {
String pnum = cursor.getString(cursor.getColumnIndex("pnum"));
long newPnum = Long.valueOf(pnum).longValue() + Long.valueOf("10").longValue();
String updateSql = "update game_record set pnum = '" + newPnum + "' where propsid = '" + "1" + "'";
db.execSQL(updateSql);
} else {
String insertSql = "insert into game_record (propsid, price, ptype, pnum) values ('" + "1" 
+ "', '" + "2" + "', '"+ "1" + "', '" + "10" + "')";
db.execSQL(insertSql);
}
}
db.setTransactionSuccessful();
}
} catch (Exception e) {
e.printStackTrace();
} finally {
if(cursor != null)
cursor.close();
if(db != null){
db.endTransaction();
db.close();
db = null;
}
dbHelper.close();
}
}

}