+ \TextBox5.Text + \+ TextBox6.Text+\ string strIns = \Count,Price,Factory,Fday,Day)values('\ OracleCommand insCom = new OracleCommand(strIns, conn);
conn.Open();
Int32 n=insCom.ExecuteNonQuery(); if (n > 0) {
Response.Write(\
language=javascript>alert('添加成功!');\ }
conn.Close();
OracleConnection OracleConnection(\
conn1=
new
Source=orcl;User
ID=system;password=xiao871112;Unicode=True\ string strFac = TextBox5.Text ; string
strIns1
=
\
into
com
(Factory)values('\
OracleCommand insCom1 = new OracleCommand(strIns1,
21
conn1);
conn1.Open();
Int32 m = insCom1.ExecuteNonQuery(); if (m > 0) {
Response.Write(\
language=javascript>alert('添加成功!');\ }
conn1.Close();
OracleConnection conn2 = new OracleConnection(\Source=orcl;User
ID=system;password=xiao871112;Unicode=True\ string strPro = TextBox2.Text; string
strIns2
=
\
into
product
(Pnum)values('\
OracleCommand insCom2 = new OracleCommand(strIns2, conn2);
conn2.Open();
Int32 k = insCom2.ExecuteNonQuery(); if (k > 0) {
Response.Write(\
22
language=javascript>alert('添加成功!点击确定返回的主页面');\
Server.Transfer(\ }
conn2.Close(); } }
//查询功能的实现代码
public partial class insert : System.Web.UI.Page {
protected void Page_Load(object sender, EventArgs e) {
this.Title = \查询\ } protected EventArgs e) {
Panel1.Visible = true; B
oolean flag = false;
OracleConnection conn = new OracleConnection(\Source=orcl;User
23
void btnSubmit_Click(object sender,
ID=system;Password=xiao871112;Unicode=True\
OracleCommand com = new OracleCommand(\* from Hetong\ conn.Open();
OracleDataReader dr = com.ExecuteReader(); while (dr.Read()) { if
(txtbox1.Text
==
dr[\ {
flag = true;
Label1.Text = dr[\ Label2.Text = dr[\ Label3.Text = dr[\ Label4.Text = dr[\ Label5.Text = dr[\ Label6.Text = dr[\ Label7.Text = dr[\ float price=float.Parse(Label3.Text); float count=float.Parse(Label4.Text); float total=price*count; Label8.Text=total.ToString(); } }
24
if(flag==false)
Response.Write(\
language=javascript>alert('没有你所查询的信息， 单击确定返回');\ dr.Close(); conn.Close(); } }
3.2数据库语言的程序语言设计和操作 3.2.1创建合同管理系统数据库
25