这个是根据前面别人的例子改了一下的，呵呵~~~

注：这里面的System.Data.dll 是Unity\Editor\Data\Mono\lib\mono\2.0\System.Data.dll;但是MySql.data.dll的版本我也不知道怎么来判断，我本来用的是1.0.6.15336这个版本的，但是一直报错“MySqlException: Character set 'gbk' is not supported”，报这个错误一般都是MySql.data.dll的版本太低了，后来我改成5.0的了，结果就ok了。反正我传到我的资源里面了，不行的话你们一个个试。

数据库创建如下：    

set feedback off; drop database db; create database db; USE DB; drop table s; create table s( sno Int(10) not null primary key, name varchar(10), sex varchar(10) ); insert into s values('001','杨纯','男'); insert into s values('002','yaya','女'); insert into s values('003','dlnuchunge','男'); select * from s;

unity3d里面的代码如下：

using UnityEngine; using System; using System.Collections; using System.Data; using MySql.Data.MySqlClient; public class CMySql : MonoBehaviour { // Global variables public static MySqlConnection dbConnection;//Just like MyConn.conn in StoryTools before static string host = "localhost"; static string id = "root"; static string pwd = "mysql"; static string database = "db"; static string result = ""; private string strCommand = "Select sno from s ;"; public static DataSet MyObj; void OnGUI() { host = GUILayout.TextField( host, 200, GUILayout.Width(200)); id = GUILayout.TextField( id, 200, GUILayout.Width(200)); pwd = GUILayout.TextField( pwd, 200, GUILayout.Width(200)); if(GUILayout.Button("Test")) { string connectionString = string.Format("Server = {0}; Database = {1}; User ID = {2}; Password = {3};",host,database,id,pwd); openSqlConnection(connectionString); MySqlCommand mySqlCommand = new MySqlCommand("Select * from s;", dbConnection); MySqlDataReader reader = mySqlCommand.ExecuteReader(); try { while (reader.Read()) { if (reader.HasRows) { print("编号:" + reader.GetInt32(0)+"|姓名："+reader.GetString(1)+"|性别："+reader.GetString(2)); } } } catch (Exception) { Console.WriteLine("查询失败了！"); } finally { reader.Close(); } MyObj = GetDataSet(strCommand); } GUILayout.Label(result); } // On quit public static void OnApplicationQuit() { closeSqlConnection(); } // Connect to database private static void openSqlConnection(string connectionString) { dbConnection = new MySqlConnection(connectionString); dbConnection.Open(); result = dbConnection.ServerVersion; //Debug.Log("Connected to database."+result); } // Disconnect from database private static void closeSqlConnection() { dbConnection.Close(); dbConnection = null; //Debug.Log("Disconnected from database."+result); } // MySQL Query public static void doQuery(string sqlQuery) { IDbCommand dbCommand = dbConnection.CreateCommand(); dbCommand.CommandText = sqlQuery; IDataReader reader = dbCommand.ExecuteReader(); reader.Close(); reader = null; dbCommand.Dispose(); dbCommand = null; } #region Get DataSet public DataSet GetDataSet(string sqlString) { //string sql = UnicodeAndANSI.UnicodeAndANSI.UnicodeToUtf8(sqlString); DataSet ds = new DataSet(); try { MySqlDataAdapter da = new MySqlDataAdapter(sqlString, dbConnection); da.Fill(ds); } catch (E <div class="clearfix"></div> </div> <nav aria-label="..."> <ul class="pager"> <li class="previous"><a href="44373">上一篇：MYSQL锁处理</a></li> <li class="next"><a href="41538">下一篇： MySQL储存引擎笔记 </a></li> </ul> </nav> <div class="alert alert-warning" role="alert"> <strong>免责声明：</strong> 本文仅代表作者个人观点，与爱易网无关。其原创性以及文中陈述文字和内容未经本站证实，对本文以及其中全部或者部分内容、文字的真实性、完整性、及时性本站不作任何保证或承诺，请读者仅作参考，并请自行核实相关内容。 </div> <div class="panel panel-default"> <div class="panel-heading"> <h3 class="panel-title">相关资料<span><a target="_blank" class="pull-right" href="/mysql/">更多></a></span></h3> </div> <div class="panel-body row"> <ol> <div class="col-md-6 col-xs-12"> <li class="articleAbout"><a href='/mysql/40887' title=' 设立mysql允许外网访问 ' target="_blank"> 设立mysql允许外网访问 </a></li></div> <div class="col-md-6 col-xs-12"> <li class="articleAbout"><a href='/mysql/42553' title=' 用MySql如何根据时间查询前一天的数据， ' target="_blank"> 用MySql如何根据时间查询前一天的数据， </a></li></div> <div class="col-md-6 col-xs-12"> <li class="articleAbout"><a href='/mysql/36950' title=' mysql的alter用法小结 ' target="_blank"> mysql的alter用法小结 </a></li></div> <div class="col-md-6 col-xs-12"> <li class="articleAbout"><a href='/mysql/43613' title=' php类论坛数据库中的时间:1178287713 如何得到的 ' target="_blank"> php类论坛数据库中的时间:1178287713 如何得到的 </a></li></div> <div class="col-md-6 col-xs-12"> <li class="articleAbout"><a href='/mysql/35884' title=' mysql 5.6中关于STRICT_TRANS_TABLES的议论 ' target="_blank"> mysql 5.6中关于STRICT_TRANS_TABLES的议论 </a></li></div> <div class="col-md-6 col-xs-12"> <li class="articleAbout"><a href='/mysql/35986' title=' 【转】MySQL开发者亟需了解的12个技巧与窍门 ' target="_blank"> 【转】MySQL开发者亟需了解的12个技巧与窍门 </a></li></div> <div class="col-md-6 col-xs-12"> <li class="articleAbout"><a href='/mysql/41508' title=' mysql2装配失败in ubuntu ' target="_blank"> mysql2装配失败in ubuntu </a></li></div> <div class="col-md-6 col-xs-12"> <li class="articleAbout"><a href='/mysql/38488' title=' MySQL- 储存引擎 ' target="_blank"> MySQL- 储存引擎 </a></li></div> <div class="col-md-6 col-xs-12"> <li class="articleAbout"><a href='/mysql/38186' title=' 项目oracle迁徙到mysql的小总结 ' target="_blank"> 项目oracle迁徙到mysql的小总结 </a></li></div> </ol> </div> </div> </div> <div class="col-lg-4 hidden-sm hidden-xs"> <!--右边的内容--> <a id="AdPageRight1_AdPageRight" href="http://www.tdyun.com/cloud/?aiyiweb" target="_blank"><img class="img-responsive" src="/images/TdPageAd/vps1.png" alt="香港云服务器 免备案 云主机VPS 国内 独立IP 独享15M 月付SSD" /></a> <script src='/Scripts/AdContentPage300_1.js' language='javascript'></script> <script src='/Scripts/AdContentPage300_2.js' language='javascript'></script> <script src='/Scripts/AdContentPage300_3.js' language='javascript'></script> <div class="panel panel-default"> <div class="panel-heading"> <h3 class="panel-title">推荐阅读<span><a target="_blank" class="pull-right" href="/mysql/">更多></a></span></h3> </div> <div class="panel-body"> <ol> <li class="articleAbout"><a href=/mysql/42227 title=' Mysql 大数据量查询怎么优化(当前数据仅有80万已很慢) ' target="_blank"> Mysql 大数据量查询怎么优化(当前数据仅有80万已很慢) </a></li> <li class="articleAbout"><a href=/mysql/40386 title=' mysql表不同字符集罗致索引失效 ' target="_blank"> mysql表不同字符集罗致索引失效 </a></li> <li class="articleAbout"><a href=/mysql/40001 title=' mysql-5.5.9-win32 绿色版 编码设立 ' target="_blank"> mysql-5.5.9-win32 绿色版 编码设立 </a></li> <li class="articleAbout"><a href=/mysql/36267 title=' Windows系统中MySQL 5.6的配置文件（my.ini）批改方法 ' target="_blank"> Windows系统中MySQL 5.6的配置文件（my.ini）批改方法 </a></li> <li class="articleAbout"><a href=/mysql/39172 title=' mysql在控制台查询汉字时中文乱码的解决方法 ' target="_blank"> mysql在控制台查询汉字时中文乱码的解决方法 </a></li> <li class="articleAbout"><a href=/mysql/42216 title=' 数据库查询有关问题，求高手！不来高手就郁闷鸟 ' target="_blank"> 数据库查询有关问题，求高手！不来高手就郁闷鸟 </a></li> <li class="articleAbout"><a href=/mysql/36239 title=' mysql 相干流程工程函数 ' target="_blank"> mysql 相干流程工程函数 </a></li> <li class="articleAbout"><a href=/mysql/37816 title=' 无奈了.如何插入都是乱码，只能高手了 ' target="_blank"> 无奈了.如何插入都是乱码，只能高手了 </a></li> <li class="articleAbout"><a href=/mysql/36022 title=' mysql导出数据下令 ' target="_blank"> mysql导出数据下令 </a></li> <li class="articleAbout"><a href=/mysql/43550 title=' linux命令行下使用mysql，怎么导出查询的记录集 ' target="_blank"> linux命令行下使用mysql，怎么导出查询的记录集 </a></li> <li class="articleAbout"><a href=/mysql/40670 title=' mysql中时隔日期格式化 ' target="_blank"> mysql中时隔日期格式化 </a></li> <li class="articleAbout"><a href=/mysql/40430 title=' mysql中批改root用户的密码 ' target="_blank"> mysql中批改root用户的密码 </a></li> <li class="articleAbout"><a href=/mysql/36896 title=' (zz)skip-grant-tables：十分有用的mysql启动参数 ' target="_blank"> (zz)skip-grant-tables：十分有用的mysql启动参数 </a></li> <li class="articleAbout"><a href=/mysql/39698 title=' mysql综合练习题2(触发器)-个人备忘 ' target="_blank"> mysql综合练习题2(触发器)-个人备忘 </a></li> <li class="articleAbout"><a href=/mysql/26817 title='MySQL中的SQL-- TEXT、DATE、和SET数据类型' target="_blank"> MySQL中的SQL-- TEXT、DATE、和SET数据类型</a></li> <li class="articleAbout"><a href=/mysql/36838 title=' 初学者学mysql语句小结1 ' target="_blank"> 初学者学mysql语句小结1 </a></li> <li class="articleAbout"><a href=/mysql/41433 title=' Mysql复构图结构、表数据 ' target="_blank"> Mysql复构图结构、表数据 </a></li> <li class="articleAbout"><a href=/mysql/44206 title=' 请问一个设计数据库字段的有关问题 ' target="_blank"> 请问一个设计数据库字段的有关问题 </a></li> <li class="articleAbout"><a href=/mysql/38682 title=' 局域网内联接MySQL ' target="_blank"> 局域网内联接MySQL </a></li> <li class="articleAbout"><a href=/mysql/36263 title=' Sphinx+MySQL5.1x+SphinxSE+mmseg汉语言分词 ' target="_blank"> Sphinx+MySQL5.1x+SphinxSE+mmseg汉语言分词 </a></li> </ol> </div> </div> </div> </div> <div class="clearfix"></div> <footer class=" footer navbar-bottom"> <em>友情链接：</em> <a href="http://www.aiyiweb.com/" target="_blank">爱易网 </a> <a href="http://www.aiyiweb.com/" target="_blank">云虚拟主机技术 </a> <a href="http://www.aiyiweb.com/" target="_blank">云服务器技术 </a> <a href="http://www.aiyiweb.com/" target="_blank">程序设计技术 </a> <a href="http://www.aiyiweb.com/" target="_blank">开发网站 </a> <a href="http://www.aiyiweb.com/" target="_blank">APP开发教程 </a> <br /> <script type="text/javascript">(function(){document.write(unescape('%3Cdiv id="bdcs"%3E%3C/div%3E'));var bdcs = document.createElement('script');bdcs.type = 'text/javascript';bdcs.async = true;bdcs.src = 'http://znsv.baidu.com/customer_search/api/js?sid=15239353030108964139' + '&plate_url=' + encodeURIComponent(window.location.href) + '&t=' + Math.ceil(new Date()/3600000);var s = document.getElementsByTagName('script')[0];s.parentNode.insertBefore(bdcs, s);})();</script> Copyright © 2013-2024 爱易网页 当前在线：510人　 网站在42秒内访问总人数：510人 当前 31.16% 　<a href="https://beian.miit.gov.cn" target="_blank">粤ICP备18100884号-2 </a> <script charset="UTF-8" id="LA_COLLECT" src="//sdk.51.la/js-sdk-pro.min.js"></script> <script>LA.init({ id: "JszEmKrtpbU59dY5", ck: "JszEmKrtpbU59dY5" })</script> </footer> </div> </body> </html>