面向对象、Orcal数据库实现对数据的操作

最新推荐文章于 2023-11-02 17:23:16 发布

原创最新推荐文章于 2023-11-02 17:23:16 发布 · 1.4k 阅读

0 ·

CC 4.0 BY-SA版权

C# 专栏收录该内容

28 篇文章

订阅专栏

本文介绍了一个使用 ASP.NET 实现的数据绑定示例，该示例支持 SQL Server 和 Oracle 两种数据库，并展示了如何根据不同数据库类型动态创建连接和执行插入操作。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

--------前台--------

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="WebForm1.aspx.cs" Inherits="接口.WebForm1" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

-----------后台-----------

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.Common;
using System.Data.SqlClient;
using System.Data;
using System.IO;
using System.Data.OracleClient;
using System.Configuration;

namespace 接口
{
    public partial class WebForm1 : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
             DataLoad();
            }
        }

        private void DataLoad()
        {
            DbConnection conn = GetCon();
            DbCommand cmd = conn.CreateCommand();
            cmd.CommandText = "select * from T_User";
            DataTable dt = new DataTable();
            DbDataAdapter adapter = GetDataadpter();
            adapter.SelectCommand = cmd;
            adapter.Fill(dt);
            cmd.Dispose();
            conn.Dispose();
            this.GridView1.DataSource = dt;
            this.GridView1.DataBind();

        }
        //根据选择的数据库动态返回数据适配器
        private DbDataAdapter GetDataadpter()
        {
            DbDataAdapter adapter = null;
            //string content = File.ReadAllText(@"c:\conncetion.txt");
            string content = ConfigurationManager.AppSettings["data"];
            if (content.ToUpper() == "SQLSERVER")
            {
                adapter = new SqlDataAdapter();
            }
            else if (content.ToUpper() == "ORACLE")
            {
                adapter = new OracleDataAdapter();
            }
            return adapter;

        }
        //根据选择的数据库动态返回练级对象
        private DbConnection GetCon()
        {
         string strcon = "";
            DbConnection con = null;
           // string content = File.ReadAllText(@"c:\conncetion.txt");
            string content=ConfigurationManager.AppSettings["data"];
            if (content.ToUpper()=="SQLSERVER")
            {
                strcon = ConfigurationManager.ConnectionStrings["sqlservercon"].ConnectionString;
                con = new SqlConnection(strcon);
            }
            else if (content.ToUpper() == "ORACLE")
            {
                strcon = ConfigurationManager.ConnectionStrings["oraclecon"].ConnectionString; ;
                con = new OracleConnection(strcon);
            }
            return con;
        }

        protected void Button1_Click(object sender, EventArgs e)
        {
            DbConnection conn = GetCon();
            conn.Open();
            DbCommand cmd = conn.CreateCommand();
            string sqlrt= "insert into T_User(Id,Name,Password,E_Mail) VALUES(@id,@name,@password,@email)";

            if (conn.GetType() == typeof(OracleConnection))
            {
                sqlrt= sqlrt.Replace('@', ':');

                cmd.CommandText = sqlrt;
                cmd.Parameters.Add(new OracleParameter(":id", Convert.ToInt32(txtId.Text)));
                cmd.Parameters.Add(new OracleParameter(":name", txtName.Text));
                cmd.Parameters.Add(new OracleParameter(":password", txtPassword.Text));
                cmd.Parameters.Add(new OracleParameter(":email", txtEmail.Text));
            }
            else
            {
                cmd.CommandText = sqlrt;
                cmd.Parameters.Add(new SqlParameter("@id", Convert.ToInt32(txtId.Text)));
                cmd.Parameters.Add(new SqlParameter("@name", txtName.Text));
                cmd.Parameters.Add(new SqlParameter("@password", txtPassword.Text));
                cmd.Parameters.Add(new SqlParameter("@email", txtEmail.Text));
            }
            int num = cmd.ExecuteNonQuery();
            if (num > 0)
            {
                Response.Write("插入成功");
                DataLoad();
            }
        }

    }
}

------web.config------