最近开发使用ASP.NET+Oracle,因此写了个在Oracle数据库中执行SQL语句的类,贴出来记录一下,如果能够
using
System;
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.OracleClient;
using System.Collections;
/**/ /// <summary>
/// 执行SQL语句
/// 作者:赖兴荣
/// 日期:2008年1月19日
/// </summary>
public class executeSQL
... {
public executeSQL()
...{
//
// TODO: Add constructor logic here
//
}
//根据传入的非查询SQL语句,在Oracle中执行,同时返回执行结果
public static bool ExecuteNonQueryOracleSQL(string sql)
...{
OracleConnection conn = databaseLink.Link();
OracleCommand cmd = new OracleCommand(sql,conn);
if (cmd.ExecuteNonQuery() > 0)
...{
return true;
}
else
...{
return false;
}
}
//根据传入的查询SQL语句,在Oracle中执行,同时返回执行结果集合
public static ArrayList ExecuteQueryOracleSQL_Return(string sql)
...{
ArrayList a=new ArrayList();
OracleConnection conn = databaseLink.Link();
OracleCommand cmd = new OracleCommand(sql, conn);
OracleDataReader reader = cmd.ExecuteReader();
while(reader.Read())
...{
a.Add(reader.GetOracleValue(0));
//a.Add(reader.GetOracleValue(1));
}
return a;
}
//根据传入的查询SQL语句,在Oracle中执行,同时返回bool值,表明该查询是否成功
public static bool ExecuteQueryOracleSQL_Check(string sql)
...{
OracleConnection conn = databaseLink.Link();
OracleCommand cmd = new OracleCommand(sql, conn);
try
...{
OracleDataReader reader = cmd.ExecuteReader();
if (reader.HasRows)
...{
return true;
}
else
...{
return false;
}
}
catch (OracleException oe)
...{
return false;
}
}
}
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.OracleClient;
using System.Collections;
/**/ /// <summary>
/// 执行SQL语句
/// 作者:赖兴荣
/// 日期:2008年1月19日
/// </summary>
public class executeSQL
... {
public executeSQL()
...{
//
// TODO: Add constructor logic here
//
}
//根据传入的非查询SQL语句,在Oracle中执行,同时返回执行结果
public static bool ExecuteNonQueryOracleSQL(string sql)
...{
OracleConnection conn = databaseLink.Link();
OracleCommand cmd = new OracleCommand(sql,conn);
if (cmd.ExecuteNonQuery() > 0)
...{
return true;
}
else
...{
return false;
}
}
//根据传入的查询SQL语句,在Oracle中执行,同时返回执行结果集合
public static ArrayList ExecuteQueryOracleSQL_Return(string sql)
...{
ArrayList a=new ArrayList();
OracleConnection conn = databaseLink.Link();
OracleCommand cmd = new OracleCommand(sql, conn);
OracleDataReader reader = cmd.ExecuteReader();
while(reader.Read())
...{
a.Add(reader.GetOracleValue(0));
//a.Add(reader.GetOracleValue(1));
}
return a;
}
//根据传入的查询SQL语句,在Oracle中执行,同时返回bool值,表明该查询是否成功
public static bool ExecuteQueryOracleSQL_Check(string sql)
...{
OracleConnection conn = databaseLink.Link();
OracleCommand cmd = new OracleCommand(sql, conn);
try
...{
OracleDataReader reader = cmd.ExecuteReader();
if (reader.HasRows)
...{
return true;
}
else
...{
return false;
}
}
catch (OracleException oe)
...{
return false;
}
}
}