public static DataTable QueryDt(string sql)
{
using (OracleConnection con = new OracleConnection(connStr))
{
using (OracleCommand cmd = con.CreateCommand())
{
try
{
con.Open();
cmd.BindByName = true;
//SQL查询语句
cmd.CommandText = sql;
OracleDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
Console.WriteLine("用户名: " + reader.GetString(0));
}
Console.WriteLine();
Console.WriteLine("Press 'Enter' to continue");
reader.Dispose();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
finally
{
if (null != con || !con.Disposed())
{
con.Dispose();
}
}
}
}
}