河北地质大学本科生毕业设计
附录
附录A：
@interfaceDataBaseTool :NSObject
//创建数据库对象
+(FMDatabase *)getDataBase;
//查找groupTable中的内容
+(NSMutableArray *)searchGroupTable;
//查找menuTable中的内容
+(NSMutableArray *)searchMenuTableWithKind:(NSString *)kind;
/*------------------ orderTable ------------------*/ //查找orderTable中的内容
+(NSMutableArray *)searchOrderTable;
//点菜时查询orderTable中是否存在该数据
+(void)searchOrderTableWithMenuID:(Menu *)menu;
//修改orderTable中menuNum和remark数据
+(void)updateOrderTableWithMenuNumTF:(UITextField *)menuNumTF WithOrder:(Order *)order;
+(void)updateOrderTableWithRemark:(UITextField *)remarkTF WithOrder:(Order *)order;
//移除orderTable中的数据 +(void)deleteOrderTable;
/*------------------- group_recordTable ---------------*/ //查询group_recordTable中的数据
+(NSMutableArray *)searchGroup_RecordTable;
//向group_recordTable中插入数据
+(void)insertGroup_RecordTableWith:(group_record *)gRecord;
//清空group_recordTable中的数据 +(void)deleteGroup_RecordTable;
//删除group_recordTable中的一条记录
+ (void)deleteGroup_RecordTableWithgRecordTime:(NSString *)gRecordTime;
/*-------------------- recordTable --------------------*/
23
河北地质大学本科生毕业设计
//查询recordTable中的数据
+(NSMutableArray *)searchRecordTableWithNum:(int)num;
//删除recordTable中的一条数据
+(void)deleteRecordTableWithNum:(int)num;
//向recordTable中插入数据
+(void)insertRecordTableWith:(Record *)record;
//清空recordTable中的数据 +(void)deleteRecordTable;
@end
附录B：
staticFMDatabase * _db;
@implementation DataBaseTool
#pragma mark - 创建数据库对象 +(FMDatabase *)getDataBase {
//copy数据库文件
NSString * filePath = [NSSearchPathForDirectoriesInDomains(NSDocumentDirectory, NSUserDomainMask, YES)[0] stringByAppendingPathComponent:@\]; NSLog(@\,filePath);
NSString * path = [[NSBundlemainBundle] pathForResource:@\ofType:@\]; NSFileManager * manager =[NSFileManagerdefaultManager]; if ([manager fileExistsAtPath:filePath] == NO) {
[managercopyItemAtPath:path toPath:filePath error:nil]; }
//创建数据库文件的对象 if (_db == nil) {
_db = [[FMDatabasealloc]initWithPath:filePath]; }
return_db; }
#pragma mark - 查找groupTable中的内容 +(NSMutableArray *)searchGroupTable {
24
河北地质大学本科生毕业设计
if ([_dbopen] == NO) {
[_dbclose]; returnnil; }
FMResultSet * rs = [_dbexecuteQueryWithFormat:@\]; NSMutableArray * array = [[NSMutableArrayalloc]init]; while ([rs next]) {
Group * group =[[Groupalloc]init];
group.group_id = [rs intForColumn:@\];
group.group_kind = [rs stringForColumn:@\]; group.group_name = [rs stringForColumn:@\]; group.group_image = [rs stringForColumn:@\];
group.group_highlightImage = [rs stringForColumn:@\]; [arrayaddObject:group]; [grouprelease]; }
[rsclose]; [_dbclose];
return [array autorelease]; }
#pragma mark - 查找menuTable中的内容
+(NSMutableArray *)searchMenuTableWithKind:(NSString *)kind {
if ([_dbopen] == NO) {
[_dbclose]; returnnil; }
FMResultSet * rs = [_dbexecuteQueryWithFormat:@\iKind = %@\,kind];
NSMutableArray * array = [[NSMutableArrayalloc]init]; while ([rs next]) {
Menu * menu = [[Menualloc]init];
menu.menu_id = [rs intForColumn:@\];
menu.menu_groupID = [rs intForColumn:@\]; menu.menu_iKind = [rs stringForColumn:@\]; menu.menu_name = [rs stringForColumn:@\]; menu.menu_price = [rs intForColumn:@\]; menu.menu_unit = [rs stringForColumn:@\]; menu.menu_detail=[rs stringForColumn:@\];
menu.menu_picName = [rs stringForColumn:@\];
25
河北地质大学本科生毕业设计
[arrayaddObject:menu]; [menurelease]; }
[rsclose]; [_dbclose];
return [array autorelease]; }
#pragma mark - 查找orderTable中的全部内容 +(NSMutableArray *)searchOrderTable {
if ([_dbopen] == NO) {
[_dbclose]; returnnil; }
FMResultSet * rs = [_dbexecuteQueryWithFormat:@\]; NSMutableArray * array = [[NSMutableArrayalloc]initWithCapacity:0]; while ([rs next]) {
Order * order = [[Orderalloc]init];
order.order_ID = [rs intForColumn:@\];
order.order_menuName = [rs stringForColumn:@\]; order.order_Price = [rs stringForColumn:@\]; order.order_kind = [rs stringForColumn:@\];
order.order_menuNum = [rs intForColumn:@\]; order.order_remark = [rs stringForColumn:@\]; [arrayaddObject:order]; [orderrelease]; }
[rsclose]; [_dbclose];
return [array autorelease]; }
#pragma mark -点菜时查询orderTable中是否存在该数据 +(void)searchOrderTableWithMenuID:(Menu *)menu {
if ([_dbopen]== NO) {
[_dbclose]; return; }
FMResultSet * rs =[_dbexecuteQueryWithFormat:@\= %d\,menu.menu_id];
26
河北地质大学本科生毕业设计
if ([rs next]) {
//存在这个数据,改变该数据的menuNum值 int number = [rs intForColumn:@\];
[_dbexecuteUpdateWithFormat:@\id = %d\,number+1,menu.menu_id]; } else {
//不存在该条数据就插入
[_dbexecuteUpdateWithFormat:@\
orderTable(id,menuName,Price,kind,menuNum,remark) VALUES
(%d,%@,%@,%@,%d,%@)\,menu.menu_id,menu.menu_name,[NSStringstringWithFormat:@\%d\,menu.menu_price],menu.menu_iKind,1,@\]; } }
#pragma mark - 修改orderTable中menuNum和remark数据
+(void)updateOrderTableWithMenuNumTF:(UITextField *)menuNumTF WithOrder:(Order *)order {
if ([_dbopen] == NO) {
[_dbclose]; return ; }
[_dbexecuteUpdateWithFormat:@\= %d\,[menuNumTF.textintValue],order.order_ID]; [_dbclose]; }
+(void)updateOrderTableWithRemark:(UITextField *)remarkTF WithOrder:(Order *)order {
if ([_dbopen] == NO) {
[_dbclose]; return ; }
[_dbexecuteUpdateWithFormat:@\= %d\,remarkTF.text,order.order_ID]; }
#pragma mark - 移除orderTable中的数据 +(void)deleteOrderTable {
27