{"id":882,"date":"2015-07-13T17:47:15","date_gmt":"2015-07-13T09:47:15","guid":{"rendered":"https:\/\/ai.zhousir.top\/?p=882"},"modified":"2016-06-28T16:10:56","modified_gmt":"2016-06-28T08:10:56","slug":"sqlite%e6%95%b0%e6%8d%ae%e5%ba%93","status":"publish","type":"post","link":"https:\/\/ai.zhousir.top\/?p=882","title":{"rendered":"SQLite\u6570\u636e\u5e93"},"content":{"rendered":"

\u6570\u636e\u5e93\u5373\u5b58\u50a8\u6570\u636e\u7684\u4ed3\u5e93,\u4e0d\u7ba1\u662f\u5728PC\u7aef\u8fd8\u662f\u79fb\u52a8\u624b\u673a\u5ba2\u6237\u7aef\u90fd\u975e\u5e38\u91cd\u8981,\u5e94\u7528\u4e5f\u975e\u5e38\u5e7f\u6cdb,\u5982\u624b\u673a\u4e2d\u7684\u901a\u8baf\u5f55\u5e94\u7528,\u77ed\u6d88\u606f\u5e94\u7528,\u65e5\u5386\uff0c\u90ae\u7bb1\u5e94\u7528\u7b49\u90fd\u57fa\u4e8e\u672c\u5730\u6570\u636e\u5e93\u5b58\u50a8\u6570\u636e\u7684.
\n
\nAndroid\u624b\u673a\u4e2d\u4f7f\u7528\u7684\u662fSqlite\u6570\u636e\u5e93,SQLite\u662f\u4e00\u6b3e\u8f7b\u91cf\u7ea7\u7684\u5173\u7cfb\u578b\u6570\u636e\u5e93,\u7531\u4e8e\u5b83\u5360\u7528\u7684\u8d44\u6e90\u975e\u5e38\u5c11\uff0c\u6240\u4ee5\u5728\u5f88\u591a\u5d4c\u5165\u5f0f\u8bbe\u5907\u90fd\u662f\u7528SQLite\u6765\u5b58\u50a8\u6570\u636e.
\nSqlite\u5df2\u5b8c\u5168\u96c6\u6210\u5728Android\u624b\u673a\u4e2d\uff0c\u6240\u4ee5\u6211\u4eec\u5728\u624b\u673a\u4e2d\u4f7f\u7528sqlite\u6570\u636e\u5e93\u65f6\u4e0d\u9700\u8981\u50cfPC\u7aef\u90a3\u6837,\u5148\u5b89\u88c5\u4e00\u4e2a\u6570\u636e\u5e93\u8f6f\u4ef6\u5728\u4f7f\u7528.<\/p>\n

\u547d\u4ee4\u884c\u64cd\u4f5cSQLite<\/h2>\n

Android SDK\u7684tools\u76ee\u5f55\u4e0b\u63d0\u4f9b\u4e86\u4e00\u4e2asqlite3.exe\u5de5\u5177\uff0c\u8fd9\u662f\u4e00\u4e2a\u7b80\u5355\u7684sqlite\u6570\u636e\u5e93\u7ba1\u7406\u5de5\u5177\u3002\u5f00\u53d1\u8005\u53ef\u4ee5\u65b9\u4fbf\u7684\u4f7f\u7528\u5176\u5bf9sqlite\u6570\u636e\u5e93\u8fdb\u884c\u547d\u4ee4\u884c\u7684\u64cd\u4f5c\u3002<\/p>\n

\u7a0b\u5e8f\u8fd0\u884c\u751f\u6210\u7684*.db\u6587\u4ef6\u4e00\u822c\u4f4d\u4e8e”\/data\/data\/\u9879\u76ee\u540d(\u5305\u62ec\u6240\u5904\u5305\u540d)\/databases\/*.db”\uff0c\u56e0\u6b64\u8981\u5bf9\u6570\u636e\u5e93\u6587\u4ef6\u8fdb\u884c\u64cd\u4f5c\u9700\u8981\u5148\u627e\u5230\u6570\u636e\u5e93\u6587\u4ef6.<\/p>\n

\u64cd\u4f5c\u65b9\u5f0f\uff1a<\/p>\n

1.\u6253\u5f00\u547d\u4ee4\u884c\u7a97\u53e3 cmd
\n\u8f93\u5165>adb shell
\n\u8fdb\u5165shell\u64cd\u4f5c\u6a21\u5f0f.<\/span>
\n2.#cd data\/data\/\u9879\u76ee\u540d(\u5305\u540d)\/databases\/
\n\u8fdb\u5165\u5e94\u7528\u6570\u636e\u5e93\u6240\u5728\u76ee\u5f55<\/span>
\n3.#sqlite3 *.db
\n\u6253\u5f00\u6570\u636e\u5e93\uff0c\u8fdb\u5165\u6570\u636e\u5e93\u64cd\u4f5c\u6a21\u5f0f\uff0c\u73b0\u5728\u53ef\u4ee5\u7528\u4ee5\u524d\u7684SQL\u77e5\u8bc6\u8fdb\u884c\u589e\u5220\u6539\u67e5\u64cd\u4f5c\u4e86<\/span>
\n4.sqlite>.tables \/\/\u663e\u793a\u6240\u6709\u8868
\n5.sqlite>select * from talbesname \/\/\u67e5\u8be2\u6570\u636e<\/p>\n

\u53ef\u89c6\u5316\u64cd\u4f5cSQLite<\/h2>\n

\u5bf9\u4e8e\u547d\u4ee4\u884c\u4e3a\u719f\u6089\u7684\u64cd\u4f5c\u8d77\u6765\u8fd8\u662f\u6709\u70b9\u9ebb\u70e6\uff0c\u6ca1\u5173\u7cfbsqlite\u4e00\u6837\u4e3a\u6211\u4eec\u63d0\u4f9b\u4e86\u4e00\u6b3e\u5ba2\u6237\u7aef\u5de5\u5177\u6765\u5bf9\u6570\u636e\u5e93\u8fdb\u884c\u53ef\u89c6\u5316\u64cd\u4f5c.\u5982sqlitebrowser<\/span><\/p>\n

\u4f60\u53ea\u9700\u8981\u901a\u8fc7IDE\u5f00\u53d1\u73af\u5883\u6587\u4ef6\u7ba1\u7406\u5bfc\u51fa\u6570\u636e\u5e93\u6587\u4ef6*.db\u7528sqlitebrowser\u8f6f\u4ef6\u6253\u5f00\u4fbf\u53ef\u64cd\u4f5c.<\/span><\/p>\n

\u4ee3\u7801\u64cd\u4f5cSQLite<\/h2>\n

\u901a\u8fc7\u4e0a\u9762\u7684\u64cd\u4f5c\u6211\u4eec\u5bf9Android\u6570\u636e\u5e93sqlite\u5df2\u6709\u4e86\u4e00\u5b9a\u8ba4\u8bc6\uff0c\u6211\u4eec\u6765\u4e00\u8d77\u770b\u4e0b\u7528\u4ee3\u7801\u6765\u64cd\u4f5c\u6570\u636e\u5e93.<\/p>\n

\u6838\u5fc3\u7c7b\u00a0SQLiteDatabase<\/h3>\n

SQLiteDatabase \u6211\u4eec\u53ea\u8981\u5f97\u5230\u6b64\u7c7b\u5b9e\u4f8b\uff0c\u5c31\u53ef\u80fd\u7528\u4ee5\u524dSQL\u8bed\u53e5\u77e5\u8bc6\u5bf9\u6570\u636e\u5e93\u8fdb\u884c\u64cd\u4f5c\u4e86.<\/p>\n

[java]SQLiteDatabase db = openOrCreateDatabase("scxh1502.db", MODE_PRIVATE,null);
\ndb.execSQL("create table student (id INTEGER NOT NULL,name TEXT,PRIMARY KEY(id))");
\ndb.execSQL("insert into student (id,name) values (1001,’\u5f20\u4e09’)");[\/java]<\/p>\n

\u975e\u5e38\u7b80\u5355\uff0c\u4f46\u4e00\u822c\u6211\u4eec\u4e0d\u91c7\u7528\u4e0a\u8ff0\u65b9\u5f0f\uff0c\u800c\u662f\u901a\u8fc7\u4e00\u4e2a\u53ebSQLiteOpenHelper\u7c7b\u6765\u7ba1\u7406\u548c\u66f4\u65b0\u6570\u636e\u5e93.<\/p>\n

\u6570\u636e\u5e93\u8f85\u52a9\u7c7bSQLiteOpenHelper<\/h3>\n

SQLiteOpenHelper\u662fSQLiteDatabase\u7684\u4e00\u4e2a\u5e2e\u52a9\u7c7b\uff0c\u7528\u6765\u7ba1\u7406\u6570\u636e\u5e93\u7684\u521b\u5efa\u548c\u7248\u672c\u7684\u66f4\u65b0\u3002\u4e00\u822c\u662f\u5efa\u7acb\u4e00\u4e2a\u7c7b\u7ee7\u627f\u5b83\uff0c\u5e76\u5b9e\u73b0\u5b83\u7684onCreate\u548conUpgrade\u65b9\u6cd5\u3002<\/span>
\n\u4f7f\u7528\u65b9\u5f0f:<\/p>\n

[java]public class DataBaseHelper extends SQLiteOpenHelper {
\n private final static String DATABASE_NAME = "android1601.db"; \/\/\u6570\u636e\u5e93\u540d
\n private final static int DATABASE_VERSION = 3; \/\/\u6570\u636e\u5e93\u7248\u672c\u53f7
\n \/\/\u521b\u5efaUser\u7528\u6237\u540dSQL\u8bed\u53e5
\n private static String createUserTabelSQL = "create table " + DataColumn.UserTable.TABLE_NAME_USER
\n + "("
\n + DataColumn.UserTable.COLUMN_NAME_ID + " Integer NOT NULL PRIMARY KEY AUTOINCREMENT,"
\n + DataColumn.UserTable.COLUMN_NAME_NAME + " varchar(20),"
\n + DataColumn.UserTable.COLUMN_NAME_PASSWORD + " varchar(6) "
\n + ")";
\n \/\/\u6dfb\u52a0\u6027\u522b\u5b57\u6bb5sex\u5230User\u8868
\n private static String alterUserAddSexSQL = "Alter table " + DataColumn.UserTable.TABLE_NAME_USER
\n + " add column " + DataColumn.UserTable.COLUMN_NAME_SEX + " varchar(2)";
\n \/\/\u6dfb\u52a0\u7f16\u53f7\u5b57\u6bb5number\u5230User\u8868
\n private static String alterUserAddNumberSQL = "Alter table " + DataColumn.UserTable.TABLE_NAME_USER
\n + " add column " + DataColumn.UserTable.COLUMN_NAME_NUMBER + " Integer";<\/p>\n

private static String createStudentSQL = "CREATE TABLE "+ DataColumn.StudentTable.TABLE_NAME_SUTDENT
\n + "("
\n + DataColumn.StudentTable.COLUMN_NAME_ID + " Integer NOT NULL PRIMARY KEY AUTOINCREMENT,"
\n + DataColumn.StudentTable.COLUMN_NAME_NAME + " varchar(50), "
\n + DataColumn.StudentTable.COLUMN_NAME_AGE + " varchar(3) "
\n +")";<\/p>\n

\/**
\n * \u521d\u59cb\u5316\u6570\u636e\u5e93
\n * \u6570\u636e\u5e93\u540d\u79f0
\n * \u6570\u636e\u5e93\u7248\u672c\u53f7
\n *
\n * @param context
\n *\/
\n public DataBaseHelper(Context context) {
\n super(context, DATABASE_NAME, null, DATABASE_VERSION);
\n Logs.e("DataBaseHelper \u6784\u9020\u65b9\u6cd5");
\n }<\/p>\n

\/**
\n * \u5728\u6570\u636e\u5e93\u7b2c\u4e00\u6b21\u521b\u5efa\u65f6\u6267\u884c
\n *
\n * @param db
\n *\/
\n @Override
\n public void onCreate(SQLiteDatabase db) {
\n db.execSQL(createUserTabelSQL);
\n Logs.e("onCreate \u65b9\u6cd5");
\n }<\/p>\n

\/**
\n * \u7248\u672c\u53f7\u53d1\u751f\u53d8\u5316\u65f6\u6267\u884c
\n * newVersion\u65b0\u7248\u672c\u53f7\u5fc5\u987b\u5927\u4e8eoldVersion\u65e7\u7248\u672c\u53f7
\n * \u6267\u884c\u5b8c\u6210oldVersion = newVersion;
\n *
\n * @param db
\n * @param oldVersion
\n * @param newVersion
\n *\/
\n @Override
\n public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
\n Logs.e("onUpgrade \u65b9\u6cd5 oldVersion: " + oldVersion + " ,newVersion: " + newVersion);<\/p>\n

switch (oldVersion) {
\n case 1: \/\/\u4e3a\u6570\u636e\u5e93\u65e7\u7248\u672c\u53f7\u4e3a1\u5e94\u7528\u6dfb\u52a0\u4e00\u4e2a\u6027\u522bsex\u5b57\u6bb5
\n db.execSQL(alterUserAddSexSQL);
\n case 2: \/\/\u4e3a\u6570\u636e\u5e93\u65e7\u7248\u672c\u53f7\u4e3a1\u5e94\u7528\u6dfb\u52a0\u4e00\u4e2a\u7f16\u53f7number\u5b57\u6bb5\u5e76\u4e14\u65b0\u589e\u4e00\u4e2a\u5b66\u751f\u8868
\n db.execSQL(alterUserAddNumberSQL);
\n db.execSQL(createStudentSQL);
\n }<\/p>\n

}
\n}
\n[\/java]<\/p>\n

[java]\/**
\n * \u5c01\u88c5\u6570\u636e\u5e93\u8868\u5b57\u6bb5
\n *\/
\npublic class DataColumn {
\n \/**
\n * User\u7528\u6237\u8868
\n *\/
\n public static class UserTable implements BaseColumns{
\n public static final String TABLE_NAME_USER = "user";
\n public static final String COLUMN_NAME_NAME = "name"; \/\/\u59d3\u540d
\n public static final String COLUMN_NAME_PASSWORD = "password"; \/\/\u5bc6\u7801
\n public static final String COLUMN_NAME_SEX = "sex"; \/\/\u6027\u522b
\n public static final String COLUMN_NAME_NUMBER = "number"; \/\/\u7f16\u53f7
\n }<\/p>\n

\/**
\n * Student\u5b66\u751f\u8868
\n *\/
\n public static class StudentTable{
\n public static final String TABLE_NAME_SUTDENT = "student";
\n public static final String COLUMN_NAME_ID = "_id"; \/\/ID
\n public static final String COLUMN_NAME_NAME = "name"; \/\/\u59d3\u540d
\n public static final String COLUMN_NAME_AGE = "age"; \/\/\u5e74\u9f84
\n }<\/p>\n

}[\/java]<\/p>\n

SQLiteOpenHelper\u521b\u5efa\u6216\u6253\u5f00\u6570\u636e\u5e93\u6709\u4e24\u4e2a\u65b9\u6cd5 getReadableDatabase()\u521b\u5efa\u6216\u6253\u5f00\u4e00\u4e2a\u53ea\u8bfb\u6570\u636e\u5e93
\ngetWritableDatabase()\u521b\u5efa\u6216\u6253\u5f00\u4e00\u4e2a\u8bfb\u5199\u6570\u636e\u5e93\uff0c\u6211\u4eec\u6765\u770b\u4e0b\u5b83\u4eec\u7684\u533a\u522b:<\/p>\n

getWritableDatabase()\u548cgetReadableDatabase()\u7684\u533a\u522b:<\/span><\/p>\n

getReadableDatabase()\u5e76\u4e0d\u662f\u4ee5\u53ea\u8bfb\u65b9\u5f0f\u6253\u5f00\u6570\u636e\u5e93\uff0c\u800c\u662f\u5148\u6267\u884cgetWritableDatabase()\uff0c\u5931\u8d25\u7684\u60c5\u51b5\u4e0b\u624d\u8c03\u7528\u3002
\ngetWritableDatabase()\u548cgetReadableDatabase()\u65b9\u6cd5\u90fd\u53ef\u4ee5\u83b7\u53d6\u4e00\u4e2a\u7528\u4e8e\u64cd\u4f5c\u6570\u636e\u5e93\u7684SQLiteDatabase\u5b9e\u4f8b\u3002
\n\u4f46getWritableDatabase()\u65b9\u6cd5\u4ee5\u8bfb\u5199\u65b9\u5f0f\u6253\u5f00\u6570\u636e\u5e93\uff0c\u4e00\u65e6\u6570\u636e\u5e93\u7684\u78c1\u76d8\u7a7a\u95f4\u6ee1\u4e86\uff0c\u6570\u636e\u5e93\u5c31\u53ea\u80fd\u8bfb\u800c\u4e0d\u80fd\u5199\uff0c
\ngetWritableDatabase()\u6253\u5f00\u6570\u636e\u5e93\u5c31\u4f1a\u51fa\u9519\u3002getReadableDatabase()\u65b9\u6cd5\u5148\u4ee5\u8bfb\u5199\u65b9\u5f0f\u6253\u5f00\u6570\u636e\u5e93\uff0c
\n\u5018\u82e5\u4f7f\u7528\u5982\u679c\u6570\u636e\u5e93\u7684\u78c1\u76d8\u7a7a\u95f4\u6ee1\u4e86\uff0c\u5c31\u4f1a\u6253\u5f00\u5931\u8d25\uff0c\u5f53\u6253\u5f00\u5931\u8d25\u540e\u4f1a\u7ee7\u7eed\u5c1d\u8bd5\u4ee5\u53ea\u8bfb\u65b9\u5f0f\u6253\u5f00\u6570\u636e\u5e93.<\/p>\n

\u73b0\u5728\u5df2\u7ecf\u80fd\u521b\u5efa\u6253\u5f00\u6570\u636e\u5e93\u548c\u66f4\u65b0\u6570\u636e\u5e93\u4e86\uff0c\u63a5\u7740\u6211\u4eec\u6765\u770b\u4e0b\u5982\u4f55\u7528android\u65b9\u5f0f\u64cd\u4f5c\u6570\u636e\u8868.<\/p>\n

\u4ee3\u7801\u64cd\u4f5cSQLite_\u521b\u5efa\u6570\u636e\u5e93,\u589e,\u5220,\u6539,\u67e5<\/h3>\n

1.\u521b\u5efa\u6570\u636e\u5e93<\/span><\/p>\n

\u8fd9\u91cc\u7279\u522b\u7684\u5730\u65b9\u662f\u901a\u8fc7\u8c03\u7528\u4e86SQLiteOpenHelper\u7c7b\u7684getReadableDatabase()\u65b9\u6cd5\u6765\u5b9e\u73b0\u521b\u5efa\u6253\u5f00\u4e00\u4e2a\u6570\u636e\u5e93\u7684
\n[java]
\n\/**
\n * \u8c03\u7528\u5b9e\u4f8b
\n *\/
\n @Override
\n\tprotected void onCreate(Bundle savedInstanceState) {
\n\t\tsuper.onCreate(savedInstanceState);<\/p>\n

\t\tDatabaseHelper dbHelper = new DatabaseHelper(this);\/\/\u8fd9\u6bb5\u4ee3\u7801\u653e\u5230Activity\u7c7b\u4e2d\u624d\u7528this
\n\t\tSQLiteDatabase db = dbHelper.getReadableDatabase();\/\/\u521b\u5efa\u6216\u8005\u6253\u5f00\u6570\u636e\u5e93\uff0c\u521b\u5efa\u6570\u636e\u5e93\u65f6\u56de\u8c03DataBaseHelper\u7c7b\u4e2doncreate()\u65b9\u6cd5
\n}[\/java]<\/p>\n

SQLiteDatabase\u7c7b\u4e3a\u6211\u4eec\u63d0\u4f9b\u4e86\u5f88\u591a\u79cd\u65b9\u6cd5\uff0c\u800c\u8f83\u5e38\u7528\u7684\u65b9\u6cd5\u5982\u4e0b<\/p>\n

[java](int) delete(String table,String whereClause,String[] whereArgs) \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \/\/\u5220\u9664\u6570\u636e\u884c\u7684\u4fbf\u6377\u65b9\u6cd5
\n(long) insert(String table,String nullColumnHack,ContentValues values) \/\/\u6dfb\u52a0\u6570\u636e\u884c\u7684\u4fbf\u6377\u65b9\u6cd5
\n(int) update(String table, ContentValues values, String whereClause, String[] whereArgs) \/\/\u66f4\u65b0\u6570\u636e\u884c\u7684\u4fbf\u6377\u65b9\u6cd5
\n(void) execSQL(String sql) \u00a0\u00a0 \/\/\u6267\u884c\u4e00\u4e2aSQL\u8bed\u53e5\uff0c\u53ef\u4ee5\u662f\u4e00\u4e2aselect\u6216\u5176\u4ed6\u7684sql\u8bed\u53e5
\n(void) close() \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \/\/ \u5173\u95ed\u6570\u636e\u5e93
\n(Cursor) query(String table, String[] columns, String selection, String[] selectionArgs, String groupBy, String having, String orderBy, String limit) \u00a0\u00a0\u00a0\u00a0 \/\/ \u67e5\u8be2\u6307\u5b9a\u7684\u6570\u636e\u8868\u8fd4\u56de\u4e00\u4e2a\u5e26\u6e38\u6807\u7684\u6570\u636e\u96c6
\n(Cursor) rawQuery(String sql, String[] selectionArgs) \u00a0 \/\/ \u8fd0\u884c\u4e00\u4e2a\u9884\u7f6e\u7684SQL\u8bed\u53e5\uff0c\u8fd4\u56de\u5e26\u6e38\u6807\u7684\u6570\u636e\u96c6\uff08\u4e0e\u4e0a\u9762\u7684\u8bed\u53e5\u6700\u5927\u7684\u533a\u522b\u5c31\u662f\u9632\u6b62SQL\u6ce8\u5165\uff09[\/java]<\/p>\n

\u6570\u636e\u7684\u6dfb\u5220\u6539\u67e5\u5206\u522b\u53ef\u4ee5\u901a\u8fc72\u79cd\u9014\u5f84\u6765\u5b9e\u73b0<\/p>\n

2. \u6570\u636e\u7684\u6dfb\u52a0<\/span><\/p>\n

  • 1.\u4f7f\u7528insert\u65b9\u6cd5<\/li>\n

    [java]ContentValues cv = new ContentValues();\/\/\u5b9e\u4f8b\u5316\u4e00\u4e2aContentValues\u7528\u6765\u88c5\u8f7d\u5f85\u63d2\u5165\u7684\u6570\u636e
    \ncv.put("username","Jack Johnson");\/\/\u6dfb\u52a0\u7528\u6237\u540d
    \ncv.put("password","iLovePopMusic"); \/\/\u6dfb\u52a0\u5bc6\u7801
    \ndb.insert("user",null,cv);\/\/\u6267\u884c\u63d2\u5165\u64cd\u4f5c
    \n[\/java]<\/p>\n

  • 2.\u4f7f\u7528execSQL\u65b9\u5f0f\u6765\u5b9e\u73b0<\/li>\n

    [java]String sql = "insert into user(username,password) values (‘Jack Johnson’,’iLovePopMuisc’);\/\/\u63d2\u5165\u64cd\u4f5c\u7684SQL\u8bed\u53e5
    \ndb.execSQL(sql);\/\/\u6267\u884cSQL\u8bed\u53e5
    \n[\/java]<\/p>\n

    3.\u6570\u636e\u7684\u5220\u9664<\/span><\/p>\n

    \u540c\u6837\u67092\u79cd\u65b9\u5f0f\u53ef\u4ee5\u5b9e\u73b0<\/p>\n

  • 1.\u4f7f\u7528delete\u65b9\u6cd5<\/li>\n

    [java]String whereClause = "username=? and "sex=?";\/\/\u5220\u9664\u7684\u6761\u4ef6
    \nString[] whereArgs = {"Jack Johnson","\u7537"};\/\/\u5220\u9664\u7684\u6761\u4ef6\u53c2\u6570
    \ndb.delete("user",whereClause,whereArgs);\/\/\u6267\u884c\u5220\u9664[\/java]<\/p>\n

  • 2.\u4f7f\u7528execSQL\u65b9\u5f0f\u7684\u5b9e\u73b0<\/li>\n

    [java]String sql = "delete from user where username=’Jack Johnson’";\/\/\u5220\u9664\u64cd\u4f5c\u7684SQL\u8bed\u53e5
    \ndb.execSQL(sql);\/\/\u6267\u884c\u5220\u9664\u64cd\u4f5c[\/java]<\/p>\n

    4.\u6570\u636e\u4fee\u6539<\/span>
    \n\u540c\u4e0a\uff0c\u4ecd\u662f2\u79cd\u65b9\u5f0f<\/p>\n

  • 1.\u4f7f\u7528update\u65b9\u6cd5<\/li>\n

    [java]ContentValues cv = new ContentValues();\/\/\u5b9e\u4f8b\u5316ContentValues
    \ncv.put("password","iHatePopMusic");\/\/\u6dfb\u52a0\u8981\u66f4\u6539\u7684\u5b57\u6bb5\u53ca\u5185\u5bb9
    \nString whereClause = "username=?";\/\/\u4fee\u6539\u6761\u4ef6
    \nString[] whereArgs = {"Jack Johnson"};\/\/\u4fee\u6539\u6761\u4ef6\u7684\u53c2\u6570
    \ndb.update("user",cv,whereClause,whereArgs);\/\/\u6267\u884c\u4fee\u6539
    \n[\/java]<\/p>\n

  • 2.\u4f7f\u7528execSQL\u65b9\u5f0f\u7684\u5b9e\u73b0<\/li>\n

    [java]String sql = "update [user] set password = ‘iHatePopMusic’ where username=’Jack Johnson’";\/\/\u4fee\u6539\u7684SQL\u8bed\u53e5
    \ndb.execSQL(sql);\/\/\u6267\u884c\u4fee\u6539[\/java]<\/p>\n

    5.\u6570\u636e\u67e5\u8be2<\/span><\/p>\n

    \u6570\u636e\u67e5\u8be2\u76f8\u5bf9\u524d\u9762\u51e0\u79cd\u65b9\u6cd5\u5c31\u590d\u6742\u4e00\u4e9b\u4e86\uff0c\u56e0\u4e3a\u67e5\u8be2\u4f1a\u5e26\u6709\u5f88\u591a\u6761\u4ef6<\/p>\n

  • 1.\u901a\u8fc7query\u5b9e\u73b0\u67e5\u8be2\u7684<\/li>\n

    [java]public Cursor query(String table, String[] columns, String selection, String[] selectionArgs, String groupBy, String having, String orderBy, String limit)[\/java]<\/p>\n

    \u5404\u53c2\u6570\u8bf4\u660e\uff1a<\/p>\n

    table\uff1a\u8868\u540d\u79f0
    \ncolums\uff1a\u5217\u540d\u79f0\u6570\u7ec4
    \nselection\uff1a\u6761\u4ef6\u5b50\u53e5\uff0c\u76f8\u5f53\u4e8ewhere
    \nselectionArgs\uff1a\u6761\u4ef6\u8bed\u53e5\u7684\u53c2\u6570\u6570\u7ec4
    \ngroupBy\uff1a\u5206\u7ec4
    \nhaving\uff1a\u5206\u7ec4\u6761\u4ef6
    \norderBy\uff1a\u6392\u5e8f\u7c7b
    \nlimit\uff1a\u5206\u9875\u67e5\u8be2\u7684\u9650\u5236
    \nCursor\uff1a\u8fd4\u56de\u503c\uff0c\u76f8\u5f53\u4e8e\u7ed3\u679c\u96c6ResultSet<\/p>\n

    \u9488\u5bf9\u6e38\u6807\uff08Cursor\uff09\u4e5f\u63d0\u4f9b\u4e86\u4e0d\u5c11\u65b9\u6cd5<\/p>\n

    \u65b9\u6cd5\u540d\u79f0\u00a0 \u65b9\u6cd5\u63cf\u8ff0
    \ngetCount() \u603b\u8bb0\u5f55\u6761\u6570
    \nisFirst() \u5224\u65ad\u662f\u5426\u7b2c\u4e00\u6761\u8bb0\u5f55
    \nisLast() \u5224\u65ad\u662f\u5426\u6700\u540e\u4e00\u6761\u8bb0\u5f55
    \nmoveToFirst() \u79fb\u52a8\u5230\u7b2c\u4e00\u6761\u8bb0\u5f55
    \nmoveToLast()\u79fb\u52a8\u5230\u6700\u540e\u4e00\u6761\u8bb0\u5f55
    \nmove(int offset) \u79fb\u52a8\u5230\u6307\u5b9a\u7684\u8bb0\u5f55
    \nmoveToNext()\u79fb\u52a8\u5230\u4e0b\u4e00\u6761\u8bb0\u5f55
    \nmoveToPrevious() \u79fb\u52a8\u5230\u4e0a\u4e00\u6761\u8bb0\u5f55
    \ngetColumnIndex(String columnName) \u83b7\u5f97\u6307\u5b9a\u5217\u7d22\u5f15\u7684int\u7c7b\u578b\u503c<\/p>\n

    \u5b9e\u73b0\u4ee3\u7801<\/p>\n

    \u65b9\u6cd5\u4e00<\/pre>\n
    [java]
    \nCursor c = db.query("user",null,null,null,null,null,null);\/\/\u67e5\u8be2\u5e76\u83b7\u5f97\u6e38\u6807
    \nif(c.moveToFirst()){\/\/\u5224\u65ad\u6e38\u6807\u662f\u5426\u4e3a\u7a7a
    \n\u00a0\u00a0\u00a0 for(int i=0;i<c.getCount();i++){
    \n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 c.move(i);\/\/\u79fb\u52a8\u5230\u6307\u5b9a\u8bb0\u5f55
    \n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 String username = c.getString(c.getColumnIndex("username");
    \n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 String password = c.getString(c.getColumnIndex("password"));
    \n\u00a0\u00a0\u00a0 }
    \n}
    \n[\/java]<\/p>\n
    \u65b9\u6cd5\u4e8c<\/pre>\n
    [java]
    \nCursor c = db.query("user",null,null,null,null,null,null);\/\/\u67e5\u8be2\u5e76\u83b7\u5f97\u6e38\u6807
    \nwhile(cursor.moveToNext()){
    \n  int id = cursor.getInt(cursor.getColumnIndex("id"));
    \n  String name = cursor.getString(cursor.getColumnIndex("name"));
    \n  String number = cursor.getString(cursor.getColumnIndex("number"));<\/p>\n
       Logs.v("id :"+id + " name :"+name+ " number :"+number);
    \n}
    \n[\/java]<\/p>\n
  • 2.\u901a\u8fc7rawQuery\u5b9e\u73b0\u7684\u5e26\u53c2\u6570\u67e5\u8be2<\/li>\n
    [java]Cursor c = db.rawQuery("select * from user where username=?",new Stirng[]{"Jack Johnson"});
    \nif(cursor.moveToFirst()) {
    \n\u00a0\u00a0\u00a0 String password = c.getString(c.getColumnIndex("password"));
    \n}<\/p>\n
    [\/java]<\/p>\n","protected":false},"excerpt":{"rendered":"
    \u6570\u636e\u5e93\u5373\u5b58\u50a8\u6570\u636e\u7684\u4ed3\u5e93,\u4e0d\u7ba1\u662f\u5728PC\u7aef\u8fd8\u662f\u79fb\u52a8\u624b\u673a\u5ba2\u6237\u7aef\u90fd\u975e\u5e38\u91cd\u8981,\u5e94\u7528\u4e5f\u975e\u5e38\u5e7f\u6cdb,\u5982\u624b\u673a\u4e2d\u7684\u901a\u8baf\u5f55\u5e94\u7528,\u77ed\u6d88 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[7],"tags":[],"_links":{"self":[{"href":"https:\/\/ai.zhousir.top\/index.php?rest_route=\/wp\/v2\/posts\/882"}],"collection":[{"href":"https:\/\/ai.zhousir.top\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ai.zhousir.top\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ai.zhousir.top\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ai.zhousir.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=882"}],"version-history":[{"count":15,"href":"https:\/\/ai.zhousir.top\/index.php?rest_route=\/wp\/v2\/posts\/882\/revisions"}],"predecessor-version":[{"id":1632,"href":"https:\/\/ai.zhousir.top\/index.php?rest_route=\/wp\/v2\/posts\/882\/revisions\/1632"}],"wp:attachment":[{"href":"https:\/\/ai.zhousir.top\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=882"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ai.zhousir.top\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=882"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ai.zhousir.top\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=882"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}