¹ØÓÚʹÓÃmysqlÎÊÌâ

C# code:
using MySql.Data.MySqlClient;


public static bool IsExist(string username)
{
string myconnectionstring = "server=192.168.1.208;User Id=root;password=123;Database=dressroom";
MySqlConnection myconnection = new MySqlConnection(myconnectionstring);
MySqlCommand mycmd = new MySqlCommand("select account_id from account where account_name=?userName", myconnection);
try
{
mycmd.Parameters.Add(new MySqlParameter("?userName", MySqlDbType.VarChar, 32));
mycmd.Parameters[0].Value = username;
mycmd.Connection.Open();
MySqlDataAdapter da = new MySqlDataAdapter(mycmd);
DataSet ds = new DataSet();
da.Fill(ds);
if (ds != null)
{
if (ds.Tables.Count > 0)
{
if (ds.Tables[0].Rows.Count > 0)
{
return true;
}
else
{
return false;
}
}
else
{
return false;
}

}
else
{
return false;
}

}
ca