unity网络功能 -数据库链接-发送网络数据

连接数据库

暂时还搞不懂，电脑可以链接，但手机不行

unity封装的比较好了
直接创建 MySqlConnection对象就行了

    public MySqlConnection getsqlConn()
    {
  string constructorString = "datasource=8.131.67.188; port =3306;database=unity;user=0000;pwd= 0000;";
        MySqlConnection conn = new MySqlConnection(constructorString);
        conn.Open();
            return conn;
}

SQL语句的执行

   MySqlConnection conn = getsqlConn();//直接获取到上面那个连接哈

   string sql = "select * from ranking order by score desc;";
        //检索全部+直接排序了  检索时直接拍完了啊
        MySqlCommand cmd = new MySqlCommand(sql, conn);//执行语句
        MySqlDataReader mr = cmd.ExecuteReader();//获取返回
		//结束

        int rank=1;
        while (mr.Read())
        {
            ScoreEntityOL onScore = new ScoreEntityOL();
            onScore.id = mr.GetInt16("id");直接get列名
            onScore.name = mr.GetString("name");
            list.Add(onScore);
        }



插入语句

public void Insert(){
    string sql = "insert into ranking(name,score,time) VALUES('" + name + "'," + score + ",'" + time + "')";

  string sql2 = "UPDATE ranking  SET score=" + score + " where name='" + name + "';";


        MySqlCommand cmd1 = new MySqlCommand(sql, conn);

        cmd1.ExecuteNonQuery();


}

获取网页源码+发送网络数据

 public string HTreturn(string http)
    {

        HttpWebRequest request = WebRequest.Create(http) as HttpWebRequest;
        request.Method = "GET";
        HttpWebResponse response = request.GetResponse() as HttpWebResponse;
        Stream sm = response.GetResponseStream();
        StreamReader read = new StreamReader(sm, Encoding.UTF8);
        string a = read.ReadToEnd();
        return a;
    }



 发送喽string us = HTreturn("http://59.110.231.16:8080/SSMSpring_war/account/UTupscore?name=" + name + "&score=" + score + "&time=" + time);

剩下的都是字符的后期处理了