|
例子主要实现在添加单词页面向SQLite数据库中添加单词，单词页面从SQLite数据库取数据显示在页面上
例子使用的xib实现,使用了导航栏Navigation
前期准备就是在AppDelegate.m 里该实现的实现
YcwViewController.h
#import "sqlite3.h"
@interface YcwViewController : UIViewController<UITableViewDataSource,UITableViewDelegate>
@property (strong,nonatomic) IBOutlet UITableView *myTableView;
@end
YcwViewController.m
@interface YcwViewController ()
{
sqlite3 *db;
NSMutableArray *array;
}
@end
@implementation YcwViewController
- (void)viewWillAppear:(BOOL)animated //从添加单词页面返回单词页面时，重新加载myTableView
{
[self.myTableView reloadData];
}
- (void)viewDidLoad
{
[super viewDidLoad];
self.title = @"单词";
self.myTableView.delegate = self;
self.myTableView.dataSource = self;
UIBarButtonItem *rightButton = [[UIBarButtonItem alloc]initWithBarButtonSystemItem:UIBarButtonSystemItemAdd target:self action:@selector(goToSecondView)];
[self.navigationItem setRightBarButtonItem:rightButton];
array = [NSMutableArray array];
NSLog(@"%@",[self getDBPath]);
NSFileManager *fileMgr = [NSFileManager defaultManager];
if ([fileMgr fileExistsAtPath:[self getDBPath]]==NO) {
NSLog(@"------------------");
//将NSString对象转换成const char * 的C类型数据
const char *dbPath = [[self getDBPath] UTF8String];
//SQLite的策略是如果有该文件就打开，若果没有就创建文件
if (sqlite3_open(dbPath,&db)==SQLITE_OK) {
char *errMsg;
const char *sql_str = "CREATE TABLE Words (danci VARCHAR,chinese VARCHAR)";
//errMsg传的是地址，因为该函数通过地址引用来写报错字符信息
if (sqlite3_exec(db,sql_str,NULL,&errMsg)) {
NSLog(@"fail to create db");
}
sqlite3_close(db);
}
else{
NSLog(@"failed to open/create database");
}
}
[self initializeDataToDisplay];
}
- (void)initializeDataToDisplay //从数据库中取数据
{
const char *dbPath = [[self getDBPath] UTF8String];
sqlite3_stmt *statement;
if(sqlite3_open(dbPath,&db)==SQLITE_OK)
{
NSString *querySql = [NSString stringWithFormat:@"SELECT * FROM Words"];
const char *query_stmt = [querySql UTF8String];
if (sqlite3_prepare_v2(db,query_stmt,-1,&statement,NULL)==SQLITE_OK) {
while (sqlite3_step(statement)== SQLITE_ROW) { //一行一行的读取查询得到的数据
Word *word = [[Word alloc]init];
word.danci = [NSString stringWithUTF8String:(char *)sqlite3_column_text(statement,0)];
word.chinese = [NSString stringWithUTF8String:(char *)sqlite3_column_text(statement,1)];
[array addObject:word];
}
}else{
NSLog(@"%s",sqlite3_errmsg(db));
}
sqlite3_finalize(statement);
}
}
- (NSString *)getDBPath //数据库的存储路径
{
NSString *string = [NSString stringWithFormat:@"%@/Documents/db2.sqlite",NSHomeDirectory()];
return string;
}
- (void)goToSecondView
{
YcwSecondViewController *secondView = [[YcwSecondViewController alloc]initWithNibName:@"YcwSecondViewController" bundle:nil];
secondView.array = array;
[self.navigationController pushViewController:secondView animated:YES];
}
- (NSInteger)tableView:(UITableView *)tableView numberOfRowsInSection:(NSInteger)section{
return [array count];
}
- (UITableViewCell *)tableView:(UITableView *)tableView cellForRowAtIndexPath:(NSIndexPath *)indexPath{
NSString *cellIden = @"myCell";
UITableViewCell *cell = [tableView dequeueReusableCellWithIdentifier:cellIden];
if (cell==nil) {
cell = [[UITableViewCell alloc]initWithStyle:UITableViewCellStyleSubtitle reuseIdentifier:cellIden];
}
Word *word = (Word *)array[indexPath.row]; //另外申明的一个Word类，方便存储数据
cell.textLabel.text = word.danci;
cell.detailTextLabel.text = word.chinese;
return cell;
}
YcwSecondViewController.h文件
#import "sqlite3.h"
@interface YcwSecondViewController : UIViewController
@property (strong,nonatomic) IBOutlet UITextField *danciTextfield;
@property (strong,nonatomic) IBOutlet UITextField *chineseTextField;
- (IBAction)addWord:(id)sender;
@property NSMutableArray *array;
@end
YcwSecondViewController.m文件
@interface YcwSecondViewController () { sqlite3 *db; } @end @implementation YcwSecondViewController - (void)viewDidLoad { [super viewDidLoad]; self.title = @"添加单词"; NSLog(@"%@",self.array); } - (IBAction)addWord:(id)sender { char *errMsg; const char *dbPath = [[self getDBPath] UTF8String]; if (sqlite3_open(dbPath,&db)== SQLITE_OK) { NSString *insertSQL = [NSString stringWithFormat:@"INSERT INTO Words values('%@','%@')",self.danciTextfield.text,self.chineseTextField.text]; const char *insert_stmt = [insertSQL UTF8String]; if (sqlite3_exec(db,insert_stmt,&errMsg)==SQLITE_OK) { Word *word = [[Word alloc]init]; word.danci = self.danciTextfield.text; word.chinese = self.chineseTextField.text; [self.array addObject:word]; self.danciTextfield.text = @""; self.chineseTextField.text = @""; NSLog(@"添加成功"); [self.danciTextfield becomeFirstResponder]; NSLog(@"%@",self.array); }else{ NSLog(@"插入数据错误%s",errMsg); sqlite3_free(errMsg); } sqlite3_close(db); } } - (NSString *)getDBPath { NSString *string = [NSString stringWithFormat:@"%@/Documents/db2.sqlite",NSHomeDirectory()]; return string; } @end （编辑：李大同）
【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!
|
