ios sqlite3 实例，建表，增删攺查

// // DBOperaTion.h // Sqlite3Test // // Created by yunfenghan Ling on 12-11-28. // Copyright (c) 2012年 yunfenghan Ling. All rights reserved. // #import <Foundation/Foundation.h> #import "sqlite3.h" @interface DBOperaTion : NSObject { sqlite3 *database; } //----------------------------------------建立sqlite文件 - (BOOL)openDatabase; - (void)closeDatabase; //----------------------------------------建表 - (BOOL)createTable; //----------------------------------------插入、查询、删除、更新 - (BOOL)insertDataWithSQL:(NSString *)sql; - (BOOL)selectDataWithSQL:(NSString *)sql; - (BOOL)deleteDataWithSQL:(NSString *)sql; - (BOOL)updateDataWithSQL:(NSString *)sql; @end