测试Oracle的链接

2015-12-01 15:31:17  访问(1865) 赞(0) 踩(0)

        /// <summary>
        /// 测试Oracle的链接
        /// </summary>
        /// <param name="dbConnectionString"></param>
        /// <returns></returns>
        protected string OracleConnTest(string dbConnectionString)
        {
            string theResult = null;

           OracleConnection conn = null;
           OracleCommand cmd = null;

            try
            {
                conn = new OracleConnection(dbConnectionString);
                conn.Open();

                cmd = new OracleCommand();
                cmd.CommandText = "select sysdate as retValue from sys.dual ";
                cmd.CommandType = CommandType.Text;
                cmd.Connection = conn;

                object obj = cmd.ExecuteScalar();

                if (obj != null)
                {
                    theResult = "连接成功，当前数据库时间为：" + obj.ToString();
                }
                else
                {
                    theResult = "连接成功";
                }
            }
            catch (Exception err)
            {
                theResult = "-连接失败，发生异常：" + err.Message;
            }
            finally
            {
                if (cmd != null)
                {
                    cmd.Parameters.Clear();
                    cmd.Dispose();
                    cmd = null;
                }

                if (conn != null)
                {
                    if (conn.State != ConnectionState.Closed)
                    {
                        conn.Close();
                    }

                    conn.Dispose();
                    conn = null;
                }
            }

            return theResult;
        }

标签：Oracle    数据库    测试连接    数据库连接测试 

上一条：

下一条：

相关评论

发表评论

类型：	留言 建议 疑问
内容：
	(Alt+Enter)