欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  数据库

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

}

相关标签: mysql 数据库