非Select和Select-HibernateTemplate里执行SQL-语句 (非select下拉框定位)

下面将为您介绍在Target="_blank">hibernateTemplate里执行的两种SQL语句，一种执行非Select语句的情况，以及一种执行Select语句的情况，供您参考，希望对您有所启迪。

如下所示只能执行非Select语句；

public static void executeSQL(HibernateTemplate hibernateTemplate,

String sql)

final String tempsql = sql;

hibernateTemplate.execute(new HibernateCallback()

public Object doInHibernate(Session session)

throws HibernateException

session.createQuery(tempsql).executeUpDate();

return null;

若要执行Select则用session.createQuery(tempsql).list();

此处final String tempsql = sql;必须为final 表示tempsql不可以修改；#p#

内联类的要求；

public Object doInHibernate(Session session)返回Object等于hibernateTemplate.execute(new HibernateCallback()的返回，可以通过查看源代码看的出来；

下面是执行select语句的情况：

return (List)hibernateTemplate.execute(new HibernateCallback()

public Object doInHibernate(Session session)

throws HibernateException

List list=session.createQuery(tempsql).list();

return list;

【编辑推荐】SQL中select语句返回多条记录给变量赋值的处理

对SQL Server中任意select语句分页的存储过程

SQL语句中SELECT语句的执行顺序

为您讲解SQL的SELECT语句

sql server增加及删除约束的方法

---

操作Access数据库的一些常用方法，代码如下Imports SystemImports Class DBPrivate Shared com As Shared reader As Shared adapter As Shared conn As

获取数据库连接

Public Shared ReadOnly Property NewConn() As OleDbConnectionGetDim connectionString As StringconnectionString = (Supermarket)连接2010数据库connectionString = Provider=.12.0;Data Source=F:\连接03-07数据库connectionString = Provider=.4.0;Data Source=F:\JL\应该在这里先判断conn是否为NothingIf conn Is Nothing Thenconn = New (connectionString)End IfIf <> ()End IfReturn connEnd GetEnd Property

执行增删改(无参)

执行的Sql语句 Public Shared Function ExecuteNonQuery(ByVal sql As String) As Integercom = New (sql, NewConn())Return ()End Function

执行增删改(有参)

Public Shared Function ExecuteNonQuery(ByVal sql As String, ByVal para As OleDbParameter()) As Integercom = New (sql, NewConn)(para)Return ()End Function

执行增删改的存储过程

Public Shared Function ExecuteNonQuery(ByVal para As SqlParameter(), ByVal ProcedureName As String) As IntegerDim CMD As = New () = NewConn() = = (para)Return Function

执行查询(返回一个结果集，无参)

Public Shared Function GetScalar(ByVal sql As String) As StringDim> Public Shared Function GetScalar(ByVal sql As String, ByVal para As SqlParameter()) As Integercom = New (sql, NewConn)(para)Return 32(())End Function

执行查询(返回一行数据,无参)

Public Shared Function GetReader(ByVal sql As String) As OleDbDataReadercom = New (sql, NewConn)reader = ()Return readerEnd Function

执行查询(返回一行数据,有参)

Public Shared Function GetReader(ByVal sql As String, ByVal para As SqlParameter()) As OleDbDataReadercom = New (sql, NewConn)(para)reader = ()Return readerEnd Function

执行查询(返回一个数据集,无参)

Public Shared Function GetDataSet(ByVal sql As String) As> Public Shared Function GetDataSet(ByVal sql As String, ByVal para As SqlParameter()) As DataTableDim dataset As DataSetdataset = New DataSet()com = New OleDbCommand(sql, NewConn)(para)adapter = New OleDbDataAdapter(com)(dataset)Return (0)End FunctionEnd Class