android-SQLiteDatabase数据库使用

//获取数据库对象或者创建数据库，使用绝对路径
SQLiteDatabase db=SQLiteDatabase.openOrCreateDatabase(this.getFilesDir().toString()+"/ch05.db3",null);
String string_id=id.getText().toString();
String string_password=pasword.getText().toString();
try{//存在表直接插入数据,使用sql语句修改数据
                    db.execSQL("insert into user values (?,?)",new String[]{string_id,string_password});
                }catch (SQLiteException e){//异常处理建表
                    db.execSQL("create table user(" +
                            "id varchar(20)," +
                            "password varchar(20))");
                    db.execSQL("insert into user values (?,?)",new String[]{string_id,string_password});
                }
//查询数据
 Cursor cursor=db.rawQuery("select * from user",null);
                while(cursor.moveToNext()){
                    System.out.println("账号："+cursor.getString(cursor.getColumnIndex("id"))+"密码："+cursor.getString(cursor.getColumnIndex("password")));
                }