-
<column length=“100” name=“bName”/>
-
</property>
-
<property generated=“never” lazy=“false” name=“bcategory” type=“integer”>
-
<column name=“bCategory”/>
-
</property>
-
<property generated=“never” lazy=“false” name=“bdescriptioin” type=“string”>
-
<column length=“250” name=“bDescriptioin”/>
-
</property>
-
<property generated=“never” lazy=“false” name=“baddTime” type=“timestamp”>
-
<column length=“23” name=“bAddTime”/>
-
</property>
-
<property generated=“never” lazy=“false” name=“bmark” type=“string”>
-
<column length=“250” name=“bMark”/>
-
</property>
-
</class>
-
<sql-query callable=“true” name=“getAllBook”>
-
{call getAllBook()}
-
-
<return alias=“book” class=“com.test.models.Book” entity-name=“com.test.models.Book” >
-
<!-- entity-name=""
-
其中,alias属性可以符合标志符名称即可,无特别要求,class和entity-name指向相同,或只能二选一,因它们两都是指定返回对象类型 -->
-
<return-property column=“bID” name=“bid”/>
-
<return-property column=“bName” name=“bname”/>
-
<return-property column=“bCategory” name=“bcategory”/>
-
<return-property column=“bDescriptioin” name=“bdescriptioin”/>
-
<return-property column=“bAddTime” name=“baddTime”/>
-
<return-property column=“bMark” name=“bmark”/>
-
</return>
-
</sql-query>
-
<sql-query callable=“true” name=“getBookByCategoryName”>
-
{call getBookByCategoryName(?,?)}
-
<return alias=“book” class=“com.test.models.Book”>
-
<return-property column=“bID” name=“bid”/>
-
<return-property column=“bName” name=“bname”/>
-
<return-property column=“bCategory” name=“bcategory”/>
-
<return-property column=“bDescriptioin” name=“bdescriptioin”/>
-
<return-property column=“bAddTime” name=“baddTime”/>
-
<return-property column=“bMark” name=“bmark”/>
-
</return>
-
</sql-query>
-
</hibernate-mapping>
四,页面或action中通过Hibernate调用存储过程
[java] view plain copy
-
<%@ page language=“java” import=“java.util.*” pageEncoding=“UTF-8”%>
-
<%@ page language=“java” import=“com.test.hbm.HibernateSessionFactory”%>
-
<%@ page language=“java” import=“org.hibernate.SessionFactory”%>
-
<%@ page language=“java” import=“org.hibernate.Session”%>
-
<%@ page language=“java” import=“com.test.models.Book”%>
-
<%@ page language=“java” import=“com.test.common.Funs”%>
-
<%@ page language=“java” import=“org.hibernate.Query,org.hibernate.SQLQuery”%>
-
<%@page import=“java.sql.ResultSet,java.sql.Connection,java.sql.CallableStatement”%>
-
<%@page import=“org.hibernate.Hibernate”%>
-
<%
-
String path = request.getContextPath();
-
String basePath = request.getScheme()+"😕/"+request.getServerName()+":"+request.getServerPort()+path+"/";
-
%>
257
【一线大厂Java面试题解析+后端开发学习笔记+最新架构讲解视频+实战项目源码讲义】
浏览器打开:qq.cn.hn/FTf 免费领取
. String totalNum = hs.createSQLQuery(“select count(bid) as totalNum from Books”).addScalar(“totalNum”,Hibernate.INTEGER).list().get(0).toString();
-
out.print("
totalNum = " + totalNum ); -
%>