應(yīng)用程序直接去連接數(shù)據(jù)庫，并對(duì)數(shù)據(jù)庫進(jìn)行增刪改查
準(zhǔn)備工作：
1.連接數(shù)據(jù)庫的第三方工具：https://github.com/oleghnidets/OHMySQL
2.數(shù)據(jù)庫：數(shù)據(jù)庫地址、數(shù)據(jù)庫名稱、端口號(hào)、用戶名、用戶密碼
第一步：連接數(shù)據(jù)庫
連接數(shù)據(jù)庫的測(cè)試參數(shù)：
用戶名：wangsan
密碼：123456
服務(wù)器域名：ceshi.cn
數(shù)據(jù)庫名字:ceshi
端口號(hào):10000
//初始化一個(gè)連接用戶對(duì)象
OHMySQLUser *auser = [[OHMySQLUser alloc] initWithUserName:@"wangsan"
password:@"123456"
serverName:@"ceshi.cn"
dbName:@"ceshi"
port:10000
socket:@"ceshi.cn"];
OHMySQLStoreCoordinator *coordinator = [[OHMySQLStoreCoordinator alloc] initWithUser:auser];
//連接
[coordinator connect];
//判斷是否連接成功我們可以ping一下
if (coordinator.isConnected == YES) {
switch ([coordinator pingMySQL]) {
case OHResultErrorTypeNone:
{
//數(shù)據(jù)庫連接成功
}
break;
case OHResultErrorTypeLost:
{
//與服務(wù)器的連接丟失
}
break;
case OHResultErrorTypeGone:
{
//MySQL服務(wù)器已經(jīng)消失了。
}
break;
case OHResultErrorTypeUnknown:
{
//未知錯(cuò)誤
}
break;
default:
break;
}
}else{
}
判斷連接成功后獲取對(duì)象并將對(duì)象存起來，這樣就不用每次查詢數(shù)據(jù)連接一次
//獲取上下文
OHMySQLQueryContext *queryContext = [OHMySQLQueryContext new];
queryContext.storeCoordinator = coordinator;
[OHMySQLManager sharedManager].mainQueryContext = queryContext;
對(duì)數(shù)據(jù)庫操作的使用方法：
增：在表userTable新增一條數(shù)據(jù)，我們將要傳的值以NSDictionary形式傳輸
NSDictionary *dic = @{@"addTime" :nowTime,
@"name": self.nameView.textFile.text,
@"phoneNumber": self.phoneView.textFile.text,
@"password": self.passwordView.textFile.text };
OHMySQLQueryRequest *query = [OHMySQLQueryRequestFactory INSERT:@"userTable" set:dic];
NSError * error = nil ;
NSArray * tasks = [[OHMySQLManager sharedManager].mainQueryContext executeQueryRequestAndFetchResult: query error:&error];
NSLog(@"%@, %@", tasks,error.description);
if (!error) {
NSLog(@"添加成功");
}else{
NSLog(@"%@",error.description);
}
刪：刪除userTable表中name叫王三的人，condition表示條件等于數(shù)據(jù)庫while
OHMySQLQueryRequest *query = [OHMySQLQueryRequestFactory DELETE:@"userTable" condition:@"name='王三'"];
NSError error = nil
NSArray * tasks = [[OHMySQLManager sharedManager].mainQueryContext executeQueryRequestAndFetchResult:query error:&error];
NSLog(@"%@, %@", tasks,error.description);
if (!error) {
NSLog(@"刪除成功");
}else{
NSLog(@"%@",error.description);
}
改：修改表userTable中名字叫王三的手機(jī)號(hào)
//要修改的手機(jī)號(hào)以鍵值對(duì)的形式（phoneNumber是數(shù)據(jù)庫存儲(chǔ)的字段）
NSDictionary *dic = @{@"phoneNumber" : @“18862033568”};
//條件是名字叫王三
NSString *sqltStr1 = [NSString stringWithFormat:@"name = '%@'", @“王三”];
OHMySQLQueryRequest *query = [OHMySQLQueryRequestFactory UPDATE:@"userTable" set:dic condition:sqltStr1];
NSError error = nil
NSArray * tasks = [[OHMySQLManager sharedManager].mainQueryContext executeQueryRequestAndFetchResult:query error:&error];
NSLog(@"%@, %@", tasks,error.description);
if (!error) {
NSLog(@"修改成功");
}else{
NSLog(@"%@",error.description);
}
查：查詢表userTable中名字叫'王五',手機(jī)號(hào)是'18895322310'的人，并以ID進(jìn)行降序排列
NSString *sqltStr =@"name = '王五' AND phoneNumber = '18895322310'";
//orderBy：依據(jù)什么排序
//ascending：是否為升序，YES為升序，NO為降序
OHMySQLQueryRequest *query = [OHMySQLQueryRequestFactory SELECT:@"userTable" condition:sqltStr orderBy:@[@"id"] ascending:YES];
NSError error = nil
NSArray * tasks = [[OHMySQLManager sharedManager].mainQueryContext executeQueryRequestAndFetchResult:query error:&error];
NSLog(@"%@, %@", tasks,error.description);
if (!error) {
NSLog(@"查詢成功");
NSLog(@"%@", tasks）；
}else{
NSLog(@"%@",error.description);
}
查的擴(kuò)展：
查：查詢表userTable中名字叫'王五',手機(jī)號(hào)是'18895322310'的人的password，并以ID進(jìn)行降序排列（注釋：這個(gè)方法OHMySQL里面沒有是我自己添加的，根據(jù)自己需要查詢內(nèi)容可以自己添加查詢方法）
NSString *sqltStr =@"name = '王五' AND phoneNumber = '18895322310'";
//orderBy：依據(jù)什么排序
//ascending：是否為升序，YES為升序，NO為降序
//field：只查詢password
OHMySQLQueryRequest *query = [OHMySQLQueryRequestFactory SELECT:@"userTable" field:@"password" condition:sqltStr orderBy:@[@"id"] ascending:YES];
NSError error = nil
NSArray * tasks = [[OHMySQLManager sharedManager].mainQueryContext executeQueryRequestAndFetchResult:query error:&error];
NSLog(@"%@, %@", tasks,error.description);
if (!error) {
NSLog(@"查詢成功");
NSLog(@"%@", tasks）；
}else{
NSLog(@"%@",error.description);
}
后續(xù)將上Demo
問題：手動(dòng)導(dǎo)入OHMySQL框架時(shí)可能報(bào)錯(cuò)(錯(cuò)誤截圖如下)，可能是缺少了libc++，所以要添加libc++，設(shè)置->target-->build phase->Link Binary With Libraries->添加 搜索libc++，選擇libc++.tbd文件。
