struts与spring整合时使用与不使用hibernate时的applicationContext.xml文件配置问题

最新推荐文章于 2018-12-09 14:52:00 发布

yjz764297625

最新推荐文章于 2018-12-09 14:52:00 发布

阅读量143

点赞数

CC 4.0 BY-SA版权

分类专栏： hibernate 文章标签： java 运维数据库

本文链接：https://blog.youkuaiyun.com/yjz764297625/article/details/84282803

hibernate 专栏收录该内容

6 篇文章

订阅专栏

本文对比了在不使用hibernate时通过DAO直接与dataSource打交道的方法与使用hibernate通过sessionFactory与dataSource交互的方法。详细阐述了两种方式下的UserDAO实现代码，并分析了各自的优缺点。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

当不使用hibernate操作数据库时，DAO直接和dataSource打交道，配置如下：

	<bean id="userDAO" class="com.demo.spring.dao.UserDAO">
		<property name="dataSource">
			<ref local="dataSource" />
		</property>
	</bean>

对应的UserDAO代码如下：

package com.demo.spring.dao;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import javax.sql.DataSource;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.core.RowMapper;

public class UserDAO {
	private DataSource dataSource;

	public DataSource getDataSource() {
		return dataSource;
	}

	public void setDataSource(DataSource dataSource) {
		this.dataSource = dataSource;
	}

	@SuppressWarnings("unchecked")
	public boolean isValid(String username, String password) {
		List userList = new ArrayList();
		JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);
		userList = jdbcTemplate.query("SELECT * FROM user WHERE username='"
				+ username + "' and password='" + password + "'",
				new RowMapper() {
					public Object mapRow(ResultSet rs, int rowNum)
							throws SQLException {
						User user = new User();
						user.setId(rs.getString("ID"));
						user.setUsername(rs.getString("username"));
						user.setPassword(rs.getString("password"));
						user.setEmail(rs.getString("email"));
						return user;
					}
				});
		if (userList.size() > 0) {
			return true;
		} else {
			return false;
		}
	}

	public boolean isExist(String username) {
		JdbcTemplate jdbcTemplate = new JdbcTemplate(dataSource);
		int count = jdbcTemplate.queryForInt("SELECT count(*) FROM user WHERE username='" + username
				+ "'");		
		if (count > 0) {
			return true;
		} else {
			return false;
		}
	}

	public void insertUser(User user) {
		String username = user.getUsername();
		String password = user.getPassword();
		String email = user.getEmail();
		JdbcTemplate jt = new JdbcTemplate(getDataSource());
		jt.update("insert into user(username,password,email) values ('"
				+ username + "','" + password + "','" + email + "');");
	}
}

当使用hibernate进行数据库操作时，DAO是和sessionFactory打交道，而sessionFactory是和dataSource进行联系的，配置代码如下：

	<!-- 配置hibernate -->
	<bean id="sessionFactory"
		class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
		<property name="dataSource">
			<ref local="dataSource" />
		</property>
		<property name="mappingResources">
			<list>
				<value>com/ssh/beans/User.hbm.xml</value>
			</list>
		</property>
		<property name="hibernateProperties">
			<props>
				<prop key="hibernate.dialect">
					org.hibernate.dialect.MySQLDialect
		    </prop>
				<prop key="hibernate.show_sql">true</prop>
			</props>
		</property>
	</bean>

	<bean id="userDAO" class="com.ssh.dao.impl.UserDAO">
		<property name="sessionFactory">
			<ref local="sessionFactory" />
		</property>
	</bean>

这是的UserDAO的代码如下：

package com.ssh.dao.impl;

import java.util.List;

import org.hibernate.HibernateException;
import org.hibernate.Session;
import org.hibernate.criterion.Restrictions;
import org.springframework.orm.hibernate3.HibernateCallback;
import org.springframework.orm.hibernate3.support.HibernateDaoSupport;

import com.ssh.beans.User;
import com.ssh.dao.interfaces.IUserDAO;


@SuppressWarnings("unchecked")
public class UserDAO extends HibernateDaoSupport implements IUserDAO{

	public void deleteUser(String userid) {
		Object p = getHibernateTemplate().load(User.class, new Integer(userid));
		getHibernateTemplate().delete(p);
	}

	public User getUser(String userid) {
		return (User) getHibernateTemplate().get(User.class,
				new Integer(userid));
	}


	public List getUsers() {
		return getHibernateTemplate().find("from User");
	}

	public void insertUser(User user) {
		getHibernateTemplate().saveOrUpdate(user);
	}

	public boolean isExist(final String username) {
		List list = (List) getHibernateTemplate().execute(new HibernateCallback() {
			public Object doInHibernate(Session session)
			throws HibernateException {
				List result = session.createCriteria(User.class).add(
						Restrictions.eq("username", username)).list();
				return result;
			}
		});
		if (list.size() > 0) {
			return true;
		} else {
			return false;
		}
	}

	public boolean isValid(final  String username, final String password) {
		List list = (List) getHibernateTemplate().execute(new HibernateCallback() {
			public Object doInHibernate(Session session)
			throws HibernateException {
				List result = session.createCriteria(User.class).add(
						Restrictions.eq("username", username)).add(
								Restrictions.eq("password", password)).list();
				return result;
			}
		});
		if (list.size() > 0) {
			return true;
		} else {
			return false;
		}
	}
}