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