using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Data.OracleClient;
using System.Data;
namespace Winform
{
public class DBFactory
{
static string strConn = "Data Source=yzl;User ID=abc;Password=sss";
OracleConnection conn = null;
private OracleConnection GetOracleConnection() {
conn = new OracleConnection(strConn);
conn.Open();
return conn;
}
private DataSet Command(string sql) {
OracleConnection conn = GetOracleConnection();
OracleCommand oraCmd = new OracleCommand(sql, conn);
//ora.Open();
OracleDataAdapter oda = new OracleDataAdapter(oraCmd);// ("SELECT * FROM FAIS.UNIT_BASE;",ora);
System.Data.DataSet ds = new System.Data.DataSet();
oda.Fill(ds);
conn.Close();
return ds;
}
public DataSet ExcuteDataSet(string sql)
{
return Command(sql);
}
public bool ExcuteSql(string sql)
{
try
{
Command(sql);
return true;
}
catch
{
return false;
}
}
}
}
c#使用2013连接Oracle数据库
最新推荐文章于 2023-06-21 15:39:19 发布