Android-Sqlite使用手册

Love The Way You Lie 2022-07-30 13:11 154阅读 0赞

sqlite3使用手册

--------------------

**查看数据库版本**

sqlite3 -version

![Center][]

**打开或创建数据库**

sqlite3  DatabaseName . db

![Center 1][]

**查看数据库文件信息**

.database

![Center 2][]

**查看数据库表**

.table

![Center 3][]

**退出sqlite**

.quit 或 .exit

![Center 4][]

**列出当前显示格式的配置**

.show

![Center 5][]

**显示数据库结构/** **显示表的结构**

.schema

. schema 表名

![Center 6][]

**设置分隔符**

.separator 分隔符

![Center 7][]

![Center 8][]

**显示标题栏**

.headers  on/off

![Center 9][]

**设置显示模式**

.mode 模式

![Center 10][]

![Center 11][]

**设置NULL值显示样式**

.nullvalue

![Center 12][]

sqlite简单语法

--------------------

**建立数据表**

create table table\_name(field type1,fieldtype1,….);

table\_name是要创建数据表的名称，field x上是数据库表内字段名字，typex则是字段类型。

![Center 13][]

**添加数据记录**

insert into table\_name(列 field1,field2,….)values(值val1,val2,….);

例如，往老师信息表添加数据：

![Center 14][]

**修改数据**

update 表 set 列 = ‘新值' \[where 条件语句\]

![Center 15][]

![Center 16][]

**删除数据**

delete from 表  \[where 条件语句\]

如果设定 where 条件子句，则删除符合条件的数据记录；如果没有设定条件语句，则删除所有记录。

![Center 17][]

**修改数据**

update 表 set 列 = ‘新值’ \[where 条件语句\]

update 语句用来更新表中的某个列，如果不设定条件，则所有记录的这一列都被更新；如果设定了条件，则符合条件的这一列被更新， where 子句被用来设定条件，如下例：

![Center 18][]

![Center 19][]

**删除数据**

delete from 表 \[where 条件语句\]

如果设定 where 条件子句，则删除符合条件的数据记录；如果没有设定条件语句，则删除所有记录。

![Center 20][]

**查询数据记录**

查询输出列出数据记录(select \* from table\_name;)

限制输出数据记录数量( select \* from table\_name limit val;)

升序输出数据记录( select \* from table\_name order by field asc;)

降序输出数据记录(select \* from table order by field desc;)

条件查询 (select \* from table\_name where expression;)

( select \* from table\_name where field in(‘val1’,’val2’,’val3’);)

( select \* from table\_name where fieldbetween val1 and val2;)

查询记录数目(select count(\*) from table\_name;)

**删除数据表**

drop table table\_name;

**Android编码手册**

--------------------

**创建辅助类**

public class DatabaseHelper extends SQLiteOpenHelper \{  
private static final String *name* = "count" ;  //数据库名称  
  private static final int  *version* = 1 ;  //数据库版本  
  public DatabaseHelper(Context context) \{  
super(context ,  *name* , null,  *version*) ;  
  \}  
  
@Override  
  public void  onCreate(SQLiteDatabase db) \{  
db.execSQL( "CREATE TABLE IF NOT EXISTS person (personid integer primary key autoincrement, name varchar(20), age INTEGER)") ;  
  \}  
  
@Override  
  public void  onUpgrade(SQLiteDatabase db , int oldVersion , int newVersion) \{  
db.execSQL( "ALTER TABLE person ADD phone VARCHAR(12)") ;  //往表中增加一列  
  \}  
\}

**插入数据**

SQLiteDatabase db = DatabaseHelper.(mContext , 1).getWritableDatabase() ;  
db.execSQL( "insert into Book (name, author, pages, price) values(?, ?, ?, ?)”, new String\[\] \{ "The Da Vinci Code ", "Dan Brown ", " 454 ", " 16.96 " \});  
db.execSQL( "insert into Book (name, author, pages, price) values(?, ?, ?, ?)”, new String\[\] \{ "The Lost Symbol ", "Dan Brown ", " 510 ", " 19.95 " \});  
db.close() ;

**删除数据**

SQLiteDatabase db = DatabaseHelper.(mContext ,  1).getWritableDatabase() ;  
db.execSQL( "delete from Book where pages > ?" , new String\[\] \{ "500" \}) ;  
db.close() ;

**更新数据**

SQLiteDatabase db = DatabaseHelper.(mContext ,  1).getWritableDatabase() ;  
db.execSQL( "update Book set price = ? where name = ?" , new String\[\] \{ "10.99" ,  
 "The Da Vinci Code" \}) ;  
db.close() ;

**查询数据**

SQLiteDatabase db=DatabaseHelper.(mContext , 1).getReadableDatabase() ;  
Cursor cursor=db.rawQuery( "select \* from Book" ,null) ;  
 //跳转到指针最开始  
 if(cursor.moveToFirst())\{  
do\{  
//获取数据  
  /\* cursor.getString(cursor.getColumnIndex("isRemind”)) \*/  
  \} while(cursor.moveToNext()) ;  
\}  
db.close() ;

参考

--------------------

使用介绍：《第一行代码》-- 6.4节 -- SQLite数据库存储

SQLite 教程：http://www. [runoob.com/sqlite/sqlite-tutorial.html][runoob.com_sqlite_sqlite-tutorial.html]

[Center]: /images/20220724/ea1a850e55a54a6fa3d3c722d99c163d.png
[Center 1]: /images/20220724/15d498491755461babd7060def6c8ee3.png
[Center 2]: /images/20220724/262f382d06a14fb8a557b89d4f095db2.png
[Center 3]: /images/20220724/76b7f2d8d9de45af8d267bc31f2e7aff.png
[Center 4]: /images/20220724/6b4a8bac1aa94f2283bbeb75ec3857c4.png
[Center 5]: /images/20220724/812e72de4edc45a78c0402067fd59973.png
[Center 6]: /images/20220724/7a05bb09309342969ba9f822e4d6fcc3.png
[Center 7]: /images/20220724/2972149094f14747b13d876ebce233d4.png
[Center 8]: /images/20220724/13df22af520041779f1094c513d767c4.png
[Center 9]: /images/20220724/b9664f3e586c40ba99bfafd8cbf58177.png
[Center 10]: /images/20220724/2a27d61017ab4114b4e57e0108a34bcb.png
[Center 11]: /images/20220724/acaa8d5da84b4fbe837a59eba530a87e.png
[Center 12]: /images/20220724/5d35b67f9b20435888baf64647012782.png
[Center 13]: /images/20220724/94786e09c0d44dbeb71360cc2b75bfb8.png
[Center 14]: /images/20220724/925c3c15af4e4b7794f38887041b5f42.png
[Center 15]: /images/20220724/9d7c5fbe74014e72be35d7b7cd1913ed.png
[Center 16]: /images/20220724/970a445f71444b71b30f97b587b51f51.png
[Center 17]: /images/20220724/1ed14372edff49359ae36b5f159ca4ec.png
[Center 18]: /images/20220724/69ab5632c11c462b8bbd6ead8f7f6f37.png
[Center 19]: /images/20220724/bf9d8a264b9942ae98109bcc3c2b11ac.png
[Center 20]: /images/20220724/85dc5a70ff4a46768c3ded12e07765fa.png
[runoob.com_sqlite_sqlite-tutorial.html]: http://runoob.com/sqlite/sqlite-tutorial.html