Android学习笔记(十七)——数据库操作(下)

  //此系列博文是《第一行Android代码》的学习笔记,如有错漏,欢迎指正!

  这一次我们来试一试升级数据库,并进行数据库的CRUD操作,其中, C 代表添加(Create) ,R 代表查询(Retrieve) ,U代表更新(Update) ,D代表删除(Delete) 。每一种操作各自对应着一种 SQL命令。前面我们已经知道,调用 SQLiteOpenHelper的 getReadableDatabase()或 getWritableDatabase()方法是可以用于创建和升级数据库的, 不仅如此, 这两个方法还都会返回一个SQLiteDatabase对象,借助这个对象就可以对数据进行 CRUD 操作了。

一、升级数据库:
  假如我们已经有了一个BookStores用于储存书籍,现在我们想再建一个Category用于储存书籍的分类,代码如下:

 public class MyDatabaseHelper extends SQLiteOpenHelper {
public static final String CREATE_BOOK = "create table Book ("
+ "id integer primary key autoincrement, "
+ "author text, "
+ "price real, "
+ "pages integer, "
+ "name text)";
public static final String CREATE_CATEGORY = "create table Category ("
+ "id integer primary key autoincrement, "
+ "category_name text, "
+ "category_code integer)";
private Context mContext;
public MyDatabaseHelper(Context context, String name, SQLiteDatabase.CursorFactory factory, int version) {
super(context, name, factory, version);
mContext = context;
}
@Override
public void onCreate(SQLiteDatabase db) {
db.execSQL(CREATE_BOOK);
db.execSQL(CREATE_CATEGORY);
Toast.makeText(mContext, "Create succeeded", Toast.LENGTH_SHORT).
show();
}
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
}
}

  当我们启动程序时,会发现Category并没有被建立。因为此时 BookStore.db 数据库已经存在了,之后不管我们怎样点击 Create database 按钮,MyDatabaseHelper 中的 onCreate()方法都不会再次执行,因此新添加的表也就无法得到创建了。

  我们有一个简单而粗暴的方法来解决这个问题:只需要先将程序卸载掉,然后重新运行。这时BookStore.db 数据库已经不存在了,如果再点击 Create database 按钮,MyDatabaseHelper 中的 onCreate()方法就会执行,这时 Category表就可以创建成功了。这种方法显然过于极端,所以我们选择使用onUpdate()方法:

 @Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
db.execSQL("drop table if exists Book");
db.execSQL("drop table if exists Category");
onCreate(db);
}

   onUpgrade()方法中执行了两条 DROP 语句,如果发现数据库中已经存在 Book 表或 Category 表了,就将这两张表删除掉,然后再调用 onCreate()方法去重新创建。这里先将已经存在的表删除掉,是因为如果在创建表时发现这张表已经存在了,就会直接报错。

   为了让onUpgrade()方法能够执行,我们得使用SQLiteOpenHelper 的构造方法里接收的第四个参数,它表示当前数据库的版本号,之前我们传入的是 1,现在只要传入一个比 1 大的数, 就可以让 onUpgrade()方法得到执行了。代码如下:

dbHelper = new MyDatabaseHelper(this, "BookStore.db", null, 2);

  这样我们就能成功新建Category了。启动程序后按下按钮,然后在 adb shell中打开 BookStore.db 数据库,然后键入.table 命令,结果所下所示:

  可以看到此时数据库中有三张表,android_metadata 表是每个数据库中都会自动生成的,不用管它,另外键入.schema 命令便可以查看一下建表语句。

  aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAAp8AAACHCAIAAADfkKWAAAAgAElEQVR4nO2dWXccNdrH60swM1nscO+P8BKSEAhD0lmcLzBZCRM6nATC4qzYCQzlfel2t9vuth2nzJeAod9AFiA4tmM7XMIw4CUz552Zq7l8L6q6WlJJKklV1Yv9/x0OJ66ukh6pVPrrUan0WC+++OLGxsZogIWFhePHj1vNQsou26ktlK+UtrRTdtJtSSUdW4kTtLPRaMh2AgBoZP773//+8ssvq6ur//znP/+P4F//+pf7f59///vf//nPfzY2No4fP/7s2bO7d+/OzMxYrrrncrnmVndgWZZlpexyuVyOT38DxKTuidsJAABNThR1v3v3blXdGYHfqupe0Z1yuRzJr4wrHY38OFKZspNW0MbKF8RL7Pcx1rkfFWrUPmternoT0r+1pZ3a9Hsx02D3MU51JwW+hurelnZqqYNqxDVrXJvZ57a0w80kaZVttHxBvDS7CtasfTaYKlSolD+5sbCgf4tB3WvtH1mW1XD30VjdHceprbrz2wF1NGU3jL4np+4J6L3w4VXpxSLY03D5gniJ/T7WtvesXftsMFWo4FVAgoNh9VrSfd7b2irnpuxQfSc8xEijAdl9JIcb5XLZIS5JqnajqLvjOKy6+wJfG3VvSzteXfpV1yCPSBOpu+TZTVRlGzBfEC9NrYK1bJ+Nqe6et1TtZeMnOXXXupKqf4XRgFI6chvahL/ER8LqXiktT3zJ8RJZIcHjzKjHH11Vnj+/+VUG226NpW33RDfBag0SGfDztdPVGqdHdZXzvXL5PwZuD3PP6LtOdQ5U4eTpiOpBXq7KD4ImFOjEiEKlq4by6kFmD7/eGjFf5hJuSoQx4nbFrVve+Zw+gLzPMdgjbp9q7bn6GEnslBQ6qfuoWy42E8p04fNS+bV27bMG5ZL3MyycIoQMP4Tp+z846bRddtJsLfNPLou6yGAG8vuoJJ9US2eavbpO8fp5z0fnjgfl5ZKlz3Vmg/UQv7q7kOpeJlo9ZWalKMRgSXSce5MCE0ekuldqwXFst+NzzyHrn0yftcH/I5XizPB45apmy5qmqu5hXoCy7y4qV6BADOzsY6CQlV6MWw8Se0TnN1i+VIMTHPYTkrQrLsLz2dte/Tsee8TtU9qeSRsqw2WBnSKSvY+65RIbLHtevGM1bJ+Jl8tgpUDFZ1J63ylKnzTHa8OB33mpB9NT7vfon4QdX0gq5GCMfu5kx4l06Gqjb3B4uWTp8/SUXwIzdf/xxx811D28SL5pElFUUHe/SfjnVo5QB6qpVNsQ3Zr4czOENczwLni+qrqLKkiQDr8eAhYoP8sBByVYD8F06MKED435LmDj5KvePsXtSmwB/3zqQuKPmOwJbZ9M/TDNkB5syAbYLAnfR91yCZ+vkOel1u0z8XKF9TMcAr6TDMmglB3wSE6gy6Gi7pzyKpoWPEfgDrPPXdhxbw5G0D7CsgjPV1hfwfturO6zs7NVdc/n8xJ15+gM23wr5oiO82sh5b8Xcv0hx3FC1J28i+RcCJM4ZQY9fxKzuld/5U8sKaq7qFwhsA4Krx4E82PhvZjg/IbLV6N9xqfubM9Ldtox2CNrn4rtufIX187QAgfTieU+6parmkUwU8nzUvP2WZtySfoZGk4yKh1KMH3edEbgkgjqzitv0C7BkJlNh/B8SaePfe5kx317ZNl5GcjKJU2fc/cE9z02dXdRVfd4fHd/9iNlu8XxHoTqe/MQ393iZURVLjVJJhpr851EoboLKoU7LjPz3dXgjMqFvbygHpTsYcvbQPnWzXcnfqSm8BLx3Ym/lNoz3bdy7ZQUOMn7qFuugG2Vc2TPSx3aZ03KxTtfepbnb4WNBSTpJ63uav1eyFNq8eufcyXlQ0t89zCz2tKOfM18WPoB+BlGUffZ2VlTdRc2SUlT5U2HMelXvoKQ9Kopmzt2DQ7eqqeTXgz5NMocLvae0eOF6tgwzZ+oEKYjOE1YrqqBvIFDsD2wPQ7Zy3DqQWiP5PyGype+k8zhQDsMUfdAPYecn7LLZX++KVZ7hO1T1p6FVcuzk1vexO+jbrnEz5f4ealH+0y6XKH9TICU1sdwwvTZrt1c3Q36vWoWSiMepg6DF7uFkR2vpsPkmrJpN6Pqu/PLFZq+Uj3US90t/ykJTBWJjlM/ME8RM3kk71WpdOiRsZc0UeHEye7xctmprHq2bSYN2tZgt+cZTg/9g6bI0hHXg6BcVvW5YgcJos7NTyC0HsT2CM9vtHzZeuOlRBoTo7r7c06x2yNun7L2LBQmvp38dpXofXTLl1Yul/T54j8vdWmfSZcrtJ9hSel9DCdJP1UtVCqK767c73FMCi0C88hRJunoFPUceXeLU0FKuhaavrwQTjrazDxH3X2Nb+6daENHt9JabgYUx+TIN1GUvCgTYm6fidnZcDRmO9kktAXVHSQJ1N2jurWRStfY7Oqu/zYN+caOyG+JKenYSpygnY1GQ7aTTQPUvcZA3T2oaQ3d1UMA6FCZp0usBcXUPhO3E2wloO41JhF1z+fzeuqessvVNYroSwAAAIBIQN0BAACAzUZS6r64uAh1BwAAAOoC1B0AAADYbNRR3YkPSNOMupPfltakGgAAAIBNRN3UPbCJUVXdBfsYAgAAAECJGNT9+fPn+upO748hmpmHvAMAAAD61EndOTtyQt0BAACAeIhH3cfGxsbGxjTVPdx3xxo7AAAAwICaqLtaLKnqvzmxkgAAAACgSr3UnRNzqXKQHysJAAAAAIrEqe6kxut97w4AAACA+Ihf3V2Bh7oDAAAA9QLqDgAAAGw2ElH3sbGxmNW9SRfY+V/1N6n9AAAAmhOoe5JA3QEAANSDhNXdXxgfcQ28TB1TdpmXB7NhTl2AugMAAKgHtVD3iqpF2HlOqI5BDW9rg7oDAADY2tRS3RmJI/16Uvh4x+lLU7bvo9P71ZO/l7kefUj6/pUCg1QEmo19R6g7Yt8BAACIh5Qt06QaqjvlurelnepfbLy44HEinZTNkWqOWvJ9d076RDLVLLi74apMPgRj3/nqjth3AAAAosPdIo6hhu/dWXeY1Wg7JT/u+b7BoUo1E0kW4nz9f/BqihZi7kxB4Hxm/3zOzDzkHQAAgD6VrdvD55HjUfdCoaDmuxPeMSVvFRkUHVea0iYzEKg7L32/wjjVxawKDJ1U58W+g7oDAACIiitxytIRm7ozAs977078Zei7h8kiebm+784bDGnqMC/2XVDdscYOAACAAXXw3VXUPWX7Rhm/d2fm0FM2UchgboEakL1351YXYbOgmsNi31XfuyP2HQAAgMjU7r17oULI9+6UMcZr5snpCWZ5PKWZVObytfpSwaULEVjSFxb7rjpXgdh3AAAAYqIWa+YLBInsVQcAAAAAZeJXd1fgoe4AAABAvYC6AwAAAJuNRNS9UCgkpO7C79KbhGa3HwAAQFMAda8pCdpPri8MzyG4Wa+aVaLd+5V39RcsdaRt4u9YFPw4QXw+D376evVmar8suUj1KbRfuBZUYgn/fJNyAQDqTQ3UnY3h5uVM9CbVrsTgY7FGiBbTCFSi5xjslcPfApCGuItU2qLjwrxSKd5mxORtpO6oKH1ROrIy8tLXrTdd+0XEVZ9C+9vSjm4jCBlm4EkDoJlIOr47J4abZXG+cCM/d4e6R0O3RuRfVXhptgW2JpAeV7WT3MiQswuQUvoqjUaUPpuOThlU7Bdem1B9xq3uuuUCADQKZur+7Nkzx3EcxwlVd35/wBxl9qoR7RkXmB+Ux4LTiO3GnfelI97Q6UhiylFG8VxQ1hjJ9/f8HfRD0BSptrSjkbhIdSKqEWcPQTq1MHUPyTs0fbVkzO0XoVWf8g0sgjZIh0OcfRr4QZeMygUAqDdR1X3Xrl0bGxv5fD5Hs7Cw0N7e7ktXSFft9xqhblhwtCDocVjHKqRTCkae42wsx+yd54su4fyGeTfs77K9+fz0FWc0Khdp+p9a3XWM6k5WBXN5sMCS9FUcSmn6JvWma7+iYfLjAnXn218dGaqlwz3fuFwAgHpjoO7t7e0rKyszMzMzMzOeumez2Ww2m8lmfObn548dO+bmEfBAA/2x32vEpu66sd2od8+E5AnSEb7rDXsJzJm14PWegf12NTpVnZV7KpPy7AWxqDtTcGN1l6+2E8Xc5Taz4Ht0wZyQif0iYhwtCe57G7kJsmoygnEx1B2A5sFA3Y8ePbq0tDw5OTk5NWW1traur68PDQ0ODg4ODHoMDAzMzc0dOXqUzsuL4VYL353pm1U8s6q8E368KB25nf5Voe8kpDHxjN93qkqDruMuSVpLjTiLMYxm5tUnitVmmDXqTdd+EXG+6RBdpKvJxPmYmQegaTFQ98OHDy8uLhYKhfHxcaulpWVtba27p9sm6e7+/vHjVIq/bskyee9ewcx3V8NTdcqfjdBhcn0pHd/dWN0VO2Ftx92KRY3IWRLqell5Oelz05HZHVqfavVmZL/MrtjUXeEllWoypqsFAQCNgoG6Hzx4cH5+PpPNjo7mrJ07d66urt6+fbvrVldXV1dnZ2dnV1dnV9e33377xhtvcGO4Vf9FvNkmVidpqrtk4Z5uT5Syy046TWsePx2Rnak0xxGXGSt7727YqwZHFcL3rII0Jau3IquRSEHFS9T46eu6kSHpW6pvNAztFxHzqjrRjAQvvJIoHfp8w3IBAOqNgbq//vrrjx//0NfXPzA4aG3fvv3XX3+9evVqx5WOjzo6Ojo6Oq5cuXLl6v379w8cOBBY1s5KPXuUMxMe9OG4L0zlOSjMzPtXhEzzS2fm6eIKulr1NfOyUsuy5ubAWCPx3Dnncz5PqEx0cI+LCNxg5jUFe1CUviyd8BoKDN+UE9G1P9wWjfoU3Ueu/cRx/gMjToczfFauZABAg2Cg7vtfffW77777y18+s+1ua9u2bX//+9/fe+/di5cuXrx48eKlS5cuvXvp3Xfv3bu3f/9+JRPkngQAAAAANDFQ93379j18+Kizs+v27U+s3//+93/729/SF9Ln3z7/5/Pnz58/f/7tt8+/nf7qq/LevfuUzdBZ5w0AAAAAKQbq/vKePffv37967fqNmx9bv/vd737++edz5948c/bMmTNnzp49e/bNN8++ee7LL//68st76l06AAAAYCtioO67d+/++utvPuq4cvXqNeuFF1746aefTp85ffLUyZMnT548derU6dOnz5z94osvdu9+ud6l4+GvV1Je967ztpF8C6r5TZRWXqK1BjHR7HMpzW4/AABExEDdX3rppXv3vv7gw486rlz11P3U6VMnTpz404k/nfAE/swXX3zx0u7d9S4dj2TVnbwwOXU3+l5Kh2ZXx2a3HwAAImKg7v/z0kv37t17/4MPP+q4Yr3wwgs//fzTmTOnT548ceKEK+6nT5+pqHtwDbzxJ0dxwd21RnZywuquZY9u4nWkFvex4SsBAADqhLm6v//BRx0d3nv3N988e/r0qVOnT50+c9p99/7Fl1/u3v2yiTpC3WNMvI5A3QEAoH5EmJn/sKPjirdm/u23z7/11rlz5948d+7cW2+99daf//zXr756ec8eoTp6x6uuvZ2yuB8Bk/035wv5Svr+lTG/gubbKbaH+i24CZ1/hakscfYDoHcFilo/gq+nJfVA3TS3XOL7KLKHbie8rQzJlCTtJPSrf279KJYLAACaBrNVdd98803HlStXr16z/vCHP/zyyy+XLl18550L6fTbFy6kL1y4cOGdd8rl/927b59c3f3OlDpLYTtNUSw1k61V5Yjt5NtDXciquyimiZFVnPxEe96Z1I9AYAP1IN5nh3sfRfaI1V34Bl3uu+vsCahXLgAAaAYM1H3P3r33Hzy4dv36jZs3re3bt/36668dH334wfuXL7/33uXL712+fPny++9//fXX+/fvD/iaVHSWat/Mdudh+8aHx2qLCaGdAnuoC3kbyPNKY2RVaBST6n71Jjnx1J1XXnEGYnUP3QqdyFxcU1rqrlg/KuUCAIBmwEDdX3nllUePHnXdunX79ifWjh07fvvtt87Oj29cv3792rVr165eu3bt6tWr9x88OHDgQNjMfOXPUHXnzEjrf0VmgMhOkT3UhTVUd8VYc+oI4/wIf2XnwsX3MbQ9MCKrMTcgst8sFh+3XAAA0AwYqPtrr732/ePH3d3d3d09VsvOnWtra7b92aeffnL79q3bFbwoMnGpe1zBLXUR2hmmz1J1j2q1pu+euLoT51SNMFf3kJcesvRl9ivUj0q5AACgGTBQ9z/+8Y9zc3ODQ0NDQ8NWa2vL+vr64OBAf39/X29vX29vT29vd0/PYzcCrIG6a8V8i1fdXV8tsJCPa2dIDDrue3fuS2ZDOzXeuyeo7rKYeMKAPzx7qiZ7q9koqRdeIixaxFh8obH+AACgsTFQ90OHDi0sLOTy+Xw+b7W2tm5sbGSz2ZGRkeHhoeHh4aGhocHBwbknT44cOaI6o073n9RFsrXT9VR3vj3UhQFn0ba55xrZGUxCtmZeG1V1l8XE49xHsT3kLLh0zTwzBcJpJxz72dMF9aNWLgAAaHwM1P3IkSNLS0vFYrFYLFq7du16/vx5Pp/P5UZdstlsNpudn184evRovUvXMCT9BgEAAAAgMFD3o8eOLS8vT09PT09Pe+o+NjaWz+dzuZz7/1wut7CwcOzYsXqXrmGAugMAAKghBure3t6+srIyMzMzMzNjtba2uupekfaKui8uQt2rQN0BAADUkBjUfWNjw5uTHx0dzeXc/6DuoAbUeT175PV2qvbXYHSoG83ILLYhAKBWGKj7sWPHVlZW7ty5Mz09bbW0tKyvrw8PDw8PD4+MjIyMZEYymWx2FO/dQQ2AuscG1B2AzYXJe/ejR5eWlkqlUqlUsnbu3Lm+vj4wMNDf3z8wMDAwODg0PDw8PPJEtGbeSYdYJP+OOQaYXcqp7fPYNdIx9ly65Uq8HhLOt1726xLFziS+ldPaJyDmfP29HBQHHDrnAwBqi4G6p1Kpp4tPC4VCYWzM2rlz59raWm9fX29vX19ff3//wODg0NDQ8JMnT1KHD5v0SsmqAmcjmDbW/yB2UIG61z2dpIG6V7OAugOweTBQ94MHD87Pz2cymczIiLVjx461tbWenp7unp6e3t7evj7XhZ+be6Kwm03VX+Z8ZRz41JjwrtnvlbVioPG3yuF+3W3Qq2rFTGM/5q5uhKdVD64ipG33RPazfXG96dS/Rsy02O6juFzasexiqWf6sGuZpHVUBZA65qTb+PaHxtbjlEuWN7eKDAjuAwEAaHgM1P3111+fm5sb6B/o7+v31L3b3Ze2p6ent7evv39gYHBubu7QoUNydac68ZCdaAXbk9LpKMRA8y6Q79JetUFb3TVjpllWWypF6mfITq6CevA3dEvZZcexXSEM7samEBtNlK++lxrHfZSUi2+XuFyx1LMVnNiR1orv1ZJb8cnsF9kjuV8ChOU1AOoOQBNioO6vvvra999/b39mf/aXzyh17/bEvb9/YGBubu7gwYOB9+7US25+jDWxunDON1pVFfCAAl2s331qq7vYoPAZYDoznXrwz+UeCK+38PrXr+g47qO4XBabAtdM/pjEvJ7ZFMPGPBXnPWU7tu14BaAu0FH3sHLJrMCyNwC2GmYx4r799tvbt27f6rrlqbttd9t2d3d3d09vb19ff39//w8//OCru3hmvvJnfWLEuROh3nxwTL47bS07ocuVR3o+Vq46gnoQqqBivYWru7hcskqIeh/N1F2gvjHUM3tyqMq6zntb2rFT7oQE47prqbv6qEJWXgDA1sBA3fft3ffo4aPOjzs7b37MzsxXxD1udU8oRlwlrzjfu9OphM0Ak+XS9ynZcoT57pwS+qkqqDu3XLLTot7H+NQ9nnrWVtm2tFO2066/nrKddIpx3RNTd3F5AQBbAwN137t378MHD2/euHnj+o3qqjrvpXtfn/tl3A/EzLyeuksWvgUPG7wXD1VxUr1009eNmUYdZIqoUQ8SFVSqt9D6N4mZFsN9jFfdo9czlYHn34erbLWNOY7DCDcnc549RuouKK8+eO8OQBNiou579j548ODG9Rs3rl2vfBHnUdF2elUdM8NpWSG9FXURZ8lU+IyuGGZZMj91gSkKU5x08kx/yC0Xla17OeVzKdWDXAXD6y20/qXlEhH9PsY4Mx9LPVNHnXSbwjiHXYWnKuW0Pfoz85LyagN1B6AJMfbdb1y/ceN6Vd3d793d9fKDQ0PDc0+eHEo152Qg+jIAaCrLAwEATYPRe/e9Dx8+/PjmzZs3bjLq7ov78JMnT1JNqu6WZbgWH4BNSehSDABA42GyZn7fK48ePerq7Orq7CRn5vv6+vo2i7oDAAAATYzJ9+7793/37XeffvLJp7c/8dS9r6/f3YbW0/aRzPz8/OHDh/XtIV/witYsN6EbIVwfEFJeAAAAwAADdT9w4MDjx497u3t6unu8KDKDHkPDw8MjI5lMNju/sHDkyBFzuwSTgZtO3ckTmrBcAAAAGhIDdX/jjTeezD0ZGhwaGhy0WlpaNjY2MpnMSCaTyWSyboz3fH5xcTFSBFh1tauXLmrlC3UHAABQQwzU/dChQwsLC7lcLjeas1pbWzc2NkYr5HK5fD5fKBQWnz49duyYuV1QdwAAAMAUA3U/cvjI0tOl4kSxODFhtba2Pn/+fMylUCgUCuPj4xPF4tLSUnt7u2VJYov5PzjpdCCGJKt2mjG1/DSYSxTizCggy5f+SJr6qp2I8cXdjIw9yP0CHwAAAAjFQN2PHj26vLw8NTU1NTVl7dq16/nz5xM+xWKxWCyWSsvLy+3tx8X7bog2hyN/5/myijt30hkEtuWMw00W5cuNzeUJtfeX+4M8NZH9AAAAQCgG6t7e3r6ysjIzMzMzM+Ope0XTXSYnJyeXl5ePHz8uXAZHixlHKKOquyjGF3EghrCYyjHfOHuNOdLUQuwHAAAAJBio+/Hjx589e+Y4juM4Fd+9Iu6Tk5OTk5NTU1MVdbcsi5hipubUk1R33g64wdSITcD1Eao7LzaXrrqr2Q8AAABwMVP3H3/8cXZ2dnZ21nvvPjExUSx64u5O2VPq7kK68Umre9hkdmK+uyA2VzAsWdmWpobJeAAAAOYYq/vnn3/++eefWy2trRsbG2NjhXFa4D11F8YWC7yTNlZ3vRhfRu/d+dfoxHxzUyDXGTBXcsOjYDYeAACAEZHVvaVlfX1jNJfz9L1YKlHqLo4tRiyZT0Xx3bVifJmtmReMCBRjvlWLk7ZJWwJpSdbMY2YeAACABlHV3d2rbiSTzeXHCuPjExPFUqnEn5kXg4+9AQAAgBiJqu47duxYW1sbHBrOjubGxgrj4xPFYmlyEuoOAAAA1I2o6r59+/bV1bW+/kHPfS+MT0wUiS/ilIC6AwAAADESVd23bdu+urra29s/PJIZzeXd5XWlUklL3cMJ3ckVAKBL5H0UQqI6Ndo+DY1mDwBJEl3dt/22utrd0zc0NJIdzbnue5HciTYWoO4AxA7UHYDNSxzq/ttqd0/v4NBwJjvqu++eujO7shhPv0PdawhvOx4xeK3SvCStdkmkH6W9qdiD9gw2CzHMzLu+++DQcCYzOjqay+fHCoXCUzdGHKXKEXZogbrXiJTNDMJSKfSGmxaoe7zpA9BIxLKqbrWnt39oaMQN757L5cfGxrz47pQqMxJN+vXkI8c7Tl8akCAQD5LxFy/2nX6MPvqwnSZ7Utl993OyUxZ3rLdl+2S1mITcbSDcDRioGqXrOZgDNzwjZ2MmNn2J8d42EE66jd1WItB+9GMziu3Rbc/i9AFoUCKr+44dq2trff0Dw8OZTHY0Ozo6msvl8zmOulPSQb2wYzeuCx4n0kkFosWCmJBNrvBj31naMfoEmxTK7jvZ+xIpkj3s1n2hKo1JyNkHOXBSVd059Sx8Ti0iz0B8pmD6IuMrZ6TssuPYrsAHnvhgz6Ecm1Fsj3Z7Fp0PQKMS/Xv3ne737plMdnQ0Nzqac1lcXPDVXTCeZoOm2Cn5cc8X2ZqdeE1Q1MjgpvnqMfroLPyzpPed15NSF2xZx52GjWugVv9VdReM0Xj3xQqkwP07rEH5yVdOpA7wYyRqxWZUskelPYvPB6BRib5XXcv6+nomkx3N5fJVRL472cmwQVPslPg4Mbu25Tvx5JA7JYLFdlox+piT/Qyl953fkVZ76i0+5lOMSeirOFP/oncd/gm8+yI6IEpfgFDdRe0nmEV4PYjs0WnPkvMBaFRi2Gd+Y2PDfddeKBTGKvDeuxOx0Qx9d0yKJYs4dI0g9p2l5rv7cFQn3HcXdKSVa7b0qxqlmIRCFQ9Vd13fXZS+AFXfXWKSWT1Eas/w3UFzEFXdW70YcWPj4+MTExPj4+Pj4+OFQmFxcTGwZt4TD8uyIrx3F87VgjggJ1jY4+S3D6FduGCgEJzMCX/vLuxIU3a57Dhb3nHn3BehqrHKF6Lu2u/dBekLEKt7yEAz8IOofYrs0W3PkvMBaFCiqvuuXbvc+O4TExNFl4mJiYkJ8os4zvSaZQnW4gqOU70PqQogfugpSGadVrlc9mLf0b4M507SNz94tpsOPbMju+8CS7d2Q+DfF4kPTb7kCvXdmRzkqidJX2K8QN0tUfsRtDdh+xTYo9ueJecD0JjEo+7FYrFUKpVKJf8fMe9VBzYlUZe6b92l8k0F50sz/lgBABAfUdX9xRdf/Mc//jFZoVQquf+IeZ95sFloa5O8xdVMCkvlAQBAQMzq7qIb3x1sHahpzyh7jsH5AwAAMfGo+xRBNN+dnMQTrbmGvwYAAADIiFPdSfc9qu8u2jEK6g4AAACEkcjMfHLqHulMAAAAYGsAdQcAAAA2G/GoeynA0tKSp+7U5zDsrpbewXRguzFWs8lUBHtJBjKgPlH1r8BKLAAAAJud2L53Z6h87y76Ipn8Gor3Ml3kkfN3z9CIUeZKPpx9AAAAmxhjdZ+dnZeuba0AAAFdSURBVGX3qiN5+vRpe3u7cBkcLckcgY6q7uIYU/4BaDwAAIBNSjzqPh7A24nWxZ8ip+bUk1R3SYwpJjF8NA0AAGDTYabuz549o9S9EMCLIkNCuvFJq3tYMDn47gAAADYxxuruOM7s7Kyn7mMBvAiwqbQgODQbFs5c3fVilOG9OwAAgM1P0urOCzfmQiyZT0Xx3bVilGmumQ8syfdQTwEAAACoPVHU3XGcMHVXo2E/WYe6AwAAaEbM1H1lZeXu3btQdwAAAKARMVb3mZmZqrorraoTA3UHAAAAYsRM3ZeXl+/cuXP37t141B0AAAAAMWKs7tPT0zMzM1B3AAAAoOGIou537tyBugMAAAANh5m6Ly0tTU1NTU9PQ90BAACAhsNY3Uul0tTUFNQdAAAAaDjM1P3p06elUmlychLqDgAAADQcxupeLBZLpRLUHQAAAGg4zNR9cXFxfHy8WCz+Pxy9Gz/AMdmBAAAAAElFTkSuQmCC" alt="" />

