iOS 问题：求教，sqlite3数据库插入数据总是失败，请问是啥原因？
NSString *resourcePath = [[NSBundle mainBundle] resourcePath];
NSString *path = [resourcePath stringByAppendingPathComponent:DB_NAME];
NSFileManager *fileManager = [NSFileManager defaultManager];
NSLog(@"path,%@",path);
BOOL find = [fileManager fileExistsAtPath:path];
NSLog(@"find,%hhd",find);
NSLog(@"find");
// 2.打开iPhone上的sqlite3的数据库文件
// 判断数据库是否打开
if(sqlite3_open([path UTF8String], &) != SQLITE_OK)
sqlite3_close(database);
NSLog(@"打开数据库文件失败");
NSLog(@"数据库打开成功");
// 3.准备sql语句
NSMutableString *sqlStr = [NSMutableString string];
for (NSDictionary *item in weatherInfo){
NSString *dd=item[@"wid"];
NSString *insertSqljokes = [[NSString alloc] initWithFormat:@"INSERT INTO jokes(name,code,nearing,comments,zhongwen) VALUES('%@','%@','%@','%@','%@');",item[@"name"],item[@"code"],item[@"nearing"],item[@"comments"],item[@"zhongwen"]];
NSLog(@"insertSqljokes,%@",insertSqljokes);
const char *selectS
selectSql = [insertSqljokes UTF8String];
sqlite3_stmt * //用于保存编译好的SQL语句
//执行查询
if (sqlite3_prepare_v2(database, selectSql, -1, &, nil)==SQLITE_OK) {
NSLog(@"插入成功");
if (sqlite3_prepare_v2(database, selectSql, -1, &, nil)!=SQLITE_OK) {
NSLog(@"插入失败");
sqlite3_close(database);
求教，sqlite3数据库插入数据总是失败，请问是啥原因？
NSString *resourcePath = [[NSBundle mainBundle] resourcePath];
NSString *path = [resourcePath stringByAppendingPathComponent:DB_NAME];
NSFileManager *fileManager = [NSFileManager defaultManager];
NSLog(@"path,%@",path);
BOOL find = [fileManager fileExistsAtPath:path];
NSLog(@"find,%hhd",find);
NSLog(@"find");
// 2.打开iPhone上的sqlite3的数据库文件
// 判断数据库是否打开
if(sqlite3_open([path UTF8String], &) != SQLITE_OK)
sqlite3_close(database);
NSLog(@"打开数据库文件失败");
NSLog(@"数据库打开成功");
// 3.准备sql语句
NSMutableString *sqlStr = [NSMutableString string];
for (NSDictionary *item in weatherInfo){
NSString *dd=item[@"wid"];
NSString *insertSqljokes = [[NSString alloc] initWithFormat:@"INSERT INTO jokes(name,code,nearing,comments,zhongwen) VALUES('%@','%@','%@','%@','%@');",item[@"name"],item[@"code"],item[@"nearing"],item[@"comments"],item[@"zhongwen"]];
NSLog(@"insertSqljokes,%@",insertSqljokes);
const char *selectS
selectSql = [insertSqljokes UTF8String];
sqlite3_stmt * //用于保存编译好的SQL语句
//执行查询
if (sqlite3_prepare_v2(database, selectSql, -1, &, nil)==SQLITE_OK) {
NSLog(@"插入成功");
if (sqlite3_prepare_v2(database, selectSql, -1, &, nil)!=SQLITE_OK) {
NSLog(@"插入失败");
sqlite3_close(database);
共有 1 个回答
sql文有问题吧
登录后方可回复
登录后方可回答
耗时 0.1104 秒HONEYWELL系统故障处理问答_百度文库
两大类热门资源免费畅读
续费一年阅读会员，立省24元！
评价文档：
17页免费5页免费47页免费34页免费270页4下载券 4页免费4页免费44页1下载券2页免费2页免费
喜欢此文档的还喜欢46页免费12页4下载券90页免费2页免费17页免费
HONEYWELL系统故障处理问答|H​O​N​E​Y​W​E​L​L​系​统​故​障​处​理​问​答
把文档贴到Blog、BBS或个人站等：
普通尺寸(450*500pix)
较大尺寸(630*500pix)
你可能喜欢}