blocks|key|564827|text|核心数据是一种在iOS中持久化对象的技术，通常用作本地数据库。事实上，在iOS中，NSPersistentStore几乎总是作为SQLite数据库实现的。但是，如果您希望进行网络调用以从服务器上的数据库中获取数据，则Core+data不会执行此操作。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|564828|简而言之，您需要在您的服务器上构建一个允许您访问数据的web服务。处理服务和移动设备之间通信的一个好方法(当然不是唯一的方法)是使用套接字。Here+is+a+tutorial可以让你有一个好的开始。|564829|entityMap|0|LINK|mutability|MUTABLE|url|http://www.raywenderlich.com/3932/how-to-create-a-socket-based-iphone-app-and-server^0|15|H|0|1Y|I|0|0^^$0|@$1|2|3|4|5|6|7|P|8|@$9|Q|A|R|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|S|8|@]|D|@$9|T|A|U|1|V]]|E|$]]|$1|H|3|-4|5|6|7|W|8|@]|D|@]|E|$]]]|I|$J|$5|K|L|M|E|$N|O]]]]

Core Data is a technology for persisting objects in iOS and is often used as a local database. In fact, the <code>NSPersistentStore</code> is almost always implemented as a SQLite database in iOS. However, if you are looking to make network calls to get data from the database on your server, Core Data does not do that.

The short answer is that you need to build a web service on your server that allows you to access the data. A good way (though certainly not the only way) to handle the communications between your service and mobile device is with sockets. <a href="http://www.raywenderlich.com/3932/how-to-create-a-socket-based-iphone-app-and-server" rel="nofollow">Here is a tutorial</a> that can get you a good start.

blocks|key|6041662|text|CoreData实际上使用的是SQLite...您可以使用NSURLRequest访问数据库，然后使用请求创建一个NSData。根据您的服务器返回给您的格式(即JSON)，您可以将NSData转换为字典。这在JSON中看起来像这样：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|6041663|+NSDictionary+*contentDictionary+=+[NSJSONSerialization+JSONObjectWithData:contentServerResponse+options:NSJSONReadingMutableContainers+error:nil];|code-block|syntax|javascript|6041664|然后，您可以访问字典常用的键-值-访问并将内容分配给您的ViewController。|6041665|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

CoreData actually uses SQLite...
You can access your database with an NSURLRequest, then creating a NSData with the request.
Depending on the format which your Server gives you back (i.e. JSON) you can transform the NSData into a Dictionary. This would look like this with JSON:

<pre><code> NSDictionary *contentDictionary = [NSJSONSerialization JSONObjectWithData:contentServerResponse options:NSJSONReadingMutableContainers error:nil];
</code></pre>

then you can access the Dictionary usual Key-Value-Access and assign the content to your ViewController.

blocks|key|2689213|text|如果您使用的是MAMP，请尝试编写PHP脚本文件来访问JSON数据库，并在mySQL中使用json_encode函数将其回显为JSON文本。您可以使用很多解析器来解析iOS中的JSON。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2689214|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

If you are using MAMP try writing php script files to access the mySQL db and echo it as JSON text using json_encode function in PHP. You have many parsers to parse JSON in iOS.

blocks|key|1109120|text|可以连接到mysql数据库。我是通过php完成的，它会返回一个我的应用程序解析并存储的xml文件。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1109121|此链接也涵盖了此主题。|1109122|How+to+connect+to+a+MySQL+database+from+an+iPhone?|offset|length|1109123|entityMap|0|LINK|mutability|MUTABLE|url|https://stackoverflow.com/questions/468618/how-to-connect-to-a-mysql-database-from-an-iphone^0|0|0|0|1E|0|0^^$0|@$1|2|3|4|5|6|7|P|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|Q|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|R|8|@]|9|@$F|S|G|T|1|U]]|A|$]]|$1|H|3|-4|5|6|7|V|8|@]|9|@]|A|$]]]|I|$J|$5|K|L|M|A|$N|O]]]]

Connecting to a mysql database IS possible. I did it via php which returned an xml file which my app parsed and stored.

This link also covers this topic as well.

<a href="https://stackoverflow.com/questions/468618/how-to-connect-to-a-mysql-database-from-an-iphone">How to connect to a MySQL database from an iPhone?</a>

I'm searching for a way to connect an app with a database, created in Sequel Pro which is connected with a mySQL Server (started over MAMP).
I've already searched for some solutions but there are hundreds of different posts, some said that SQLite will be the only possibility, some others said that CoreData will be perfect.

Now I found a framework called 'MCPKit', but this framework isn't really up-to-date and it looks like Apple itself also recommends CoreData for Data Management. (<a href="https://developer.apple.com/technologies/ios/data-management.html" rel="nofollow">https://developer.apple.com/technologies/ios/data-management.html</a>)

I'm not familiar with CoreData and I'll be very happy if someone knows an other way to build up the connection.

I try to be as specific as possible but if you already have some questions, please ask.

How to connect an iOS app to a database (mySQL & SequelPro)?

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

我正在寻找一种连接应用程序与数据库的方法，在Sequel Pro中创建，它与mySQL服务器(通过MAMP启动)连接。我已经寻找了一些解决方案，但有成百上千种不同的帖子，一些人说SQLite将是唯一的可能性，另一些人说CoreData将是完美的。现在我找到了一个名为'MCPKit‘的框架，但这个框架并不是最新的，而且看...

问如何将iOS应用连接到数据库(mySQL和SequelPro)？
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何将iOS应用连接到数据库(mySQL和SequelPro)？EN