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 implements
ISystemLoginDAO ...{
   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();
}
   
}
}