iphone-common-codes-ccteam源代码 CCSqlite3.h

最新推荐文章于 2025-12-04 15:25:15 发布

最新推荐文章于 2025-12-04 15:25:15 发布 · 82 阅读

文章标签：

#数据库

本博客介绍了一个由CCTeam提供的名为CCSqlite3的Objective-C类，用于封装SQLite3操作。该类提供了初始化、设置SQL、准备语句、获取数据和结束会话等方法，简化了与SQLite3数据库的交互。包括如何通过自定义delegate来接收特定的事件，如另一行数据加载完成。

// // CCSqlite3.h // CCFC // // Created by xichen on 11-12-18. // Copyright 2011 ccteam. All rights reserved. // #import <Foundation/Foundation.h> #import <sqlite3.h> @class CCSqlite3; @protocol CCSqlite3Delegate // the row starts with 1. - (void)onCCSqlite3AnotherRowOK:(CCSqlite3 *)sqlite withRow:(int)row; @end @interface CCSqlite3 : NSObject { @private sqlite3 *_db; NSString *_sql; sqlite3_stmt *_statement; id<CCSqlite3Delegate> _delegate; int _row; } @property(nonatomic, assign) id delegate; // if you don't want to call getData method, then get the statement by yourself. @property(nonatomic, assign, readonly) sqlite3_stmt *statement; - (id)initWithSqliteDBFullPath:(NSString *)dbFullPath; - (void)dealloc; - (void)setSql:(NSString *)sql; - (BOOL)prepare; - (void)getData; - (void)end; // set so, we can get the random results - (void)setRandomReturns:(int)n; // if set so, the sqlite will returns the rowCount row data, which starts from argument start. - (void)setNRowsFrom:(int)start withRowCount:(int)rowCount; @end可能有更新:

googlecode链接地址： http://code.google.com/p/iphone-common-codes-ccteam/source/browse/trunk/CCFC/files/CCSqlite3.h

github地址: https://github.com/cxsjabc/iphone-common-codes-ccteam/tree/master/CCFC/files/CCSqlite3.h