DBHelper连接oracle数据库类

数据库|mysql教程

DBHelper,连接,oracle,数据库,%–,Nam

数据库-mysql教程

多条件筛选源码,ubuntu中git太慢,设置tomcat字符集编码,企查查使用爬虫,验证码图片识别php,广宁seo工作lzw

%– Name: Author: Description: –% %@ CodeTemplate Language=C# TargetLanguage=Text Src= Inherits= Debug=False Description=Template description here. % %@ Property Name=SampleStringProperty Type=System.String Default=SomeValue Optional=True

会说话的tom猫 源码,ubuntu没有语言库,怎么用Tomcat运行系统,nodejs爬虫设置,php显示文字在左上,宣化seolzw

udp打洞 c源码,ubuntu如何查看目录,tomcat跑多个应用包,挖爬虫技巧,如何获取php地址,巫溪一站式seo推广费用是多少lzw

<%–

Name:

Author:

Description:

–%>

using System;

using System.Collections.Generic;

using System.Text;

using System.Data.OracleClient;

using System.Data;

using System.Configuration;

namespace WindowsFormsApplication1

{

public class DBHelper

{

public static string ConnString

{

get

{

return ConfigurationManager.ConnectionStrings[“db”].ConnectionString;

}

}

public static OracleConnection Connection

{

get

{

return new OracleConnection(ConnString);

}

}

public static int ExecuteCommand(string sql)

{

OracleCommand cmd = new OracleCommand(sql, Connection);

cmd.Connection.Open();

try

{

int result = cmd.ExecuteNonQuery();

return result;

}

finally

{

cmd.Connection.Close();

cmd.Connection.Dispose();

}

}

public static int ExecuteCommand(string sql, OracleParameter[] values)

{

OracleCommand cmd = new OracleCommand(sql, Connection);

cmd.Connection.Open();

try

{

cmd.Parameters.AddRange(values);

return cmd.ExecuteNonQuery();

}

finally

{

cmd.Connection.Close();

cmd.Connection.Dispose();

}

}

public static int GetScalar(string sql)

{

OracleCommand cmd = new OracleCommand(sql, Connection);

cmd.Connection.Open();

try

{

int result = Convert.ToInt32(cmd.ExecuteScalar());

return result;

}

finally

{

cmd.Connection.Close();

cmd.Connection.Dispose();

}

}

public static int GetScalar(string sql, OracleParameter[] values)

{

OracleCommand cmd = new OracleCommand(sql, Connection);

cmd.Connection.Open();

try

{

cmd.Parameters.AddRange(values);

int result = Convert.ToInt32(cmd.ExecuteScalar());

return result;

}

finally

{

cmd.Connection.Close();

cmd.Connection.Dispose();

}

}

public static OracleDataReader GetReader(string sql)

{

OracleCommand cmd = new OracleCommand(sql, Connection);

cmd.Connection.Open();

OracleDataReader reader = cmd.ExecuteReader(CommandBehavior.CloseConnection);

return reader;

}

public static OracleDataReader GetReader(string sql, OracleParameter[] values)

{

OracleCommand cmd = new OracleCommand(sql, Connection);

cmd.Parameters.AddRange(values);

cmd.Connection.Open();

OracleDataReader reader = cmd.ExecuteReader(CommandBehavior.CloseConnection);

return reader;

}

public static DataSet GetDataSet(string sql)

{

DataSet ds = new DataSet();

OracleCommand cmd = new OracleCommand(sql, Connection);

try

{

OracleDataAdapter da = new OracleDataAdapter(cmd);

da.Fill(ds);

return ds;

}

finally

{

cmd.Connection.Dispose();

}

}

public static DataSet GetDataSet(string sql, OracleParameter[] values)

{

DataSet ds = new DataSet();

OracleCommand cmd = new OracleCommand(sql, Connection);

try

{

cmd.Parameters.AddRange(values);

OracleDataAdapter da = new OracleDataAdapter(cmd);

da.Fill(ds);

return ds;

}

finally

{

cmd.Connection.Dispose();

}

}

}

}

// My methods here.

public string SampleMethod()

{

return “Method output.”;

}