FMDB使用

1，导入FMDB库；
FMDB在github中的地址：https://github.com/ccgus/fmdb.git
下载完成解压，把目录下的fmdb导入工程


2，把FMDB库导入之后，再倒入静态库libsqlite3.0.tbd

3，最好建一个专门管理FMDB的类，里面包含增删改查的方法，这样调用的时候会比较方便。

FMDB使用基本的sqlite语句（t_student 为定义的表名）
插入数据：INSERT INTO t_student(age, score, name) VALUES (‘28’,’100’, ‘jonathan’);
例：NSString *insertSQL = [NSString stringWithFormat:@”INSERT INTO %@(%@) VALUES (%@)”,tableName,keyString,valuesString];

查询数据:
查询整个表：SELECT * FROM t_student;
例： NSString *selectSQL = [NSString stringWithFormat:@”SELECT *FROM %@”,tableName];
按照条件查询：SELECT * FROM t_student WHERE name = ‘cnw’， age = ‘20’;
例： NSString * selectSQL = [NSString stringWithFormat:@”SELECT *FROM %@ WHERE %@”,tableName,selectMstring];

修改数据：
UPDATE t_student SET name = ‘MM’ WHERE age = ‘10’
UPDATE t_student SET name = ‘MM’ ,age = ‘12’ WHERE age = ‘10’ and name = ‘cnw’
例： NSString *updateSQL = [NSString stringWithFormat:@”UPDATE %@ SET %@ WHERE %@”,tableName,updateMstring,whereMstring];
注：where后面如果多条件and一定要有，并且不能让and结尾
UPDATE t_student SET name = ‘MM’ ,age = ‘12’ WHERE age = ‘10’ and name = ‘cnw’ and或者UPDATE t_student SET name = ‘MM’ ,age = ‘12’ WHERE age = ‘10’ ，name = ‘cnw’ 会报错

删除数据：
删除所有数据：DELETE FROM t_student;
例：NSString *deleteSQL = [NSString stringWithFormat:@”DELETE FROM %@”,tableName];
删除指定数据：DELETE FROM t_student WHERE name = ‘cnw’ age = 20;
DELETE FROM t_student WHERE name = ‘qlt’ and age >26 and score < 80;
例：NSString *sql = [NSString stringWithFormat:@”DELETE FROM %@ WHERE %@”,tableName,whereString];

如果创建用户路径的时候，使用Documents，首字母要大写，否则也会报错