二、添加数据:

   SQLiteDatabase 中提供了一个 insert()方法,这个方法就是专门用于添加数据的。它接收三个参数,第一个参数是表名,我们希望向哪张表里添加数据,这里就传入该表的名字。第二个参数用于在未指定添加数据的情况下给某些可为空的列自动赋值 NULL, 一般我们用不到这个功能, 直接传入 null 即可。 第三个参数是一个 ContentValues 对象, 它提供了一系列的 put()方法重载,用于向 ContentValues 中添加数据,只需要将表中的每个列名以及相应的待添加数据传入即可。现在我们就在BookStores中添加两本书,首先我们添加一个Button元素:

 <Button
android:id="@+id/add_data"
android:layout_width="match_parent"
android:layout_height="wrap_content"
android:text="Add data"
/>

  然后在主活动中修改代码如下:

  Button addData = (Button) findViewById(R.id.add_data);
addData.setOnClickListener(new View.OnClickListener() {
@Override
public void onClick(View v) {
SQLiteDatabase db = dbHelper.getWritableDatabase();
ContentValues values = new ContentValues();// 开始组装第一条数据
values.put("name", "Let's learn Android");
values.put("author", "Doctor ha");
values.put("pages", 454);
values.put("price", 16.96);
db.insert("Book", null, values); // 插入第一条数据
values.clear();// 开始组装第二条数据
values.put("name", "Why I give in learning Android");
values.put("author", "Doctor ha");
values.put("pages", 510);
values.put("price", 19.95);
db.insert("Book", null, values); // 插入第二条数据
}
});

  在添加数据按钮的点击事件里面,我们先获取到了 SQLiteDatabase 对象,然后使用ContentValues来对要添加的数据进行组装。 如果你比较细心的话应该会发现, 这里只对 Book表里其中四列的数据进行了组装,id那一列没并没给它赋值。这是因为在前面创建表的时候我们就将 id 列设置为自增长了,它的值会在入库的时候自动生成,所以不需要手动给它赋值了。 接下来调用了 insert()方法将数据添加到表当中, 注意这里我们实际上添加了两条数据,上述代码中使用 ContentValues 分别组装了两次不同的内容,并调用了两次 insert()方法。

  aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAAqcAAABzCAIAAAAqtzxDAAAgAElEQVR4nO2dW28jyXXH+TG83s3jAgb04g/gxLOakTTS8NXPRuDET0SQi3d3dBfZ3SSbl+ZdGgPJQwIwgWMHcT6BJ3MTKVGUZr+Cg52L4fV6LoYf81B9qao+p7qru0mRmvNDYTBqVp8+den6d126OvfrXx7/6z/XGtX7P/v7n/zFJ999+fJrp1506sVm/ahZc8PF5DS/tZ7LmpXC8OHDYWElc8NzYtn9JwiCIJaCP//5z7/97W9fvHjx+9///g8c3377LfvX549//OObN29ev36d31qfXozbTaPVKLUaJabsTr2YI9VPzAz9z9sPfaKvwMeOe04uxxIAxcSOgxF97Dzsk3gctK+wgwHb18u3pP6rzKXKT9R/wdEYtvD4SdJFEMR1k0b1202j1Sy1GiWnoVR9p37k1MOqLwnM0PWIa2WCJmalMNRtW+K3jzeblRUvD/K25pPFSmEYmelcKQq2sePotfL5leCqwTlcMQolitnH7KjSCNnXzTdd/zGyyk/U/5XCULcSRDx+0J1GEMtEMtW/vBi3HaPdNNrNEuvxtxolhep7wl/3VT/cUvgNiC80XGtFqp8BujmSt6Oz3NMWWRmx43H99K6ct/lyD/6KYz9OpcHsy3Z00hDHf/TcGeVn1qqvmy6CIBaFxKrfcUy+ux+p+q72e6oPtxPS0aD5RBtwfsDA/z08TI2NcUY0VeD4sdCNk+x4fvoeiC1j2B3Q/5B52X7wk0ZbqyleK4WhhnFMjVKqlORzOAlRqh9x7Uj78cwk9x9DKz9ZdYiZDQrVB+2A8ROniyCI6ya96vvCD6l+o8hG/0Oq7+pWRBPutyaR3bbwUwTSEskdsYjGKm/LrZt7LmzHk2P2A9dZjuoNyb8Lw8SY/ZgjIN5Jmv1VrWY8Q9Xns0I6PZxghf04HVCl/ST5put/TMfUxxHVh/0Pnhjj2QHjJ04XQRDXTRrV7zgmG+ePr/pFfjVfqMcaaqf91iQz1RebqxjCwM9tc1KI2EHnkqMmmYFRDqhVlcxojazqrBiMM7gvn5CJ6ksJT6z66lV+/jlx1Cs8T4+MISXxHyPDpyik3FlC9NYXYs/LpPoEsTwkVP3puNMKVJ+FmKo/Cq3hZ6Pc9jz6+lKbHacnF8g+1+/H7Kj99M+KnNuQc8L7WbKvOZ8aVzJ0O/oK01oqBSz2SDTCH3/AOd5ItUa+6fqPkeWMCXaSrlZz8WmEnyCWlpSqzwu/rPqvfNVvqFXfbTVySeb1PZL19ePhqr3Q/03RkIJ9L52+fmLVj9k4a3f0c5moFD+qIpyvSi9gH7Sj8jsyP+PlWyL/VX5lpvoxJrvimkm6SpEgiEUhver7wg+ofgtV/bwdUvfgf9zMObcqSlP1FQsGdVuovP1wWCiIWgjbwfzMF4COu8pZ1bx+wtY2/LSBzuMiNhWrxlKrFKas+NI42L5utzPCfi7uzEhC/zEyXs2HjWAAE2qoHTF+wnQRBHHdJFb9bsvqtixe+5Wq72l/oPrC8Lj8CCAfBUbUw30+cEJWfYUYI/z+GRHTBcoRfjG5SBMcfw2/KtWqS4NXkLxR9PSB+MDrEt7ACHgcI1TA0nSHfBCzr7ITnUOhx7rYRnT9j/ZFIz+xcgT9547DNwxuB3isjp3JBEEsCMlVv20x4e+2LJXqsxBS/Rioex4EQRAEQWiSVPXPum3LF/5o1feFX0P1czm9decEQRAEQShJrPq9drnXLvPj/KDql9KpPkEQBEEQmZFM9a8uPdXnxvkjVL+14Krvr5OKvQ5fZzaTn2XVfHdL61rYWoaMWPaxl2X3nyAIIiUpVZ8X/mjVb324qs+fODvVT/Relw7LrprL7j9BEERKkqt+p9zrlPlxfkD1282St02/qPrhNfmJX43KCnA3HlXkGau+lj+6xq+ReZTjwmcCQRDENZFY9fudSr9T4bv7sOq3RdWfcqqvp5qk+hkav0ZI9QmCIK6PTFSfCb9a9UuxVN89HgwF2Pkc+BIz364Db/h79v0zM57ihv3E/RF+C2+655+RVK6A/QzE3Y7S5g/y9rciH4RCY+nCyxHzR6wn0NaNvCVFPYnctQDMn5jpIgiCWBpSqn6/U2Hj/JjqG0z4/R5/HNX3G1khVoxtRbFv0yXZYlYN7ifsj3CirPrYt2ASeQVcD9vjL0n+IMIbygd8/yCwHDF/cNVHZ+jVfX2dPRD10kUQBLEMJFX9c23VZ8I/hef1ha/aBG223MxH7asf/e27jED9RPwRToQ22IdSk8iryK+/BPv5J7kSpPpQevEL4KofuVU8d3E8p7RUP2b+xEkXQRDEMpCV6vfaZUz1DV/7JdXHR/i9PyNVHxjZ1n/bLQGYn5g/wolzVP2Y3+6LD/p9JPRXeUwdL8fI+iCJr8ZYAuZ/sm8bgukiCIJYBhKr/qBb7XcrvPYjqu9wqt/MWvWz+oioLqifUbqtVP20Xmv29Weu+lycwInkqh8xeaKyr/I/Rv7ESRdBEMQykEb1WWDaj6s+19dvN0vTi6Sqr/UNvWxVn/XtQgsIQT8jvukHzuuDk9gJ/dSY15+h6qu+MYh+KAnyJ3DZXUUnPAKgp6BJS/ltw8hvJxIEQSw2yVT/eUj1+52KWvWNsOpHj8yL7apwkmot93WqPuyPcGKoc2nbYNxEfoZNqNbwaxNX9VXfGATKEfeHH01XruGXhkyAegL4L0dH8ideugiCIBaf2ap+xzE6Di/8hqv6BGPWMxEEQRAEwZFY9Y979qBXDbQfUX2TVF8FqT5BEAQxR2ap+q++7jhm2/EX9DHVH5PqB5DqEwRBEHMkjepLwg+rfscx+B7/Jak+MXuueX196nV+cf2fw1Oj7legkn0rkiCIeZFQ9a9c1eeFH1N90+3xU1+fmBek+plBqk8QN4uZqv6LbsvstEyvx2+0HU/1w2v4r/2be/Iu8cJ2gbKPGbZouumaeT7M+LrX5b8uafycxTt9WvscZHxdfy+KmA8iOvEJgpgvSVV/ctKvScIPqr7lqb6r/bzq67VWs1ULYIObFbm/wu0MQ6p/7XZmDal+cAlSfYK4OaRR/ZN+7bhv+9oPqz7f3W9Hqr57POhfA29Jh4YGuN64/L611jfl4C2AwLfTE7S2Wt+gk19GDzb+08oHphQFm0WUtx3A800n/zW+QZdZOeLp0v42YCb5LB5mnilqRyCMwrFhYQX2P/JbhUC6VNcGsygB4X0sCIJYeFKqPt/jx1Tf6nKD/JcxVF9o3CN25EW2aRXtxPimnHuCehf7wAdt1df8Bl0ut5LP87oasaMtkg/+BnZ5++FwaDOBDO8+F+Nbc9h19Xu1WZSjIl2wX3i6MsnnXHggSJkrfi+Y33pQ5T/mj6K8END0JoBUnyCWkBmrftsSu/vmJTyvL0yiw9+sw1UHiJ9oNVeoxxRqev1mVVv1cYeiR5LFi+nkgx8XPBCdb9H5r5/RWZQjnq6cbAF0E35WSZ7PssWoZyGvs5+3h7Y9dBMgnKCj+lHpUnlBy+0I4kMjver74/yA6vdc1bf8Cf44fX249VT2deQHiFQNGhtQdceVM+rri97KA8OgbIrjumo1QvIBVceY+Rat+ni6VJmQthyTqT6iyhnksxw5Un1ZZ3+lMLTzbABD6uprqX78pw1VegmC+DBIpvpfXU1OBjVB+FHVD4R/Bqo/o2/uedfKcl5ftBI1ksynS78PKqcjqq8PpNC3GkP1wXSpoqUtx+xUP5t81lbflcLwoV1g/fu8PSzkpa7+zFQfTy9BEB8GiVX/waAudfdh1eeE3+y0zMtpUtVXLLgLH04w7x6p7ryq6drX/QadcFBKokY+KNQxVr5F5n+Sb9BlUI7Zqn76fBYu4I4HRKtvUMeGw6Ek6MDFIX8SqT6SXn1oXp8glpBUqi929yNV3+q2LF719UaYpeFVYKlW9MgwjrRMGraOuBJjqFQ0L7WTYLqEy7LThT5arHxQq2N0vkXmvzJdGOnLMcMR/kzyWTg6LKzEeP6RV//FlXjRH/0RfkV6tSHVJ4glJM0I/4NBne/xg6pfZsLvT/C7qr+MUBtHECLeskSCIJaGNH19P7BOf5Tqt5dc9XO5hO8GEMSNJHKpB0EQi0dK1Wc9frXqs2B121a3veyqTxAEQRBLzAz7+q9fveh3yrzw95KrPj+BjK2hXuRuR4T/Cwc3/XvdruhAy9IJgiCUpFf9E+8/kapfTqH6Hsig4sKrvsc1DYrm9bZET71r23VBqk8QBKFk1qpf6XfKvc7MVT9VzHmS3qtEFvRUf/5ZJ70TkW5VOak+QRAERiYj/GrVF4SfVH++qu/KqbflUDxFvSbV598jT3h5Un2CIAglWan+yQCe169wQVR94VVvvpH3fxgWCqEuqixIvBVkj9XQBYA38PPR3+eRQf2H3/BH/FfFl94Lj0wXDvtq8Ep0VGAfgof+cRv+hiF/DvcSPP6tP+y6wlYF8DYB8lbG8nHx1LwdO4cIgiA+DBKq/nO9vn6l36mIfX1sPxFsMzz+d6gdj7mDqXiB0Pak8SUC3Q8lbD/0c/gRAYiPrlTQ74gzs4X4PejwJTyF9ffmEWTWi+v7z6Lbim/iAVeESgWxjx7n7GguZSAIgvggmLHqdytSd//y8iy/tY6KmqgOgFakVX3sm2ncgdiD4FA8wL4igXh8fJRbV/XFTXhjjWggqo88Q3GHVwrDhw/5w+jeeYAdrD8P2Fcef8i+N0/j/ARBEGFmq/qDblUS/svpWTCv77f1wpjsLFUf2wk4bCyOQIb9h+yHTpHlCoivmJ+ew6Q7ovqAP/LDSd5OofpcXx/6OA5nHz3Ob4urnWyCIIibT3LVP248OI6p+pzwe319Dr4fOWvVj1oplmRjcmCwWS1veF8/jp8LpfqZ9vXFZydbYT+qr7+8rx4SBEHMlsSq//Nkqn/FVB/9Vpv8UZLkqq/3zTTNeX38W3MRHzIL+a/2BzIUe6A+MfFVXzGvn0L1WZ4o7MeY11+aHRwIgiDmSVrVP45SfRZ87fdUH/9WG7eEP5+mry8Nn6u/maa7hj/+N/TUI/zK+NLwf2S6MkND9SV3hDX8Cef15RxNvIY/5RflCIIgbiBpVJ8FX/gB1T/u2b7wD3jVj8ccBrMJgiAI4sOBVJ8gCIIgPhSyUH1X+BHV71UHvUD4SfUJgiAI4rpIr/p+jx9WfRb8Hr+W6hMEQRAEkSFZqf7Pjxsh1X9Nqk8QBEEQC8ScVN8d6u9Wry7PSfUJgiAI4lqYqeq/PO7bkvCT6hMEQRDEdTFb1T/p2yei8C+o6if45l5O+4s9BEEQBHG9kOq7JFFwUn2CIAhiqZi16tdO+jY/zv98UVWfQdu5EQRBEDeYeag+L/wLrvqMuN/cIwiCIIilglRfgPr6BEEQxA1mDqpfO+nXZqv62Py6znGa1ycIgiBuPHNSfb+7v6CqT2v4CYIgiA+A+an+yexU//pYKQxp/p8gCIJYFuam+rWTfu2mqT59HYggCIJYKmas+oMbrfoEQRAEsVTMVfVP+vbzq1iqv1IYLmUneqUwTPTK36Kld9b+zNh++lcvmQXGQpVMIvJ2yhdRVwpDVT6ktk8QxNyYreo/GNQfDOq88D+/mgiqjwySL5oKxiVz1Qfzh60iZMS4WKBgUmTcjiL/87YYmzcCKYMcP8p+FkSIlKalpayJAqT6BEF4zEX1B4Dqc52pGKovSkuqdnim7Xh2qo/mj6aicQ2y6JzSDqrKrlui6iu8CccHT0qQb8pyzEyGFkv1kz7NzFqVSfUJYnmYh+o/AFR/ZYU1XXk7vup77Uq6ntxyqD6aP0iGYYjtMfeX2g4s5eyNBamJV6g+GB88KWvVz2wsYaFU33321feHVJ8gCI/5qH4wzi+P8CdRfeghABqnDo0985O14X40ZMe7kH9mRNvmxg9MiV1rdFxe2beWNhbQavXDqs/OjrAD+eO9pRhX9ZH44ElK1eeyjkVRlyOCcFLsLIRUP+SPdDBG/cHridoXVokDh1R2/IPDQsErAlV9Bu8jPtew+SHOPkEQC89yqn7QGAv9ft4YOiAA994QO17L5qtNHNX34/Ner+Tz3jWBNGupPus+x1MvPl2uc3Y+2k7Yn2BngrDqQ0bQ+KB9XPX5X4TM0OuFJ+2Nhq6C+QOXL1Z/8HqiTMKwsCImBbcTciJQfag+o/cRlybBQ9g+QRALz/xUn03wZ6j6D+283CgH0fC+LLo+DrKjO5kgxYe1Bmjk46o+L9waauGpcl54WFLYgfLfi4AIqND2R8WPrfpi+mXBi18ySWeF5Kvg/kjX4nQYmSuJtCMSSLS8VAOyg8zsqPwB76OQBfBvGuEniOVhrqr/YFDPuK8Pd4WVegiqRQI7IFJ8oTUUx6WTqb70t+6sMzbCD/Vo+b/F4WtsUDpIfGT8uKoPGOIHczRl3LcWv0QhOYT9ActXmS4t1eTHmYLomB3JbVH1gSth9R87gNknCGLhWU7VF/riM+/rZ6H6ocmHhKofbm41l/Zxo7IKO6g/OUUTj2RWhn19+WqJ1tlpdfvVfX3YT7mvn4Xqh5cyQCqOqXuk6uv29fWfWgiCWBDmrfpfZaD6efuhoF74vD4qJHA/FZnXz0r1Bf8Tqr5Kut00Y4ImXVZhJ5nqA8lC48ef18es6klNvqDqyCoIZQ3iD1K+Wam+vKIEGYsCBwH42Rw0n3Xn9RH7BEEsPNel+sAybN4tUBWQwWX+N/QH/jfhuDSAIB3NboSfs+6tohM7V2Ftx8aSBVOhq0Ov94OxcTtaqs95CmdUbNUXgQtGnpeIuDbgZCiHlEAjCqA/cPlmo/r8KgnujLB9aKGf9/KKWvVzypoCeQjaJwhi4bnuvj6CSnVuIouW3ln7s2jpJQiC+EAg1V8IFi29pPoEQRA3kgVVfYIgCIIgMmdBVX9Z+4K66wC48xYqvYvS10+an7NG6z2A67DPL2S4hpo16/xJSOr1BxHpovUNxDJwbaqvXoq1aCoYl8xVH1pNFrTo8a4Ex8fWyGH+KOPr+kmqPyf7id9vTH9ZUn2CWEjmrPq1r64m+a21XI7bwRS6kyLWeKdpT2baDman+lxnLfTmGP9aQNTF0PhK4YVVH3tRHfKTy2Ygx0VjwBp1N0Zmqo+8737juSbVnzFJHypmrcqk+sQyMDfVr7Hw3FN9jhi71ghR0nUklkP1sW/u6e6EisfPRvUT+ikZAzYbYm+oZ9zXv5kaqOJGptjtA+ini1SfIBKq/tpXzyc/P67HUX1X7E+88Pzq/B6k+nH6+sDefP4fUAcuNCYNvASP7LYqv6/vnxlxT7vxA1PwJgHx34+PVlN124fHz6ivD3siFWmohCVj/p++GfcInJ/wY2IMFdDSQO6iBf88vgqJ9REb6VDuixACtq+oVwlSDPoD10+s/qP+JPAfzOeINA3p24MEkZQEqn9va+2rK6b6QkBV/2RQOxnYx337uG9fXZ5vbd4RXEiyd5vfmAn9/tDefFALArf8iB3vjvY32Iuj+n583uuMvrnH+7kSY1M0PH7QuEFdeNW8PjbQzx0HHgLkRQXyvIW/1dxDOy8dCOenXGdidrI0VF/auhDaIVFyAJ6y4JMe/ZCG2cfrVQTg8wjkT8bfDIztf0Q+w1kzLKzAWxLFsB+oPnRfo+0JnC7MPkEsMElUf3Ptq6tJePBeVv3fvX55Mqj7kj/o2YNu9erybPPu7eD6SDscR/W9EWBQXTT3b8fs6E4mSPFhMYoxo+GDNDyu+ubjqFhEfLCtUnTs4bYtveoPCyu5vD207aH7v9BDnbzjrNCZjr04MF5pRo2pQHMW0OSJeGb8EWBINZPYkVMcxx+utLD6H+lPXP91x654iZaXrMSzH6g+ki5VvY143KQRfmIZSKD6W5t3nl+en/RrXLBP+jag+uzrusf92qBX7XcqvXb5cjre3PBUH2+E4/b1sQFwRW8IvGgCOyBSfKEVEOcXkqt+7F/jxtd5CkHipxzhdzUzb7N/hoV8YQiN5fP5KT4BJOz5xowYQ/U5L7h+vzhujo6UhIFUM4m6QDKG+APVT6z+R/oT0//IfA6Rp28PEkQ6Eqj+5t3bV5fnxz37uGcPulU/wCP8J/3acc/udyrdltVumheT0cb6Z7lcTt1YR6i+0BefeV8/C9UPTT5kofrZiP4sVF9zNR9TStseeoP7ts3NsCB2uCe/uJmgpfp6ff0cN2Ch2XuFmJHqo/4g9XMeqq+VW+Kjif94omFfqfq6ff3E5UIQ10cS1d+4fTk963eq/U6l36n0OpVeu9xrlwHVZ5I/6Fa7LavdNJq14uT8dP3OrVxUA6xU/bwddFHQeTh8kg28NRE7maq+4H961Q+bUU+MApdFj6tUH7QT8pMrX6CoQ/Y51/mSU7eqefvhw+Ewbkcf9kQRkx9JjqP6TPYL4uIPLNcjmJXqY/4g9XPWqh+Zz2E3QRGOY98d51CqPt6eIClF7BPEApNA9e+ur15Ox712udsqd1tWx7E6jtlxTED1meT32uV202zWirXqwfnZ0zu3fwgMNapVUIoOaF3ED/xvwnFpAEE6mt0IP2c91Tf30NTmBOmMzh3uCuEEAqoPx0f9FH6DHrKg1QrBE1Is1Ree/9QgfUQFQcax8lKqGn8OOJAUzp1of2ei+pg/cP2cuepH5XPoqvAYUxz7Q/r2IEHkcolUf2N9dXox7rasjmO2HbPVNFpNw2kYIdV/9YJJfsexnEapbh9Wy3vj8dPbq38V6ZZyhPkGsmjpnbU/GdmfVytLrfl8oHwmiNmTSPU/m16MO47Zdpjel5r1YrNWFFT/k0+++/rVCyb5rabRrBXtykHZ3B2Pnqx+9peRbi2aCs6aRUvvUqh+/PH6JMZXFLO7RGZQPhPEnEnc12e9fKdRataKDfuobh9Jqv/R61cvOi2r1TSa9WKtelix9szS9uj08We3fnDdqSaWG2+8foYSIQyDL9QT2c2C8pkg5kxi1W85htMwmOTXKge1yoGo+h9/9OrVi5ZjOPVSvXpYtfbLxo5xdH/0LJnq8/Oy0e8PEwRBEAQRJtlqvunFuNU0nHqpYR/VqofV8n7V2gup/suvnUapbh9Vrf2yuWsa26Xi/bR9fWRUl1SfIAiCICJJovobq9OLMevo16uHdnm/bO6WjV1A9d3pfGPXMnbM0rYxM9VPFZMgCIIgPgwSqf5tpvqN2lGtclCx9pimC6r/8ccfvXz5dcM+qlr7JpP80rZRvD8ePSHVJwiCIIhrQVL9N2/evId4+/Ytv0vP9GLsNEoN+8gu75eNXaN03yh+Cah+vXpYMfcMJvml+0bp/nj0ZPXWX+Zy0hvU8vZh7sFCaNs1aK+x0Mu1wEvk/DnCq8n+GbR4mCAIgrjpSKr//v3773//+59++umnn376ve997wc/+MFPf/rTRqPx/v37sOqzVXqWsVM6+rJ4KKv+d16+/LpWPSybu0bxPpN8o7TtvbmHvZnLv70DTdZjPXh494yI7WfDe/nR4ABBEARxgwH7+j/60Y9+/OMfb29vD4fD3/zmN1hfv+69jlc8/PLo4AtR9b/7nZcvv65VDsrmLtN7s7RtlrbHY6b6yPI7UarhrVxTqb64ySb4cQ3SfoIgCOKGEp7XZ8L/+eef/+IXv5hMJkzypX34A9U394zi/aODLw73P8/9+j9Dql89rJh7TO9NY9s0tsfjp8EuPf5QuzA2P0vVD20EDEo8034a8icIgiBuGEz1X758+c033/gL996+ffv+/ftf/epXvuRL39xjq/nq3vj94f7nB3s/C1T/n3jVt/ZMY8fywnj89La0Nx/f7Z+16kd91Yv6+gRBEMQNhqn+7373uz/84Q9/5Hj37t2f/vSnd+/e+UfevHnz9u1bpvqXnupX1Kpfrx5Wy/tlY9cPZ2wf/nwB+Sorp8rgTHt81UeWDmDfQKN5fYIgCOLGw1T/m2++Ybqu4O3bt7zqt5pGwz6qWHtGKTTC76t+wz6yKwcVa88N5p6n+jY6yM4t4c+n6euj39aDvjlGa/gJgiCIDwCm+t9++21Y432l53FVfzpuO0azVrTLB9wa/tC8vruPT+XArhzY5QO7fHB+9uzO7R/GdI5euScIgiCIDGGqHxb4d+/esX8lXr9+vbV553J61nEsp2HU7aOqtWca20bpfrCG/x//7q8//u532I68bKd+P0zOT9fv3IrpHKk+QRAEQWQIU/2wumMw1b+6POu1y23HdOqlun1YLe9X/H34m/b9n/3DTz7++KNXL7/2vsUbhIvJeGP9s5jOkeoTBEEQRIYw1X+tw73NO1eX54Nutdsqtx3T//JeoPqf/8PfsG/udVtWp2V1HNMPz57+xiwd3N1Y5cJtFjY3bm/eFcOGG7w43inroeCdu7V5597mnXuba/e21vJb62nCva21e5tr9zbvbG3e2dq8E7jkXWjLuxB3rbX81pp0YnBuOLBEra9uCOEzFta5sIEE9tPd9dW7G6tgBt7lDa6JAbUPOLMRiuZeFErX3Y3VjfVV/iqI/6sbbvGJzvuFzvmwHvh/iwuCM1It8vOfK6Yg3Ntyy4gvi42gRq16bqxyZRS44SfBrX7QdcWCdpODFpYUwvXHvwu80hHsCL9KGRV22E2d7KF3OlBbuBCqJ1IFuyWVkXjWZ3wm390IbnPFbQIEJJrQUHjNi+p0LuF3wzfgGl97V++uBxmOlS92q4LVPuyh0Natc2W9LjeYdwHPsasrq5xgBPcWcVj0XHY7VJfcezZ814TKUS4O/05nZ21xNwgrC3b/yjemKwpuCxCEzTXJAq8dXlsBSgNgJJwKoeWBdES8l1llu7V+59aaH27/cO32D9fv3Fpfu8U1cXI5Sle/u3F7Y33VtbYmlz5zKfBEbDE2vCadd56lt2wdjUePBj2736322uWOY7Eufe7XvzzhVf/1qxf9TkUK//1f/z569r9Xl2dIOEfC2SULUz+MQ0Gw89wLvBE/cKbCdsaXFyyMphej6WR0MRldTE2jZWsAAAUISURBVE4n5yw888LpxYQPbjQ/TCbPJufPJmdSeOqHcxbGT8+E8MQP4/GT8ejJePR4PHoihLH//8fsV+4s16x0lcnZs3PmgOw5c3s0nYynF264jAxehnt5Hiqp6dnlFLLGnYjmP3MjyHM3087HbuCzyz3op9crHbFoTqeT0XQyml6MphejSy+wwp365RWUrHy68GtQiM/4U0LV49nk/JlfxOdeyfqlyQqLL24xuKnja4Vb3KePx6ePR6ePR6ePx6ePvTrwmPv10ej00emzR6fPHp0+fXT61P3/iA+nLLjWxqePR6ePxqePRqePheOjJ2NWqcYsvaeT89MLNzO5wp2O/eJWBPCe5WqRKvg3rCqCGw280FhsPbi6F6pv52duno/5PB8JuS3cp1zmexkIhzELo1CpSTf4iLt0KGa4tojnAmexaP7Ncs41Pudwm/OEq6Vc2xIOoinxJn0CWRb94ZyZKB1jFtwThZv96eTcPdcvDv+UoHE4fwYEsUGenD2dnD9VtANuMzLxmxG3/k8vxtOLEVjPgyoqVrnL4L7gVWbkNSNc8FrpqdyKjuFbwK3Svp+8OJ4/vzx/fuXLYuDSdOp7Lgro1eSrq8lXV5Px6NH//Po/jvv2cc8edKv9TqXXLvfa5dz//PLk3/6l7tR2vvynv/3kk49efP1/Dwb1456tEfr2Sb920q8d92vHfdsPg5496FUHXTC4zxODbmXQrR73qoNe9bhbPe5Vj3v2MXdWvys8fzCnvWB121a3xYI/MmG0m0arWWo1ik696NSLzdpRs3bYrB069aNm7cipF536Uatx5DSOnEbR8aI59SOnftSsHTZqhw37wA3Vg3r1oF49aFT3Wai7Yc+u7NllL1T8sFst71YtFnbsMgu7XtiplHcq5k7F3GFxvF/37MpevbrnGT+oVffr1YOGfdissX+PnHqx1Si1m6V202g3jU7L7LbNXtvsta0gQzrlXqfc75S5HHOP97tlltWDIJOFwGd1T3zmCxdf3zPV71QG3XK/w8rC7LaMdrPUapRYTjZrhw2bZeB+OLAc9ormkOV/q3HUahRZaDdZYKkudRyj45Q6DvvTjcPOcupHTr3oNIL4vhG/WP3gxm8UnbpggdWThn3QsPdrlb1aZY+VWtXaqVo7FWunau5UraAoq+Ud9lO1vMMVulum1fJuxdqpWDsVc7tsblvGfasUhLIhB6v0pVn60jj6Qgyfm8UvjOIXRvELs/ilH6zSl1Yp+NMscceN+2Vzp2LtVsu7tcp+wz5ssprjGB3H7LYsVmGQGwoIfbkyCPXhuAdXJ3YXH8vRqkiDIHczuGsBwa1vLavTMjuO0WqUnHqxWTusVw9qlX27vFe1divmTtncLhvblnm/bGyXjftlc7tiuaFsesHN/CCw/LT8IBZTxdwWw04obIeDW0+AsFu1xNO5X92aVtmrQYFvVUI2d6vWLniWH+qqX3c546xBc/2pVXZrQkvFB9kx/8RqedcusxP3G3YQ6tV96S6zg5gs8kGzdtDgg9ueCE1KIzDL2u3DRnC/s5bTbzyLHcfoOAZTCvZvt2V2W1a3bXXbVq9tsSaUNWteWxrcDp7cWJ2W2W0xI6zRM1oNo9UosdBuGu2mye64bsvqdSy3ce6W/TtCqv+9Trnbtjots9u2um6jXRl0K8c9+6TvBl8c+ZuXk1EWrfZgUHswqD8Y1B4MaidusI/d0+2fnzT/HxQ/5XQPSRCdAAAAAElFTkSuQmCC" alt="" />

  可以看到两本书都已经储存在数据库里了。(注意,SQL语句句末须加分号)

