62,046
社区成员
发帖
与我相关
我的任务
分享
//这是连接
//得到连接方法
public static OracleConnection Connection
{
get
{
string connectionString = ConfigurationSettings.AppSettings["ConnStr2"];
OracleConnection connection = new OracleConnection(connectionString);
if (connection == null)//如果连接是空,创建连接,并打开连接
{
connection = new OracleConnection(connectionString);
connection.Open();
}
else if (connection.State == System.Data.ConnectionState.Closed)//如果连接存在,并关闭,打开连接
{
connection.Open();
}
else if (connection.State == System.Data.ConnectionState.Broken)//如果上一次连接未关闭,先关闭连接,再打开
{
connection.Close();
connection.Open();
}
return connection;
}
}
//其中一条查询函数
public static int GetScalar(string safeSql)//无参数sql语句
{
OracleCommand cmd = new OracleCommand(safeSql, Connection);
int result = Convert.ToInt32(cmd.ExecuteScalar());
Connection.Close();
Connection.Dispose();
return result;
}
public static int GetScalar(string safeSql)//无参数sql语句
{
using (OracleConnection conn = new OracleConnection(connstr))
{
conn.Open();
OracleCommand cmd = new OracleCommand(safeSql, conn);
int result = Convert.ToInt32(cmd.ExecuteScalar());
conn.Close();
return result;
}
}
private static OracleConnection connection;
public static OracleConnection Connection
{
get
{
string connectionString = ConfigurationSettings.AppSettings["ConnStr2"];
using (OracleConnection connection = new OracleConnection(connectionString))
{
if (connection.State == System.Data.ConnectionState.Closed)//如果连接存在,并关闭,打开连接
{
connection.Open();
}
if (connection.State == System.Data.ConnectionState.Broken)//如果上一次连接未关闭,先关闭连接,再打开
{
connection.Close();
connection.Open();
}
return connection;
}
}
}
//其中一条查询函数
public static int GetScalar(string safeSql)//无参数sql语句
{
OracleCommand cmd = new OracleCommand(safeSql, Connection);
int result = Convert.ToInt32(cmd.ExecuteScalar());
Connection.Close();
Connection.Dispose();
return result;
}