using System.Collections;
using System.Collections.Generic;
using UnityEngine;
using MySql.Data.MySqlClient;
using System.Data;
using System;
public class getGameUserAccount : MonoBehaviour
{
// Start is called before the first frame update
void Start()
{
mySqlCon();
}
// Update is called once per frame
void Update()
{
}
public void mySqlCon()
{
//數(shù)據(jù)庫登錄數(shù)據(jù)
string conStr = "server=localhost;User Id = root;password=123456;Database=gamerdata;charset=utf8";
//建立連接
//實(shí)例化的同時調(diào)用MySqlConnection,傳入?yún)?shù)
//這里的傳入?yún)?shù)個人認(rèn)為是CMD里面的直接輸入了,string格式直接類似手敲到cmd里面
MySqlConnection myCon = new MySqlConnection(conStr);
//打開連接
myCon.Open();
//插入數(shù)據(jù),其中useraccount為表名,括號內(nèi)為表的格式
/*
//此處注釋是因?yàn)椴荒芴砑酉嗤麈I的值
MySqlCommand myCmd = new MySqlCommand("insert into useraccount(id,nickname,password) values (4,'list','testList')", myCon);
if (myCmd.ExecuteNonQuery() > 0)
{
Debug.Log("Query Success!");
}
*/
//查詢數(shù)據(jù)
string selStr = "select * from useraccount";
MySqlCommand mySelect = new MySqlCommand(selStr, myCon);
DataSet ds = new DataSet();
try
{
MySqlDataAdapter da = new MySqlDataAdapter(selStr, myCon);
da.Fill(ds);
Debug.Log(ds.Tables[0].Rows[0][0]);
Debug.Log(ds.Tables[0].Rows[0][1]);
Debug.Log(ds.Tables[0].Rows[0][2]);
Debug.Log(ds.Tables[0].Rows[0][3]);
//Table[0].Rows[0][0]
Debug.Log("Query Success!");
}
catch (Exception e)
{
throw new Exception("SQL:" + selStr + "\n" + e.Message.ToString());
}
myCon.Close();
}
}
到此這篇關(guān)于Unity連接MySQL時讀取表格的方式的文章就介紹到這了,更多相關(guān)Unity連接MySQL讀取表格內(nèi)容請搜索腳本之家以前的文章或繼續(xù)瀏覽下面的相關(guān)文章希望大家以后多多支持腳本之家!