三、更新数据:

  SQLiteDatabase 中也是提供了一个非常好用的 update()方法用于对数据进行更新,这个方法接收四个参数,第一个参数和 insert()方法一样,也是表名,在这里指定去更新哪张表里的数据。第二个参数是 ContentValues 对象,要把更新数据在这里组装进去。第三、第四个参数用于去约束更新某一行或某几行中的数据,不指定的话默认就是更新所有行。
  接下来我们仍然是在Database项目的基础上修改, 体会一下更新数据的具体用法。比如说刚才添加到数据库里的第一本书,我们现在尝试更新它的价格,首先添加一个button:

 <Button
android:id="@+id/update_data"
android:layout_width="match_parent"
android:layout_height="wrap_content"
android:text="Update data"
/>

  然后在主活动中添加下列代码:

 Button updateData = (Button) findViewById(R.id.update_data);
updateData.setOnClickListener(new View.OnClickListener() {
@Override
public void onClick(View v) {
SQLiteDatabase db = dbHelper.getWritableDatabase();
ContentValues values = new ContentValues();
values.put("price", 10.99);
db.update("Book", values, "name = ?", new String[]{"Let's learn Android" });
}
});

  这里在更新数据按钮的点击事件里面构建了一个 ContentValues 对象,并且只给它指定了一组数据, 说明我们只是想把价格这一列的数据更新成 10.99。 然后调用了 SQLiteDatabase的 update()方法去执行具体的更新操作,可以看到,这里使用了第三、第四个参数来指定具体更新哪几行。第三个参数对应的是 SQL 语句的 where 部分,表示去更新所有 name 等于?的行,而?是一个占位符,可以通过第四个参数提供的一个字符串数组为第三个参数中的每个占位符指定相应的内容。

  运行之后效果如下:

  aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAAqEAAACLCAIAAADeaNdwAAAgAElEQVR4nO2d6V8TybrH+//hP7hnrjrquEZZ/oKRXYiACztJSMLWIGtCgKCe0Zn8FWfuFR33UYGgzltRXAj6ueecV+flfdFJp5d6qrsqHZLA7/vinLFT/dRT1U39+qlV+f79+69mfvv1t7/++quurk4BAAAAwL7zn//85+PHj1++fPn+/fv/GfjnP/+p/a/Ov/71r3//+9+ZTKauru6vv/76zYzy/ft3y6VUKgWNBwAAAEqFnMa/e/fOWeN/+w1xPAAAAFAyvNT4lI0iaXyVP7W2lvJXeW54n6h0/wEAAFQE0hr/66+/liyOr3SNLKL/PnVNxzkHY2q39yiKVgBWSuo6M6GO6mP7ZL7OtM+xQ8G2L1Zvsv7zzBVUn6T/Jkdd2KLTy5QLAFBq5DT+7du39+7dM06wc9R4i5yksvkb2pR8g1LlT4m2JO5bw4NNVVWuDnyq4HdElT/lWOmGp2iyTV0n8/L5qvK55u8xPEbTE6XsU3Z4ZWTZF603Uf8pvKpP0v8qf0r0JXD42MBfGgCVhGca/+3bN8ulX3/99d27d3V1dax2QW8udFkxtE3QeA8QrRGf6lzlOSWx6iB13a2fuZx9qvG55//lxr6bl4ayb7UjUgY3/pP3Fqk+vdZ40XIBAMoFaY3/5Zdf7t69e/fu3Xv37t27d0/59u2b/g+dd+/e1dbWUq2C5Wq+sSSba2NngP67vcOZ6q10aJiYPcGmEM1iJ+en7oG5HbS7w/TfZt5qP/+TQMsqKFVV/pSAcUp7CtQki8/2IjhpvEPejvbdmZH3n0KoPrXXwWU1cDSeaYeZXrpcAIBSI6HxtbW1b9++/fvf//5Ljrt37yrfvn3T/6GT0/isSjk02Hrb4RiS2b8ZiHbHGmQ5NE0+1dqWZe9l28mJr/aDIRB2inSsv5s6fCn7Lns3cjcJxqJCjbaHGm+sCsvt9gJz7LsJLrn2ZepN1H+XjvGvExrP9j//fejODjO9dLkAAKVGTuPfvHlz586dO3fu/D2Hsre3p/37FwNv376tqanRcrJFo7ZWWW87PNN4c+PkQgaMY9IG4SPskGPAToPDjB4MVhtqMSPURyoyr89NN731Bk803lJwaY3nz8XT73GjVfbxdaJ/SMZ/Cg+/mYjnrhVEbBYg9XUMjQegcpDQ+Jqamq2trds5NLFX9vb29H/oym/U+Bxaf7W6H3G8pYV2E6XlRd4Q01N2+H7qdzmOUlhrIvezxb7gOKhbgRAN4jmmhTSJMUlDqq/efdexuz5ngXoT9Z/Cy7EP6iZRZTakR189ABWLtMavrq7eynH79m1lb29Pu2RU/jdv3lRXV1vzrPKn1lKKzHh8Drk43h1ZbTfFtgU0m8y4SiSOl9Z4l02xcBCveKJJxh4T0/288jLsM+3w/HasT3f1JuU/zy/PNN7FsJVbM7JzCQEA5YKExldXV6fT6WQyuZrj1q1byt7ennZJk3mzxvtUm5bn/8sw4m2YuySo8ZxpfaLtkU9dS/n9ZuVj26H89PkZQTnPWd54vGTbav+2IMdfCZucuV0FaxKlo/QENrZ90ZDSwb7idoxD0n8Kj+fcUb0TjKEx0o45vWS5AAClphCN19Bk3qrxmsznNd7U0W0VfOtVRt+4PZ5jDqTyc3DRV6/f4dDxz+2rNxeXaHDdz6vnlZqXNTMHizecKJ6RnrGEIdfpwbxOYXvAloEL60XKPs+Ocw3ZPuJcGxH139kXgfqkniPTf8N19h8MbYfxEe26kgEAZYK0xq+srKysrOgyr2QyGe3fRpln99Uz4UcVAAAAABBEWuOXl5d1TWdr/J07d1hz7jiIzAUHAAAAABe5OXdaHG/qq89kMkbZ1+N4EY0HAAAAgGcUovHWvvqlpSVd5rVQvnw1Xp/N5HpuvMgopHF0VHD1lFBe1BwEj6j0fpVK9x8AAApEWuM1Ndfj9qzGazKv99gfVo033lg8jZdaWSVCpWtkpfsPAAAFIqfxm5uby8vLRplXMplMIpEwhvKrq6tbW1s1NTWMefLSi5O8grnXDS9xkTVeyB9R4yVkP55j2VcCAACUCGmN19U8r/GLi4sWmTdqvJhGQuM9NF5CoPEAAFA6CtR4XeatGq/9kE6neRqfvZ4P81Wfwlw0bGzFGSvqc/b1Oz0emmb7Sftj+s2+gZ1+h6w4MfYPMO8lVGj9EKutOfVgemhauejnSPljfk9Y2yAaLXHeE8ddApj147JcAABQMRSi8UY1VzKZTDwe12V+aWnJpcbrTaoplYsNOanz2WQ2Z+VD+8n2x3SjVeOpE1KkvGLkR+2XJ1M/hMza6oHenYf5HCl/aI0nR9b5cbzIfoJi5QIAgEpAWuN1Kc9q/O7ubjwe12ReU/rl5WWjxjPiIUvLbW3Unfafdz7/zSNIPwl/TDeyNqJnlUbKK8czUfL73svkxNJ4VnnpDGiNd9xS3ZA5XVNCGu+yftyUCwAAKoEC43g9lGdo/NLSkru++tw/HTWe0Uctvt5MAspPyh/Tjfuo8S7Pr3MPeWoQ+au1d5x+jo7vg0VqBfoJKP/lzvdjlgsAACqBQuJ4PZRfWlpSdnd3Y7GYReY3Nze91Hivjs0UhfTTSaW5Gl+o14JxfNE13pAm74S8xjsMg/Ds8/x3UT9uygUAAJWAxxpvkXl5jRc6R85bjdfiNts0P6afDufaMcfjmYPPkn4KjMcXUeN55+yRxwex/Mm7nJ3rZhJ88hayaAWe7+d4fiAAAJQ3BWq8LvN5jTfKvFHjnfvYza2o6Sbe/OpSajzbH9ONtsBRVZlppfy0m+DNqxfGrcbzztljPEfaH2O/OHdevaU7hPGeMPy3Jifqx125AACg/Clc4zWZV3Z3dxcWFiwav7GxUab73JWEYo8pAAAAAAY80fhEIpHVeA1d6aHxJqDxAAAA9hFo/D4CjQcAALCPFFHjY7EYNB7sAyWe817wbDy3/u/DN6Lo2Uhy5yUCAPaLomi8rvTr6+vQeFBsoPGeAY0H4GDhpcbHYjG2xtvn1af8Dn7x1z17gGW3c9PWe9Z51B62X6LlKno9FDnfUvkvSiF+FmNVndC+Ah7nq+/94PKzQyQ9AGB/KaLGLywsGDVerG0qrjYwto+pssYihn1XoPElt1NsoPH5LKDxABwcPNZ4i8w7aHz2ej52ZqxKti1NNkTa1vXNQueqsTfYYa4Gl2hbhc5hsy7+zm+iJ1QPmi74VS2hdZk/XW8i9S9wDptnz5Eul/D5eJ7Us/my5hnn7cjLoOlayl/F9t/xvD5GuXh5M6tIAvu+EQCAsqdY4/Hz8/Pz8/Pr6+vV1dV8jTc15Q572RIbnJrtuDhXLXsDf7f3vA/CGi94DpuiVPl8RhV12AuWqAd9MzifupZKqZoc2ndyc3HeGpWveMTqxXPklIvtF10uT+pZsXfycGtFj3CN2/jx/Kf84TwvArK8EkDjAahAJDS+urp6Y2Nj0YyzxjPCJMtco/09d84WDdkaWr0RFdZ42iHnPmFzZiL1oKdlXnCuN+f6F69oL54jXS7FaoHpJvvLRL6erRadvnxygbxPTalqKlsA0w0iGu9ULp4XmBQHwGFj/zSe7qvP/bM0585pXaPZHmKP4nizt9YuXqZImnto+dpD1AOphS7rzVnj6XLxKqHQ5yin8YQGe1DP1sSOWqsF8lX+lOrTOicsYbyQxrv/tuCVFwBwOCiWxuvj8V5qfJHOncvl5eV4vNmKU5+wsVzi8aW1HE5xPKOEulUXGs8sFy9Zoc/RO433pp6FtbbKn1pT/Vrs7lNTfp8ljC+axtPlBQAcDrzU+JgNd3Pucv+0xVvsaXH2yxLj5Y5abtQwUfui57CZLlqKKFAPHC10VW+O9S9zDpsHz9FbjS+8nk0ZZGN9Z63Nv2OpVMoi34zMWf5IaTxRXnEwHg9ABeLZnLtMJhO3Qa6PX0spikObZbqJMaHKuY+XxjJ1mW2dcMVFp6fZvKVVZJbLlK12uyn+clUPfC10rjfH+ueWi6Lw5+hhX70n9Wy6mvJXufjasc7RcyvoZn/E++o55RUGGg9ABSKt8UtmlEwms2hjY2Ojtra21GWUAi0aAGZykwcBABWDhMbX1tam0+llM0omk1laWrJE95ubm5Wq8YoiOV8fgAOJ4xQNAED5Ia3xK2aUTCajqb0xut/c3Kyrqyt1GQEAAIDDiITG19XVpdPppBllb29PF3w9uk+n01Iabxz4peY1V2BIQc4bcCgvAAAAIIGcxm9tba2a8VbjcxDdgwdO440JKrBcAAAAyhIvNd4Y12tiXySNLyiltwjlC40HAACwj0hr/C0zVo3XZB4ab0sMjQcAALBPyGn8mzdvBDXetLTaKGP6Dym/33Y6pVXzBM/p0m1YbnFxao0LePmaF1WbVsEbzg1jbmRmvchcsQ8AAAA44qXGr9jIaTy1Wwe1sZzxd1Zc63LvT3MGto09vQiZqXyZ531l5Tr7L+0HvjXKfwAAAMARz/rq9bVzRnIaT0ySM0saQy4L1Xjq3DDDBQ8O3HR9jhxjn7IU15qD/wAAAAAHz+bcZTKZhA3THjh6p7Opl72YGs/aQ9duzbCZuDikxrPO+xLVeHf+AwAAAEyk98DJjrknk8lkcnV11XTu3Lzl3DkjxpC+2Brv1L1dtDieOO/LftTZmsq1hu55AAAA8sidO6ftV7+8vJwdd08mld3d3enp6enp6Zsa09PT09OvXr26cOECfV6ZbaxaWuPFzg2TGo9n3yNyjpxmwTj/wHIn87AV9M8DAACQQkLjL1y4sL6+vhCLxePxxURiaWl5aXlZ+fLly8TExNjY2KjG2NjY2PiLFy/OnTvPO6/MMK3eV0gcL3RumNy8euK7wOU5cvni+FWjLzZbnHn16KsHAAAggITGnz9//uWrl9MzM7Nzc/MLC/H4YiKRUD5//jw8HAqFgoFAIBAIBIPBUCj09OnT06dPu3QFi8MBAAAAD5HQ+DNnzjx/8WJ8YkKdnJqemZmbn4/F48rOzk5fX19vb293d/f1GzdudHf39PT88cejEydOunQFGg8AAAB4iITG//TTT0+fPg1HItHR0XFVvTk9PTc/r3z8+PHq1a7Ozs4rV674/f4rHR2dnZ1rDx4cO3bMpSvQeAAAAMBDJDT++PHjjx4/HgwEgsPD0ZHRCXVyemZW+fDhg9/f3tZ2ubm5uampqbmlpbX18v/87//+938f8cxZx71gAQCiFLzvgsMZUeW2r0O5+QNAMZHQ+GPHjj18+LC3r29gaCgUDo+OjU9O3VS2t7dbW1uam5oaGhrq6+vr6+sbGht///33v/3wg2fOQuMB8BxoPAAHFwmNP3r06IOHD290d/f29weCocjIyIQ6qWxvb7c0Nzc2Nly6dOnnn3/++eefL9XX/+Mf//ivv/3NupeLdIc8NH4fYW3iQ4OBlsql2JpXDPuFvG9u/MH7DA4KEhp/5MiRBw8eXL9xo6e3bzAQCEei4xMTyvb2dmtLS1NTY319/aWfL9XX1zc0NBg1nrEmXhRo/D7hUy2fYj4f2sQDCzTeW/sAlBMyGn9U1/heTePHxieUDx8+tLe3tba2Njc1NTY2NjU1Nzc3//777z/88INZmy1CbYzxjX94rOvmW21CBLyB8xXGOk9P/Nw/82XVb2xPec9dz0n1KcwvvkPbMrs755C5bYS2YYOpRs31bM+BeeQjYzsnq32O89ltI1L+Kus2FLb3R/y8R9of0feZtg9AmSLTV3/s6EOtr76vbygQDEej4xMTysePH7q6Ojs6rvjb29va2trb29vb2+/fv3/kyBH69DTTQJ510zv7dYMdn+0cWuARvI4W9nl6ivC5f8QGh7znbmyDDRaN7ezhHWjlnnPI2EnZliiv8Yx6Jv9OFUOettOe7PYp53MpfOpaKqVqMm/7i7e3HK7Pe6T9EX6fqfQAlCvSc+56env7BwaCoVB0ZGRCVZWdnZ2e7u4b169fu3rt6tWr165du3b9+sOHD3/88UdurG49gkX18a9n45LD2ZTvCy6V0r75vvtz/8xZ6Km4z53VnppuOLRBvBnr+Qju6j+v8cSXGuu5KDYLzH87vVC6+VxC0wX2uYtC5z268sfN+0ynB6BckVw79+hR/8DA0NDQcDg8OjamTk4pnz59GhoaGhwcHOgf6O/vHxgYGBwcfPz48U8//WT7czM2NdYjWFQffd3Q33bom/LiwQ9QiKl4Quf+WRLrGXKfO7s5zbfXh/zLz+U5h7qWW+qfGv3QE7CeC3WBsk9Aajz1/tizcK4Hyh+R95mTHoByRULjT548+eTJk2AoOBweHhkdnVDVm9PTyufPn6PRaCQSCYfD4XA4EolEo9Hnz5+fOXOGPG9NMo5HN1lxoQ/CIc7TU9zF8ToM7XGO44nmNHfPoR68cXXOIanljhovGsdT9gncxvEcl+TqoaD3GXE8qAwkNP706VPPnj+LjkRHR0cnVHXq5s3ZuTnl69evk5OTqqpOZFFVVX358uX58+dZc+W0M1Wlx+PJ3lvgBcbOFut14/oIx4ac+Fywd+w4j8eTzalPXVtLpQ59EM94LqS2WfXPQeOFx+MJ+wS0xjt8btp+oN5Pyh/R95mTHoAyRULjz549++eff6qqOjk1OT09PTs3txCLKbu7u7Ozs7OzszNZZmdnZ1+/fn3x4kVbnxsx7Zo9D9Zw3dQGGbUBeI+5U9Iyi2ttbS17np45rmE8SfPDt6fW7Jh7eXjPnfD0cL8I7OfCiaeNw16OcbwlB772cexznCc0XqHeH+J9I99Pwh/R95mTHoDyRELjfT7f69evZ2dn5+bmFhYWYvH4YiKhZDKZeCwWi8UWFhYWFmKxWCwWj29sbFTX1JS6jKC8KXQ6/OGdTl9RMNaksb8YAADeIaHxF6svbmxsxOPx3PnxS8vLy0omk0nkWFxcXFxMJBKJzc3N2traUpcRlB1VVZzRXUFTmE4PAAAEEhpfU1Ozmd5c1lhZWVlZSSaTFo1PJBKJxNISNB4wMXWEFrJfGQJBAACgkdD42tradDqdTCaTyeRqDiWTycRzxGKxeDy+uLi4ublZI6Pxxm49al52OcduDv6XHQbJLbUrImBqMwAAcJHQ+Lq6uq2trVtmlN3d3TkT8/MLC+vr69XV1fLeUbtNlbvG5yhRP7LgOrKKXYoIjQcAAC5yGv/mzZvbZpSvX79OTU1qqJOTU1NTN6enX716deHCRXnv3GtkeY7KFu6VlAUxjd//qrOss5DOHBoPAABcPNP4z58/RyKRSCQSjkQikcjI6Ojo2NiLF3+eP39e3jtovJiFrHhm94RxqZ8l0njjGkjJ7KHxAADAxTON39nZ6e/vy9E/ODQUCAafPnt25swZRbEsnLHui5m96LeFn1b5MVohdqO0ZWBa0qrfIaoMpP8s+6T/vPSWdcCO5aKpqqoyzVynE9r3Cl3Tr6uuzx/TSunPrlLXEnA9NWmzRail90vILpO33lF+H34AALBveKbxHz9+vHr1atfVrs6urq6rV69dv9HT2/dI26+eXMFsbKRZg+xUiMnec8Nh11TbRpTu239yBbbdvu1n+wcBIz05w0A8yNbM+t1Hx/YscnqqbwZmElXzfmd6cpV1bhidI+upEPbJ6wY7jOEJaDwA4NDjmcZvb2+3tV2+fPlya+vl1stt/isdXVevPXz48PiJE6SEmbWAoQyFajx9bpV+wXV3Nisdwz6ngHR60X25+Z7mtwF11VtBaDzxxWTdt9x4mblPGZEjFasz7HOvr+EcQgAAoPBO49+/b2pqbGxsbGhsbGhsamm93O6/srb24NixY9ms9Jbd1LtaTI1n9EUTQu1GDu3+s+zbbrGKEyM9Z1x5HwbLCY1n+MM6f0yR1XjTdvX2I0IM9snrxg1KhYsNAAAHH880/v37942NDZfqL126dOlSfX1jU3Pr5bb79+8fOXrUlKExRiy2xjvN55LZcJrRbcwXMzqOd+NnWWm8p3G8y3MIna7n5g1A5gEAwIbHGt/Q2FDf0HCpvqGpubm1LafxPr9F5xhzqpmjp+41XuzcM8GxWtJ/p8OnbP7z/WEZKv5m7O41njMeX4DG888h5F3P26Emc0D7AQCHGg/H49+3tDQ3Nzc3NTU1NjW1tLa2tfvvr60dPXqUfYSZhmFava+QON7SEc4/90x0Xj3Hf8Z8eAf/qfSWjnzHcnmGgMZb3DHNq5ccj7fWqPS8+mynjPUOaDwA4BDjmcZ/+LDd3t7W1t7Wevlya1tbu/9KR2fngweG8Xgn9qFbGhwqMBkPAHDI8W7t3IcPXV1dXV1dnV1dHZ2dXdeuXb9x4+Effxw/ftylK9B44CV4nwAAhx4v98Dp7enp6e3p6e3t7unp7evr6+9//PjxyZMnXbqCNhkAAADwEM80/tOnT0M6gUAwFAqGQk+fPTt1+rSjE1X+VEWKO2/c2uG+sipvsf0psn23ix+dLDCnW1QgBU/TJHdk8sg+AGDf8HK/+mg0Go2OjIyMaJvVj46NvXjx4uzZs/nc6N3oKrJl9VzjWfWT1x93OVHpOXY49W9dCMCYwchN72TfCxwkSdBSRb6JJqDxAIAcnmn8ly9fsqfOTU1NTU3dvHnz5s2br1698vl8iilQcqHxlnnXhbS6RW21vdN4qn4M7rsqiaH5tU06Z12n/DG7ZdZ4xw0HHDVeot64pfdMdMpL42W/XYqtwdB4ACoHzzQ+d378fPbw+Pns+fEXL15U9ANSiM1KuBpQWJRWGRpP1Y+5NXVuW6n0DnbYwq3NSrck5mg8Mz3zJq813rN+grLS+OyXrrg/0HgAQA7PND6TySyaSSQSm5ub1dXV+dxkNJ4l+axOZ1svMv/cNt56a9Z5ayyq8vulW9KbnXHdd22pH8b+bvwW367lrL3rbU+B5U9u3ZlbjSfSM2/iaryh6vIfKPRz5NSEeEeQw34G7NPxnN8f+j3h+6K9xOadICk7+kXtPKL8zkDuzw8kznWk7QMAyh4vNX4lx/Jy9j/S6XRtbW0+NzmNzze9jP3OqvJ3sJpyti4SdnLtmO28NQJzeqPXVT5fLk9Gmd1qPEPy+S4Zy5V1zrYNnPE66U9+Zbld41nCSaZn2qcLYvzFdiKd+4hWNtK05UL5w36+1PtDvyfcIpj2FeLbsTmRf+ys95n8OzKUyeQh2z4AoOzxTOP39vZWbWxtbdXV1eVzK0Dj11QfK67Vkgnu907ZER0WsKRnK4vo+HchGq/QGwfyNhRk1T9jJN9WKqOG8dK71njGuXwGVXL/ZGTHd6y50P5Y8jKoLjHq4WjHTF6QrVMpWHaIsRieP9z3yuqh6JgRAKBc8FLjb9++fcuMhxqf8leRw9Uc8WNqg4QdJpb09p3siY7PovXVc63R1y3+mDuiqe7lfOEd07vVeIYhY0eNoGjr1tw/UZb4sf1hPl9uuYQ00tiHlE9O2bG4bdZ4Rk78aR/2C5R9AEDZ463G37FcffPmjQcab4qzix7He6HxtmEEOY0vLH5yLfG0P7xMicryMI635iY1G04opOfH8Ww/rXG8Fxpvn4LA0mxKyx01XjSOF/9GAQCUCZ5p/Ldv3+7cuXPnzh2vNd6n5sMn/ng8KRvsGJQYj/dK403+S2q8sTVmjxWT8sXIlrwuo/E8+/Lj8ZRVMWGhzwl0wFbHhD/E8/VK460zQYh+JmaAb5uGwcpJdDyesA8AKHu813ijzOc0njE12ugEUwOIbmLjb+QPxt9M1y2dA5ar3vXVG6xry8msffDmRpVRP6YmmFFctsZTtUPWGtsfi2uGOwyesivKtcabYT8YY/GI50j5wDLhCKu3gOkP+/l6o/HG2Q2GO+z2WdPxcgtK+BqvOLwRdg+Z9gEAZc/+aLwDPI05iJRbeYvtT7mVFwAADglF0Xhd5qHxTMqtvNB4AAA4kBRL4zVcajwAAAAAPKd4Gn/79u3b1rVzBJUa54mO3xvuK6vylkscL1ufxUZobn4p7BsnIJTgzSp2/UhS8LwBh3JhXgKoBOQ0fmtry7ISPrs+3oKu8fwJU+WmeW7xXONZc77IOXcE7PTUTDbKH256UT+h8ftkX3qFYeHZQuMBKEskNL62tjadTieTyWQyqe9op+zt7d26dcu+z522l21+70/W343DvOtCWo+itnreabwhELOt3TJO1XfKjEzPlVm2xlMLw1l+8tb4WY0x5o1nU3im8cT68gNPiTS+yMh+QhRbg6HxoBKQ0Piampp0Or2cJbszvbK3t5dMJlfMpNPpmpoac44u9oQxJSksSKgMjS/2uXNeabyknxZjPpXVCaD6vI7jD6bi8TiQJc5+8YuXCxoPgJTGV1dXb2xsxOPxePZ0ucTS0pKSyWQSiUQikdAPnWOcO6coLuI8m3baJZ8VnNl6lxmLzol9Sq3r4/U7Hf6Cs+nzptiL8h3Xi+s4aye/paPTexTHsz2xPFLWbj3Gf+v/1M1kr7Drk/1R6KLNF1I8Q6Z+/T7jK2R+H6leDMvSeYdM2fY575VEiZn+sN9P6v0n/ZHwn1nPDmVK4fw9AGSR0PgLFy68fv06d0z8wsJCLBaPK7u7u/Pz8/Pz87Nzc7Nz2V/X19d9Pvt2HqL7oOlNlymmt+1zx2ov2O08YSf396tvVudG4/X0Rq+9OXfO5GeViw3G6PT5powVnvPG46kue8N1huRbJwNYRyD0bdvWVJ/lgr0+re+MywBKQOMNJahibC3EcIA9+GAsuvMnGWWffq8cYH59sPzx+Nw81/471DO7alL+KvaGPy7s5zWe9XdNtifsclH2AShjJDT+3LlzL1++nJyampq6eXN6emZmZnZuTvny5YuqTkxMTIyPj4+Pj09MTKiq+vLly3PnzuVzI1pdNxqf68tlaongPueUHdFhAUt6tvS4GJvQIZqZrNbazotj4ZCe2TJxgnZ2S1a4xqf8VYpPTalqKvtftk84616tpkDZ9RQ+d0/Tqb+ENfrAGgYx3+m+L5elkTJ2rCV241jh62sAAAfGSURBVI/haVHvv6M/bv0X7ZcyCrJ1qok7+3mNJ8rFe28dPi7RVw8qAQmNP3PmzPPnz0dHR0fHxsYnJtTJyampKeXz50/DwyGdcDgcjkSeP39++vTpbFZ0k+s2jqe6sjmRDjNTCTtMLOlNf/PmkQJ5jXf9q9v0It8cRPoC++qzCulTtf9J+X3+FKtX3lifZr2XjGpdJnSh8QYvDDG9uQec7AWxw9JIGS1hiRbhD+v9pN5/R39c+u9YzzZ8OH8PgMKQ0PhTp049ffp0OBwORyLRkRFN6ZWdnZ3e3t7e3t6e3t6e3t6+/v6BwcEnT56cPHlSURR+0+yg8aY4u+hxvBcabxtG8ELjvZH4Ymi84Jw7TRdVNZXrpldVw1gJYcfwnee2EoQ0XiyOVwydEYKRKYsiaTzpD/F+7ofGC9WW+UNE/xgRsM/VeNE4Xvq5AFA6JDT+5MmTT548CQSDwVBoOByORKMjIyPKhw8fOjs7Ojo6rnR0dHR0XL169fqNG3/88cePx48rTs0tV+N9aj78IMfP6MEx5h8iYcdTjTf5X7jG283wBzQZ2ZLXeRrPtGPz0/B8GY/aZt/guvHJ8dtQn7q2lkq5DeLZnnBSGvuE3Wi8JvJ+86QNqtYdKJbGU/4Q72exNd6xnu1uMiXXjf1sHwZX4+n2hCgpYR+AMkZC40+cOPH48ePBoaGhgCbzw5FIRNne3m5tbWlpaWluaWlpbW1rb+/o7Hzw4MHRY8cYnYZ8zbMkZyibww/G30zXLZ0Dlqve9dUbrBd07hxZWsUklM61Y8jBXkCGxrPTk36afmN9UrFmGeS/h1xpvOlrjw8R/3HIV5z2vLgaZryH2Ulkrx1nf4ui8ZQ/7Pez6BrvVM+2XNn9R27sp3D+HgCKIqvxjx4/GhgcHBwaCgQDoVAoHB5W3r9/39TU1NjU2NDY2NjU1NLa2u73319bO3L0qKMT3L7iA0i5lbfY/nhkf7/aVLTd+wPqGYDiI6Xxxx89fjQwODA4NDQUCASDweHhkPL+/fvGxoaGhob6hvqGhobmlpa29vb7a2tHjhxxdKLcNK/YlFt5K0Lj3fe8yxiv4ozKAs9APQOwz8j21efi+EAgGAyEQkHl/fv3zc1NWijflIvj19zF8QBwyPW8F1EQTB3aZfX9dbBAPQOwz8ho/MkTjx8/HgoMBQKBQFDT+ICyvb19+XJra2trS2tLa2tru9/f0dn54OHDY8eOiXtlHE91Xq8LAAAAADsSGv/TTyefPHkSDAVDw6HQcGh4ODQ8HFQ+fPjQkZ1Xf+VKR0eXPq/+x+Py3hH9s9B4AAAAwBG59fHPnj2LRCPRaDQajUSjkWg0rOzs7PT0dHd3d9/o7u7u7u7t6xsYGHj85MmJ7Pp4KcRWP0H1AQAAgDxy+9y9ePF8bHxsfHxsfHxsbGx0bGxU+fz5UzAYDAaDgWAwEAyGQqHhcPjZs+enTp2S9w4aDwAAAMgivV/91NTk1M2pqanJqanJqUlV+fLly9j42NjY2Ojo6Ojo6Nj4+MTExJ9/vjx79qyiWFYsW7fiyl7027YwY+3bZVvMyli0bbzHtBRYvwMTegEAABx0JDTe5/O9fv1qdm52bm52dm52dnZmdnZG+fr168zMzMzMzPT09LR2Us3s7OvXr30+H70S1rh+hjXITkXn7L0pHDZute+Lh8AfAADAAUZC4y9evLi+vh6Lx+LxWDwei8VisdiCkslkFhfj8dwF7Xj5jY2NixcvkpPkzMLM3gS1II03b0/JPHICSg8AAOCAIqHx1dXVm5ubS3kSS0sJZW9vL5lMJpPJlWRyeWVlZWVleXk5nU7X1NRks9I7zU297MXUeNsWukxB15QenfcAAAAOGBIaX1tbm06nV8woe3t7t3Ksrq6u3rq1urq6tbVVW1trytAY0hdb451OtkIcDwAA4AAjofF1dbVbW1urZpS9vb3bOnfuaP+f1XifnziH1KDBzBFy9xpPDPlT54BhPB4AAMCBR0rj67a2tm6ZMWv87du3b9++detWTuNVsrvcMK3eV0gcT54vxzp3S3BevW3afhb3FgAAAID9x0uNT+rkovutra38eLwTZbvEHRoPAACgEpHWeEvQrs2rX1xMJBKJREKbi7e8nE6nq6urXboCjQcAAAA8pJA43qTxX3e/zs7Ozs7Nzc3Nz8/PLywsLMTi6xsbFy5cdOkKNB4AAADwkAL76vMa/+XLF1VV1cnJycnJyampqZvT0zMzr16/Pu/DojQAAACgBHim8Z8/fw5HIpFoNDoyMjo6NjY+MaFOvnz58uzZc6UuIwAAAHAYKXzOXVbjd3Z2BgYHhwKBQDAYDA2HI9HoyOjzF3+ePnO21GUEAAAADiOeafzHnZ2e3t7evr6+/oGBwaFAMBQKR549f3Hq9JlSlxEAAAA4jHi2du7jx4/Xb9zo7unp7unt7e8fGAoEQuGnz5+fOnW61GUEAAAADiOeafyHjx+v3bh+o7u7u6enty+r8c+g8QAAAECJ8D6O7+3r7xsYGAwE0VcPAAAAlBAvNb6nt7evv38gOxwfDkdHMOcOAAAAKBWeafzOzo4m70OBYDA0HI5GR8bGX/z58sxZaDwAAABQAjzT+E+fPgVDodDwcDgciURHRsfGx7X18efOl7qMAAAAwGHEK43/f2umCAvXbI7rAAAAAElFTkSuQmCC" alt="" />  

  可以看到第一本书的价格已被更新了。

