Oracle常用的SQL执行方法

//程序集 MySql.Data.dll, v6.9.8.0
using MySql.Data.MySqlClient;
using System;
using System.Collections.Generic;
using System.Configuration;
// 程序集 System.Data.dll, v4.0.0.0
using System.Data;
using System.Linq;
namespace SQLCommand
{
    class Program
    {
        public static int commTime = int.Parse(ConfigurationManager.AppSettings["commandTimeOut"]);
        static void Main(string[] args)
        {
        }
        /// <summary>
        /// 执行查询语句，返回DataTable
        /// 解决错误问题：(0x80004005): Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.TimeoutException: Timeout in IO operation
        /// </summary>
        /// <param name="SQLString">查询语句</param>
        /// <param name="commTime">设置查询Timeout</param>
        /// <returns>用于复杂查询</returns>
        public static DataTable GetDataTable(string SQLString, int commTime)
        {
            string connectionString = ConfigurationManager.AppSettings["connectionString"];
            using (System.Data.SqlClient.SqlConnection connection = new System.Data.SqlClient.SqlConnection(connectionString))
            {
                DataTable dt = new DataTable();
                try
                {
                    connection.Open();
                    System.Data.SqlClient.SqlDataAdapter da = new System.Data.SqlClient.SqlDataAdapter();
                    System.Data.SqlClient.SqlCommand comm = new System.Data.SqlClient.SqlCommand(SQLString, connection);
                    //设置延迟时间
                    comm.CommandTimeout = commTime;
                    da.SelectCommand = comm;
                    da.Fill(dt);
                }
                catch (System.Data.SqlClient.SqlException ex)
                {
                    throw new Exception(ex.Message);
                }
                return dt;
            }
        }
        public static DataTable GetDataTable(string connectionString, string SQLString)
        {
            using (MySqlConnection connection = new MySqlConnection(connectionString))
            {
                DataSet ds = new DataSet();
                try
                {
                    connection.Open();
                    MySqlDataAdapter command = new MySqlDataAdapter(SQLString, connection);
                    command.SelectCommand.CommandTimeout = commTime;
                    command.Fill(ds, "ds");
                }
                catch (MySqlException ex)
                {
                    throw new Exception(ex.Message);
                }
                return ds.Tables[0];
            }
        }
        /// <summary>
        /// 执行一条计算查询结果语句，返回查询结果（object）。
        /// </summary>
        /// <param name="SQLString">计算查询结果语句</param>
        /// <returns>查询结果（object）</returns>
        public static object GetSingle(string connectionString, string SQLString, params MySqlParameter[] cmdParms)
        {
            using (MySqlConnection connection = new MySqlConnection(connectionString))
            {
                using (MySqlCommand cmd = new MySqlCommand())
                {
                    try
                    {
                        //设置超时时长
                        cmd.CommandTimeout = commTime;
                        PrepareCommand(cmd, connection, null, SQLString, cmdParms);
                        //ExecuteScalar执行成功，竟然返回为空
                        //object obj = cmd.ExecuteScalar();
                        int rows = cmd.ExecuteNonQuery();
                        cmd.Parameters.Clear();
                        return rows;
                    }
                    catch (MySqlException e)
                    {
                        throw e;
                    }
                }
            }
        }
        private static void PrepareCommand(MySqlCommand cmd, MySqlConnection conn, MySqlTransaction trans, string cmdText, MySqlParameter[] cmdParms)
        {
            if (conn.State != ConnectionState.Open)
                conn.Open();
            cmd.Connection = conn;
            cmd.CommandText = cmdText;
            if (trans != null)
                cmd.Transaction = trans;
            cmd.CommandType = CommandType.Text;//cmdType;
            if (cmdParms != null)
            {
                foreach (MySqlParameter parameter in cmdParms)
                {
                    if ((parameter.Direction == ParameterDirection.InputOutput || parameter.Direction == ParameterDirection.Input) &&
                        (parameter.Value == null))
                    {
                        parameter.Value = DBNull.Value;
                    }
                    cmd.Parameters.Add(parameter);
                }
            }
        }
    }
}