hibernate连接mysql配置_Spring中集成Hibernate连接MySQL数据库配置

Spring配置文件applicationContext.xml中加入数据库连接配置

weblogic.jndi.WLInitialContextFactory

t3://127.0.0.1:7001

weblogic

weblogic

MySQLDataSource

< bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">

com.mysql.jdbc.Driver

jdbc:mysql://localhost:3306/test

root

123

org.hibernate.dialect.MySQLDialect

false

org.hibernate.hql.classic.ClassicQueryTranslatorFactory

classpath:/cn/git/common/hbm

配置完成后即可在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();

}

}

}