public static OleDbConnection getConnOra()
{
if (connOra == null)
initalConnect();
connOra.Open();
return connOra;
}高手在帮忙给看下啊~!谢谢
{
if (connOra == null)
initalConnect();
connOra.Open();
return connOra;
}高手在帮忙给看下啊~!谢谢
帮忙在看下啊,谢谢
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.OleDb; /// <summary>
/// doubleConn 的摘要说明
/// </summary>
public class doubleConn
{
protected static string connectionStringOra = ConfigurationSettings.AppSettings["ConnectionStringOracle"];
protected static string connectionStringAccess = ConfigurationSettings.AppSettings["ConnectionStringAccess"]; private static System.Data.OleDb.OleDbConnection connOra = null;
private static System.Data.OleDb.OleDbConnection connAccess = null; private static void initalConnect()
{
connOra = new System.Data.OleDb.OleDbConnection(connectionStringOra);
connAccess = new System.Data.OleDb.OleDbConnection(connectionStringAccess);
}
public static OleDbConnection getConnOra()
{
if (connOra == null)
initalConnect();
connOra.Open();
return connOra;
} public static OleDbConnection getConnAccess()
{
if (connAccess == null)
initalConnect();
connAccess.Open();
return connAccess;
}
}
public class demo
{ public void addDemo()
{
OleDbConnection connOra = doubleConn.getConnOra();
OleDbConnection connAccess = doubleConn.getConnAccess(); String strAddOra = @"insert into or_user_tb(id,name,password,username,sex,phone)values(1,'MAQH','mybrother','MAQH','1','1390123456')";
String strAddAcc = @"insert into acc_user_tb(id,name,password,username,sex,phone)values(1,'MAQH','mybrother','MAQH','1','1390123456')"; System.Data.OleDb.OleDbCommand cmdOra = new System.Data.OleDb.OleDbCommand(strAddOra, connOra);
System.Data.OleDb.OleDbCommand cmdAcc = new System.Data.OleDb.OleDbCommand(strAddAcc, connAccess); cmdOra.ExecuteNonQuery();
cmdAcc.ExecuteNonQuery();
}
}
和connectionStringAccess = ConfigurationSettings.AppSettings["ConnectionStringAccess"];
这两句写到:
private static void initalConnect()
{
connectionStringOra = ConfigurationSettings.AppSettings["ConnectionStringOracle"];
connectionStringAccess = ConfigurationSettings.AppSettings["ConnectionStringAccess"];
connOra = new System.Data.OleDb.OleDbConnection(connectionStringOra);
connAccess = new System.Data.OleDb.OleDbConnection(connectionStringAccess);
}