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("登入失败");
}
/// <summary> /// 建立执行命令语句对象 /// </summary> /// <param name="sql"></param> /// <param name="mysql"></param> /// <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"></param> 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; }}}
每个人都需要一台速度更快、更稳定的 PC。随着时间的推移,垃圾文件、旧注册表数据和不必要的后台进程会占用资源并降低性能。幸运的是,许多工具可以让 Windows 保持平稳运行。
Copyright 2014-2025 https://www.php.cn/ All Rights Reserved | php.cn | 湘ICP备2023035733号