解析数据部分代码
MySqlCommand cmd = new MySqlCommand("select * fromaccount where acct = @acct", conn); cmd.Parameters.AddWithValue("acct", acct); reader = cmd.ExecuteReader(); id = reader.GetInt32("id"), name = reader.GetString("name"), lv = reader.GetInt32("level"), exp = reader.GetInt32("exp"), power = reader.GetInt32("power"), coin = reader.GetInt32("coin"), diamond = reader.GetInt32("diamond")## 创建新账号部分代码
insert into account set acct=@acct,pass =@pass,name=@name,level=@level,exp=@exp,power=@power,coin=@coin,diamond=@diamond" cmd.Parameters.AddWithValue("acct", acct); cmd.Parameters.AddWithValue("pass", pass); cmd.Parameters.AddWithValue("name", pd.name); cmd.Parameters.AddWithValue("level", pd.lv); cmd.Parameters.AddWithValue("exp", pd.exp); cmd.Parameters.AddWithValue("power", pd.power); cmd.Parameters.AddWithValue("coin", pd.coin); cmd.Parameters.AddWithValue("diamond", pd.diamond); //名字是否已经存在 MySqlCommand cmd = new MySqlCommand("select * from account where name= @name", conn); cmd.Parameters.AddWithValue("name", name); reader = cmd.ExecuteReader(); if (reader.Read()) { exist = true; } //更新玩家数据 MySqlCommand cmd = new MySqlCommand( "update account set name=@name,level=@level,exp=@exp,power=@power,coin=@coin,diamond=@diamond where id =@id", conn); cmd.Parameters.AddWithValue("id", id); cmd.Parameters.AddWithValue("name", playerData.name); cmd.Parameters.AddWithValue("level", playerData.lv); cmd.Parameters.AddWithValue("exp", playerData.exp); cmd.Parameters.AddWithValue("power", playerData.power); cmd.Parameters.AddWithValue("coin", playerData.coin); cmd.Parameters.AddWithValue("diamond", playerData.diamond); //TOADD Others cmd.ExecuteNonQuery();