四、删除数据:
  SQLiteDatabase 中提供了一个 delete()方法专门用于删除数据,这个方法接收三个参数,第一个参数仍然是表名,这个已经没什么好说的了,第二、第三个参数又是用于去约束删除某一行或某几行的数据,不指定的话默认就是删除所有行。同样的,我们先声明一个button:

 <Button
android:id="@+id/delete_data"
android:layout_width="match_parent"
android:layout_height="wrap_content"
android:text="Delete data"
/>

  接着在主活动中添加如下代码:

 Button deleteButton = (Button) findViewById(R.id.delete_data);
deleteButton.setOnClickListener(new View.OnClickListener() {
@Override
public void onClick(View v) {
SQLiteDatabase db = dbHelper.getWritableDatabase();
db.delete("Book", "pages > ?", new String[]{"500" });
}
});

   我们在删除按钮的点击事件里指明去删除 Book表中的数据, 并且通过第二、第三个参数来指定仅删除那些页数超过 500页的书籍。

   运行效果如下:

  aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAAqUAAABVCAIAAAD/twpVAAAZ7klEQVR4nO2d23MURfvH569ATgEupOqtyo0XXgkKCCLowiapssqirPIOIqwmIEGSbM6BZCGJOW4SSII/q/bCKrnDO5X4Qw7R8Ca7Cf+AHJJsEJGA5eV7Mbuz3T399EzPzmZ3k++nLEpmZ555umfo7zx9eNpovnFjfHy8tbV18+bNT548aW1tbWlpbm5qampqamxsbGhsvHP3zoEDBwwAAAAArDr//vvvw4cPFxYW/vzzz78Ynj9/bv5p8ffff7948SKZTL61a9ePP/1UefLkqdDnX1RVnT5z5syZL43jVzi9b2lpac7IfQ71vjQUm5yMhUp9N7xKFLv/AAAAigIPer/77bd/vnkz9PkXVdXVp8+cOXv27NmzNYZxqNmm900mjU1NjU1Nd+/ePfAe9F4kh/4HIpMWzndgz3Z7jWGYBZCdSR2XnmgRCch94o9L7SvsUMjt69WbV/9V5rKqT9J/zlEXtujzvZQLAJBvPOj9nj17Jn/55fSZL788e7bm3Lmvvjp//vx545BhGHuqJfF9c3Nzc3NzS/O9e/feO/ieYRg2aYmlfGHal0zjUhqK6bYq7lvGtU1paboOAhHNb4rSUMyx0pmnyNmmjpP3CgRKM3fNXMM8Ru6JUvYpO6oyyuzr1puu/xR+1Sfpf2kopvsSOHx44F8aAMWEB73f9+67t279er62traurr6+PhwON4TDxo0bVz5+3TAMgxm/b2lpaWlpbW1ta2trb5+amjr4/kFZG2E1HZbEMO0U9N4HdGskEHGu8rSqiJpIHXfrZ/rOgQj73DN/c2PfzUtD2Rft6JTBjf/ktTmqT7/1XrdcAIBCwYPeH3jvvTt37jQ2NTU3N5t63trSatxIz9fbsmXLwsLChQsX2tvb29rbL1y4cLHjYkdn5++//37o8CGqhRCOZhpOsulmOwms3+2d0lSPpkMjJe0t5kI3wU7aT8sDvk20uyP132ZetJ/5SaOV1ZSt0lBMwzilQ1nqk+CzvQhOeu9wb0f77sx4959Cqz7N18FlNSj0XmpHer7ncgEA8o0HvT906NDU1NTFixcvdnR0dHR0dnZ2dnZm9H7r1i2Li4uRSKSzs7OjszMSiVy6fPny5cvT9+9/8MEHlpg5NN5WO+IYqtm/H4g2SAy+HJqpQERs11LXyu2khdj8gQmQnSIg8XeuU5iy77LXI32RZoyq1YD7qPdsVQiX2wussO8m6FTa91Jvuv67dEx9nNB7uf+Zb0V3dqTney4XACDfeND7Dz74cHp6+vLly11dXV1dXd1d3d1dXRm9L9m6dWlpqaenx/y1p6fn6697v+7tnZmZCQTYYJWNUm0ttNWO+Kb3fEPlQhLYMWxGBAk75Jix02CypGdD1p4KZrT6UXXmBLrpyhcv8EXvhYJ71nv1PD7rGje6ZR+PJ/qNvPhP4eP3E/HczYLozSCkvpSh9wAUDx70/siRI//970xfmv6+vr6+PkbvS0qSS0v9/f19fX29fX39/f0DA4MDg4Ozs7NHjx7l7272aUdWI74XWms30VtG8JlYn7Kj9tO6ynEkQ6yJ9M+Cfc1xU7dioRvcK0xr6ZNkUoen/nz33cvu+qU16k3Xfwo/x0eoi3RVmjkf/fkAFC0e9D4YDM7Ozg7xZPR+27ZtyWRyaGhocHBwcHBwaGgoGh2ODg/HE4lgMCjevzQUm4wZXsbv03iL792R0nku5s2iCZXGWzrxvWe9d9ksawf3hi/6xPakcNeryiuxL7Wj8tuxPt3Vmyf/VX75pvcuhrbcmvE6DxEAUCh40PuysvJEIjHCI+r98PBwNBqNDkWj0eHh4ZGRkZFESu8DEZuuZ/6PGSFn5j1p6r1iSqBu2xSITMZCIV4F5XYoPwMhSbCuclY1fu+xnbV/Z5DjtYRNxbywrPWJ0lR68pvcvm6o6WDfcDsO4tF/Cp/n61G9FpLhM9IOf77HcgEA8o0Hva+oqEgkEld4RL2PRqPp0D8ajUajw8PxeOLo0aBtCr0o/uJRSf+5Pc6TDryq7+CiP9+6wmFwQNmfzxeXaHzdz89XlVp1a+kdBG8U0b3kfMlSiHRniPQ4he0BC4Mb4kHKvsqOcw3ZPuhcG9H139kXjfqknqPUf+a4/B8MbUfyQe26kgEABYJnvb/Kw4/fJ5MDAwP9/f39fX39/f39/f0DAwMzM7OBI0dcOaWONgAAAACgiTe9n5ubG+Nh1+NtXVpa6unu7u6y6O7u7r6fWo/nEp055QAAAABQ4r/em/l2Oi5eNFPutLe3t7dfaG+/MDX12/vvv5/v8gIAAADrEc96f/XqVU7v07yZyp/f3NzY0NAQDjeEGxrCDeGGhjt37uzfX5D74VozoVzPsdcZtWRHUzVXZGndi5qz4BPF3t9S7P4DAECW+Kb3Vny/adOmx48f19XWnv/qq6/Opag5d+7WrVt79+7Nd3ll5Fbv2Qtzp/eeVmvpUOx6Wez+AwBAlmSj9yai3m/cuPHRo0c1Z8+eOX36dHV1dXV1dVV1VVX15OQvb7/zjmS+vecFT34hzaujOjnHeq/lj67xPLIaz7HgKwEAAPKE/3r/2muvPXz4sLqq6ovPQ6FTp06dOnXq5KmTJ0/9/PPNXbt3e9FL6L2PxvMI9B4AAPKHb3pvsWHDhj/++OOLz0OnTp48+VnlZ5WVlZWVJ05U/vTTT2+9tYvUy9TxTPgfCRjSRclsiy5ZsZ+2b13p81C23E/aH+43e+I86wqvQiXJT8DnLcq2fojV3Ip64B6aWS76OVL+8O+JLP0ia0nxnjhmIZDWj8tyAQBA0ZC93ovr7029/zwUOvXZZ59Vnqg8ceLEiRPHj5/48UdnvbeaV+4sF0lBqX3kvCSIVUP7KfeHu1DUe2r3Fk9eSe5H5enzUj+E5Nrqgc4EJH2OlD+03pMj8er4XiePoV65AACgGMiZ3svi+127dtniUW4fmkxrLTbwTvnwnfep8wnST8If7kJZYnxZaTx55bhfSyYPv5c7yfReVl76BrTeO6Z4Z25O15SW3rusHzflAgCAYsA3vTcpOVy1YcOGhw//MIfvmfH7kz//fHO3YvxekS9WGReKnw6ex9ddQvlJ+cNduIp673KfPfeQOxqRv4o96PRzdHwfBNnV6D+g/Pe2D6G0XAAAUAz4Gd9f/Pj1ksNV5ny9L788c+Z09enq6uqqFJOTv7yTnp/vg977tdWnLqSfToqt1PtsvdaM73Ou98w5GSe8673DUInKvsp/F/XjplwAAFAM+K/35nq88+fNxfc152pqampqas7W3Pr/W3v37vWi91r73fmr92Y8Z5siKPXTYf896fi9dLDao58a4/c51HvVfoDk1kYyfzIup+bJceJPXkIWLct9CB33OQQAgMLG//58M99OY2NjY0OacEM4bObX2++2H55vUbmLVPO086n3cn+4C20BZSQiPdeTn3YTqvn52rjVe9V+gJLnSPvD9p0r5+cL3SSS90Tiv3g6UT/uygUAAIWP//H95s2bFxYWLl4waU/90X5hauq3gweRPz9NrscdAAAAAAb/5+dv3bp1cXGxy8b0tNb+eGsd6D0AAIBVxH+9LykpWVpaGhjoT/+XYmZmJhCAvqWB3gMAAFhF/Nf7bdu2JZPJEYbRkdHR0dFEIhEMBvNdXrDGyfPc+axn8rn1fxW+F3X3bfK2ryMAYLXwX++3b9++vLw8xjM+Pj4/P19WVpbv8oI1DvTeN6D3AKwtcqL3T58+/eabb67xPHjwoKKiQjI/P+/744nZ3bmUf6KPPrZluuXKeT3k+L758l+XbPzMxUo9rbwFPt/Xyi3h8hNE53wAwOriv97v2LHj6dOn33777f/xsHqv107lVickqWpKxRiFyfECvc+7nVwDvc/cAnoPwNqhYPQ+dTwTU0tWPdu6A5gIXFw/rbX/mzyZj3S1uYd2Vmu/OHFxeSZ5n1Y9mBoRipgnimkE6HrTqX+N/eJ8e450ubT38fOlnvnDpmeKtyMjidyxWKhU7r/jvoKScqnuLa0iD9jzUgAACp4c6r2Jlt5zzbpDPl0iySpvx8X+b6kL1NnnMz5o673mfnGGURoIsIrqkI+WqAcrCV0gMhmLRUxptGeQc7EvHHVf/UjWj+eoKJfcL7pcvtSzYe/8UdaKFfmy6QNV/lP+KJ4XAVleD0DvAShCvOl9IpG4wqOn95LwSZintLr749miJFujazWo2npPO+Tcb8zfTKcerHOlB5zrzbn+9Svaj+dIl8sQLUjdlH+leK9n0aLTV1A6wA9EYpFILFUA7gIdvXcql8oLTKgDYL2RK723ZP6bNO7689N/zc/+eGb3aaoX2af4nvdW7AaWCibfi6vWIaIeSF10WW/Oek+XS1UJ2T5Hb3pP6LEP9Sye7Ki7ZoBfGopFAmanhRDea+m9++8MVXkBAOsDz3o/mkbUe3N+vjUtfyLN/Px8eXm5b3qfo/3x0vfyc/yet+LUb8yWSz/uFMvhFN9LSmhZdaH30nKpTsv2Ofqn9/7Us7buloZik5GQGdMHIrFQQAjvc6b3dHkBAOsDD3pfXl6eSCQy2XRGR0dHR0W9t2R+PE1q/b0HvVdMqbMf9jC+7qjrrJ7p2tfdL447KBRRox4Uuuiq3hzr38t+cT48R3/1Pvt65m6Q6gNw1t3MOxaLxQQpl9xc5o8nvSfKqw/G7wEoQrzpfTweH05jqr5Dvp2rV6/Ozc0Fg0Ev/clCZ6pkMpZzPzCNMAVabp1wxUXHKG9eaCGl5eJua17OxWWu6kGti8715lj/ynJRZP8cfezP96WeuaOxUKmLLx9xfp9bcef90e/PV5RXG+g9AEWIB70vKyuLx+PRNKbqG729vQ0NDZWVldu2bVteXh7lGRkZSSQSR48ezXd5PYHWDQCe9MRDAEDR4E3vZ2dnhxii0ahx/fr1aDQaDoft+fNNiljvDcPjvH8A1iSOUzoAAIWHB70PBoOzs7ODDENDQxm9LykpSSaTURvxePzIkSP5Li8AAACwHvFF7wcHB3On9+xAMTU/upBDDQf/Cw5mmDffruiAKecAAKDEN70/duxYMBjct29fruJ7ogux4PU+TZ66QAN6qcyzzryWL6D3AACgxDe9t+bn52r83r1eFubgYvZeebKgp/erX3XCeofsZoxD7wEAgMKX+XpDQ0Oc3i8vL1+xkUgkgsGgd0+h93oWUkKaTh7kTkvzpPfsunCPt4feAwCAEv/1Xrr+fmxsLLX+3lDsq2b9EAuFbGGpKEWsFSJDqu0GkhX1AecddURI/+Ur9gn/VecL67wdy0Vj7u1b6nyqJK/ApHU8It9vkL2GWdRO78tH3ZdLPSBf9i8mIhaP85cGIma98VcU3kcgAACsGrnSeyutHptPt6ysjM4MQiW0Y3+XNdgu84/yN7AlF3WvBWRmE7t928/2jwPJ+eSMBP3g2zQbch8122+R1lYryw4nsOlzLf/N0yOK/eskd5Q9FcI+eZyxIxnCgN4DANY9udT7iYmJiQkrkf6DBw/Ky8tJOeN1QaIS2eo9tb8Zc8B1l7fsPIl9RQHp8+k+bV2951PouurFIPSe+HpiDpeGYpOT7GEy/53EDhXDS+wrj0+a+8GjVx8AAOzksD9fCPHnU3pvGAbTynM9sLnUeyqPr92YG2m0+y+zb7tEFCrJ+Ypx6FUYXCf0XuKP+FkSiGSh90x8L9vOhrFPHmeT2moXGwAA1j65m693NYV9/N6CjR1zrfdOc8G8JBSXdC2rhY2O7934WVB672t8z381RRT2neL74l1QCAAAucV/vU+tv+e30xkZTa/HI/dVE7cR8a73evubaY7t0vvCOWw6ZvNf7Y/MkOtuec+413vF+H0Wem/WicK+i/F7avIHvgMAAOsa//V+69atS0tLfSb9JgMDAwMzMzOBADPP2975ykzPD2QT3wud5er9zXTn57vf707dn688X+jsdyyXb2joveAONz/f4/i9WKOe5+enOmvEK6D3AIB1jP96v2XLloXFxUuXLl26dNmkq6urq6trenr68OHDLt1aha5rsK7ARD4AwDrHZ72vOlyyefOmJ0+etLW1tae4YDI1NXXw4EGXbkHvgZ/gfQIArHs86725LR6n9xc/ft0oObxx48bHjx83NjY2Njax3L17d//+/S7dQvsMAAAA+IiPet+8x3j9cFXrxo0bHz16VFdXL3D79u19+/Y5OlQaihWl0KvGuR2uK6jy5tqfHNt3u6DSyYJ0ekYRkvUUTzL7k0/2AQCrRjZ6b5LW++ZDpsXXXnvt0aNHtbW1dXV1dXX1dXV1dbW1tbW1v/766969ezN3prPgFWUr67vey+ono0Xu7kSdr7CjqH9xQYFk9qPyfCf7fuAgT5qWivJN5IDeAwDSZK/3puSber/nk9ZUfF9fXx8Oh8PhcH19fX1dXR2j90wA5ULvhfnb2bTAOW3B/dN7qn4Y912VhGmKbZPXZccpf3i3eL13TGjgqPce6k1Zet8EqLD03ut3TK71GHoPQPHgi94PDg4aN64cf90w3vyk1Rq/b2pqbm5qbmpsamxoaAiHb9++/e677xrW5i1EYhSlHmQXvRWH3lP1w7eszu0sdb6DHbmIm7PbhZMVei89X3qR33rvW/9BQel96qtX3x/oPQAgjX96f+NG9R7DMN7ctCkzP7+tra29ra2ttbW1peXevXsH2Pl6XvReJv+yjmlbT7N6fznVem7ZvnAySjP524XzeWdc928L9SPJK6du/e26Lsulb3sKMn/Sa9nc6j1xvvQipd4zVZf5WKGfo6Im9DuIHPIlyHfxc35/6PdE7Yv5EvMZKCk71kFzr6RMFiL3+xwS+0/S9gEABY+fej8+Pv7Jm8bmzZsXFhY6Ojo6OzsjkUuRSKSzs7Ozo+O3337j1uN50/tMMyzJs1aauULWrMs1krCTbtNs+8IR8OezXpcGAul7SsrsVu8l8q92iS1Xyjlb+jn2OOlPZuW6Xe9lIkqeL7VPF4T9xbZznvtI12sEarsL5Y/8+VLvD/2eKIvA5TBS27E5kXnssveZ/HfElInzUG4fAFDw+Kz3Zr6dxcXF7u7unp6enp6e7u7u7u7unu7u+/fvc/l2stD7yUhAFu+ap2nmn6fs6A4dCOfLVUZ3vDwbvTfohIWqRIay+peM/NtKxeqZ6nzXei/ZP5BRKPdPxusYkHgX2h/hXowCEyMjjnZ4MuIsTr2Q2SHGa1T+KN8r0UPdcSUAQKHgv96b+XR7e3v7Lfr6+vr6ZmZmPvzww8yds4zvqeFthRBKdcKDHSnC+fbM+kTnaM7685XW6OOCP3xnNdUFnSm84/lu9V5iiO3A0RRwy5r7JyoTQrk/0uerLJeWXrJ9S5nTKTuC27zeS+6kniZiP0DZBwAUPP7rfUlJydLS0sDAwJC5VG9waGhwcHBwcHZ2NhAQ4oQsxu9XJb73Q+9tQw3e9D67uMq13NP+qG5KVJaP8b14N08z6bRCfXV8L/dTjO/90Hv7lAWZflO67qj3uvG9/vcKAKBAyIneJ5NJKxFPNE08Hj9y5Ejmzl70PhDJhFXq8XtSQuSxKTF+75fec/571Hu2ZZaPLZNSJrktedyL3qvsex+/p6zqiQy9n6EDtjom/CGer196L84cIfqfpIG/bdqG7E664/eEfQBAweO/3m/bti2ZTFqJeGx6L5lizTok1QOiK5n9jfyB/Y07LnQaCEf9689nrJtL1MR+er6BldQP1xxLiivXe6p2yFqT+yO4xlzBeCqvKNd6zyN/MGzxiOdI+SAz4YisF0Hqj/z5+qP37GwI5gq7fdlUvvTCFLXeGw5vhN1DqX0AQMGTw/58Nh3P0NDQ7OwsF98TqPRmLVJo5c21P4VWXgAAWCd40PtgMDgzMzPAYxw7diwYDO7bt8/U+9Sm92kk4/cE600PCq280HsAAFiT+Kb3169fj0aj4XDYiu/ZEN/UezfxPQAAAAB8J7d6z0q+V71nB2Cd1zMDAAAAwI5vet/b29vQ0FBZWWnN1xOm7MXj8aNHj3r3lFiFBb0HAAAAHMnV/HxT44eHh4eHh0dGRkZGRhKJRDAY9O6p+1XXntdnAwAAAGsUz3o/xJPR++3btyeTyZGRkdHR0dHR0Stp5ubmysrKvHsKvQcAAAC8Iuj9ixcvXslYWVmx9L68vHx2djbKw+n98vLylStXrqYZGxsbGxubn58vLy83DMV+ZUxe91BElGxZvjPbomHJ4nUiOyyTIgXrhwEAAKx1BL1/9erVG2+8sXPnzp07d/7nP//ZvXv38ePHu7q6Xr16xep9PB63eutNRL1nlX5sbGx8fDyt91SGDjYhiGxQnora5flAqJH+1Jn2fHzoEAAAALCGkcb3H3300aefflpbWxuLxW7evCnE9xUVFfF4nB2aHxkZyej9jh07lpeXxxkmJiYmJiYePHhQUVFBTrDjRVoi2dnqvcP+ZrbEdwAAAMDawT5+b0p+TU3Nd999Nz09bYo9O35fUVGRSCRGGEZHR93rvWEYsv3KeDn2X+9V+5vxxpAgFAAAwJrD1PvFxcVnz55ZU/NWVlZevXr1/fffW2LvVu9bWlosvZ9Ic+3atWvXrnF6b8KG+rnWe8V+a9bPiO8BAACsUUy9X15e/uuvv/5mePny5T///PPy5UvryIsXL1ZWViy9H+VR6T0X35P7lTF6LB1Rd6/3xBQBar81jN8DAABY85h6/+zZM1PRFaysrOjpvSD5ab2n9ytjpucHsonv6f3TJPubYX4+AACAdYCp98+fP7eru6XxLA56L4zfs3o/Pz8v9ufTYAk9AAAA4COm3tul/eXLl+afAm713lqGZwG9BwAAAPKFqfd2Xacg9f6HH36YmJiw9P6qjbm5uVS+HRdA7wEAAAAfMfU+qYNU7/8Hv0oJo0QSAKQAAAAASUVORK5CYII=" alt="" />

  可以看到第二本书的数据已被删除了。

