程序收藏

                   本文小白 仅供提醒

  程序功能收藏:  第三方的收藏功能LKDBHelper

            收藏的判断

// 收藏

- (void)button:(UIButton *)button

{

   

    if ([button.titleLabel.text isEqualToString:@"收藏"]) {

        // 打开数据库

        LKDBHelper *dbHelper = [Collect getUsingLKDBHelper];

        

        // 创建表

        [dbHelper createTableWithModelClass:[Collect class]];

        

        // 插入数据

        Collect *cc = [[Collect alloc] init];

        cc.title = self.manhuaName;

        cc.cover_url = self.manhuaPicurl;

        cc.lastup = self.manhuaGengxin;

        cc.artist_name = self.manhuaAuthorName;

        cc.grade_ave = self.manhuaNum;

        cc.comic_id = self.manhuaID;

        cc.typeName = self.manhuaFenName;

        cc.brief_intrd = self.manhuaJianjie;

        // 异步 插入数据

        [dbHelper insertToDB:cc];

        

        [_shouButton setTitle:@"取消收藏" forState:UIControlStateNormal];

    }

    

    if ([button.titleLabel.text isEqualToString:@"取消收藏"]) {

        // 打开数据库

        LKDBHelper *dbHelper = [Collect getUsingLKDBHelper];

        

         _array =  [dbHelper searchWithSQL:@"select * from @t" toClass:[Collect class]];

        // 删除数据

        for (int index = 0; index < _array.count; index++) {

            if ([[_array[index] title] isEqualToString:self.manhuaName]) {

               

                [dbHelper deleteToDB:_array[index]];

            }

        }

        [_shouButton setTitle:@"收藏" forState:UIControlStateNormal];

    }

}

调出在数据库的应用 查询

 // 打开数据库

    LKDBHelper *dbHelper = [Collect getUsingLKDBHelper];

    

    _a =  [dbHelper searchWithSQL:@"select * from @t" toClass:[Collect class]];

    for (int inde = 0; inde < _a.count; inde++) {

        

        NSLog(@"dsdsdsds %@", [_a[inde] title]);

    }