数据库fmdb

最新推荐文章于 2022-09-20 11:14:58 发布

远远100

最新推荐文章于 2022-09-20 11:14:58 发布

阅读量282

点赞数

文章标签： fmdb

本文链接：https://blog.csdn.net/pyy11111111/article/details/51592986

版权

#import "ViewController.h"
#import "FMDatabase.h"

//dic  --->  哈希算法
//保存   1000     999   ---->  数据库 (哈希算法)

//  --->  10GB  PC
//  --->  Sqlite  --->  基本单位(表)  字段
// int    integer
// float  real
// string text(varchar)
// data   blob

//区分数据唯一性 ---> 主键

//SQL(Structured Query Language)

//表
//Student  name   age
//创建一个表
//create table if not exists 表名 (字段1 字段类型,字段2 字段类型,...);

//create table if not exists Student (id integer primary key autoincrement,name text,age integer);

//增  删  改  查
//插入数据
//insert into 表名 (字段名,...) values (值,...);
//insert into Student (name,age) values ('zhangsan',100);

//查 *
//select 字段,... from 表名 where语句 order by 字段 desc | asc;
//select name,age from Student;
//select * from Student where name = 'zhangsan' and age > 100;
//select * from Student order by age desc;

//改
//update 表名 set 字段 = 值 条件
//update Student set age = 20 where name = 'zhangsan';

//删除
//delete from 表名 where 语句;
//delete from Student where name = 'zhangsan';

//系统

//库文件 /Applications/Xcode.app/Contents/Developer/Platforms/iPhoneOS.platform/Developer/SDKs/iPhoneOS8.4.sdk/usr/lib/libsqlite3.0.dylib

@interface ViewController ()

@end

@implementation ViewController

- (void)viewDidLoad {
    [super viewDidLoad];
    // Do any additional setup after loading the view, typically from a nib.
    //dataBase
    //.txt
    //创建数据库  ---->  沙盒
    NSString *docPath = [NSString stringWithFormat:@"%@/Documents/Student.db",NSHomeDirectory()];
    NSLog(@"%@",docPath);    //
    
    //单例  ---->  全局
    FMDatabase *dataBase = [FMDatabase databaseWithPath:docPath];
    [dataBase open];
    
    //Cocochina
    //http://course.tuicool.com/course/tag/ios-dev
    
    //创建表
    NSString *sqlStr = @"create table if not exists Student (id integer primary key autoincrement,name text,age integer)";
    [dataBase executeUpdate:sqlStr];
    
#if 0
    //增加数据
    sqlStr = @"insert into Student (name,age) values (?,?)";
    for(NSInteger i = 0; i < 10;i++ )
    {
        NSString *name = [NSString stringWithFormat:@"qianfeng%ld",i];
        NSInteger age = arc4random() % 100 + 1;
        //全部是对象
        [dataBase executeUpdate:sqlStr,name,[NSNumber numberWithInteger:age]];
    }
#endif
    
    //查询
    sqlStr = @"select * from Student where age < ?";
    FMResultSet *result = [dataBase executeQuery:sqlStr,@50];
    while ([result next]) {
        //类型ForColumn:
        NSLog(@"%@",[result stringForColumn:@"name"]);
        NSLog(@"%d",[result intForColumn:@"age"]);
    }
    
    //修改
    sqlStr = @"update Student set age = ? where name = ?";
    [dataBase executeUpdate:sqlStr,@1000,@"qianfeng0"];
    
//    //删除  和  修改
    sqlStr = @"delete from Student where age < 50";
    
    [dataBase executeUpdate:sqlStr];
    
    [dataBase close];
    
    
    
    
    
    
    
}

- (void)didReceiveMemoryWarning {
    [super didReceiveMemoryWarning];
    // Dispose of any resources that can be recreated.
}

@end

使用方法

#import "CYDataBase.h"

#import "FMDatabase.h"

@implementation CYDataBase

{

FMDatabase *_fmDataBase;

}

- (id)init

{

self = [super init];

if (self) {

NSString *docPath = [NSString stringWithFormat:@"%@/Documents/User.db",NSHomeDirectory()];