unity3d中連接數(shù)據(jù)庫

1、unity3d中連接數(shù)據(jù)庫.txt38當(dāng)烏云布滿天空時(shí)，悲觀的人看到的是“黑云壓城城欲摧”，樂觀的人看到的是“甲光向日金鱗開”。無論處在什么厄運(yùn)中，只要保持樂觀的心態(tài)，總能找到這樣奇特的草莓。在unity3d中連接數(shù)據(jù)庫收藏1.C#代碼：usingUnityEngineusingSystemusingSystem.CollectionsusingSystem.DatausingMySql.Data.MySqlClientpubliccl

2、assCMySql:MonoBehaviourGlobalvariablespublicstaticMySqlConnectiondbConnectionJustlikeMyConn.conninStyToolsbefestaticstringhost=“192.168.1.100“staticstringid=“mysql“這里是你自己的數(shù)據(jù)庫的用戶名字，我一開始想用root，發(fā)現(xiàn)不行，后來添加了新的用戶才可以staticstring

3、pwd=“123456“staticstringdatabase=“test“staticstringresult=““privatestringstrComm=“fromunity3d_testDERBYid“publicstaticDataSetMyObjvoidOnGUI()host=GUILayout.TextField(host200GUILayout.Width(200))id=GUILayout.TextField(id2

4、00GUILayout.Width(200))pwd=GUILayout.TextField(pwd200GUILayout.Width(200))if(GUILayout.Button(“Test“))stringconnectionString=string.Fmat(“Server=0Database=1UserID=2Passwd=3“hostdatabaseidpwd)openSqlConnection(connectionS

5、tring)MyObj=GetDataSet(strComm)GUILayout.Label(result)OnquitpublicstaticvoidOnApplicationQuit()closeSqlConnection()returnds#endregionusingUnityEngineusingSystemusingSystem.CollectionsusingSystem.DatapublicclassDataBaseTe

6、st:MonoBehaviourpublicGUISkinmyGUISkin=newGUISkin()stringstrID=““stringstrName=““stringstrSex=““intIndex=1UsethisfinitializationvoidStart()voidOnGUI()GUI.skin=myGUISkinif(GUI.Button(newRect(100320100100)“ClickMe“))feach(

7、DataRowdrinCMySql.MyObj.Tables[0].Rows)if(Index.ToString()==dr[“ID“].ToString())strID=dr[“ID“].ToString()strName=dr[“Name“].ToString()strSex=dr[“Sex“].ToString()breakIndexif(Index5)Index=1GUI.Label(newRect(32010015070)“D