sqlite嵌入式编程实例

[root@localhost mysqlite_databasefile]# ./mysqlite3 You have opened a sqlite3 database successfully! row:4 column = 5 The result of querying is : azResult[0] = ID azResult[1] = SensorID azResult[2] = SiteNum azResult[3] = Time azResult[4] = SensorParameter azResult[5] = 1 azResult[6] = 101 azResult[7] = 261 azResult[8] = 20100314 azResult[9] = 18.9 azResult[10] = 2 azResult[11] = 369 azResult[12] = 281 azResult[13] = 20100616 azResult[14] = 113.0 azResult[15] = 3 azResult[16] = 667 azResult[17] = 290 azResult[18] = 20110315 azResult[19] = 27.0 azResult[20] = 4 azResult[21] = 865 azResult[22] = 300 azResult[23] = 20120616 azResult[24] = 323.0 ppppppppppppppppppppppppppppppppppp Total column is 5 字段名: ID---->字段值:1 字段名: SensorID---->字段值:101 字段名: SiteNum---->字段值:261 字段名: Time---->字段值:20100314 字段名: SensorParameter---->字段值:18.9 ========================== Total column is 5 字段名: ID---->字段值:2 字段名: SensorID---->字段值:369 字段名: SiteNum---->字段值:281 字段名: Time---->字段值:20100616 字段名: SensorParameter---->字段值:113.0 ========================== Total column is 5 字段名: ID---->字段值:3 字段名: SensorID---->字段值:667 字段名: SiteNum---->字段值:290 字段名: Time---->字段值:20110315 字段名: SensorParameter---->字段值:27.0 ========================== Total column is 5 字段名: ID---->字段值:4 字段名: SensorID---->字段值:865 字段名: SiteNum---->字段值:300 字段名: Time---->字段值:20120616 字段名: SensorParameter---->字段值:323.0 ========================== row:3 column:5 After deleting,the result of querying is : azResult[0] = ID azResult[1] = SensorID azResult[2] = SiteNum azResult[3] = Time azResult[4] = SensorParameter azResult[5] = 1 azResult[6] = 101 azResult[7] = 261 azResult[8] = 20100314 azResult[9] = 18.9 azResult[10] = 2 azResult[11] = 369 azResult[12] = 281 azResult[13] = 20100616 azResult[14] = 113.0 azResult[15] = 3 azResult[16] = 667 azResult[17] = 290 azResult[18] = 20110315 azResult[19] = 27.0 [root@localhost mysqlite_databasefile]#