>  기사  >  데이터 베이스  >  mysql-关于连接服务器端MySql数据库,却不能成功打开

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

WBOY
WBOY원래의
2016-06-06 09:41:50944검색

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("登入失败");
}

<code>    /// <summary>    /// 建立执行命令语句对象    /// </summary>    /// <param name="sql">    /// <param name="mysql">    /// <returns></returns>    public static MySqlCommand getSqlCommand(String sql, MySqlConnection mysql)    {        MySqlCommand mySqlCommand = new MySqlCommand(sql, mysql);        //  MySqlCommand mySqlCommand = new MySqlCommand(sql);        // mySqlCommand.Connection = mysql;        return mySqlCommand;    }    /// <summary>    /// 查询并获得结果集并遍历    /// </summary>    /// <param name="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;    }    /// <summary>    /// 建立mysql数据库链接    /// </summary>    /// <returns></returns>    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;    }}</code>

}

<code></code>
성명:
본 글의 내용은 네티즌들의 자발적인 기여로 작성되었으며, 저작권은 원저작자에게 있습니다. 본 사이트는 이에 상응하는 법적 책임을 지지 않습니다. 표절이나 침해가 의심되는 콘텐츠를 발견한 경우 admin@php.cn으로 문의하세요.