经过昨天下午和今天上午的不懈努力，终于通过了SQLite的学习。

我们现在这里定义一个有关SQLIte的封装类，便于我在后面的用户注册，用户密码找回，和登录界面的使用

1.首先我们看看我们建立的userModel，虽然很多属性没有使用，但是作为备用

LCUserMessageModel.h文件。

#import <Foundation/Foundation.h>

@interface LCUserMessageModel : NSObject<NSCoding>

@property (assign,nonatomic)NSInteger QQ;

@property (copy,nonatomic)NSString *userName;

@property (copy,nonatomic)NSString *userAddress;

@property (copy,nonatomic)NSString *userMobilephineNumber;

@property (copy,nonatomic)NSString *userPassword;

@property (copy,nonatomic)NSString *userRePassword;

@property (copy,nonatomic)NSString *userStuID;

@property (copy,nonatomic)NSString *userSeriousFriendName;

@property (copy,nonatomic)NSString *userPIDSixNumber;

@end

LCUserMessageModel.m文件，要说明的是，如果我是用了SQLite进行存储，那么就不需要NSCODing协议了，但是我使用的原因是因为我多次修改，使用了文件存储的方法。

//

//  LCUserMessageModel.m

//  手机QQ客户端

//

//  Created by lichan on 13-12-11.

//  Copyright (c) 2013年 com.lichan. All rights reserved.

//

#import "LCUserMessageModel.h"

@implementation LCUserMessageModel

@synthesize QQ, userAddress,userMobilephineNumber,userName,userPassword,userPIDSixNumber,userRePassword,userSeriousFriendName,userStuID;

- (void)encodeWithCoder:(NSCoder *)aCoder

{

       [aCoder encodeInteger:QQ forKey:@"QQ"];

       [aCoder encodeObject:userName forKey:@"userName"];

       [aCoder encodeObject:userAddress forKey:@"userAddress"];

       [aCoder encodeObject:userMobilephineNumber forKey:@"userMobilephineNumber"];

       [aCoder encodeObject:userPassword forKey:@"userPassword"];

       [aCoder encodeObject:userRePassword forKey:@"userRePassword"];

       [aCoder encodeObject:userStuID forKey:@"userStuID"];

       [aCoder encodeObject:userSeriousFriendName forKey:@"userSeriousFriendName"];

       [aCoder encodeObject:userPIDSixNumber forKey:@"userPIDSixNumber"];

}

- (id)initWithCoder:(NSCoder *)aDecoder

{

    if (self = [super init]) {

        self.QQ = [aDecoder decodeIntegerForKey:@"QQ"];

        self.userName = [aDecoder decodeObjectForKey:@"userName"];

        self.userAddress = [aDecoder decodeObjectForKey:@"userAddress"];

        self.userMobilephineNumber = [aDecoder decodeObjectForKey:@"userMobilephineNumber"];

        self.userPassword = [aDecoder decodeObjectForKey:@"userPassword"];

        self.userRePassword = [aDecoder decodeObjectForKey:@"userRePassword"];

        self.userStuID = [aDecoder decodeObjectForKey:@"userStuID"];

        self.userSeriousFriendName = [aDecoder decodeObjectForKey:@"userSeriousFriendName"];

        self.userPIDSixNumber = [aDecoder decodeObjectForKey:@"userPIDSixNumber"];

    }

    return self;

}

-(NSString *)description

{

    return [NSString stringWithFormat:@"QQ:%d password:%@",self.QQ,self.userPassword];

}

@end

2.关于SQLite进行属性封装的类。很明显，我继承了NSOBject类型。注释给予说明

#import <Foundation/Foundation.h>

#import <sqlite3.h>

@class LCUserMessageModel;

@interface LCSQLite3Methods : NSObject

{

    sqlite3 *database;

    NSError *error;

    NSString *DBFilePath;

}

- (LCUserMessageModel *)queryFromDB;  //查找所有的QQ注册信息，很多时候用不上

