//ASP.NET操作ORACLE事例
using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Data.OracleClient;
namespace OracleTemp
{
/// <summary>
/// WebForm1 的摘要说明。
/// </summary>
public class WebForm1 : System.Web.UI.Page
{
protected System.Web.UI.WebControls.DataGrid DataGrid1;
protected System.Web.UI.WebControls.Button btnAdd;
protected System.Web.UI.WebControls.Button btnDelete;
protected System.Web.UI.WebControls.Button btnUpDate;
protected System.Web.UI.WebControls.Button btnNew;
protected System.Web.UI.WebControls.Label Label1;
protected System.Web.UI.WebControls.TextBox txtID;
protected System.Web.UI.WebControls.Button btnQuery;
protected System.Web.UI.WebControls.TextBox txtName;
protected System.Web.UI.WebControls.Label Label2;
OracleConnection OracleConn; private void Page_Load(object sender, System.EventArgs e)
{
// 在此处放置用户代码以初始化页面
if(!Page.IsPostBack)
{
DisplayEmp();
}
}
private void OpenOracleDataBase()
{
string strConn=System.Configuration.ConfigurationSettings.AppSettings["ORACLE_CONNECTIONSTRING"].ToString();
OracleConn=new OracleConnection(strConn);
OracleConn.Open();
}
private void CloseOracleDataBase()
{
OracleConn.Close();
}
private void DisplayEmp()
{
OpenOracleDataBase();
string strSql="select empno as 员工编号,ename as 姓名,job as 工作 from emp";
OracleCommand ocomm=new OracleCommand(strSql,OracleConn);
DataGrid1.DataSource=ocomm.ExecuteReader();
DataGrid1.DataBind();
CloseOracleDataBase();
} private void OracleData(string strSql)
{
OpenOracleDataBase();
OracleCommand OracleCmd=new OracleCommand("",OracleConn);
OracleCmd.CommandText=strSql;
OracleCmd.ExecuteNonQuery();
CloseOracleDataBase();
} private void btnAdd_Click(object sender, System.EventArgs e)
{
string strInset="insert into emp values(7777,'郝东','PG',7789,'23-1月 -82',3500,12,10)";
OracleData(strInset);
} private void btnNew_Click(object sender, System.EventArgs e)
{
DisplayEmp();
} private void btnDelete_Click(object sender, System.EventArgs e)
{
string strDelete="delete emp where empno=7777";
OracleData(strDelete);
} private void btnUpDate_Click(object sender, System.EventArgs e)
{
string strUpDate="update emp set ename='郝凌平' where empno=7777";
OracleData(strUpDate);
} private void btnQuery_Click(object sender, System.EventArgs e)
{
OracleDataReader odrTemp;
OpenOracleDataBase();
OracleCommand ocmdTemp=new OracleCommand("select ename from emp where empno="+Convert.ToInt32(txtID.Text.Trim())+"",OracleConn);
odrTemp=ocmdTemp.ExecuteReader();
while(odrTemp.Read())
{
txtName.Text=odrTemp.GetString(0);
}
CloseOracleDataBase();
}
}
}
/////////////////////////////
web.config配置
<configuration>
<appSettings>
<add key="ORACLE_CONNECTIONSTRING" value="Data Source=dlq;User Id=scott;Password=tiger;Max Pool Size = 512;"/>
</appSettings>
代码是连接ORACLE的,跟SQL没多大差别,将主见全改成SQL的就行了
using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Data.OracleClient;
namespace OracleTemp
{
/// <summary>
/// WebForm1 的摘要说明。
/// </summary>
public class WebForm1 : System.Web.UI.Page
{
protected System.Web.UI.WebControls.DataGrid DataGrid1;
protected System.Web.UI.WebControls.Button btnAdd;
protected System.Web.UI.WebControls.Button btnDelete;
protected System.Web.UI.WebControls.Button btnUpDate;
protected System.Web.UI.WebControls.Button btnNew;
protected System.Web.UI.WebControls.Label Label1;
protected System.Web.UI.WebControls.TextBox txtID;
protected System.Web.UI.WebControls.Button btnQuery;
protected System.Web.UI.WebControls.TextBox txtName;
protected System.Web.UI.WebControls.Label Label2;
OracleConnection OracleConn; private void Page_Load(object sender, System.EventArgs e)
{
// 在此处放置用户代码以初始化页面
if(!Page.IsPostBack)
{
DisplayEmp();
}
}
private void OpenOracleDataBase()
{
string strConn=System.Configuration.ConfigurationSettings.AppSettings["ORACLE_CONNECTIONSTRING"].ToString();
OracleConn=new OracleConnection(strConn);
OracleConn.Open();
}
private void CloseOracleDataBase()
{
OracleConn.Close();
}
private void DisplayEmp()
{
OpenOracleDataBase();
string strSql="select empno as 员工编号,ename as 姓名,job as 工作 from emp";
OracleCommand ocomm=new OracleCommand(strSql,OracleConn);
DataGrid1.DataSource=ocomm.ExecuteReader();
DataGrid1.DataBind();
CloseOracleDataBase();
} private void OracleData(string strSql)
{
OpenOracleDataBase();
OracleCommand OracleCmd=new OracleCommand("",OracleConn);
OracleCmd.CommandText=strSql;
OracleCmd.ExecuteNonQuery();
CloseOracleDataBase();
} private void btnAdd_Click(object sender, System.EventArgs e)
{
string strInset="insert into emp values(7777,'郝东','PG',7789,'23-1月 -82',3500,12,10)";
OracleData(strInset);
} private void btnNew_Click(object sender, System.EventArgs e)
{
DisplayEmp();
} private void btnDelete_Click(object sender, System.EventArgs e)
{
string strDelete="delete emp where empno=7777";
OracleData(strDelete);
} private void btnUpDate_Click(object sender, System.EventArgs e)
{
string strUpDate="update emp set ename='郝凌平' where empno=7777";
OracleData(strUpDate);
} private void btnQuery_Click(object sender, System.EventArgs e)
{
OracleDataReader odrTemp;
OpenOracleDataBase();
OracleCommand ocmdTemp=new OracleCommand("select ename from emp where empno="+Convert.ToInt32(txtID.Text.Trim())+"",OracleConn);
odrTemp=ocmdTemp.ExecuteReader();
while(odrTemp.Read())
{
txtName.Text=odrTemp.GetString(0);
}
CloseOracleDataBase();
}
}
}
/////////////////////////////
web.config配置
<configuration>
<appSettings>
<add key="ORACLE_CONNECTIONSTRING" value="Data Source=dlq;User Id=scott;Password=tiger;Max Pool Size = 512;"/>
</appSettings>
代码是连接ORACLE的,跟SQL没多大差别,将主见全改成SQL的就行了
我用的是c#语言编写的呢,asp好象不太适合哦。