android 数据库sqlite的使用方法

直接上代码，一看便明了

public class DBdao {
	private Context context;
	private static MyOpenHelper mMyOpenHelper;

	public DBdao(Context context) {
		super();
		this.context = context;
		mMyOpenHelper = new MyOpenHelper(context);
	}

	// 插入用户的账号密码
	public void insertUser(String account, String password) {
		SQLiteDatabase db = mMyOpenHelper.getWritableDatabase();
		// 可以此方式执行sql语句，replace into 如果数据库有此id数据则进行更新，否则插入数据
		db.execSQL(
				"replace into users (account,pwd,time) values(?,?,"
						+ System.currentTimeMillis() + ");", new String[] {
						account, password });
		db.close();
	}

	// 删除某用户信息
	public void delUser(String account) {
		SQLiteDatabase db = mMyOpenHelper.getWritableDatabase();
		// 可以将变量直接写在sql语句中
		db.execSQL("delete from users where account='" + account + "' ;",
				new String[] {});
		db.close();
	}

	public class MyOpenHelper extends SQLiteOpenHelper {

		public MyOpenHelper(Context context) {
			// super(context, 数据库名称, factory, version);
			super(context, "test", null, 1);
		}

		// 回调函数:创建数据库
		@Override
		public void onCreate(SQLiteDatabase db) {
			// 见表语句
			db.execSQL("create table if not exists users (account text primary key,pwd text,time long);");
		}

		@Override
		public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
			// TODO Auto-generated method stub
			// 数据库版本更新时，再此处写入语句
		}

	}
}