????// ===========sql????????SQLite?????================================

 

public void insert() {
db.execSQL("insert into person(name?? phone?? money) values(??? ??? ?)"??
new Object[] { "????"?? "18666"?? 6000 });
db.execSQL("insert into person(name?? phone?? money) values(??? ??? ?)"??
new Object[] { "С??"?? "18666"?? 6000 });
db.execSQL("insert into person(name?? phone?? money) values(??? ??? ?)"??
new Object[] { "???"?? "18666"?? 6000 });
}
public void delete() {
db.execSQL("delete from person where name = ?"?? new Object[] { "????" });
}
public void update() {
db.execSQL("update person set money = 10000 where name = ?"??
new Object[] { "С??" });
}
public void query() {
// ?α?????????????????????????resultSet??????
Cursor c = db.rawQuery("select * from person"?? new String[] {});
while (c.moveToNext()) {
String name = c.getString(c.getColumnIndex("name"));
String phone = c.getString(c.getColumnIndex("phone"));
System.out.println(name + ";" + phone);
}
}

????// ==============???????api??SQLite?????????======================

 

/**
* api-insert data to table
*/
public void insertApi() {
ContentValues cv = new ContentValues();
cv.put("name"?? "???");
cv.put("phone"?? 15666);
cv.put("money"?? 630);
long id = db.insert("person"?? null?? cv);
System.out.println(id);
}
/**
* api-delete data from table
*
* @return the number of rows affected
*/
public int deleteApi() {
int affectedNum = db.delete("person"?? "name=?"?? new String[] { "С??" });
return affectedNum;
}
/**
* api-update
*/
public void updateApi() {
ContentValues contentValues = new ContentValues();
contentValues.put("name"?? "С??");
contentValues.put("money"?? "10");
// return the number of rows affected
db.update("person"?? contentValues?? "name=?"?? new String[] { "???" });
}
public void queryApi() {
Cursor cursor = db.query("person"?? new String[] { "phone"?? "money" }??
null?? null?? null?? null?? null);
while (cursor.moveToNext()) {
String phone = cursor.getString(cursor.getColumnIndex("phone"));
String money = cursor.getString(cursor.getColumnIndex("money"));
System.out.println(phone + "##" + money);
}
}