Home > Database > Mysql Tutorial > body text

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

WBOY
Release: 2016-06-06 09:41:50
Original
928 people have browsed it

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>
Copy after login

}

<code></code>
Copy after login
Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn:Public welfare online PHP training,Help PHP learners grow quickly!