Spring中集成Hibernate连接MySQL数据库配置

Spring配置文件applicationContext.xml中加入数据库连接配置<?xml version="1.0" encoding="UTF-8"?><!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" "http://www.springframework.org/dtd/spring-beans.dtd"><beans><bean id="jndiTemplate" class="org.springframework.jndi.JndiTemplate"><property name="environment">   <props>    <prop key="java.naming.factory.initial">weblogic.jndi.WLInitialContextFactory</prop>    <prop key="java.naming.provider.url">t3://127.0.0.1:7001</prop>    <prop key="java.naming.security.principal">weblogic</prop>    <prop key="java.naming.security.credentials">weblogic</prop>   </props></property></bean><!--利用Weblogic配置数据库jndi连接--><bean id="jndiDataSource" class="org.springframework.jndi.JndiObjectFactoryBean"><property name="jndiName">   <value>MySQLDataSource</value></property><property name="jndiTemplate">   <ref local="jndiTemplate" /></property></bean><!--直接配置数据库连接-->< bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource"><property name="driverClassName"><value>com.mysql.jdbc.Driver</value></property><property name="url"><value>jdbc:mysql://localhost:3306/test</value></property><property name="username"><value>root</value></property><property name="password"><value>123</value></property></bean><bean id="sessionFactory" class="org.springframework.orm.hibernate3.LocalSessionFactoryBean"><property name="dataSource">   <ref bean="jndiDataSource" /></property><property name="hibernateProperties">   <props>    <prop key="hibernate.dialect">org.hibernate.dialect.MySQLDialect</prop>    <prop key="hibernate.show_sql">false</prop>    <prop key="hibernate.query.factory_class">org.hibernate.hql.classic.ClassicQueryTranslatorFactory</prop>   </props></property><!-- property name="mappingResources">   <list>    <value>cn/git/common/hbm/UserInfo.hbm.xml</value>   </list></property--><property name="mappingDirectoryLocations">   <list>    <value>classpath:/cn/git/common/hbm</value>   </list></property><!--配置Spring中的Hibernate模板类--></bean><bean id="hibernateTemplate" class="org.springframework.orm.hibernate3.HibernateTemplate"><property name="sessionFactory">   <ref bean="sessionFactory" /></property></bean><bean id="transactionManager" class="org.springframework.orm.hibernate3.HibernateTransactionManager"><property name="sessionFactory">   <ref bean="sessionFactory" /></property></bean><!--在类中直接调用hibernate模板类来访问数据库-->    <bean id="systemLoginDAO" class="cn.git.systemLogin.dao.hibernate.SystemLoginDAO"><property name="hibernateTemplate">   <ref bean="hibernateTemplate" /></property></bean></beans>配置完成后即可在systemLoginDAO类中直接访问数据库了：）package cn.git.systemLogin.dao.hibernate;import java.sql.Connection;import java.sql.PreparedStatement;import java.sql.ResultSet;import org.springframework.orm.hibernate3.support.HibernateDaoSupport;import org.apache.commons.logging.Log;import org.apache.commons.logging.LogFactory;import org.hibernate.classic.Session;import cn.git.systemLogin.dao.ISystemLoginDAO;public class SystemLoginDAO extends HibernateDaoSupport implementsISystemLoginDAO ...{   private Log log=LogFactory.getLog(this.getClass());      public boolean checkUserPassword(String userName,String userPassword)...{   Session session=getHibernateTemplate().getSessionFactory().openSession();Connection conn = session.connection();String query="select * from userInfo where userName=? and userPassword=?";try...{   PreparedStatement pstmt = conn.prepareStatement(query);    pstmt.setString(1,userName);   pstmt.setString(2,userPassword);   ResultSet rs = pstmt.executeQuery();    if(rs.next())...{    return true;   }else...{    return false;   }}catch(Exception e)...{   return false;   }finally...{   session.close();}   }}