DBHelper连接oracle数据库类

%-- 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

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();
            }
        }

    }
}

public string SampleMethod()
{
 return "Method output.";
}