sqlite

1. db.insert(String table, String nullColumnHack, ContentValues values);  
2. db.update(String table, Contentvalues values, String whereClause, String whereArgs);  
3. db.delete(String table, String whereClause, String whereArgs);  

1. db.rawQuery(String sql, String[] selectionArgs);  
2. db.query(String table, String[] columns, String selection, String[] selectionArgs, String groupBy, String having, String orderBy);  
3. db.query(String table, String[] columns, String selection, String[] selectionArgs, String groupBy, String having, String orderBy, String limit);  
4. db.query(String distinct, String table, String[] columns, String selection, String[] selectionArgs, String groupBy, String having, 

  db.execSQL("INSERT INTO person VALUES(null, ?, ?, ?)", new Object[]{person.name, person.age, person.info}); 

   Cursor c = db.rawQuery("SELECT * FROM person", null);  

以下为案例，方便以后自己查阅，待续。。。

public class DBHelper extends SQLiteOpenHelper{

    private static final String DATABASE = "test";

    private static final int VERSION =1;

    public DBHelper(Context context) {
        super(context, DATABASE, null, VERSION);
    }

    @Override
    public void onCreate(SQLiteDatabase db) {

        String sql = "Create table student(" +
                " id INTEGER PRIMARY KEY AUTOINCREMENT," +
                " name varchar, age Integer)";

        db.execSQL(sql);

    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {

    }
}

public class MainActivity extends AppCompatActivity {


    SQLiteDatabase sqLiteDatabase;
    SQLiteOpenHelper sqLiteOpenHelper;
    DBHelper db;

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);

         db = new DBHelper(this);
        sqLiteDatabase = db.getWritableDatabase();

    }

    public void createdb(View view){

        Toast.makeText(MainActivity.this,"createDb",Toast.LENGTH_LONG).show();
    }

    public void add(View view){

        ContentValues values = new ContentValues();
        values.put("name", "cdc");
        values.put("age", "12");
        Long uid = sqLiteDatabase.insert("student", null, values);
    }
    public void query(View view){

        Log.v("query","query");

        Cursor cursor = sqLiteDatabase.rawQuery("select * from student", null);

        while (cursor.moveToNext()){
           Log.v("rs",cursor.getString(cursor.getColumnIndex("name")) + "id:" + cursor.getInt(cursor.getColumnIndex("id")) );

        }


//        Cursor cursor = sqLiteDatabase.rawQuery("select * from student where name =?",new String[]{"cdc"} );
//
//        while (cursor.moveToNext()){
//            Log.v("rs",cursor.getString(cursor.getColumnIndex("name")));
//
//        }

        Log.v("query", "query end ");
    }

    public void update(View view){

        ContentValues cv = new ContentValues();
        cv.put("name", "tom");
        sqLiteDatabase.update("student", cv, "id = ?", new String[]{"1"});


    }

    public void delete(View view){

        //String table, String whereClause, String[] whereArgs
        sqLiteDatabase.delete("student","id = ?",new String[]{"1"});

	sqLiteDatabase.delete("student","name = ? AND id = ?",new String[]{"finn","1"});
    }}