unity mysql 类库_unity中使用MYSQL数据库的一些总结

usingSystem;usingSystem.Collections.Generic;usingSystem.Linq;usingSystem.Text;usingSystem.Threading.Tasks;usingMySql.Data.MySqlClient;usingSystem.Data;///

///需要引用的DLL文件：///Mysql.Data.dll///在unity中需要：///l18n.cjk.dll///l18n.dll///system.data.dll///system.drawing.dll///

namespace数据库操作

{classProgram

{//远程连接//string connectionString= "User ID = ; Password =.; Host =; Port =3306;Database = ;Charset = ";//本地连接

public static string connectionString= "User ID = ; Password = ; Host = ; Port = 3306;Database = ;Charset =";public staticMySqlConnection dbConnection;static void Main(string[] args)

{

}//打开数据库链接

static void OpenSqlConnection(stringconnectionString)

{

dbConnection= newMySqlConnection(connectionString);

dbConnection.Open();

}//关闭数据库连接

static voidCloseConnection()

{if (dbConnection != null)

{

dbConnection.Close();

dbConnection.Dispose();

dbConnection= null;

}

}//保存数据

public static DataSet GetDataSet(stringsqlString)

{

DataSet ds= newDataSet();try{//用于检索和保存数据//Fill(填充)能改变DataSet中的数据以便于数据源中数据匹配//Update(更新)能改变数据源中的数据以便于DataSet中的数据匹配

MySqlDataAdapter da= newMySqlDataAdapter(sqlString, dbConnection);

da.Fill(ds);

}catch(Exception ee)

{throw new Exception("SQL:" + sqlString + "\n" +ee.Message.ToString());

}returnds;

}//增 insert

static voidAdd()

{

OpenSqlConnection(connectionString);string sqlstring= "insert into userinformation(name,password,tel) values();";//保证sql语句的正确性

GetDataSet(sqlstring);

CloseConnection();

}//删 delete

static voidDelete()

{

OpenSqlConnection(connectionString);string sqlstring = "delete from 表名;";

GetDataSet(sqlstring);

CloseConnection();

}//改 update

static voidUpdate()

{

OpenSqlConnection(connectionString);string sqlstring = "update 表名 set 字段=值 where 条件;";

GetDataSet(sqlstring);

CloseConnection();

}//查 select

static voidSelect()

{

OpenSqlConnection(connectionString);

MySqlCommand mysqlcommand= new MySqlCommand("select * from 表名;", dbConnection);

MySqlDataReader reader=mysqlcommand.ExecuteReader();try{while(reader.Read())

{if(reader.HasRows)

{//reader.getstring(0)/getint(0).....

}

}

}catch(Exception)

{

Console.WriteLine("failed to select");

}finally{

reader.Close();

}

CloseConnection();

}

}

}