提示插入成功,数据库中却没有改变
三层一个很简单的插入却遇到了问题,代码如下
model层public class Admin
{
private int ID;
private string Name;
private string Pwd;
public int id
{
get { return ID; }
set { ID = value; }
}
public string name
{
get { return Name; }
set { Name = value; }
}
public string pwd
{
get { return Pwd; }
set { Pwd = value; }
}
bll层 public void Add(Admin a)
{
da.Add(a);
}
dal层 public void Add(Admin a)
{
string sqlstr = "insert into Admin values(@name,@pwd)";
SqlCommand cmd = db.GetCommand();
cmd.CommandText = sqlstr;
db.AddParameters("@name", a.name);
db.AddParameters("@pwd", a.pwd);
db.opencon();
try
{
cmd.ExecuteNonQuery();
}
catch (Exception e)
{
throw e;
}
finally
{
db.closecon();
}
页面中代码如下:protected void Button2_Click(object sender, EventArgs e)
{
Admin a2 = new Admin();
a2.name = TextBox1.Text;
a2.pwd = TextBox2.Text;
BLLAdmin ba2 = new BLLAdmin();
try
{
ba2.Add(a2);
Response.Write("<script>alert('添加成功')</script>");
}
catch (Exception ee)
{
throw new Exception(ee.Message.ToString());
}
}
最后运行时提示添加成功,但是数据库中数据却没有改变,哪位大侠来看下