【正文】 XXX大學(xué)本科學(xué)生畢業(yè)設(shè)計(jì)（論文） 網(wǎng)絡(luò)對戰(zhàn)游戲《奇跡之?！贩?wù)器數(shù)據(jù)庫的設(shè)計(jì)與實(shí)現(xiàn) 學(xué) 生：XXX學(xué) 號：20055237指導(dǎo)教師：XXX 副教授助理指導(dǎo)教師：專 業(yè)：軟件工程 XXX大學(xué)軟件學(xué)院二〇〇九年六月 Ba. D. Project of Chongqing University Design and Implementation of ServerDatabase for the Online Game “LegendaryOcean” . Candidate: XXXSupervisor: A. Prof. Tan HuixinAssistant Tutor:Major: Software Engineering College of Software EngineeringChongqing UniversityJune 2009 XXX大學(xué)本科學(xué)生畢業(yè)設(shè)計(jì)（論文） 中文摘要 摘 要 隨著網(wǎng)絡(luò)的普及，網(wǎng)絡(luò)游戲已經(jīng)成為大家耳濡目染的新生事物?，F(xiàn)在，可以說網(wǎng)絡(luò)游戲已經(jīng)成為人們休閑、娛樂的有效方式。網(wǎng)絡(luò)游戲必須依托于互聯(lián)網(wǎng)，可以多人同時參與游戲，通過人與人之間的互動達(dá)到交流、娛樂和休閑的目的。在網(wǎng)絡(luò)游戲中，數(shù)據(jù)庫主要用來保存用戶資料，包括用戶注冊信息、用戶游戲資料以及其他設(shè)置資料。網(wǎng)絡(luò)游戲的服務(wù)器端在處理這些資料時，必然要使用數(shù)據(jù)庫進(jìn)行大量數(shù)據(jù)的永久存儲，所以在網(wǎng)絡(luò)游戲的開發(fā)中數(shù)據(jù)庫的設(shè)計(jì)也是很重要的環(huán)節(jié)。本項(xiàng)目就是完成網(wǎng)絡(luò)游戲服務(wù)器數(shù)據(jù)庫的設(shè)計(jì)和實(shí)現(xiàn)。本項(xiàng)目選擇MySQL作為數(shù)據(jù)庫管理系統(tǒng)，還使用了MySQL提供的C API，通過該API的功能進(jìn)行連接管理、實(shí)施查詢、處理結(jié)果集等操作。在項(xiàng)目開發(fā)的過程中，1. 通過需求分析，完成了數(shù)據(jù)庫的概念設(shè)計(jì)、邏輯設(shè)計(jì)以及系統(tǒng)架構(gòu)設(shè)計(jì)。2. 通過系統(tǒng)架構(gòu)圖，并結(jié)合需求，分析出了系統(tǒng)各個部分的工作情況以及數(shù)據(jù)的交互情況。3. 將MySQL C API封裝成易于使用的數(shù)據(jù)庫接口。4. 為數(shù)據(jù)庫服務(wù)器提供了操作數(shù)據(jù)庫的函數(shù)。 關(guān)鍵詞：數(shù)據(jù)庫系統(tǒng)，網(wǎng)絡(luò)游戲，MySQL C API，封裝IXXX大學(xué)本科學(xué)生畢業(yè)設(shè)計(jì)（論文） 目錄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 bee an effective way of the people’s 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 serverside 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 pleted as follows:1. Through the requirement analysis, we plete the concept and logic design of database, and system architecture design.2. Through the system architecture diagram, we analyze the work of the various parts of the system and the data interactive situations.3. Packaged the C API as easytouse database interface.4. Provided functions for the database server operating the database. Keywords: database system, online game, MySQL C API, Packag II重慶大學(xué)本科學(xué)生畢業(yè)設(shè)計(jì)（論文） 目錄目 錄 摘 要 .......................................................................................................................................... I ABSTRACT ................................................................................................................................. II 1 緒 論 ...................................................................................................................................... 1 課題研究背景 ........................................................................................................................... 1 課題研究意義 ........................................................................................................................... 2 2 系統(tǒng)需求分析 ...................................................................................................................... 4 需求概述 ................................................................................................................................... 4 數(shù)據(jù)庫系統(tǒng)需求 ....................................................................................................................... 4 用戶用例分析 ........................................................................................................................... 5 3 系統(tǒng)設(shè)計(jì) ................................................................................................................................. 8 MySQL概述 .............................................................................................................................. 8 數(shù)據(jù)庫概念設(shè)計(jì) ....................................................................................................................... 8 數(shù)據(jù)庫邏輯設(shè)計(jì) ..................................................................................................................... 14 4 系統(tǒng)難點(diǎn)技術(shù)分析與設(shè)計(jì) .......................................................................................... 19 系統(tǒng)架構(gòu)設(shè)計(jì)與分析 ............................................................................................................. 19 將MySQL C API封裝成易于使用的數(shù)據(jù)庫接口 ................................................................ 27 MySQL C API 概述 ..........................................................