环境:
unity+vs2015
unity设置:edit->Project setting -> player ->API Compatibility Level 变成.NET 2.0
VS设置:.NET Framework 4.5.1
mysql.data.dll一定要从这里下,官网下的不好使
点击打开链接
using System.Collections;
using System.Collections.Generic;
using UnityEngine;
using System.Data;
using System;
using MySql.Data.MySqlClient;
public class conndb : MonoBehaviour {
public static MySqlConnection dbConnection;
// static string host = "localhost";
//如果是局域网,那么写上本机的局域网IP
static string host = "localhost";//ip地址,如果是本机则写localhost,如果不是本机,则写安装数据库电脑的ip
static string id = "root";//数据库的用户名
static string pwd = "";//数据库的密码
static string database = "db001";//数据库的名称 这里我的数据库名称为:examsystem
public static void OpenSql()
{
try
{
string connectionString = string.Format("Server = {0};port={4};Database = {1}; User ID = {2}; Password = {3};", host, database, id, pwd, "3306");
dbConnection = new MySqlConnection(connectionString);
dbConnection.Open();
}
catch (Exception e)
{
throw new Exception("服务器连接失败,请重新检查是否打开MySql服务。" + e.Message.ToString());
}
}
}