ハルシオンシステムの気ままBlog

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

public class TestWindow : MonoBehaviour {

    public GameObject windowSet;
    public Image filter;

    void Awake() {
        name = "TestWindow";
        transform.SetParent(GameObject.Find("Canvas").transform, false);
    }

    void Start() {
        Hashtable startSetHasah = new Hashtable();
        startSetHasah.Add("x", 0f);
        startSetHasah.Add("y", 0f);
        startSetHasah.Add("time", 0.2f);
        iTween.ScaleFrom(windowSet, startSetHasah);

        Hashtable startFilterHash = new Hashtable();
        startFilterHash.Add("from", 0f);
        startFilterHash.Add("to", 0.8f);
        startFilterHash.Add("time", 0.2f);
        startFilterHash.Add("onupdate","FadeFilter");
        iTween.ValueTo(gameObject, startFilterHash);
    }

    public void SelectClose() {
        Hashtable closeSetHash = new Hashtable();
        closeSetHash.Add("x", 0f);
        closeSetHash.Add("y", 0f);
        closeSetHash.Add("time", 0.2f);
        closeSetHash.Add("oncompletetarget", gameObject);
        closeSetHash.Add("oncomplete", "CloseWindow");
        iTween.ScaleTo(windowSet, closeSetHash);

        Hashtable endFilterHash = new Hashtable();
        endFilterHash.Add("from", 0.8f);
        endFilterHash.Add("to", 0f);
        endFilterHash.Add("time", 0.2f);
        endFilterHash.Add("onupdate", "FadeFilter");
        iTween.ValueTo(gameObject, endFilterHash);
    }

    private void FadeFilter(float value) {
        filter.color = new Color(0f,0f,0f,value);
    }

    public void CloseWindow() {
        Destroy(gameObject);
    }

}

    public Text outputText;

    string SERVER = "xxx.xxx.xxx.xxx";		// DBのIPアドレス
    string DATABASE = "XXX";				// DB名
    string USERID = "XXX";					// DBアクセスユーザ
    string PORT = "3306";
    string PASSWORD = "XXX";				// DBアクセスパスワード

	void Start () {
	    
	}

    public void SelectButton() {
        GetDBData();
    }

    void GetDBData() {

        MySqlConnection con = null;

        string conCmd = 
                "server="+SERVER+";" +
                "database="+DATABASE+";" +
                "userid="+USERID+";" +
                "port="+PORT+";" +
                "password="+PASSWORD;

        try {

            con = new MySqlConnection( conCmd );
            con.Open ();

        } catch (MySqlException ex){
            Debug.Log ( ex.ToString() );
        }

        string selCmd = "SELECT * FROM TEST1;";

        MySqlCommand cmd = new MySqlCommand( selCmd, con );

        MySqlDataReader reader = cmd.ExecuteReader();

        string outString = "";

        while (reader.HasRows) {
            outString += reader.GetName(0) + ":" + reader.GetName(1) + "\r\n";
            while(reader.Read()){
                outString += reader.GetString(0) + ":" + reader.GetString(1) + "\r\n";
            }
            reader.NextResult();
        }

        outputText.text = outString;

        reader.Close();
        reader.Dispose();
        con.Close ();
        con.Dispose ();
    }