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

注：这里面的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/43347' title=' 时间有关问题 ' target="_blank"> 时间有关问题 </a></li></div> <div class="col-md-6 col-xs-12"> <li class="articleAbout"><a href='/mysql/36667' title=' MySql查看状态跟连接数 ' target="_blank"> MySql查看状态跟连接数 </a></li></div> <div class="col-md-6 col-xs-12"> <li class="articleAbout"><a href='/mysql/44203' title=' MySQL存储过程_删除时更新另一张表计数？解决办法 ' target="_blank"> MySQL存储过程_删除时更新另一张表计数？解决办法 </a></li></div> <div class="col-md-6 col-xs-12"> <li class="articleAbout"><a href='/mysql/40737' title=' 源码编译装配mysql(适用于5.5全部版本) ' target="_blank"> 源码编译装配mysql(适用于5.5全部版本) </a></li></div> <div class="col-md-6 col-xs-12"> <li class="articleAbout"><a href='/mysql/36775' title=' mysql的dump导库下令 ' target="_blank"> mysql的dump导库下令 </a></li></div> <div class="col-md-6 col-xs-12"> <li class="articleAbout"><a href='/mysql/43739' title=' 新手 为什么小弟我的Mysql启动时出现异常。 ' target="_blank"> 新手 为什么小弟我的Mysql启动时出现异常。 </a></li></div> <div class="col-md-6 col-xs-12"> <li class="articleAbout"><a href='/mysql/36309' title=' windows停安装mysql5.6.13的主从复制 ' target="_blank"> windows停安装mysql5.6.13的主从复制 </a></li></div> <div class="col-md-6 col-xs-12"> <li class="articleAbout"><a href='/mysql/42974' title=' 查询某个数据表table中除去列名为ID之外的所有列，该如何写 ' target="_blank"> 查询某个数据表table中除去列名为ID之外的所有列，该如何写 </a></li></div> <div class="col-md-6 col-xs-12"> <li class="articleAbout"><a href='/mysql/36224' title=' MySQL中时间->数目字转换和IP地址->数字转换（转） ' target="_blank"> MySQL中时间->数目字转换和IP地址->数字转换（转） </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/host/?aiyiweb" target="_blank"><img class="img-responsive" src="/images/TdPageAd/hostTest15day.png" alt="香港全能空间 免费试用15天香港高速云虚拟主机PHP/ASP/NET送MSSQL和MYSQL" /></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/41224 title=' MySQL闪来方案讨论及实现 ' target="_blank"> MySQL闪来方案讨论及实现 </a></li> <li class="articleAbout"><a href=/mysql/40413 title=' mysql 查询当天、本周、下周、本月、下个月份的数据 ' target="_blank"> mysql 查询当天、本周、下周、本月、下个月份的数据 </a></li> <li class="articleAbout"><a href=/mysql/36478 title=' mysql函数范例-统计日新增用户 ' target="_blank"> mysql函数范例-统计日新增用户 </a></li> <li class="articleAbout"><a href=/mysql/37105 title=' 施用mysql命令行导出sql ' target="_blank"> 施用mysql命令行导出sql </a></li> <li class="articleAbout"><a href=/mysql/38208 title=' 记录一次 mysql 无法启动 的有关问题 ' target="_blank"> 记录一次 mysql 无法启动 的有关问题 </a></li> <li class="articleAbout"><a href=/mysql/39723 title=' 查询a表中有但b表中没的数据，求sql ' target="_blank"> 查询a表中有但b表中没的数据，求sql </a></li> <li class="articleAbout"><a href=/mysql/41376 title=' mysql utf8筑表 ' target="_blank"> mysql utf8筑表 </a></li> <li class="articleAbout"><a href=/mysql/42182 title=' like语句后面加上逻辑表达式的不解解决办法 ' target="_blank"> like语句后面加上逻辑表达式的不解解决办法 </a></li> <li class="articleAbout"><a href=/mysql/39311 title=' MySql 中查询树形构造的全部子项列表 Function ' target="_blank"> MySql 中查询树形构造的全部子项列表 Function </a></li> <li class="articleAbout"><a href=/mysql/41331 title=' 请问mysql高手行转列有关问题 ' target="_blank"> 请问mysql高手行转列有关问题 </a></li> <li class="articleAbout"><a href=/mysql/39179 title=' mysql 怎么高效获取新插入的最后记录 ' target="_blank"> mysql 怎么高效获取新插入的最后记录 </a></li> <li class="articleAbout"><a href=/mysql/39873 title=' 远程访问MySQL提示is not allowed to connect to this MySQL的解决方法 ' target="_blank"> 远程访问MySQL提示is not allowed to connect to this MySQL的解决方法 </a></li> <li class="articleAbout"><a href=/mysql/40469 title=' mysql中引号有关问题 ' target="_blank"> mysql中引号有关问题 </a></li> <li class="articleAbout"><a href=/mysql/41146 title=' Mysql各种表格查询含实例，日报，周报，月报，时间差自动计算 ' target="_blank"> Mysql各种表格查询含实例，日报，周报，月报，时间差自动计算 </a></li> <li class="articleAbout"><a href=/mysql/38006 title=' iBatis施行MySQL与Oracle批处理更新异同 ' target="_blank"> iBatis施行MySQL与Oracle批处理更新异同 </a></li> <li class="articleAbout"><a href=/mysql/36270 title=' MySQL对于有大量反复数据表的处理方法 ' target="_blank"> MySQL对于有大量反复数据表的处理方法 </a></li> <li class="articleAbout"><a href=/mysql/36888 title=' mysql惯用函数总结 ' target="_blank"> mysql惯用函数总结 </a></li> <li class="articleAbout"><a href=/mysql/42319 title=' mysql下limit,该如何解决 ' target="_blank"> mysql下limit,该如何解决 </a></li> <li class="articleAbout"><a href=/mysql/38134 title=' Mysql失灵后的数据恢复 ' target="_blank"> Mysql失灵后的数据恢复 </a></li> <li class="articleAbout"><a href=/mysql/38642 title=' ubuntu上mysql命令行未成功 ' target="_blank"> ubuntu上mysql命令行未成功 </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人　 网站在2时2分36秒内访问总人数：41310人 当前 9.92% 　<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>