mysql-关于连接服务器端MySql数据库,却不能成功打开
程序员文章站
2022-06-05 20:03:47
...
mysql数据库
namespace Lode
{
class Program
{
static void Main(string[] args)
{
string load, password;
load = Console.ReadLine();
password = Console.ReadLine();
if (Search(load,password))
{
Console.WriteLine("登入成功");
}
else
Console.WriteLine("登入失败");
}
/// /// 建立执行命令语句对象 /// /// /// /// public static MySqlCommand getSqlCommand(String sql, MySqlConnection mysql) { MySqlCommand mySqlCommand = new MySqlCommand(sql, mysql); // MySqlCommand mySqlCommand = new MySqlCommand(sql); // mySqlCommand.Connection = mysql; return mySqlCommand; } /// /// 查询并获得结果集并遍历 /// /// public static bool Search(string load,string password ) { /* //连接数据库 //server=这里写服务器的IP地址;uid=数据登录名;pwd=密码;database=数据库 String mysqlStr = @"Database=bbs;Data Source=59.74.169.59;User Id=bbs;Password=kjcxlab.com!@!@;pooling=false;CharSet=utf8;port=8080"; // String mySqlCon = ConfigurationManager.ConnectionStrings["MySqlCon"].ConnectionString; */ MySqlConnection mysql = getMySqlcon(); int i = 0; Console.WriteLine("46"); try { Console.WriteLine("56"); if (mysql.State == ConnectionState.Open) //检查连接状态 { mysql.Close(); } Console.WriteLine("63"); mysql.Open(); //打开数据库连接 string sqlSearch; Console.WriteLine("64"); if (IsEmail(load)) { sqlSearch = @"select * from bbs_common_member where email='" + load + "' AND password=MD5('" + password + "')"; } else { sqlSearch = @"select * from data where username='" + load + "' AND password=MD5('" + password + "')"; } MySqlCommand mySqlCommand = getSqlCommand(sqlSearch, mysql); i = Convert.ToInt32(mySqlCommand.ExecuteScalar()); } catch (MySqlException oe) { Console.WriteLine(oe.Message); } finally { if (mysql.State == ConnectionState.Open) mysql.Close(); } if (i != 1) { return false; } else return true; } /// /// 建立mysql数据库链接 /// /// private static MySqlConnection getMySqlcon() { //server=这里写服务器的IP地址;uid=数据登录名;pwd=密码;database=数据库 String mysqlStr = @"Database=bbs;Data Source=59.74.169.59;User Id=bbs;Password=kjcxlab.com!@!@;pooling=false;CharSet=utf8;Port=8080"; //String mySqlCon = ConfigurationManager.ConnectionStrings["MySqlCon"].ConnectionString; MySqlConnection mysql = new MySqlConnection(mysqlStr); return mysql; } public static bool IsEmail(string str) { string res = string.Empty; string expression = @"^([\w-\.]+)@((\[[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}\.)|(([\w-]+\.)+))([a-zA-Z]{2,4}|[0-9]{1,3})(\]?)$"; bool boo = new Regex(expression).Match(str).Success; return boo; }}
}