using System.Collections;
using System.Collections.Generic;
using UnityEngine;
//引用两个库文件system.data和MySql.Data.MySqlClient;
public class OptMysqlInUnity : MonoBehaviour {
private string dataname = "xiaocongcong";
private string idAddress = "localhost";
private string root = "root";
private string password = "123456";
MySqlConnection mySqlConnection;
//加载
private string connectionStr = "";
//命令行
private string comdText = "select * from usercongcong;";
//插入
private string insertText = "insert into usercongcong values(7,'肖聪聪',50,'nan','yanjiao','936900711@qq.com');";
//删除数据
private string delectText = "delete from usercongcong where id = 6;";
void Start () {
connectionStr = string.Format("Server={0}; Database={1}; User={2}; Password = {3}",idAddress,dataname,root,password);//引号中的代码最好不要改,每个单词中间都用分号隔开
mySqlConnection = new MySqlConnection(connectionStr);
}
private void OnGUI()
{
if (GUILayout.Button("openMySql"))
{
if(mySqlConnection != null)
{
mySqlConnection.Open();
print("打开数据库成功");
}
}
if (GUILayout.Button("查询表"))
{
MySqlCommand command = new MySqlCommand(comdText, mySqlConnection);
if (command != null)
{
//不改变表直接查询
MySqlDataReader reader= command.ExecuteReader();
if (reader.HasRows)//检测读取的东西是否有行
{
while(reader.Read())//读取行内的信息
{
string tempStr = "";
tempStr += reader["name"];
print(tempStr);
}
}
}
}
if (GUILayout.Button("插入数据"))
{
MySqlCommand comd = new MySqlCommand(insertText,mySqlConnection);
if(comd != null)
{
int read = comd.ExecuteNonQuery();//改变表
print("插入成功");
}
}
if (GUILayout.Button("删除数据"))
{
MySqlCommand co = new MySqlCommand(delectText,mySqlConnection);
if(co != null)
{
int c = co.ExecuteNonQuery();
print("删除成功");
}
}
}
using System.Collections.Generic;
using UnityEngine;
using MySql.Data.MySqlClient;
using system.data;
//引用两个库文件system.data和MySql.Data.MySqlClient;
public class OptMysqlInUnity : MonoBehaviour {
private string dataname = "xiaocongcong";
private string idAddress = "localhost";
private string root = "root";
private string password = "123456";
MySqlConnection mySqlConnection;
//加载
private string connectionStr = "";
//命令行
private string comdText = "select * from usercongcong;";
//插入
private string insertText = "insert into usercongcong values(7,'肖聪聪',50,'nan','yanjiao','936900711@qq.com');";
//删除数据
private string delectText = "delete from usercongcong where id = 6;";
void Start () {
connectionStr = string.Format("Server={0}; Database={1}; User={2}; Password = {3}",idAddress,dataname,root,password);//引号中的代码最好不要改,每个单词中间都用分号隔开
mySqlConnection = new MySqlConnection(connectionStr);
}
private void OnGUI()
{
if (GUILayout.Button("openMySql"))
{
if(mySqlConnection != null)
{
mySqlConnection.Open();
print("打开数据库成功");
}
}
if (GUILayout.Button("查询表"))
{
MySqlCommand command = new MySqlCommand(comdText, mySqlConnection);
if (command != null)
{
//不改变表直接查询
MySqlDataReader reader= command.ExecuteReader();
if (reader.HasRows)//检测读取的东西是否有行
{
while(reader.Read())//读取行内的信息
{
string tempStr = "";
tempStr += reader["name"];
print(tempStr);
}
}
}
}
if (GUILayout.Button("插入数据"))
{
MySqlCommand comd = new MySqlCommand(insertText,mySqlConnection);
if(comd != null)
{
int read = comd.ExecuteNonQuery();//改变表
print("插入成功");
}
}
if (GUILayout.Button("删除数据"))
{
MySqlCommand co = new MySqlCommand(delectText,mySqlConnection);
if(co != null)
{
int c = co.ExecuteNonQuery();
print("删除成功");
}
}
}