连接数据库--ORACLE(不完整)
using System;
using System.Data;
using System.Data.OracleClient;
namespace ASPNETClassLibrary
...{
/**//// <summary>
/// Command_ORACLE 的摘要说明。
/// </summary>
public class Command_ORACLE
...{
public Command_ORACLE()
...{
//
// TODO: 在此处添加构造函数逻辑
//
}
...#region
/**//// <summary>
/// 连接数据字段
/// </summary>
private static string _connectionString;
/**//// <summary>
/// 设置为只读
/// </summary>
public static string connectionString
...{
get
...{
return _connectionString;
}
set
...{
_connectionString = value;
}
}
/**//// <summary>
/// 打开数据的连接
/// </summary>
/// <returns></returns>
public static OracleConnection getOracleConnection()
...{
try
...{
string OracleString = _connectionString ; //"Provider=Microsoft.Jet.Oracle.4.0;User ID=Admin;Data Source='" + HttpContext.Current.Server.MapPath("~/LHB_DataBase/LHB.mdb") + "';Jet Oracle:Engine Type=5;Jet Oracle:Database Locking Mode=1;Jet Oracle:Global Partial Bulk Ops=2;Jet Oracle:Global Bulk Transactions=1;Jet Oracle:Create System Database=False;Jet Oracle:Encrypt Database=False;Jet Oracle:Don't Copy Locale on Compact=False;Jet Oracle:Compact Without Replica Repair=False;Jet Oracle:SFP=False";
OracleConnection oc = new OracleConnection(OracleString);
oc.Open();
return oc;
}
catch(Exception ex)
...{
string temp = ex.Message;
return null;
}
}
/**//// <summary>
/// 获取 OracleCommand 对象
/// </summary>
/// <returns></returns>
public static OracleCommand getOracleCommand()
...{
OracleConnection cn = getOracleConnection();
if (cn == null)
...{
return null;
}
else
...{
OracleCommand cmd = new OracleCommand();
cmd.Connection = cn;
return cmd;
}
}
/**//// <summary>
/// 新建一个DataSet对象
/// </summary>
/// <param name="ExecuteString">要执行的语句,可是Oracle语句,也可是存储过程的名称</param>
/// <returns></returns>
public static DataSet getDataSet(string ExecuteString)
...{
OracleConnection cn = getOracleConnection();
OracleDataAdapter odda = new OracleDataAdapter(ExecuteString,cn);
DataSet ds = new DataSet();
if (cn == null)
...{
return null;
}
else
...{
odda.Fill(ds);
return ds;
}
}
/**//// <summary>
/// 新建一个DataSet对象
/// </summary>
/// <param name="ExecuteString">要执行的语句,可是Oracle语句,也可是存储过程的名称</param>
/// <param name="name">表的名字</param>
/// <returns></returns>
public static DataSet getDataSet(string ExecuteString, string name)
...{
OracleConnection cn = getOracleConnection();
OracleDataAdapter odda = new OracleDataAdapter(ExecuteString,cn);
DataSet ds = new DataSet();
if (cn == null)
...{
return null;
}
else
...{
odda.Fill(ds,name);
return ds;
}
}
/**//// <summary>
/// 新建一个DataSet对象
/// </summary>
/// <param name="ExecuteString">要执行的语句,可是Oracle语句,也可是存储过程的名称</param>
/// <returns></returns>
public static DataTable getDataTable(string ExecuteString)
...{
OracleConnection cn = getOracleConnection();
OracleDataAdapter odda = new OracleDataAdapter(ExecuteString,cn);
DataTable dt = new DataTable();
if (cn == null)
...{
return null;
}
else
...{
odda.Fill(dt);
return dt;
}
}
/**//// <summary>
/// 执行Oracle语句,返回受影响的行数,
/// -2 说明数据连接失败,
/// -3 发生异常错误。
/// </summary>
/// <param name="ExecuteString">要执行的语句,可是Oracle语句,也可是存储过程的名称</param>
/// <returns></returns>
public static int ExecuteNonQuery(string ExecuteString)
...{
int count;
OracleCommand cmd = getOracleCommand();
if (cmd == null)
...{
/**//// <summary>
/// 说明数据连接失败
/// <summary>
return -2;
}
else
...{
/**//// <summary>
/// 把要执行的字符串给LHB_CMD
/// <summary>
cmd.CommandText = ExecuteString;
/**//// <summary>
/// 开始执行
/// <summary>
count = cmd.ExecuteNonQuery();
/**//// <summary>
/// 返回一个值.
/// <summary>
return count;
}
}
/**//// <summary>
/// 执行指定的Oracle语句,返回首行首列
/// -2 说明数据连接失败,
/// -3 发生异常错误。
/// </summary>
/// <param name="ExecuteString">要执行的语句,可是Oracle语句,也可是存储过程的名称</param>
/// <returns>返回首行首列的那个值</returns>
public static string ExecuteScalar(string ExecuteString)
...{
try
...{
string ShouHangShouLie;
OracleCommand cmd = getOracleCommand();
if (cmd == null)
...{
return "-2";
}
else
...{
cmd.CommandText = ExecuteString;
ShouHangShouLie = cmd.ExecuteScalar().ToString();
return ShouHangShouLie;
}
}
catch (Exception LHB_EE)
...{
string temp = LHB_EE.Message;
return "-3";
}
}
#endregion
}
}
using System.Data;
using System.Data.OracleClient;
namespace ASPNETClassLibrary
...{
/**//// <summary>
/// Command_ORACLE 的摘要说明。
/// </summary>
public class Command_ORACLE
...{
public Command_ORACLE()
...{
//
// TODO: 在此处添加构造函数逻辑
//
}
...#region
/**//// <summary>
/// 连接数据字段
/// </summary>
private static string _connectionString;
/**//// <summary>
/// 设置为只读
/// </summary>
public static string connectionString
...{
get
...{
return _connectionString;
}
set
...{
_connectionString = value;
}
}
/**//// <summary>
/// 打开数据的连接
/// </summary>
/// <returns></returns>
public static OracleConnection getOracleConnection()
...{
try
...{
string OracleString = _connectionString ; //"Provider=Microsoft.Jet.Oracle.4.0;User ID=Admin;Data Source='" + HttpContext.Current.Server.MapPath("~/LHB_DataBase/LHB.mdb") + "';Jet Oracle:Engine Type=5;Jet Oracle:Database Locking Mode=1;Jet Oracle:Global Partial Bulk Ops=2;Jet Oracle:Global Bulk Transactions=1;Jet Oracle:Create System Database=False;Jet Oracle:Encrypt Database=False;Jet Oracle:Don't Copy Locale on Compact=False;Jet Oracle:Compact Without Replica Repair=False;Jet Oracle:SFP=False";
OracleConnection oc = new OracleConnection(OracleString);
oc.Open();
return oc;
}
catch(Exception ex)
...{
string temp = ex.Message;
return null;
}
}
/**//// <summary>
/// 获取 OracleCommand 对象
/// </summary>
/// <returns></returns>
public static OracleCommand getOracleCommand()
...{
OracleConnection cn = getOracleConnection();
if (cn == null)
...{
return null;
}
else
...{
OracleCommand cmd = new OracleCommand();
cmd.Connection = cn;
return cmd;
}
}
/**//// <summary>
/// 新建一个DataSet对象
/// </summary>
/// <param name="ExecuteString">要执行的语句,可是Oracle语句,也可是存储过程的名称</param>
/// <returns></returns>
public static DataSet getDataSet(string ExecuteString)
...{
OracleConnection cn = getOracleConnection();
OracleDataAdapter odda = new OracleDataAdapter(ExecuteString,cn);
DataSet ds = new DataSet();
if (cn == null)
...{
return null;
}
else
...{
odda.Fill(ds);
return ds;
}
}
/**//// <summary>
/// 新建一个DataSet对象
/// </summary>
/// <param name="ExecuteString">要执行的语句,可是Oracle语句,也可是存储过程的名称</param>
/// <param name="name">表的名字</param>
/// <returns></returns>
public static DataSet getDataSet(string ExecuteString, string name)
...{
OracleConnection cn = getOracleConnection();
OracleDataAdapter odda = new OracleDataAdapter(ExecuteString,cn);
DataSet ds = new DataSet();
if (cn == null)
...{
return null;
}
else
...{
odda.Fill(ds,name);
return ds;
}
}
/**//// <summary>
/// 新建一个DataSet对象
/// </summary>
/// <param name="ExecuteString">要执行的语句,可是Oracle语句,也可是存储过程的名称</param>
/// <returns></returns>
public static DataTable getDataTable(string ExecuteString)
...{
OracleConnection cn = getOracleConnection();
OracleDataAdapter odda = new OracleDataAdapter(ExecuteString,cn);
DataTable dt = new DataTable();
if (cn == null)
...{
return null;
}
else
...{
odda.Fill(dt);
return dt;
}
}
/**//// <summary>
/// 执行Oracle语句,返回受影响的行数,
/// -2 说明数据连接失败,
/// -3 发生异常错误。
/// </summary>
/// <param name="ExecuteString">要执行的语句,可是Oracle语句,也可是存储过程的名称</param>
/// <returns></returns>
public static int ExecuteNonQuery(string ExecuteString)
...{
int count;
OracleCommand cmd = getOracleCommand();
if (cmd == null)
...{
/**//// <summary>
/// 说明数据连接失败
/// <summary>
return -2;
}
else
...{
/**//// <summary>
/// 把要执行的字符串给LHB_CMD
/// <summary>
cmd.CommandText = ExecuteString;
/**//// <summary>
/// 开始执行
/// <summary>
count = cmd.ExecuteNonQuery();
/**//// <summary>
/// 返回一个值.
/// <summary>
return count;
}
}
/**//// <summary>
/// 执行指定的Oracle语句,返回首行首列
/// -2 说明数据连接失败,
/// -3 发生异常错误。
/// </summary>
/// <param name="ExecuteString">要执行的语句,可是Oracle语句,也可是存储过程的名称</param>
/// <returns>返回首行首列的那个值</returns>
public static string ExecuteScalar(string ExecuteString)
...{
try
...{
string ShouHangShouLie;
OracleCommand cmd = getOracleCommand();
if (cmd == null)
...{
return "-2";
}
else
...{
cmd.CommandText = ExecuteString;
ShouHangShouLie = cmd.ExecuteScalar().ToString();
return ShouHangShouLie;
}
}
catch (Exception LHB_EE)
...{
string temp = LHB_EE.Message;
return "-3";
}
}
#endregion
}
}