1、 Oralce官網 下載 安裝 ODTforVS2015_121025 重啟VS
2、項目引用 Oracle.ManagedDataaccess.dll
3、數據庫連接字符串： user id=xxxx;passWord=xxxx;data source=192.168.0.xxx:1521/orcl(數據庫名)
4、使用方法：
OracleConnection con = new OracleConnection(); con.ConnectionString = "user id=his3;password=his3;data source=192.168.1.237/ORCL"; con.Open(); OracleCommand cmd = new OracleCommand(); cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = "select * from gy_yonghuxx"; cmd.Connection = con; OracleDataAdapter da = new OracleDataAdapter(); da.SelectCommand = cmd; DataSet ds = new DataSet(); da.Fill(ds); con.Close(); da.Dispose(); cmd.Dispose(); con.Dispose(); 工具類：using System;using System.Collections.Generic;using System.Linq;using System.Text;using Oracle.ManagedDataAccess.Client;using System.Configuration;using System.Data;using System.Reflection;namespace NCToOA{ public class OracleHelper { #region 變量 /// <summary> /// 數據庫連接對象 /// </summary> PRivate static OracleConnection _con = null; public static string constr = ConfigurationManager.ConnectionStrings["OracleStr"].ToString(); #endregion #region 屬性 /// <summary> /// 獲取或設置數據庫連接對象 /// </summary> public static OracleConnection Con { get { if (OracleHelper._con == null) { OracleHelper._con = new OracleConnection(); } if (OracleHelper._con.ConnectionString == "") { OracleHelper._con.ConnectionString = OracleHelper.constr; } return OracleHelper._con; } set { OracleHelper._con = value; } } #endregion #region 方法 #region 執行返回一行一列的數據庫操作 /// <summary> /// 執行返回一行一列的數據庫操作 /// </summary> /// <param name="commandText">Oracle語句或存儲過程名</param> /// <param name="commandType">Oracle命令類型</param> /// <param name="param">Oracle命令參數數組</param> /// <returns>第一行第一列的記錄</returns> public static int ExecuteScalar(string commandText, CommandType commandType, params OracleParameter[] param) { int count = 0; using (OracleHelper.Con) { using (OracleCommand cmd = new OracleCommand(commandText, OracleHelper.Con)) { //try //{ cmd.CommandType = commandType; if (param != null) { cmd.Parameters.AddRange(param); } OracleHelper.Con.Open(); count = Convert.ToInt32(cmd.ExecuteScalar()); //} //catch (Exception ex) //{ // count = 0; //} } } return count; } #endregion #region 執行不查詢的數據庫操作 /// <summary> /// 執行不查詢的數據庫操作 /// </summary> /// <param name="commandText">Oracle語句或存儲過程名</param> /// <param name="commandType">Oracle命令類型</param> /// <param name="param">Oracle命令參數數組</param> /// <returns>受影響的行數</returns> public static int ExecuteNonQuery(string commandText, CommandType commandType, params OracleParameter[] param) { int result = 0; using (OracleHelper.Con) { using (OracleCommand cmd = new OracleCommand(commandText, OracleHelper.Con)) { try { cmd.CommandType = commandType; if (param != null) { cmd.Parameters.AddRange(param); } OracleHelper.Con.Open(); result = cmd.ExecuteNonQuery(); } catch (Exception ex) { result = 0; } } } return result; } #endregion #region 執行返回一條記錄的泛型對象 /// <summary> /// 執行返回一條記錄的泛型對象 /// </summary> /// <typeparam name="T">泛型類型</typeparam> /// <param name="reader">只進只讀對象</param> /// <returns>泛型對象</returns> private static T ExecuteDataReader<T>(IDataReader reader) { T obj = default(T); try { Type type = typeof(T); obj = (T)Activator.CreateInstance(type);//從當前程序集里面通過反射的方式創建指定類型的對象 //obj = (T)Assembly.Load(OracleHelper._assemblyName).CreateInstance(OracleHelper._assemblyName + "." + type.Name);//從另一個程序集里面通過反射的方式創建指定類型的對象 PropertyInfo[] propertyInfos = type.GetProperties();//獲取指定類型里面的所有屬性 foreach (PropertyInfo propertyInfo in propertyInfos) { for (int i = 0; i < reader.FieldCount; i++) { string fieldName = reader.GetName(i); if (fieldName.ToLower() == propertyInfo.Name.ToLower()) { object val = reader[propertyInfo.Name];//讀取表中某一條記錄里面的某一列 if (val != null && val != DBNull.Value) { if (val.GetType() == typeof(decimal) || val.GetType() == typeof(int)) { propertyInfo.SetValue(obj, Convert.ToInt32(val), null); } else if (val.GetType() == typeof(DateTime)) { propertyInfo.SetValue(obj, Convert.ToDateTime(val), null); } else if (val.GetType() == typeof(string)) { propertyInfo.SetValue(obj, Convert.ToString(val), null); } } break; } } } } catch (Exception ex) { throw; } return obj; } #endregion #region 執行返回一條記錄的泛型對象 /// <summary> /// 執行返回一條記錄的泛型對象 /// </summary> /// <typeparam name="T">泛型類型</typeparam> /// <param name="commandText">Oracle語句或存儲過程名</param> /// <param name="commandType">Oracle命令類型</param> /// <param name="param">Oracle命令參數數組</param> /// <returns>實體對象</returns> public static T ExecuteEntity<T>(string commandText, CommandType commandType, params OracleParameter[] param) { T obj = default(T); using (OracleHelper.Con) { using (OracleCommand cmd = new OracleCommand(commandText, OracleHelper.Con)) { cmd.CommandType = commandType; cmd.Parameters.AddRange(param); OracleHelper.Con.Open(); OracleDataReader reader = cmd.ExecuteReader(CommandBehavior.CloseConnection); while (reader.Read()) { obj = OracleHelper.ExecuteDataReader<T>(reader); } } } return obj; } #endregion #region 執行返回多條記錄的泛型集合對象 /// <summary> /// 執行返回多條記錄的泛型集合對象 /// </summary> /// <typeparam name="T">泛型類型</typeparam> /// <param name="commandText">Oracle語句或存儲過程名</param> /// <param name="commandType">Oracle命令類型</param> /// <param name="param">Oracle命令參數數組</param> /// <returns>泛型集合對象</returns> public static List<T> ExecuteList<T>(string commandText, CommandType commandType, params OracleParameter[] param) { List<T> list = new List<T>(); using (OracleHelper.Con) { using (OracleCommand cmd = new OracleCommand(commandText, OracleHelper.Con)) { try { cmd.CommandType = commandType; if (param != null) { cmd.Parameters.AddRange(param); } OracleHelper.Con.Open(); OracleDataReader reader = cmd.ExecuteReader(CommandBehavior.CloseConnection); while (reader.Read()) { T obj = OracleHelper.ExecuteDataReader<T>(reader); list.Add(obj); } } catch (Exception ex) { list = null; } } } return list; } #endregion #endregion }}
新聞熱點
疑難解答
