Java Web整合开发(20) -- Hibernate入门

Spring与Hibernate整合

ApplicationContext.xml

8      <!-- dataSource injection-->
9      <bean id="DataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource" >
10         <property name="driverClassName" value="org.apache.derby.jdbc.ClientDriver"/>
11         <property name="url" value="jdbc:derby://localhost:1527/SoccerLeague"/>
12         <property name="username" value="javaee"/>
13         <property name="password" value="javaee"/>
14     </bean>
15 
16     <!-- sessionFactory injection-->
17     <bean id="SessionFactory" class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
18         <property name="dataSource" ref="DataSource"/>
19         <property name="hibernateProperties">
20             <props>
21                 <prop key="hibernate.dialect">org.hibernate.dialect.DerbyDialect</prop>
22                 <prop key="hibernate.show_sql">true</prop>
23                 <prop key="hibernate.format_sql">true</prop>
24             </props>
25         </property>
26         <property name="mappingResources">
27             <list>
28                 <value>domain/League.hbm.xml</value>
29                 <value>domain/AdminUser.hbm.xml</value>
30             </list>
31         </property>
32     </bean>

Spring与iBATIS整合

UserSqlMapping.xml

1  <?xml version='1.0' encoding='UTF-8'?>
2  <!DOCTYPE sqlMap PUBLIC "-//iBATIS.com//DTD SQL Map 2.0//EN" 
3              "http://www.iBATIS.com/dtd/sql-map-2.dtd">
4  <sqlMap namespace="user_space">
5      <typeAlias alias="user" type="com.bjoracle.user.domain.User" />
6      <select id="findUserByusernameAndPassword" 
7          resultClass="user" parameterClass="user">
8          <![CDATA[
9              select id, username, password from user 
10             where username = #username# and password = #password#
11         ]]>    
12     </select>
13     <insert id="insertUser" parameterClass="user">
14         insert into user(username, password) 
15             values(#username#, #password#) 
16     </insert>
17     <delete id="deleteUserByUsername" parameterClass="user">
18         delete from user where username = #username#
19     </delete>
20     <update id="updatePasswordByUsername" parameterClass="user">
21         update user set password = #password# where username = #username#
22     </update>
23 </sqlMap>