<?xml version="1.0" encoding="utf-8"?> <!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd"> <hibernate-mapping> <class name="com.cv.hibernate.nativesql.model.EmployeeBean" table="EmployeeBean_Native_SQL"> <id name="id" type="long"> <column name="EID" precision="10" scale="0" /> <!-- <generator class="assigned" /> --> </id> <property name="firstName" type="string"> <column name="FIRSTNAME" length="29" /> </property> <property name="lastName" type="string"> <column name="LASTNAME" length="29" /> </property> <property name="email" type="string"> <column name="EMAIL" length="39" /> </property> </class>
<!-- <sql-query name="get_emp_pro_mysql"> <return alias="emp" class="com.cv.hibernate.nativesql.model.EmployeeBean" /> <![CDATA[CALL get_emp_pro_mysql(:id)]]> </sql-query> --> <sql-query name="get_emp_pro_mysql"> <return alias="emp" class="com.cv.hibernate.nativesql.model.EmployeeBean" /> <![CDATA[CALL get_emp_pro_mysql(?)]]> </sql-query>
<sql-query name="get_emp_count_pro_mysql"> <return alias="emp" class="com.cv.hibernate.nativesql.model.EmployeeBean" /> <![CDATA[CALL get_emp_count_pro_mysql(?,?)]]> </sql-query> <sql-query name="get_emp_MyBean_pro_mysql"> <return-scalar column="result" type="long" /> <![CDATA[CALL get_emp_MyBean_pro_mysql(?,?)]]> </sql-query>
<sql-query name="get_emp_pro_mysql_by_fname"> <return alias="emp" class="com.cv.hibernate.nativesql.model.EmployeeBean" /> <![CDATA[CALL get_emp_pro_mysql_by_fname(?)]]> </sql-query>
<sql-query name="get_emp_fname_lname_pro_mysql"> <return-scalar column="firstname" type="string" /> <return-scalar column="lastname" type="string" /> <![CDATA[CALL get_emp_fname_lname_pro_mysql(?)]]> </sql-query>
<!-- <sql-query name="get_emp_MyBean_pro_mysql"> <return alias="myBean" class="com.cv.hibernate.nativesql.model.MyBean"> </return> <![CDATA[CALL get_emp_MyBean_pro_mysql(?,?)]]> </sql-query> --> <!-- <sql-query name="get_emp_count_int_pro_mysql"> <return-scalar column="result" type="int" /> <![CDATA[CALL get_emp_count_int_pro_mysql(?,?,?)]]> </sql-query> -->
</hibernate-mapping>
|
No comments:
Post a Comment