- (NSInteger)insertORUpdateToDB:(LCUserMessageModel *)user;//注册账号的使用调用

- (NSMutableArray *)findUserPasswordByMobilePhoneNumber:(NSString *)phoneNumber;//找回密码界面调用此方法

- (NSMutableArray *)findUserPasswordByQQ:(NSInteger )qq Password:(NSString *)password;//用户登录时候调用此方法

@end

3.密码找回界面，SQLite接口类的使用

1）LCFInd.h文件，不再赘述

#import <UIKit/UIKit.h>

@class LCSQLite3Methods;

@interface LCFindPSWViewController : UIViewController

@property (weak, nonatomic) IBOutlet UITextField *mobilePhoneNumber;

@property (strong,nonatomic)LCSQLite3Methods *SQLiteMethods;

- (IBAction)findPSWButtonPressed:(id)sender;

-(IBAction)textFieldDoneEditing:(id)sender;

@end

2）实现文件，由于我只能依赖手机号进行找回，除非用户写入了QQ。唯一保险的办法是直接找回所有通过此手机号注册的所有QQ和密码。后续会完善此BUG。

#import "LCFindPSWViewController.h"

#import "LCSQLite3Methods.h"

#import "LCUserMessageModel.h"

@interface LCFindPSWViewController ()

@property (strong,nonatomic)LCUserMessageModel *userModel;

@end

@implementation LCFindPSWViewController

- (id)initWithNibName:(NSString *)nibNameOrNil bundle:(NSBundle *)nibBundleOrNil

{

    self = [super initWithNibName:nibNameOrNil bundle:nibBundleOrNil];

    if (self) {

        self.title = @"密码找回";

        // Custom initialization

    }

    return self;

}

- (void)viewDidLoad

{

    [super viewDidLoad];

     self.navigationController.navigationBarHidden = NO;

    self.SQLiteMethods = [[LCSQLite3Methods alloc]init];

    // Do any additional setup after loading the view from its nib.

}

- (void)didReceiveMemoryWarning

{

    [super didReceiveMemoryWarning];

    // Dispose of any resources that can be recreated.

}

- (IBAction)findPSWButtonPressed:(id)sender {

     NSString *MPnumber = self.mobilePhoneNumber.text;

     NSMutableArray *findArray =[self.SQLiteMethods findUserPasswordByMobilePhoneNumber:MPnumber];

       NSString *message = [NSString stringWithFormat:@"此手机号注册的QQ号码：%@",findArray];

       UIAlertView *alertView = [[UIAlertView alloc]initWithTitle:@"恭喜您，密码找回成功！" message:message delegate:self cancelButtonTitle:@"好的" otherButtonTitles:nil];

       [alertView show];

//    self.userModel = [[LCUserMessageModel alloc]init];

//

//    NSString *path = [NSSearchPathForDirectoriesInDomains(NSDocumentDirectory, NSAllDomainsMask, YES) objectAtIndex:0];

//    NSString *userFilePath = [path stringByAppendingPathComponent:self.mobilePhoneNumber.text];

//

//    NSMutableData *data = [NSMutableData dataWithContentsOfFile:userFilePath];

//

//    self.userModel = [NSKeyedUnarchiver unarchiveObjectWithData:data];

//

//    NSString *MPnumber = self.mobilePhoneNumber.text;

//

//    NSString *message = [NSString stringWithFormat:@"已初始化账号为%@的密码为%@,请尽快修改密码。",MPnumber,self.userModel.userPassword];

//    UIAlertView *alertView = [[UIAlertView alloc]initWithTitle:@"恭喜您，密码找回成功！" message:message delegate:self cancelButtonTitle:@"好的" otherButtonTitles:nil];

//

//    [alertView show];

}

#pragma mark 取消键盘响应的方法

-(IBAction)textFieldDoneEditing:(id)sender

{

    [sender resignFirstResponder];

}

@end