SQLite数据库的基本操作
1）创建一张表
    CREATE TABLE person (
        id integer primary key autoincrement,
        name varchar(20),
        number varchar(20)
    );

2）向表中插入数据
    insert into person (name,number) values ('zhangshan',110)
    insert into person (name,number) values ('lishi',112)

3）查询整表数据
    select *from person
4）查询某一条件表数据
    select *from person where name='lishi'
5）更改特定条件表数据
    update person set number='119' where name='zhangshan'
6）删除特定条件表数据
    delete from person where name='lishi'

7）删除整表数据
    delete from person

SQLite数据库的基本操作
1）创建一张表
    CREATE TABLE person (
        id integer primary key autoincrement,
        name varchar(20),
        number varchar(20)
    );

2）向表中插入数据
    insert into person (name,number) values ('zhangshan',110)
    insert into person (name,number) values ('lishi',112)

3）查询整表数据
    select *from person
4）查询某一条件表数据
    select *from person where name='lishi'
5）更改特定条件表数据
    update person set number='119' where name='zhangshan'
6）删除特定条件表数据
    delete from person where name='lishi'

7）删除整表数据
    delete from person