using System;using System.Collections.Generic;using System.Linq;using System.Web;using System.Configuration;using MySql.Data.MySqlClient;namespace Work.Models{ /// /// 连接mysql数据库的连接类 /// public class ConnectMysql { /// /// 获得mysql数据库的连接对象 /// public MySqlConnection getConn() { return new MySqlConnection("Database=数据库名;Data Source=IP地址(本机为127.0.0.1);User Id=mysql登录名;Password=密码;pooling=false;CharSet=utf8;port=3306"); } }}
/// /// 检查用户登录的方法 /// public int UserLoginCheck(string UserName,string UserPass) { //为3时表示用户不存在 int flag = 3; ConnectMysql mysql = new ConnectMysql(); MySqlConnection conn = null; MySqlCommand command = null; MySqlDataReader mdr = null; string sql = "select username,password from user_info where username = @UserName and password = @UserPass"; try { conn = mysql.getConn(); command = new MySqlCommand(sql, conn); conn.Open(); command.Parameters.AddWithValue("@UserName", UserName); command.Parameters.AddWithValue("@UserPass", UserPass); mdr = command.ExecuteReader(); if (mdr.Read()) { flag = 1; } } catch (Exception e) { flag = 3; System.Diagnostics.Debug.WriteLine(e.StackTrace); } finally { conn.Close(); } return flag; }
取消
评论