1.链接oracle数据库
OracleHelpher 中创建一个
public static string connectString = ConfigurationManager.ConnectionStrings["orcale"].ConnectionString;
用于获取web.config文件中链接字符串文件
<connectionStrings>
<!--<add name="orcale" connectionString="Data Source=DESCRIPTION =(LOAD_BALANCE=ON)(FAILOVER=ON) (ADDRESS_LIST =(SOURCE_ROUTE=yes) (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.15)(PORT = 1521))(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.16)(PORT = 1521)) )(CONNECT_DATA =(SERVICE_NAME = HIS));Persist Security Info=True;User ID=system;Password=oracle"/>-->
<add name="orcale" connectionString="User id=emr;password=emr;Data Source=192.168.0.15:1521/HIS;"/>
</connectionStrings>
2.c#链接数据库的方法
#region 数据库连接
public static OracleConnection DbConn(ref string message, ref Boolean re)
{
//数据库的连接的方式
OracleConnection conn;
re = false;
message = "";
conn = new OracleConnection(connectString);
try
{
conn.Open();
re = true;
}
catch (Exception ex)
{
message = "错误:" + ex.Message.ToString();
re = false;
return null;
}
finally
{
conn.Close();
}
return conn;
}
#endregion
#region 增
public static Boolean AddSql(string sql, ref string message)
{
bool re = false;
try
{
OracleConnection conn = DbConn(ref message, ref re);
if (conn == null)
{
re = false;
message = "数据库连接对象为空"+ message;
}
else
{
try
{
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
}
catch (Exception eee)
{
re = false;
message = eee.Message.ToString();
}
OracleCommand cmd = new OracleCommand(sql, conn);
int count = cmd.ExecuteNonQuery();
if (count > 0)
{
re = true;
}
else
{
re = false;
message = "数据插入失败";
}
cmd.Dispose();
conn.Close();
}
}
catch (Exception ee)
{
re = false;
message = "add数据出错,原因:" + ee.Message.ToString();
}
return re;
}
#endregion
#region 删
public Boolean DeleteSql(string sql, ref string message)
{
bool re = false;
try
{
OracleConnection conn = DbConn(ref message, ref re);
if (conn == null)
{
re = false;
message = "数据库连接对象为空";
}
else
{
try
{
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
}
catch (Exception eee)
{
re = false;
message = eee.Message.ToString();
}
OracleCommand cmd = new OracleCommand(sql, conn);
int count = cmd.ExecuteNonQuery();
if (count > 0)
{
re = true;
}
else
{
re = false;
message = "数据删除失败";
}
cmd.Dispose();
conn.Close();
}
}
catch (Exception ee)
{
re = false;
message = "add数据出错,原因:" + ee.Message.ToString();
}
return re;
}
#endregion