五、查询数据:

  SQL的全称是 Structured Query Language,它的大部分功能是用于查询,其他的功能只是小部分,所以查询数据会比较复杂。Android中使用query()方法来对数据进行查 询,这个方法的参数非常复杂,最短的一个方法重载也需要传入七个参数:

  第一个参数是表名,表示我们希望从哪张表中查询数据;

  第二个参数用于指定去查询哪几列,如果不指定则默认查询所有列;

  第三、第四个参数用于去约束查询某一行或某几行的数据,不指定则默认是查询所有行的数据;

  第五个参数用于指定需要去 group by的列,不指定则表示不对查询结果进行 group by操作;

  第六个参数用于对 group by之后的数据进行进一步的过滤,不指定则表示不进行过滤;

  第七个参数用于指定查询结果的排序方式,不指定则表示使用默认的排序方式。

   虽然 query()方法的参数非常多,但我们不必为每条查询语句都指定上所有的参数,多数情况下只需要传入少数几个参数就可以完成查询操作了。调用 query()方法后会返回一个 Cursor对象,查询到的所有数据都将从这个对象中取出。下面我们来实践一下,首先添加一个button:

  接着在主活动中添加代码如下:

 Button queryButton = (Button) findViewById(R.id.query_data);
queryButton.setOnClickListener(new View.OnClickListener() {
@Override
public void onClick(View v) {
SQLiteDatabase db = dbHelper.getWritableDatabase();
// 查询Book 表中所有的数据
Cursor cursor = db.query("Book", null, null, null, null, null, null);
if (cursor.moveToFirst()) {
do {
// 遍历Cursor 对象,取出数据并打印
String name = cursor.getString(cursor.getColumnIndex("name"));
String author = cursor.getString(cursor.getColumnIndex("author"));
int pages = cursor.getInt(cursor.getColumnIndex("pages"));
double price = cursor.getDouble(cursor.getColumnIndex("price"));
Log.d("MainActivity", "book name is " + name);
Log.d("MainActivity", "book author is " + author);
Log.d("MainActivity", "book pages is " + pages);
Log.d("MainActivity", "book price is " + price);
} while (cursor.moveToNext());
}
cursor.close();
}
});

   可以看到,我们首先在查询按钮的点击事件里面调用了 SQLiteDatabase 的 query()方法去查询数据。这里的 query()方法非常简单,只是使用了第一个参数指明去查询 Book 表,后面的参数全部为 null。这就表示希望查询这张表中的所有数据。 查询完之后就得到了一个 Cursor 对象, 接着我们调用它的 moveToFirst()方法将数据的指针移动到第一行的位置,然后进入了一个循环当中,去遍历查询到的每一行数据。在这个循环中可以通过 Cursor 的 getColumnIndex()方法获取到某一列在表中对应的位置索引,然后将这个索引传入到相应的取值方法中,就可以得到从数据库中读取到的数据了。 接着我们使用 Log 的方式将取出的数据打印出来,借此来检查一下读取工作有没有成功完成。最后别忘了调用 close()方法来关闭 Cursor。

  程序运行效果如下:

  aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAApMAAABSCAIAAACHX8iSAAAZaElEQVR4nO1dPXbjOAxOq7fv7T51auImbiIfwP0qrl1tkSmiZt2u0/kU6xNs6VMkl9tCEkXij5Bie+zJ91UzCkmAAEQQIC08/PXXXysAAAAAAO4ED/DcAAAAAHBHgOcGAAAAgHsCPDcAAAAA3BPguQEAAADgngDPDcxBvT4Uu8Oyrn82I8BMQINAFnXdlvvjAkZyexA8d11vqt3Hw/vnA3uxF68fZSNrsV4fiv3Hw/vnw/tn18YYx+g1dHSZS8zP4vXj4f3z4bXVGnN+Ruq6dS63p469cV4Sz3nqvpnGT+q6LYcugUkPz1egtXj9KLYbbbLfCr3o5i5wX+yeH7lTKLPMToN9m91h2b0dhlE5FvG6bsv9qVpPm4h75DOLaJ7kL6eviTxMYGC0hBmTnbi9m01rNpxWN0NxopxvwQBWoudebk/BRZXR6lw3x2J3Ej13XW+qH4M7bI7drLRx7F5+ucT8dLRsgyb8dI68f9IcRacbG269PhT74+PzizZTg7pzpuQJH9DH88VpYSdOYAskK67LyTOMvNye4p1WeB6ZwRnWo7o5Prx/2lu6c032LOPMG+Qe7d/Jc9ysrjfVbvI+bBK5s8Bjdefl6hYMQPDcSRwW/Fa9qbZtcH4Eqb7bsvNw0jh2L92LSH5l4EezMGaFCT9Pz28GRWGO60Px2iozzdj3vJlO/evVaC23JyO78A2R8dzrQ/GzPTfJjQcNdvFKsTtVzaHYnWw+s1huT8WPo52Ez0rDCc84F9oz3cLCPRVez30u7VxRRB6rOy9Xt2AAgucW1+vl9lit4+CSZlZD97o5Dlm4KX6xOYZNk6c94+dYDWntKXuLjxCy5/KEHzznH8/Upu6fKeezfB3z3nEc3PH8+PyW1cW5aGk78TGpPrjz/sn+VK3rwTfQ7D2TcNIm2Fix3XR7aprA99EKMWU3tSCNZaSvpE0ciTLqojaJ5JepJYjJQ6lNz2GQz5JZ1GLQDj3u0VOFaWwtaDCQLl+PxfZQ2rNIrCWRWOCwbBLzIPri0pBH7iRft+U+SunzjFGwCre+RPkQyXOpkidxJkOkpcmHWZ3wXvh0SrMj3DY0S0geCvPKJ7qztERyfF7iO7jomw0rG5OhyE+wOk3y8XsaRg60FtLbJMqZv+8/Cy7PHdLdWswd0AWmq5XgFayd79Cr/6+jfcxPeMP7odzxfVBDvGapREnGOJlphrp/puRJXbeLkK/eHZZTeL4QLTLH4OBDViM4hq7l0/NbuT9V646WkSegbXi8OI9Wp6CyicdhJEIbnbog4TpeL/iAsv1b1DMcsrRToJ5brxN+ohn1z5vjw/tn2UydBZFYz0/IzHN9uexwCPsEPk3rzepLkQ+RfGJRypOO1qbaqbc9LIvqIwfRVvM6Neaem2nefs6VpWAcUlraW/CQrC1UhhIhbnWqZZq0qJYzs7hBz82z3PW6LXdjYKdeUhtW/NVKyE6rVhj16p/kPXfCzx9/vhjrwjCmxY/nbU9WMWOmRuzumKnOv7SH/ZpU59Eid9OMYaMVKqxNNkXaptuZhXuI82ip3osGbbQNoS4I2TGyKs8cdWUcKUIyUgKSP4s12DdYH4rRi7hmIW9x9kk0Jsd5DjvsOIwl7+mV1ZdHg+5/nArfhT5Np7qtZnSqS8OVfaFdUlruTYBFi48j01LeAluGlJBudZ5/2LSyNm9I6dIwb6hFuVbyJ4747HO5PSziG2psHKPXyr2ti/kZF3fdn3F+AiFyfycg2Y0OvpDz7KTumSm1G0Y9y/NFaSk79yGp3rQ8Rnn6gucmW+N5tLj3cr7SfGPO2I6oZ8Y5Luq6btrMgmJyWKUq8PwEI6vBUfK7wzIvDdNzJ2bThSZUX1waslF1yzENv5SlNhnH0pchn+kx90fZ1NotUVk+rl2m62c1XBeV8npqXRbbw1N0FcmQKh8nS0vikP+wZaY3pYQEq+Mjq+9pRGtKzH2m2wBfwYRfhfGDt6hLtKUa9z6ZX4UpvVp+1iJqLj0mGWjFp1OC3Ck//ZmNvuUcfxXGN8V8pso+1DlT4cl4rDKOTHi+Ji3xblqUVB8iOXr2rHrTVFOCdyebxbm02GlimOz758Pf//4+iqKND7di6nIE2Y2zO4UDs2TkZAn4GM/m0zZPz2/Vjr5crM1LFfJM5IxfecUSSxh3cifpZwKbapvevmQciufKo8T++e+3fX9anNxLYPoi0hDf91X6g0+tDZGqYC25GKCuW0Hy5jl3zExln3Mzi2JWJ+1WTZ2K0hjXn3f5h6l0TQjXDiRaXKrpUBNp6fPS30G+QCVvJac1Wt1gh7Lku/c0acP2i+apP3/fRSldAfgSC+DFV34lMpfi5J+TyoPMesfOQv2mcH0NXhO/nr4AQAM8N3CL8JylTRhn4l3Qc1EHrgPoC/hugOcGAAAAgHsCPDcAAAAA3BPguQEAAADgngDPDQAAAAD3BHhuAAAAALgnwHMDAAAAwD0BnhsAAAAA7gnw3AAAAABwT4DnBuZgUkUm4AYBDQLA/WLCd8tX6ceEaa+oZstQ2Snz3XKx19DR9cWrmJ/+C9vK53ZFfnhBJI7xu+VhXhLPeeq+mbLKY/QLwB6er0CLVAz7zqiVjypfp3t+ZOUT050Goyodm8pX/CpHcfKHzNwjn1lE8yR/cX2daeSpErOt5dK4nFR/VZi1woYy2B3q5ljs5Fphdb2pfkTfkR/KE4nj2L38Koz5iQp1Wz445icuZKTV/EkqaK0Pxf74+PyizdQs1OOaKXliF+bSeb44rUsso3eNSXWTZjT4OmOkslxaT+nDKOowjVxzJMVFDJZmUznjOPMGOaO+tApsXx/5K8wYdQjtjmeh/pVBvg9c9blX3Tq+bbUqn7wa4OPzS7Y+t1ZD0Cj3Fj0Z+dHqKKRj0vrcQ0VImaIwx/WheG2VmWbijHkznfrXq9ESK4Z9Z2Q8d64m4BU8N8mNBw12UXKxO1XNodidvli7cLk9FT+OdhL+XBUSPeNcaM90Ts+dzuJGPPfUk5Sz6BSeexIEzy2u18vtsVrHwaVQx61DV/3a42NixDW8Pe0ZP0PFPakI6UryQ4/PL2Px4O0plycU6v7GM7Wp+2fK+Sxfx7x3UvB4e3roq/xmdHEuWtEeKNmpjEl1Un1yrIp4KnY0e88knLQJNlZsN0nVyIm0QkzZTS1IIy0RG7VJq1gS6qI2ieRJMVyx5InUpucwyIcX1V0M2qHHPXqCOo2tBQ0G0uXrsdgeSnsWpAJjJLHAYdkk5kH0JVWolEbuJF+35T5K6fOMEas6mtWXKB8iebvKZyzVpVLl07CxpPSkLA1qq0KN0f1x0T/UknxCBoXbj8taNGnoOv0Cz9Z7mtHlN4PLc4d0txZzB3SBadyX/Nvu1f/X0T7mJ7zh/VDu+D4qHnzw7C2SjHEy0wx1/0x59mwR8tVdpW03zxeiReYYHHzIapAa9U/Pb+X+VK1bXns75YS24RHAPFqdgsomHoeRCG106oKEA3V5QNn+LeoZDlnaKVCfuhYnhcOPi+b48P5ZNlNnQSTW8xNyrVxfLjscAjiBT9N6Z8SLkuQTi1KedLQ21U697WFocJ5UU+pCIKExIP7XzbMojYxO5/FsvYMIxxlc2fJ63Za7MbBTL6kNK/5qJWSn1UtqUa/+Sd5zJ/z88eeLsS4MY1r8eN725H0zZmrE7o6Z6vyzlibPl6NF7qYZww65jbfIj9oUaZtuZxbuIc6jZUUSSdBG2xDqgpAdI6vyzFFXxiGR3/AWmHEM8WexBvsG60Mx7nhcs5C3OPskqhMNzGOHHYex5D29svryaND9j1NhXujjMvzCrm6OG1Mk5svQTNlBTprFJF1wGdpT/lYwb6hFuVbyJ4747HO5PSziG2psHKPXyrc9JPyMi7vuzzg/gZB2IyP28cEXcp6d1D0zpW81o57l+aK0lMhvSKo3LY9Rnr7guclWfR6tSesRW1WtQCGh7lid66bNLMomh1WqAs9PMLIaHCW/Oyzz0jBX58RsumQA1ReXhmxU3XqdpHb0TVsyTj4YFeUzPeb+KJtauyUqyyfZ4vhtQ4v4p3lubj9GlzRrIsfcK12n83j++mblW2HCr8KMI4dk+z/uuDO/ClN6tcKpiaS59BhpoBWfx1DbFfjpz3708Gj8VdhoQ/pMlf2sc6bCk/EYdRyZ8HxNWuLdtCiprp3Mqd401ZTg3clmcS4t9hu5MNn3z4e///19FEUbHxDG1OVooxtndwoHeMnISbL3YzybT9s8Pb9VO/pysTYvVcgzkTN+5RVLLGHcyZ2knwlsqm16+5JxKJ4rjxL757/f9v1pcXIvgemLSEN831fpDz61NkSqgrXkVvy6bgXJm+fcMTOVec7NLaFfTCJriWchSHX09AJ1e17sfd9w+5G7pA0EaeR0akhM41mdu/Q2ASt8iQXwQ7vDf0mK1jnLhEFmbdjPQv2mcH0NXhO/nr4AQAM8N3CLyJ7JTRtn4jnZuagD1wH0BXw3wHMDAAAAwD0BnhsAAAAA7gnw3AAAAABwT4DnBgAAAIB7Ajw3AAAAANwT4LkBAAAA4J4Azw0AAAAA9wR4bgAAAAC4J8BzA3MwtYIvcGuABgHgfjHhu+Wr9GPCtFdUKWio7JT5brnYa+jo+uJVzE//hW2lAIDIj6cQzfjd8jAviec8dd9MWeUxWnvbw/MVaJGKYd8ZdZ186vzK3fMjK5+q7jQYVenYVGbxK3fRiMkfMptUjmLSyA66kyV/OX19BV+RT7eKiisAaXM+foGvwqwVNpTB7lA3x2In1wqr6031I6o0NRScEcexe/lfjJifqFC35YNjfuKiN1rNn6SC1vpQ7I+Pzy/aTM0iPK6Zkid2YS6d54vTQukeAlsgnroXF5Inr/5EnkdmcAaH1NWHsLd055rsWcaZN8ivZP9hFbWWL33lB34WXPW5V906vm21Kp+8GuDj80u2PrdWQ9Co6Bc9GfnR6iikY9L63ENFSJmiMMf1oXhtlZlm4ox5M53616vREiuGfWdkPHdU1XFG97MwRnLjQYNdlFzsTlVzKHYnm88slttT8eNoJ+Gz0nDCM86F9ky/jOdOV1FtPbFWfuBnQfDc4nq93B6rdRxcqnmVrvq1x8fEiGt4e9ozfoaKe1IR0pXkhx6fX8ZCs9tTvgIdW4/imdrU/TPlfJavY947KY67PT3sj4+h/KKui3PRivZAyU5lTKqrNf5OxY5m75mEkzbBxortJqkaOZFWiCm7qQVppCViozZpFUtCXdQmkTwphiuWPJHa9BwG+fCiuotBO/S4R09Qp7G1oMFAunw9FttDac+CFKaMJBY4LJvEPIi+pOqT0sid5Ou23EcpfZ4xYlVHs/oS5UMkb1f5jKW6VKp8eqyOyodYOK+0qx87innKbK+VtIrGKwBvk5UncDW4PHdId2f11wWmK8krWDvfoVf/X0f7mJ/whvdDueP7qNDswbO3oGVro8XIpu6fKXlS1+0i5Ku7Sttuni9Ei8wxOPiQ1QiOoWv59PxW7k/VuuW1t1NOaBseL86j1SmobOJxGInQRqcuSDhQlweU7d+inuGQH2cM1K01nfETzah/3hwf3j/LZuosiMR6fkJmnuvLZYdDMC3waVpvVl+KfIjkE4tSnrR9UfOdetvDp9NgxlSGQafO+F6ThtWFrerCCuBe+YErw5Utr9dtuRsDO/WS2qDvlZSdVi+pRb36J3nPnfDzx58vxrowjGnx43nbk1XMmKkRuztm6smBe3i+HC1yN80YdshtvEV+1KZI23TrRbgdM4+W6r1o0EbbEOqCkB0jq/LMUVfGIZFfEq5ZHCoa7BusD8W443HNQt7i7JM4TzQwjx12HMaS9/TK6sujQfc/ToXvQp+tUzVDo+vdJpc+MfMx+qoe6dS18gPXh3lDLcq1kj9xxGefy+1hEd9QY+MYvVa+DSPhZ1zcdX/G+YmzXiKHsY8PvpDz7KTumSmNchj1LM8XpaVEfkNSvWl5jPL0Bc/drz7JJmkyLSl2z6/OnLpkHhF1R7RaN23GJZgcVqkKPD/ByGpwlPzusMxLw/Tcidl0gSPVF5eGbFSdh0tSO/qmLRnH0pchn+kx90fZ1NotUWVkS7yRRdFpVsqrJ5Kb1KvDmLlkKwBp45QqcAVM+FUYP6SJukRbxXHHnflVmNKr5eeCov2lR5UDrfh0ilqzwE9/GqSHR+OvwsaXTZ+pssN1zlR4Mh6jsnMvK8y6FC3xblqUVB8iOXr2rHrTVFOCdydLxlxa7DdyYbLvnw9///v7KIo2PjKMqcsRZDfO7lQMvZKRk2Tvx3g2n7Z5en6rduwElLZ5qUL0Q874lVcssYRxJ3eSfiawqbbp7UvGoXiuPErsn/9+2/enxcm9BKYvIg3xfV+lP0PS2hCpCtaS81t13QqSN8+5Y2Yq5ZybCF/T6bKux9NoHpeTteVd/dGp9HbnewWJjauotAKszJUf+FnAl1gAL7Q7/JekaJ2zTBjEl8K5BPWbwvU1eE3clL48VheSE872ABAAzw3cIjxnexPGcV82Pi914Dq4NX35rY5/6AkAPIDnBgAAAIB7Ajw3AAAAANwT4LkBAAAA4J4Azw0AAAAA9wR4bgAAAAC4J8BzAwAAAMA9AZ4bAAAAAO4J8NwAAAAAcE+A5wbmYFJFJuAGAQ0CwP1iwnfLV+nHhGmvqFLQUPcm891ysdfQ0fXFq5if/gvA+kd6OT+8dA8H/8iRyHOeum+mrPIYrb3t4fkKtEjFsO+MOv3U+ZW750dWPl7daTCq0rGpfMWvchQnf8jMPfKZRTRP8ufV17nmNW8csiZMW7H1AmjAFWDWChuKs3aom2OxkyvG1PWm+hHVmRnKE4nj2L38L0bMT1wc3vDBMT9xISOt5k9SP2d9KPbHx+cXbaYGdedMyRO7MJfO88Vp4RvLBJPqOM1o8HXGSGW5tFzVBy+1MpNccyTFRQyWZlM54zhzHd6vYP98TXCt2Oma4FmRgEvAVZ971els22q13ng1wMfnl2x9bq2GoFHRL3oy8qPVUUjHpPW5h4qQ3s/91+tD8doqM83EGfNmOvWvV6MlVgz7zsh47qEG6LzuZ2GM5MaDBrsoudidquZQ7E42n1kst6fix9FOwmel4YRnnAvtmX4Nz73KrZCeFftx4ioKnAuC5xY1sdweq3UcXNLMaujeVb/2+JgYcQ1vX01Zws9QcU/5cL/icT9CyJ7LEwp1f+OZ2tT9M+V8lq9j3jspeLw9PfRvTkYX56IVveHJTmVMl5Hqk2NVxFOxo9l7JuGkTbCxYrtJqkZOpBUCi25qQRppidioTVrFklAXtUkkT0oiisUnpDY9h0E+vLTiWBGSHPfoCeo0thY0GEiXr8dieyjtWSTWkkgscFg2iXkQfUn1KKWRO8nXbbmPUvo8Y8Sqjmb1JcqHSN6u8hlLdalU+eRWN06hH0rNL9oWrs+CjsOtxTAP499pe77+eFdR4Lxwee6QPMnWV+8C05XPDniv/r+O9jE/4Q3vh3LH91Hx4INnb5FkjJOZZqj7Z0qe1HW7CJmorl6vm+cL0SJzDC9z2LMHx9C1fHp+K/enat3y2tspJ7QNjxfn0eoUVDbxOIxEaKNTFyQcqMsDyvZvUc9wyI8zBuoqhxI/0Yz6583x4f2zbKbOgkis5ydk5rm+XHY4BNMCn6b1ZvWlyIdIPrEo5UlHa1Pt1Nseik5pAMBmoVu4rmVDGo7pT/Dcq2irGtaESasocC64suX1ui13Y2CnXlIbVvyVL/fCe/VP8p474eePP1+MdWEY0+LH87Ynlm3M1IjdHTPV+WctTZ4vR4vcTTOGTfNpWc8ttOl2ZuEe4jxaqveiQRttQ6gLQnaMrMozR10Zh0R+w1ugrbOSP4s12DdYH4pxx+OahbzF2SdxnmhgHjvsOIwl7+mV1ZdHg+5/nArfhT5j72VINW2Q0bLV0bwwmHpr74rd92XrD36tcE2YN9SiXCv5E0d89rncHhbxDTU2jtFr5d4wxvyMi7tuPZyfOOslchhbcPCFnGcndc9M6c6XUc/yfFFaSuQ3pMualscoT1/w3CRMmUdLit3zqzOnLplHRN0RrdZNm3EJJodVqgLPTzCyGhwlvzss89IwPXdiNl2YSPXFpSEbVbcJSFI7+qYtGcfSlyGf6TH3R9nUxp0sQ6dis+G/ooVPi567/1bKC2v08qzYhkUZKxJwdkz4VRg/eIu6RBvDcced+Y2B0qslJ2Erxf7So8qBVnw6Jb0VhJ/+NEgPj8ZfhY3rlD5TZYfrnKnwZDxGHUcmPF+Tlng3LUqXDZEcPXtWvWmqKcG7k83iXFrsN3Jhsu+fD3//+/soijY+MoypyytvN87uNB5exiMnyd6P8eQybfP0/Fbt6MvF2rxUIc9ETkCVVyyxhHEnd5J+JrCptuntS8aheK48Suyf/37b96fFyb0Epi8iDfF9X6U/+NTaEKkK1pKLAeq6FSRvnnPHzFTKOTcRfnI3iJo9e6hZuGchTQJo9QeB+V76IcVKWn/sFQm4BPAlFsAL7Q7/JSnms3auQWatKWehflO4vgaviZvS12yrAwAP4LmBW4TnlG7COBMDgnNRB66DW9PXPKsDAD/guQEAAADgngDPDQAAAAD3BHhuAAAAALgnwHMDAAAAwD0BnhsAAAAA7gnw3AAAAABwT4DnBgAAAIB7Ajw3AAAAANwT4LkBAAAA4J7wP32qa27KtwGhAAAAAElFTkSuQmCC" alt="" />

  在Android Monitor中可以看到第一本书的所有数据。

  //End.

上一篇:线段树【洛谷P2894】 [USACO08FEB]酒店Hotel


下一篇:Oracle单表去重复(一)