【正文】 （） 用戶贈(zèng)送物品后，gift表中發(fā)生變化 ⑤ 用戶Ronaldo接收禮物，其物品信息發(fā)生變化。 wp, unsigned long stub)? 用戶接收禮物時(shí)，大廳服務(wù)器請求數(shù)據(jù)庫服務(wù)器進(jìn)行收贈(zèng)操作。amp?；谝陨项?，并結(jié)合系統(tǒng)各個(gè)部分的工作情況以及數(shù)據(jù)的交互情況。 //當(dāng)前行的字段值長度。 //返回MYSQL_FIELD結(jié)構(gòu)的數(shù)組，每個(gè)字段針對一個(gè)結(jié)果集合。③ 選擇數(shù)據(jù)庫：mysql_select_db(amp。目前，MySQL提供的接口API編程語言有C，Java，PHP，Perl，Python，ODBC，Ruby，Eiffel和Tcl等，應(yīng)確保在構(gòu)建自己的MySQL應(yīng)用程序時(shí)不會(huì)因缺少選擇而造成問題。（） 用戶丟棄禮物操作流程圖 11) GC已經(jīng)在某個(gè)HS里，用戶查詢禮物信息時(shí)，HS請求DS進(jìn)行查詢禮物信息操作。操作完成后，傳回更新后的數(shù)據(jù)給HS，并提示操作成功。所以，本系統(tǒng)采用的是這種數(shù)據(jù)交換方式。（）16重慶大學(xué)本科學(xué)生畢業(yè)設(shè)計(jì)（論文） 3 系統(tǒng)設(shè)計(jì) 表gift ⑤ 在數(shù)據(jù)庫ocean創(chuàng)建表hsgcverifycode。 表ShipAccess屬性 ⑥ RoleAccess：存儲(chǔ)游戲中角色的信息（）。因此，我們迫切需要一個(gè)速度快、性能穩(wěn)定和安全的數(shù)據(jù)庫（可以非常省心地配置和使用它，并且為將來的發(fā)展奠定堅(jiān)實(shí)的基礎(chǔ)）。9) 丟棄禮物：用戶在禮物界面可選擇丟棄別人贈(zèng)送的禮物。進(jìn)入大廳時(shí)驗(yàn)證賬號(hào)、密碼以及生成的驗(yàn)證碼三項(xiàng)。操作完成后，程序調(diào)用數(shù)據(jù)庫接口保存用戶相應(yīng)信息。 只有在確定了這些需要后他們才能夠分析和尋求新系統(tǒng)的解決方法。密碼。 關(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 概述 ....................................................................................................27 封裝C API ..................................................................................................................29 5 系統(tǒng)實(shí)現(xiàn) ...............