网络对战游戏《奇迹之海》服务器数据库的设计与实现 本科论文.doc

摘 要 随着的普及，网络游戏已经成为大家耳濡目染的新生事物。现在，可以说网络游戏已经成为人们休闲、娱乐的有效方式。网络游戏必须依托于互联网可以多人同时参与游戏，通过人与人之间的互动达到交流、娱乐和休闲的目的。 在网络游戏中，数据库主要用来保存用户资料，包括用户注册信息、用户游戏资料以及其他设置资料。网络游戏的服务器端在处理资料时，必然要使用数据库进行大量数据的永久存储，所以在网络游戏的开发中数据库的设计也是很重要的环节。 本项目就是网络游戏服务器数据库的设计和实现。 本项目MySQL作为数据库管理系统，还使用了MySQL提供的C API，该API的功能进行连接管理、实施查询、处理结果集等。通过需求分析，完成了数据库的概念设计、逻辑设计以及系统架构设计通过系统架构图，分析出了系统各个部分的工作情况以及数据的交互情况。将C API封装成易于使用的数据库接口 为数据库服务器提供了操作数据库的函数。 关键词：数据库系统，网络游戏，MySQL C API，封装 ABSTRACT With the popularization of internet, online game is no longer a new thing to people. Now it can be said that online games have become an effective way of the peoples leisure and entertainment. Online games must rely on the internet, people can take part in the game at the same time, and through the interaction between people to reach the purposes of exchange, entertainment and leisure. In online games, the database is mainly used to save user’s data, including user’s registration information, user’s game information, as well as other setting information. When online game’s server-side in dealing these data, the database must be used to store large amounts of data permanent, so database designing is also a very important aspect in the development of online games. This project is about design and implementation of server database for online game. This project uses the database management system based on MySQL, also uses the MySQL C API, and this API functions can do connection management, the implementation of inquiries, processing of result sets and so on. In the project design process, the work completed as follows: Through the requirement analysis, we complete the concept and logic design of database, and system architecture design. Through the system architecture diagram, we analyze the work of the various parts of the system and the data interactive situations. Packaged the C API as easy-to-use database interface. Provided functions for the database server operating the database. Keywords: database system, online