OneAlive--数据库的搭建测试

最新推荐文章于 2024-09-10 17:58:27 发布

一克拉绿豆

最新推荐文章于 2024-09-10 17:58:27 发布

阅读量229

点赞数

分类专栏：项目笔记

本文链接：https://blog.csdn.net/qq_35711014/article/details/80235578

版权

项目笔记专栏收录该内容

16 篇文章 8 订阅

订阅专栏

using UnityEngine;
using System;
using System.Collections;
using System.Data;
using MySql.Data.MySqlClient;
using UnityEngine.UI;


public class DBdata : MonoBehaviour
{

    //建立连接的语句  
    //如果是本地数据库server为localhost，不是则输入server的地址  
    private string constr = "server=localhost;Database=Honor Of Warriors DBdata;User Id=root;password=hzq13576557892";

    /// <summary>
    /// 数据库连接插入数据
    /// </summary>
    /// <param name="userName"></param>
    /// <param name="Password"></param>
    /// <param name="Gold"></param>
    /// <param name="Diamond"></param>
    public void Insert(string userName, string Password, string Gold, string Diamond)
    {
       // string constr = "server=localhost;Database=Honor Of Warriors DBdata;User Id=root;password=hzq13576557892";
        MySqlConnection mycon = new MySqlConnection(constr); //建立连接  
        mycon.Open();
        //插入的指令  
        MySqlCommand mycmd = new MySqlCommand("insert into user(userName,Password,Gold,Diamond) values('" + userName + "','" + Password + "','" + Gold + "','" + Diamond + "')", mycon);
        if (mycmd.ExecuteNonQuery() > 0)
        mycon.Close(); //关闭连接  
    }
    /// <summary>
    /// 查询数据库数据
    /// </summary>
    public void Select()      //查询数据库数据
    {
        //string constr = "server=localhost;Database=Honor Of Warriors DBdata;User Id=root;password=hzq13576557892";
        MySqlConnection mycon = new MySqlConnection(constr); //建立连接  
        mycon.Open();
        //查询指令,输出所有数据
        string selstr = "select userName,Password,Gold,Diamond from user";
        MySqlCommand myselect = new MySqlCommand(selstr, mycon);
        DataSet ds = new DataSet();
        try
        {
            MySqlDataAdapter da = new MySqlDataAdapter(selstr, mycon);
            da.Fill(ds);
            Debug.Log("Query success!");
            string Result = "";
            DataTable dt = ds.Tables[0];
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                Result += "第" + i + "条数据" + dt.Rows[i][0].ToString() + "\t" + dt.Rows[i][1].ToString() + "\t" + dt.Rows[i][2].ToString() + "\t" + dt.Rows[i][3].ToString() + "\t" ;
            }
            print(Result + "\t");
        }
        catch (Exception ee)
        {
            throw new Exception("SQL: " + selstr + "\n" + ee.Message.ToString());
        }
        mycon.Close(); //关闭连接  
    }
    /// <summary>
    /// 更新数据库数据
    /// </summary>
    /// <param name="userName"></param>
    /// <param name="Password"></param>
    /// <param name="Gold"></param>
    /// <param name="Diamond"></param>
    public void DataUpdate(string userName, string Password, string Gold, string Diamond)   //购买商品后更新数据到数据库
    {
       // string constr = "server= localhost;Database=Honor Of Warriors DBdata;User Id=root;password=hzq13576557892";
        MySqlConnection mycon = new MySqlConnection(constr); //建立连接  
        mycon.Open();
        //插入的指令  
        try
        {
            MySqlCommand mycmd = new MySqlCommand("Update user set Gold = '" + Gold + "', Diamond= '" + Diamond + "'where userName='" + userName + "'", mycon);
            if (mycmd.ExecuteNonQuery() > 0)
                mycon.Close();   //关闭连接 
        }
        catch (Exception ee)
        {
            throw new Exception("SQL: " + mycon + "\n" + ee.Message.ToString());
        }


    }
}

using System.Collections;
using System.Collections.Generic;
using UnityEngine;
using UnityEngine.UI;

public class DataTest : MonoBehaviour {
    public DBdata dbdata;
    public InputField userName;
    public InputField Password;
    public InputField Gold;
    public InputField Diamond;
	
    //提交数据库
    public  void Submit()
    {
        dbdata.Insert(userName.text, Password.text, Gold.text, Diamond.text);
        Debug.Log("提交成功");
    }
    //查询数据库
    public void Query()
    {
        dbdata.Select();
    }
}