NHibernate+Spring.Net

转载于 2017-12-07 15:06:00 发布 · 141 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/leixin-nation/p/7999141.html

文章标签：

#java

本文介绍如何在NHibernate+Spring.net环境中执行存储过程并返回IList结果，以及如何执行SQL语句并将结果填充到DataSet中。文章提供了具体的实现代码，包括参数设置及异常处理。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

1、在NHibernate+Spring.net中执行存储过程，返回IList

/// <summary>
/// 执行存储过程
/// </summary>
/// <param name="procName">存储过程名</param>
/// <param name="dict">参数键值对</param>
/// <returns></returns>
public virtual IList executeProcQuery(string procName, Dictionary<string, object> dict)
{
IList result = new ArrayList();
IDbCommand cmd = SessionFactory.OpenSession().Connection.CreateCommand();
cmd.CommandText = procName;
cmd.CommandType = CommandType.StoredProcedure;
if (dict != null && dict.Count > 0)
{
foreach (KeyValuePair<string, object> kvp in dict)
{
IDbDataParameter parameter = cmd.CreateParameter();
parameter.ParameterName = kvp.Key;
parameter.Value = kvp.Value;
cmd.Parameters.Add(parameter);
}
}
try
{
IDataReader rs = cmd.ExecuteReader();

while (rs.Read())
{
int fieldCount = rs.FieldCount;
object[] values = new Object[fieldCount];
for (int i = 0; i < fieldCount; i++)
values[i] = rs.GetValue(i);
result.Add(values);
}
}
catch (Exception ex)
{
throw ex;
}

return result;
}

2、在NHibernate+Spring.net中执行sql语句，返回DataSet

/// <summary>
/// 填充DataSet
/// </summary>
/// <param name="sql">原生sql语句</param>
/// <returns></returns>
public DataSet ExecuteDataset(string sql)
{
DataSet ds = new DataSet();
try
{
IDbCommand command = Session.Connection.CreateCommand();
command.CommandText = sql;

IDataReader reader = command.ExecuteReader();
DataTable result = new DataTable();
result.Load(reader);
ds.Tables.Add(result);
}
catch (Exception ex)
{

}
finally
{

}
return ds;
}

转载于:https://www.cnblogs.com/leixin-nation/p/7999141.html