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

注：这里面的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="41540">上一篇： pgadmin\i,该怎么处理 </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/38906' title=' MySQL 普普通通索引、唯一索引和主索引 ' target="_blank"> MySQL 普普通通索引、唯一索引和主索引 </a></li></div> <div class="col-md-6 col-xs-12"> <li class="articleAbout"><a href='/mysql/35879' title=' Ubuntu MySQL设立开机启动 ' target="_blank"> Ubuntu MySQL设立开机启动 </a></li></div> <div class="col-md-6 col-xs-12"> <li class="articleAbout"><a href='/mysql/38529' title=' 怎么取出日期中时间的这个数字 ' target="_blank"> 怎么取出日期中时间的这个数字 </a></li></div> <div class="col-md-6 col-xs-12"> <li class="articleAbout"><a href='/mysql/43117' title=' Mysql数据库汉字乱码有关问题 ' target="_blank"> Mysql数据库汉字乱码有关问题 </a></li></div> <div class="col-md-6 col-xs-12"> <li class="articleAbout"><a href='/mysql/41028' title=' mysql进程CPU过高解决办法 ' target="_blank"> mysql进程CPU过高解决办法 </a></li></div> <div class="col-md-6 col-xs-12"> <li class="articleAbout"><a href='/mysql/44070' title=' 用MYSQL取出数据后，怎么定位到某一行某一列 ' target="_blank"> 用MYSQL取出数据后，怎么定位到某一行某一列 </a></li></div> <div class="col-md-6 col-xs-12"> <li class="articleAbout"><a href='/mysql/37036' title=' Mysql应用自定义方法，以及cakephp分页使用join查询的方法 ' target="_blank"> Mysql应用自定义方法，以及cakephp分页使用join查询的方法 </a></li></div> <div class="col-md-6 col-xs-12"> <li class="articleAbout"><a href='/mysql/39863' title=' 使用mysql关键字做表名字段的解决方法 ' target="_blank"> 使用mysql关键字做表名字段的解决方法 </a></li></div> <div class="col-md-6 col-xs-12"> <li class="articleAbout"><a href='/mysql/37292' title=' 设立MySQL自动增长起点和步长 ' target="_blank"> 设立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/vps2.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/35810 title=' mysql 高效率模糊查询 代替like ' target="_blank"> mysql 高效率模糊查询 代替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/36932 title=' (转)Mysql 慢日记优化分析方法 ' target="_blank"> (转)Mysql 慢日记优化分析方法 </a></li> <li class="articleAbout"><a href=/mysql/36644 title=' 装配mysql-5.6.10-win64 ' target="_blank"> 装配mysql-5.6.10-win64 </a></li> <li class="articleAbout"><a href=/mysql/35751 title=' mysql5.5错误： java.sql.SQLException: Packet for query is too large (1055975 > 1048576) ' target="_blank"> mysql5.5错误： java.sql.SQLException: Packet for query is too large (1055975 > 1048576) </a></li> <li class="articleAbout"><a href=/mysql/40423 title=' mysql 数值部类 bit bool integer int bigint mediumint SERIAL ' target="_blank"> mysql 数值部类 bit bool integer int bigint mediumint SERIAL </a></li> <li class="articleAbout"><a href=/mysql/36087 title=' MySQL 资料会合 ' target="_blank"> MySQL 资料会合 </a></li> <li class="articleAbout"><a href=/mysql/37195 title=' 惯用mysql ' target="_blank"> 惯用mysql </a></li> <li class="articleAbout"><a href=/mysql/43664 title=' 请问MYSQL的tablespace怎么设置 ' target="_blank"> 请问MYSQL的tablespace怎么设置 </a></li> <li class="articleAbout"><a href=/mysql/37217 title=' MYSQL入门学习之5：MYSQL的字符集 ' target="_blank"> MYSQL入门学习之5：MYSQL的字符集 </a></li> <li class="articleAbout"><a href=/mysql/42409 title=' rand by order怎么检索掉某些ID为空的数据条 ' target="_blank"> rand by order怎么检索掉某些ID为空的数据条 </a></li> <li class="articleAbout"><a href=/mysql/40016 title=' mysql查询结果归并 ' target="_blank"> mysql查询结果归并 </a></li> <li class="articleAbout"><a href=/mysql/40766 title=' mysql中sql温习 ' target="_blank"> mysql中sql温习 </a></li> <li class="articleAbout"><a href=/mysql/42741 title=' MySQL时间格式转换解决思路 ' target="_blank"> MySQL时间格式转换解决思路 </a></li> <li class="articleAbout"><a href=/mysql/43420 title=' 用PHPMyAdmin的MYSQL中遇到的有关问题（小弟我是新手） ' target="_blank"> 用PHPMyAdmin的MYSQL中遇到的有关问题（小弟我是新手） </a></li> <li class="articleAbout"><a href=/mysql/41176 title=' mysql 筑表不能默认时间 ' target="_blank"> mysql 筑表不能默认时间 </a></li> <li class="articleAbout"><a href=/mysql/35781 title=' ubuntu12.04 下设置mysql显示中文乱码有关问题 ' target="_blank"> ubuntu12.04 下设置mysql显示中文乱码有关问题 </a></li> <li class="articleAbout"><a href=/mysql/39636 title=' php中处置数据时用mysql事物处理 ' target="_blank"> php中处置数据时用mysql事物处理 </a></li> <li class="articleAbout"><a href=/mysql/42191 title=' mysql 不能 REPAIR TABLE，所有的表都不能REPAIR，表是好的。解决办法 ' target="_blank"> mysql 不能 REPAIR TABLE，所有的表都不能REPAIR，表是好的。解决办法 </a></li> <li class="articleAbout"><a href=/mysql/39215 title=' mssql与mysql差异之四:存储过程 ' target="_blank"> mssql与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 爱易网页 当前在线：2508人　 网站在1天4时38分10秒内访问总人数：391660人 当前 30.08% 　<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>