//
// ViewController.m
// test_sqlite
//
// Created by 郑玉洋 on 2017/4/13.
// Copyright © 2017年 郑玉洋. All rights reserved.
//
#import "ViewController.h"
@interface ViewController ()
@end
@implementation ViewController
- (void)addSql:(id)sender{
//为了测试这里利用随机数与for循环进行多次插入不同数据
for (NSInteger i = 0; i < 10; i++) {
NSString * sql = [NSString stringWithFormat:@"insert into t_text ('%@') values ('%@');", @"name", [NSString stringWithFormat:@"测试--%zd",arc4random_uniform(99) ]];
char * errmsg;
sqlite3_exec(db, sql.UTF8String, NULL, NULL, &errmsg);
if (errmsg) {
NSLog(@"插入失败--%s",errmsg);
}else{
NSLog(@"插入成功");
}
}
}
- (void)delSql:(id)sender{
//这里删除随机id 大于3 小于6<