/**
创新互联公司主要从事网站制作、网站建设、网页设计、企业做网站、公司建网站等业务。立足成都服务红桥,10年网站建设经验,价格优惠、服务专业,欢迎来电咨询建站服务:13518219792
* @author fangbmian, 16-03-18 10:03:50
*
* 获取本地品牌数据
*/
NSString *dbFilePath = [[NSBundle mainBundle] pathForResource:@"name" ofType:@"db"];
if (!dbFilePath) return;
carBrandList = [NSMutableArray new];
dispatch_async(dispatch_get_global_queue(DISPATCH_QUEUE_PRIORITY_HIGH, 0), ^{
queue = [FMDatabaseQueue databaseQueueWithPath:dbFilePath];
[queue inDatabase:^(FMDatabase *db)
{
FMResultSet *rs = [db executeQuery:@"select distinct CAR_BRAND,CAR_BRAND_LOGO from CAR_VEHICLE"];
while([rs next])
{
CarBrandInfoBean * info = [CarBrandInfoBean new];
info.carBrand = [rs stringForColumn:@"CAR_BRAND"];
info.carBrandLogo = [rs stringForColumn:@"CAR_BRAND_LOGO"];
[carBrandList addObject:info];
}
}];
});
/**
* @author fangbmian, 16-03-17 13:03:01
*
* item被点击
*
* @param brandName 品牌名称
*/
-(void)didClickItem:(NSString*)brandName
{
if (!queue) return;
NSMutableArray *carList = [NSMutableArray new];
[queue inDatabase:^(FMDatabase *db)
{
NSString *sql = [NSString stringWithFormat:@"select CAR_BRAND,CAR_SERIES,CAR_YEAR,CAR_TYPE,CAR_GAS,CAR_ID from CAR_VEHICLE where CAR_BRAND = \'%@\'", brandName];
FMResultSet *rs = [db executeQuery:sql];
while([rs next])
{
CarInfoBean *info = [CarInfoBean new];
info.carBrand = [rs stringForColumn:@"CAR_BRAND"];
info.carSeries = [rs stringForColumn:@"CAR_SERIES"];
info.carYear = [rs stringForColumn:@"CAR_YEAR"];
info.carType = [rs stringForColumn:@"CAR_TYPE"];
info.carGas = [rs stringForColumn:@"CAR_GAS"];
info.carTypeId = [rs stringForColumn:@"CAR_ID"];
[carList addObject:info];
}
}];
}
你得先创建一个对象啊 FMResultSet *resultAccurate = [FMResultSet new]; resultAccurate = [dbOperation executeQueryAccurately:mySqlAccurately];
1、假如创建一张PersonVO表，并存储自定义PersonVO类的数据
NSString *createSql = @"CREATE TABLE IF NOT EXISTS PersonVO (ID TEXT NOT NULL,goodsName TEXT NOT NULL,shopNo TEXT NOT NULL)"
2、根据条件查询PersonVO表中的数据
使用FMResultSet在' FMDatabase '上执行查询的结果
/**
NSData- NSStringNSString *aString = [[NSString alloc] initWithData:adata encoding:NSUTF8StringEncoding];NSString-NSDataNSString *aString = @"1234abcd";NSData *aData = [aString dataUsingEncoding: NSUTF8StringEncoding];2.NSData 与 ByteNSData- Byte数组NSString *testString = @"1234567890";NSData *testData = [testString dataUsingEncoding: NSUTF8StringEncoding];Byte *testByte = (Byte *)[testData bytes];for(int i=0;i[testData length];i++)printf("testByte = %d\n",testByte[i]);Byte数组- NSDataByte byte[] = {0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23};NSData *adata = [[NSData alloc] initWithBytes:byte length:24];Byte数组-16进制数Byte *bytes = (Byte *)[aData bytes];NSString *hexStr=@"";for(int i=0;i[encryData length];i++){NSString *newHexStr = [NSString stringWithFormat:@"%x",bytes[i]0xff]; ///16进制数if([newHexStr length]==1)hexStr = [NSString stringWithFormat:@"%@0%@",hexStr,newHexStr];elsehexStr = [NSString stringWithFormat:@"%@%@",hexStr,newHexStr];}NSLog(@"bytes 的16进制数为:%@",hexStr);16进制数-Byte数组///// 将16进制数据转化成Byte 数组NSString *hexString = @"3e435fab9c34891f"; //16进制字符串int j=0;Byte bytes[128]; ///3ds key的Byte 数组, 128位for(int i=0;i[hexString length];i++){int int_ch; /// 两位16进制数转化后的10进制数unichar hex_char1 = [hexString characterAtIndex:i]; ////两位16进制数中的第一位(高位*16)int int_ch1;if(hex_char1 = '0' hex_char1 ='9')int_ch1 = (hex_char1-48)*16; //// 0 的Ascll - 48else if(hex_char1 = 'A' hex_char1 ='F')int_ch1 = (hex_char1-55)*16; //// A 的Ascll - 65elseint_ch1 = (hex_char1-87)*16; //// a 的Ascll - 97i++;unichar hex_char2 = [hexString characterAtIndex:i]; ///两位16进制数中的第二位(低位)int int_ch2;if(hex_char2 = '0' hex_char2 ='9')int_ch2 = (hex_char2-48); //// 0 的Ascll - 48else if(hex_char1 = 'A' hex_char1 ='F')int_ch2 = hex_char2-55; //// A 的Ascll - 65elseint_ch2 = hex_char2-87; //// a 的Ascll - 97int_ch = int_ch1+int_ch2;NSLog(@"int_ch=%d",int_ch);bytes[j] = int_ch; ///将转化后的数放入Byte数组里j++;}NSData *newData = [[NSData alloc] initWithBytes:bytes length:128];NSLog(@"newData=%@",newData);3. NSData 与 UIImageNSData-UIImageUIImage *aimage = [UIImage imageWithData: imageData];//例:从本地文件沙盒中取图片并转换为NSDataNSString *path = [[NSBundle mainBundle] bundlePath];NSString *name = [NSString stringWithFormat:@"ceshi.png"];NSString *finalPath = [path stringByAppendingPathComponent:name];NSData *imageData = [NSData dataWithContentsOfFile: finalPath];UIImage *aimage = [UIImage imageWithData: imageData];UIImage- NSDataNSData *imageData = UIImagePNGRepresentation(aimae);
如果要存储复杂对象类型的数据, 该对象必须遵循NSCoding协议, 并实现对应代理方法
对象类型实现代理后, 在存储之前还有一部操作, 是把对象进行归档, 归档完成才可以使用FMDB进行存储, 对应类型为BLOB类型,.
如果要直接存储复杂对象, 不想写归档什么的玩意, 可以使用一个第三方框架 JRDB , 这个可以直接存储复杂对象, jrdb是基于FMDB进行的二次封装框架, 可以试试噢
pod会用么？会用的话，新建一个podfile文件，然后在podfile文件中添加 pod ‘FMDB'，保存后退出，然后输入pod install即可。