iphone-common-codes-ccteam源代码 CCSqlite3.h-优快云博客

本文介绍了CCSqlite3组件，该组件为iOS应用程序提供了一种便捷的方式来进行SQLite数据库操作。CCSqlite3通过简单的接口提供了数据库初始化、SQL语句准备、数据获取等功能，并支持委托模式来通知调用者有关查询进度的信息。

//
//  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