Sqlite3封装类:easysqlite

前端之家收集整理的这篇文章主要介绍了Sqlite3封装类:easysqlite前端之家小编觉得挺不错的,现在分享给大家,也给大家做个参考。

感谢Piotr.Zagawa大神,现在可以很简单地连接上sqlite3数据库了:

传送门:http://code.google.com/p/easysqlite/

使用example:(用VS2010直接有解决方案,更快捷:)

//define table structureField definition_tbPerson[] = {    Field(FIELD_KEY),Field("fname",type_text,flag_not_null),Field("lname",Field("birthdate",type_time),Field(DEFINITION_END),};//define database objectsql::Database db;try{    //open database file    db.open("test.db");    //define table object    Table tbPerson(db.getHandle(),"person",definition_tbPerson);    //remove table from database if exists    if (tbPerson.exists())        tbPerson.remove();    //create new table    tbPerson.create();    //define new record    Record record(tbPerson.fields());    //set record data    record.setString("fname","Jan");    record.setString("lname","Kowalski");    record.setTime("birthdate",time::now());    //add 10 records    for (int index = 0; index < 10; index++)        tbPerson.addRecord(&record);    //select record to update    if (Record* record = tbPerson.getRecordByKeyId(7))    {        record->setString("fname","Frank");        record->setString("lname","Sinatra");        record->setNull("birthdate");        tbPerson.updateRecord(record);    }    //load all records    tbPerson.open();    //list loaded records    for (int index = 0; index < tbPerson.recordCount(); index++)        if (Record* record = tbPerson.getRecord(index))            sql::log(record->toString());    sql::log("");    sql::log("ALL OK");} catch (Exception e) {    printf("ERROR: %s\r\n",e.msg().c_str());}

猜你在找的Sqlite相关文章