网页链接Oracle实现数据的增删改查
来源:互联网 发布:2016年地区数据库 编辑:程序博客网 时间:2024/05/23 01:14
前台代码
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:TextBox ID="txtId" runat="server"></asp:TextBox>
<asp:TextBox ID="txtName" runat="server"></asp:TextBox>
<asp:TextBox ID="txtPassword" runat="server"></asp:TextBox>
<asp:Button ID="Button1" runat="server" Text="添加" onclick="Button1_Click1" />
<asp:Button ID="btnedit" runat="server" onclick="btnedit_Click" Text="保存" />
<br />
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False">
<Columns>
<asp:BoundField DataField="ID" HeaderText="编号" />
<asp:BoundField DataField="NAME" HeaderText="帐号" />
<asp:BoundField DataField="PASSWORD" HeaderText="密码" />
<asp:TemplateField HeaderText="操作">
<ItemTemplate>
<asp:LinkButton ID="LinkButton2" runat="server" onclick="LinkButton2_Click" CommandArgument='<%#Eval("ID") %>'>删除</asp:LinkButton>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="操作">
<ItemTemplate>
<asp:LinkButton ID="ledelete" runat="server" CommandArgument='<%#Eval("ID") %>' onclick="ledelete_Click">编辑</asp:LinkButton>
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
</div>
</form>
</body>
</html>
后台代码
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Configuration;
using System.Data.OracleClient;
using System.Data;
using System.Text;
namespace Orcale连接数据库
{
public partial class WebForm1 : System.Web.UI.Page
{
string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
DataLoad();
}
}
private void DataLoad()
{
OracleConnection conn = new OracleConnection(constr);
OracleCommand cmd = conn.CreateCommand();
conn.Open();
cmd.CommandText = "select * from T_USER order by ID";
OracleDataAdapter adapter = new OracleDataAdapter(cmd);
DataTable dt = new DataTable();
adapter.Fill(dt);
cmd.Dispose();
conn.Dispose();
GridView1.DataSource = dt;
GridView1.DataBind();
}
protected void Button1_Click1(object sender, EventArgs e)
{
OracleConnection conn = new OracleConnection(constr);
OracleCommand cmd = conn.CreateCommand();
conn.Open();
cmd.CommandText = "insert into T_USER values(:id,:name,:password)";
cmd.Parameters.AddWithValue(":id",txtId.Text);
cmd.Parameters.AddWithValue(":name", txtName.Text);
cmd.Parameters.AddWithValue(":password",txtPassword.Text);
cmd.ExecuteNonQuery();
txtId.Text = null;
txtName.Text = null;
txtPassword.Text = null;
DataLoad();
}
protected void LinkButton2_Click(object sender, EventArgs e)
{
LinkButton btndelete = sender as LinkButton;
OracleConnection conn = new OracleConnection(constr);
OracleCommand cmd = conn.CreateCommand();
conn.Open();
cmd.CommandText = "delete from T_USER where ID=:id";
cmd.Parameters.AddWithValue(":id", btndelete.CommandArgument);
if (cmd.ExecuteNonQuery() > 0)
{
DataLoad();
}
}
//编辑
protected void ledelete_Click(object sender, EventArgs e)
{
txtId.Enabled = false;
LinkButton btnedit = sender as LinkButton;
OracleConnection conn = new OracleConnection(constr);
OracleCommand cmd = conn.CreateCommand();
conn.Open();
cmd.CommandText = "select ID,NAME,PASSWORD from T_USER where ID=:id";
cmd.Parameters.AddWithValue(":id", Convert.ToInt32(btnedit.CommandArgument));
OracleDataAdapter adapter = new OracleDataAdapter(cmd);
DataTable dt = new DataTable();
adapter.Fill(dt);
cmd.Dispose();
conn.Dispose();
txtId.Text = dt.Rows[0]["ID"].ToString();
txtName.Text = dt.Rows[0]["NAME"].ToString();
txtPassword.Text = dt.Rows[0]["PASSWORD"].ToString();
}
protected void btnedit_Click(object sender, EventArgs e)
{
OracleConnection conn = new OracleConnection(constr);
OracleCommand cmd = conn.CreateCommand();
conn.Open();
cmd.CommandText = "update T_USER set ID=:id,NAME=:name,PASSWORD=:password where ID="+txtId.Text+"";
cmd.Parameters.AddWithValue(":id", txtId.Text);
cmd.Parameters.AddWithValue(":name", txtName.Text);
cmd.Parameters.AddWithValue(":password", txtPassword.Text);
cmd.ExecuteNonQuery();
txtId.Text = null;
txtName.Text = null;
txtPassword.Text = null;
DataLoad();
}
}
}
Web.config链接数据库字符串
<connectionStrings>
<add name="constr" connectionString="Data Source=orclzhs;Persist Security Info=True;User ID=zhs;Password=zhs;Unicode=True" providerName="System.Data.OracleClient"/>
</connectionStrings>
- 网页链接Oracle实现数据的增删改查
- 网页链接Oracle实现数据的增删改查--gridview
- mybatis ---- 实现数据的增删改查
- html实现数据的增删查改
- MyBatis实现数据的增删查改
- Mybatis实现数据的增删改查
- 网页的增删改查
- oracle的增删改查
- springmvc+mybatis+maven+junit实现网页的增删查改
- 数据的增删改查
- 数据的增删改查
- 测试小例---Hibernate实现Oracle中数据的增删改查
- Mybatis实现对数据(oracle数据库)的增删改查(crud)
- JDBC连接Oracle数据库后实现对emp 表数据的增删改查
- JDBC实现Oracle数据库的增删改查
- mybatis实现的对数据的增删查改
- mybatis实现的对数据的增删查改
- Mybatis实现的对数据的增删查改
- KMP算法参考资料
- 逻辑思维题75道
- mysql 不 能启动的原因
- ZOJ 3258 Wistone and Owenwater 01背包+完全背包
- Jython学习笔记(一) Eclipse开发环境搭建
- 网页链接Oracle实现数据的增删改查
- chrony, ntp, 同步
- 一种基于ACE的简单应用程序模型
- ffmpeg installation
- wireless setup
- Mac OS X系统应该如何维护和保养
- Android学习笔记之AndroidManifest.xml文件解析
- 通过struts2的配置文件访问jsp
- Android自测题13