当前位置:Gxlcms > mysql > mysql-关于连接服务器端MySql数据库,却不能成功打开

mysql-关于连接服务器端MySql数据库,却不能成功打开

时间:2021-07-01 10:21:17 帮助过:12人阅读

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;    }}

}

人气教程排行