Sqlite3封装类：easysqlite

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

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

使用example：（用VS2010直接有解决方案，更快捷:）

@H_403_9@//@R_404_5552@ table structureFIEld deFinition_tbPerson[] = { FIEld(FIELD_KEY),FIEld("fname",type_text,flag_not_null),FIEld("lname",FIEld("birthdate",type_timE),FIEld(DEFinitioN_END),};//@R_404_5552@ database objectsql::Database db;try{ //open database file db.open("test.db"); //@R_404_5552@ 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(); //@R_404_5552@ 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());}