android SQLite数据库:创建及更新

一个Book的建表语句

create table Book(

    id integer primary key autoincrement, //id是主键，autoincrement表示id是自增长的

    author text,

    pages integer,

    price real,

    name text) 

前面的字符串表示数据id,后面的表示数据类型

要在代码里头执行这个SQL语句需要创建一个个类继承自SQLiteOpenHelper,，这里就叫MyDatabaseHelper

代码:

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