public static int[] getAllMemberId(Room room)
{
int[] uid = new int[room.CurrentNum];
string sql = "SELECT * FROM room_member WHERE rid = " + room.Rid;
MySqlCommand command = new MySqlCommand(sql, connection);
MySqlDataReader sqlDataReader = command.ExecuteReader();
for (int i = 0; sqlDataReader.Read(); i++)
{
uid[i] = sqlDataReader.GetInt32("uid");
}
sqlDataReader.Close(); //这行代码一定要写,否则connection无法关闭报错
return uid;
}
08-26
873
09-18
1480
10-14
418
01-19
592
06-26
3万+
04-16
456