bash-2.05b# ls

cert     devm     radius   rule     sqlite3  uibase   vpn

<SPAN style="COLOR: #ff6600">bash-2.05b# ./sqlite3 rule </SPAN>

//启动 进入数据库

SQLite version 3.5.4

Enter ".help" for instructions

<SPAN style="COLOR: #ff6600">sqlite> .tab</SPAN>

  // 显示数据库中表

DomainName             RuleIpFilterStatout    RuleSnatIp          

IpObj                  RuleIpFilterTime       RuleSnatPro 

<SPAN style="COLOR: #ff6600">sqlite> select * from IpObj;  //查询表

</SPAN>

1|test1|0|1|1.0.0.0||

2|test2|8|1|1.0.0.0||

<SPAN style="COLOR: #ff6600">sqlite> .h on</SPAN>

     // 显示表字段命令

<SPAN style="COLOR: #ff6600">sqlite> select * from IpObj;</SPAN>

<SPAN style="COLOR: #ff0000">Id|Name|VsysId|Refcount|StartIp|EndIp|Mask</SPAN>

   // 表字段

1|test1|0|1|1.0.0.0||

2|test2|8|1|1.0.0.0||

<SPAN style="COLOR: #ff6600">sqlite> insert into IpObj (Name,VsysId,Refcount,StartIp,EndIp,Mask) values('a','3','2','1.1.1.1','','');   </SPAN>

 //添加操作 

sqlite> select * from IpObj;

Id|Name|VsysId|Refcount|StartIp|EndIp|Mask

1|test1|0|1|1.0.0.0||

2|test2|8|1|1.0.0.0||

3|a|3|2|1.1.1.1||

<SPAN style="COLOR: #ff6600">sqlite> update IpObj set Name='aaa' where Id=3;</SPAN>

//修改操作

sqlite> select * from IpObj;

Id|Name|VsysId|Refcount|StartIp|EndIp|Mask

1|test1|0|1|1.0.0.0||

2|test2|8|1|1.0.0.0||

3|aaa|3|2|1.1.1.1||

<SPAN style="COLOR: #ff6600">sqlite> delete from IpObj where Id=3;</SPAN>

 // 删除操作

sqlite> select * from IpObj;

Id|Name|VsysId|Refcount|StartIp|EndIp|Mask

1|test1|0|1|1.0.0.0||

2|test2|8|1|1.0.0.0||