本文整理汇总了C#中MySqlDatabase.Release方法的典型用法代码示例。如果您正苦于以下问题:C# MySqlDatabase.Release方法的具体用法?C# MySqlDatabase.Release怎么用?C# MySqlDatabase.Release使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类MySqlDatabase
的用法示例。
在下文中一共展示了MySqlDatabase.Release方法的1个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: Refresh
public static void Refresh()
{
String dbName = Starter.CustomData.GetValue("SystemDB/dbname");
String dbHost = Starter.CustomData.GetValue("SystemDB/ipaddress");
Int32 dbPort = Starter.CustomData.GetValue("SystemDB/portno").ToInt32();
String userId = Starter.CustomData.GetValue("SystemDB/userid");
String userPwd = Starter.CustomData.GetValue("SystemDB/userpwd");
MySqlDatabase systemDB = new MySqlDatabase(dbHost, dbPort, "", dbName, userId, userPwd);
using (DBCommand cmd = new DBCommand(systemDB))
{
cmd.CommandText.Append("select uid, worldid, dbtype, dbname, ipaddress, portno, userid, passwd");
cmd.CommandText.Append(", charset, shardkey_start, shardkey_end");
cmd.CommandText.Append(" from t_listdb;");
DataReader reader = cmd.Query();
while (reader.Read())
{
DBInfo info = new DBInfo()
{
Uid = reader.GetInt32(0),
WorldId = reader.GetInt32(1),
DBType = (DBType)reader.GetInt32(2),
DBName = reader.GetString(3),
IPAddress = reader.GetString(4),
PortNo = reader.GetInt32(5),
UserId = reader.GetString(6),
UserPwd = reader.GetString(7),
CharSet = (reader.IsDBNull(8) == true ? "" : reader.GetString(8)),
ShardKeyStart = (reader.IsDBNull(9) == true ? 0 : reader.GetInt32(9)),
ShardKeyEnd = (reader.IsDBNull(10) == true ? 0 : reader.GetInt32(10))
};
Items.Add(info);
if (info.DBType == DBType.System)
SystemDB.Initialize(info);
else if (info.DBType == DBType.Auth)
AuthDB.Initialize(info);
else if (info.DBType == DBType.Game)
GameDB.AddDBInfo(info);
}
}
systemDB.Release();
}