Android 使用SQLiteDatabase操作SQLite数据库(一)

Android 使用SQLiteDatabase操作SQLite数据库(一)

Android 使用SQLiteDatabase操作SQLite数据库（一）AndroidSQLiteDatabaseAPI

(Create)(Retrieve)(Update)(Delete)

SQLiteDatabaseexecSQL()rawQuery()execSQL()deleteupdateCREATE TABLESQLrawQuery()execSQL()JavaJava

1.SQLiteDatabasedb=....;

2.db.execSQL("insertintoperson(name,age)values('3.db.close();

CRUD

insert

select

',4)");

SQL

SQL

SQL

person

insert

SQLSQL

execSQL(String sql, Object[] bindArgs)

(?)

“& ”

SQL

“”

SQL

SQLiteDatabase

javaJava

1.SQLiteDatabasedb=....;

2.db.execSQL("insertintoperson(name,age)values(?,?)",newObject[]{"3.db.close();

",4});

execSQL(String sql, Object[] bindArgs)SQLSQL

SQLiteDatabasejava1.2.3.4.5.6.7.8.9.

Java

rawQuery() select

SQLiteDatabasedb=....;

Cursorcursor=db.rawQuery(“select*fromperson”,null);while(cursor.moveToNext()){intpersonid=cursor.getInt(0);//,Stringname=cursor.getString(1);//intage=cursor.getInt(2);//}

cursor.close();db.close();

rawQuery()

selectnull

selectselect

select

javaJAVA代码

1.Cursorcursor=db.rawQuery("select*frompersonwherenamelike?andage=?",newString[]{"%传智%","4"});

Cursor

moveToNext()falsetrue

Cursor

jdbcCursorJDBCResultSet

moveToPrevious()

falsetrue moveToFirst()falsetrue moveToLast()falsetrue

Android 使用SQLiteDatabase操作SQLite数据库（二）