62,046
社区成员
发帖
与我相关
我的任务
分享
//方法一: 使用TryCatchFinally
public static List<ClassA> GetListTryCatch()
{
List<ClassA> list = new List<ClassA>();
string queryString = @"select * from tableA";
OracleConnection connection = null;
try
{
connection = new OracleConnection(connectionString);
OracleCommand command = new OracleCommand();
command.Connection = connection;
command.CommandText = queryString;
connection.Open();
OracleDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
ClassA ca = new ClassA();
ca.ItemName = reader.GetString(0);
ca.TargetValue = reader.GetDouble(1);
list.Add(ca);
}
}
catch (Exception)
{
throw;
}
finally
{
connection.Close();
// connection.Dispose(); // 不知道要不要加这句
}
return list;
}
//方法二: 使用Using
public static List<ClassA> GetListUsing()
{
List<ClassA> list = new List<ClassA>();
string queryString = @"select * from tableA";
// use using
using (OracleConnection connection = new OracleConnection(connectionString))
{
OracleCommand command = new OracleCommand(queryString, connection);
connection.Open();
using (OracleDataReader reader = command.ExecuteReader())
{
// Always call Read before accessing data.
while (reader.Read())
{
ClassA ca = new ClassA();
ca.ItemName = reader.GetString(0);
ca.TargetValue = reader.GetDouble(1);
list.Add(ca);
}
}
}
return list;
}
............
List<ClassA> listtry=null;
{
............
listtry =GetListg();
}
catch(Exception ex)
{
throw new MyException(string.Format("在用户{0}查询{1}经营报表调用GetListg()时系统异常。",user,report),ex);
}
.........
............
try
{
............
List<ClassA> list=GetListg();
}
catch(Exception ex)
{
threw new MyException(string.Format("在用户{0}查询{1}经营报表调用GetListg()时系统异常。",user,report),ex);
}
.........
............
string errmessage=string.Empty;
try
{
............
List<ClassA> list=GetListg();
}
catch(Exception ex)
{
while(ex!=null)
{
errmessage += ex.Message;
ex = ex.InnerException;
}
}
.........
public static List<ClassA> GetListg()
{
List<ClassA> list = new List<ClassA>();
string queryString = @"select * from tableA";
// use using
using (OracleConnection connection = new OracleConnection(connectionString))
{
OracleCommand command = new OracleCommand(queryString, connection);
connection.Open();
OracleDataReader reader = command.ExecuteReader(CommandBehavior.CloseConnection);
while (reader.Read())
{
ClassA ca = new ClassA();
ca.ItemName = reader.GetString(0);
ca.TargetValue = reader.GetDouble(1);
list.Add(ca);
}
reader.Close();
}
return list;
}