1.创建SQLiteOpenHelper对象; 参考代码如下: public class DBHelper extends SQLiteOpenHelper{
private final static int VERSION = 1; public DBHelper(Context context,String name,CursorFactory factory, int version) { super(context,name,factory,version); }
public DBHelper(Context context,int verstion){ this(context,null,verstion); } public DBHelper(Context context,String name){ this(context,VERSION); } @Override public void onCreate(SQLiteDatabase db) { Log.i("onCreate","create SQLiteDatabase"); db.execSQL("create table user(id int,user_name varchar(20))");//创建表 }
@Override public void onUpgrade(SQLiteDatabase db,int oldVersion,int newVersion) { Log.i("onUpgrade","onUpgrade SQLiteDatabase"); }
2.使用SQLiteOpenHelper的getReadableDatebase()或者getWritableDatabase()获取SQLiteDataBase对象: 参考代码如下: //创建时会自动调用onCreate()方法; DBHelper dbHelper = new DBHelper(SQliteActivity.this,"test_qq_db"); SQLiteDatabase db = dbHelper.getWritableDatabase(); //更新数据库版本时会自动调用onUpgrade()方法: DBHelper dbHelper = new DBHelper(SQliteActivity.this,"test_qq_db",2); SQLiteDatabase db = dbHelper.getReadableDatabase(); 3.增删改查操作代码如下: //增加数据 ContentValues values = new ContentValues(); values.put("id",1);//id 是列名,1是该列的值 values.put("user_name","qinqin"); SQLiteDatabase db = getObjectDb(); db.insert("user",values); //更新数据 ContentValues values = new ContentValues(); values.put("user_name","huangqin"); // 表名 ContentValues对象 where条件 参数 db.update("user",values,"id = ?",new String[]{"1"}); //查询数据 Cursor cursor = db.query("user",new String[]{"id","user_name"},"id=?",new String[]{"1"},"",""); while (cursor.moveToNext()) { String name = cursor.getString(cursor.getColumnIndex("user_name")); System.out.println(name); }
4.adb验证数据 运行->cmd->adb(如果出现adb不是内部命令。。。,则配环境变量)->adb shell(可以用linux中的命令) ->cd data->cd data->cd 应用程序名称->cd databases->sqlite3 数据库名称 可用.schema查看已经建的表,可以用sql语句查询表中数据。 (编辑:李大同)
【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容!
|