接口编程（实现改变文本文件中的内容切换数据库）

来源：互联网发布：核辐射是什么东西知乎编辑：程序博客网时间：2024/06/06 13:17

----------------------------WebForm1.aspx-----------------------------------------------

</html>

---------------------WebForm1.aspx.cs-------------------------------------

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;
using System.IO;
using System.Data.SqlClient;
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(@"e:\adapter.txt");
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(@"e:\conncetion.txt");
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;
}
}
}

------------------Web.config-----------------------------