Web层代码:
public partial class _Default : System.Web.UI.Page
{
LoginBusiness.Business rule = new LoginBusiness.Business(); protected void Page_Load(object sender, EventArgs e)
{ }
protected void btnLogin_Click(object sender, EventArgs e)
{
string user =this.txtUser.Text.Trim();
string userpwd = this.txtPwd.Text.Trim();
bool flag = rule.LoginUser(user, userpwd);
if (flag == true)
{
Response.Write("<script language='javascript'>alert('登陆成功');</script>");
}
else
{
Response.Write("<script language='javascript'>alert('登陆失败');</script>");
}
}
}
------
数据层:
namespace LoginData
{
public class SqlHelper
{
public string conStr = ConfigurationManager.AppSettings["ConnectionStrng1"].ToString();
public int ExcuteNonQuery(string sql)
{
SqlConnection conn = new SqlConnection();
conn.ConnectionString = conStr;
SqlCommand cmd = new SqlCommand();
cmd.CommandText = sql;
try
{
conn.Open();
cmd.ExecuteNonQuery();
}
catch (Exception e)
{
string error = e.Message;
return 0;
}
finally
{
conn.Close();
}
return 1;
}
public DataSet ExcuteDataSet()
{
DataSet ds = new DataSet();
return ds;
}
}
}
--------
业务层:
namespace LoginBusiness
{
public class Business
{
LoginData.SqlHelper data = new LoginData.SqlHelper();
//在此设置断点在WEB页面上输入用户名和密码,都能够看到有返回值。
public bool LoginUser(string username, string password)
{
string sql = "select * form username where users=" + username + "and password=" + password;
int flag;
flag = data.ExcuteNonQuery(sql);
//设置断点查看其值flag=0,失败了!是不是数据库出现了问题还是什么?望大家帮帮忙!
if (flag == 1)
{
return true;
}
else
{
return false;
}
}
}
}
public partial class _Default : System.Web.UI.Page
{
LoginBusiness.Business rule = new LoginBusiness.Business(); protected void Page_Load(object sender, EventArgs e)
{ }
protected void btnLogin_Click(object sender, EventArgs e)
{
string user =this.txtUser.Text.Trim();
string userpwd = this.txtPwd.Text.Trim();
bool flag = rule.LoginUser(user, userpwd);
if (flag == true)
{
Response.Write("<script language='javascript'>alert('登陆成功');</script>");
}
else
{
Response.Write("<script language='javascript'>alert('登陆失败');</script>");
}
}
}
------
数据层:
namespace LoginData
{
public class SqlHelper
{
public string conStr = ConfigurationManager.AppSettings["ConnectionStrng1"].ToString();
public int ExcuteNonQuery(string sql)
{
SqlConnection conn = new SqlConnection();
conn.ConnectionString = conStr;
SqlCommand cmd = new SqlCommand();
cmd.CommandText = sql;
try
{
conn.Open();
cmd.ExecuteNonQuery();
}
catch (Exception e)
{
string error = e.Message;
return 0;
}
finally
{
conn.Close();
}
return 1;
}
public DataSet ExcuteDataSet()
{
DataSet ds = new DataSet();
return ds;
}
}
}
--------
业务层:
namespace LoginBusiness
{
public class Business
{
LoginData.SqlHelper data = new LoginData.SqlHelper();
//在此设置断点在WEB页面上输入用户名和密码,都能够看到有返回值。
public bool LoginUser(string username, string password)
{
string sql = "select * form username where users=" + username + "and password=" + password;
int flag;
flag = data.ExcuteNonQuery(sql);
//设置断点查看其值flag=0,失败了!是不是数据库出现了问题还是什么?望大家帮帮忙!
if (flag == 1)
{
return true;
}
else
{
return false;
}
}
}
}
设置个断点跟踪一下。
cmd .Connection = conn;
cmd.ExecuteNonQuery();
明显select * form username where users=" + username + "and password=" + password;
这句有问题,连个'和空格都不加?
出来就是
select * form username where users=用户名and password=密码
100%的出错