Unity连接MySQL并读取表格数据的实现代码

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()
    {
        //数据库登录数据
        string conStr = "server=localhost;User Id = root;password=123456;Database=gamerdata;charset=utf8";
        //建立连接
        //实例化的同时调用MySqlConnection，传入参数
        //这里的传入参数个人认为是CMD里面的直接输入了，string格式直接类似手敲到cmd里面
        MySqlConnection myCon = new MySqlConnection(conStr);
        //打开连接
        myCon.Open();
        //插入数据,其中useraccount为表名，括号内为表的格式
        /*
        //此处注释是因为不能添加相同主键的值
        MySqlCommand myCmd = new MySqlCommand("insert into useraccount(id,nickname,password) values (4,'list','testList')", myCon);
        if (myCmd.ExecuteNonQuery() > 0)
        {
            Debug.Log("Query Success!");
        }
        */
        //查询数据
        string selStr = "select * from useraccou