SQLHelper:
public static string constr = "data source=.;initial catalog=School;User ID=sa;Password=111111";
public static int ExecuteNoQuery(string sql,params SqlParameter[] parameters)
{
using (SqlConnection conn = new SqlConnection(connStr))
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = sql;
foreach (SqlParameter parameter in parameters)
{
cmd.Parameters.Add(parameter);
}
return cmd.ExecuteNonQuery();
}
}
}
后台:
protected void btnInsert_Click(object sender, EventArgs e)
{
int result = SQLHelper.ExecuteNoQuery("insert into Class(CName,CDescription) values(@className,@classDesc )", new SqlParameter("@className", txtClassName.Text.Trim()), new SqlParameter("@classDesc", txtClassDesc.Text.Trim()));
this.Response.Write("插入" + result + "行。");
}
protected void btnDelete_Click(object sender, EventArgs e)
{
int result = SQLHelper.ExecuteNoQuery("delete from Class where CId=@cid", new SqlParameter("@cid", txtId.Text.Trim()));
this.Response.Write("删除" + result + "行。");
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
int result = SQLHelper.ExecuteNoQuery("update Class set CName=@cname,CDescription=@cdes where CId=@cid ", new SqlParameter("@cname", txtUpdateCname.Text.Trim()), new SqlParameter("@cdes", txtUpdateCdesc.Text.Trim()),new SqlParameter("@cid",txtUpdateId.Text.Trim()));
this.Response.Write("修改了" + result + "行。");
}
前台:
<div class="insert" style="border:1px">
班级名称:<asp:TextBox ID="txtClassName" runat="server"></asp:TextBox>
<br />
班级描述:<asp:TextBox ID="txtClassDesc" runat="server"></asp:TextBox>
<br />
<br />
<asp:Button ID="btnInsert" runat="server" οnclick="btnInsert_Click" Text="插入" />
</div>
<div class="delete" style="border:1px">
请输入要删除的班级ID:<br />
班级ID:<asp:TextBox ID="txtId" runat="server"></asp:TextBox>
<br />
<br />
<br />
<asp:Button ID="btnDelete" runat="server" οnclick="btnDelete_Click" Text="删除" />
</div>
<div class="update" style="border:1px">
请输入要修改的班级ID:<br />
班级ID:<asp:TextBox ID="txtUpdateId" runat="server"></asp:TextBox>
<br />
班级名称:<asp:TextBox ID="txtUpdateCname" runat="server"></asp:TextBox>
<br />
班级描述:<asp:TextBox ID="txtUpdateCdesc" runat="server"></asp:TextBox>
<br />
<br />
<asp:Button ID="btnUpdate" runat="server" οnclick="btnUpdate_Click" Text="修改" />
</div>
public static string constr = "data source=.;initial catalog=School;User ID=sa;Password=111111";
public static int ExecuteNoQuery(string sql,params SqlParameter[] parameters)
{
using (SqlConnection conn = new SqlConnection(connStr))
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = sql;
foreach (SqlParameter parameter in parameters)
{
cmd.Parameters.Add(parameter);
}
return cmd.ExecuteNonQuery();
}
}
}
后台:
protected void btnInsert_Click(object sender, EventArgs e)
{
int result = SQLHelper.ExecuteNoQuery("insert into Class(CName,CDescription) values(@className,@classDesc )", new SqlParameter("@className", txtClassName.Text.Trim()), new SqlParameter("@classDesc", txtClassDesc.Text.Trim()));
this.Response.Write("插入" + result + "行。");
}
protected void btnDelete_Click(object sender, EventArgs e)
{
int result = SQLHelper.ExecuteNoQuery("delete from Class where CId=@cid", new SqlParameter("@cid", txtId.Text.Trim()));
this.Response.Write("删除" + result + "行。");
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
int result = SQLHelper.ExecuteNoQuery("update Class set CName=@cname,CDescription=@cdes where CId=@cid ", new SqlParameter("@cname", txtUpdateCname.Text.Trim()), new SqlParameter("@cdes", txtUpdateCdesc.Text.Trim()),new SqlParameter("@cid",txtUpdateId.Text.Trim()));
this.Response.Write("修改了" + result + "行。");
}
前台:
<div class="insert" style="border:1px">
班级名称:<asp:TextBox ID="txtClassName" runat="server"></asp:TextBox>
<br />
班级描述:<asp:TextBox ID="txtClassDesc" runat="server"></asp:TextBox>
<br />
<br />
<asp:Button ID="btnInsert" runat="server" οnclick="btnInsert_Click" Text="插入" />
</div>
<div class="delete" style="border:1px">
请输入要删除的班级ID:<br />
班级ID:<asp:TextBox ID="txtId" runat="server"></asp:TextBox>
<br />
<br />
<br />
<asp:Button ID="btnDelete" runat="server" οnclick="btnDelete_Click" Text="删除" />
</div>
<div class="update" style="border:1px">
请输入要修改的班级ID:<br />
班级ID:<asp:TextBox ID="txtUpdateId" runat="server"></asp:TextBox>
<br />
班级名称:<asp:TextBox ID="txtUpdateCname" runat="server"></asp:TextBox>
<br />
班级描述:<asp:TextBox ID="txtUpdateCdesc" runat="server"></asp:TextBox>
<br />
<br />
<asp:Button ID="btnUpdate" runat="server" οnclick="btnUpdate_Click" Text="修改" />
</div>