SpringMVC整合Hibernate实现增删改查之按条件查询

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-configuration PUBLIC
        "-//Hibernate/Hibernate Configuration DTD 3.0//EN"
        "http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
    <session-factory>
        <property name="hibernate.dialect">org.hibernate.dialect.MySQL5Dialect</property>
        <property name="hibernate.show_sql">true</property>
        <property name="hibernate.format_sql">true</property>
        <property name="hibernate.hbm2ddl.auto">update</property>
        <mapping class="com.tideway.springmvc.entity.User"/>
    </session-factory>
</hibernate-configuration>

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:context="http://www.springframework.org/schema/context"
    xmlns:mvc="http://www.springframework.org/schema/mvc" xmlns:tx="http://www.springframework.org/schema/tx"
    xmlns:aop="http://www.springframework.org/schema/aop"
    xsi:schemaLocation="http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc-4.0.xsd
        http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.0.xsd
        http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-4.0.xsd
        http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd
        http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.0.xsd">

    <!-- 配置数据源 -->
    <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
        <property name="driverClass" value="com.mysql.jdbc.Driver" />
        <property name="jdbcUrl" value="jdbc:mysql://localhost:3306/attendance" />
        <property name="user" value="root" />
        <property name="password" value="密码" />
    </bean>

    <!-- 配置SessionFactory 通过spring提供的LocalSessionFactoryBean进行配置 -->
    <bean id="sessionFactory"
        class="org.springframework.orm.hibernate4.LocalSessionFactoryBean">
        <!-- 配置数据源 -->
        <property name="dataSource" ref="dataSource" />
        <property name="configLocation" value="classpath:hibernate.cfg.xml"></property>
    </bean>
    <!-- 配置一个事务管理器 -->
    <bean id="transactionManager"
        class="org.springframework.orm.hibernate4.HibernateTransactionManager">
        <property name="sessionFactory" ref="sessionFactory" />
    </bean>
    <!-- 添加一个通知取别名，然后决定管理哪一个事务管理器,***只是查询的话用不到事物 -->
    <tx:advice id="txAdvice" transaction-manager="transactionManager">
        <tx:attributes>
            <tx:method name="get*" read-only="true" />
            <tx:method name="*" />
        </tx:attributes>
    </tx:advice>
    <aop:config>
        <aop:pointcut expression="execution(* com.tideway.springmvc.service.*.*(..))"
            id="txPointcut" />
        <aop:advisor advice-ref="txAdvice" pointcut-ref="txPointcut" />
    </aop:config>
    

</beans>

package com.tideway.springmvc.daoimpl;

import java.util.List;
import org.hibernate.Query;
import org.hibernate.SessionFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Repository;
import com.tideway.springmvc.dao.UserDao;
import com.tideway.springmvc.entity.User;

//@Repository用于标注数据访问组件，即DAO组件
@Repository
public class UserDaoImpl implements UserDao {
    @Autowired
    private SessionFactory sessionFactory;

    /**
     * 查询dao层接口实现类
     * 进行动态拼接查询，拼接hql语句进行多条件查询
     */
    public List<User> getUser(String EnID, String dateafter, String datebefore) {
        String hql = "from User where 1=1";
        if(EnID!=null&&!("").equals(EnID)){
            hql=hql+" and EnID='"+EnID+"'";
        }
        if(dateafter!=null&&!("").equals(dateafter)){
            hql=hql+" and datetime>='"+dateafter+"'";
        }
        if(datebefore!=null&&!("").equals(datebefore)){
            hql=hql+" and datetime<='"+datebefore+"'";
        }
        Query query = sessionFactory.getCurrentSession().createQuery(hql);
        List<User> list=query.list();
        return list;
    }

}

package com.tideway.springmvc.service;

import java.util.List;

import com.tideway.springmvc.entity.User;

public interface UserService {
    
    /**
     * 查询的Service层接口
     * @param EnID 工号
     * @param dateafter 起止日期
     * @param datebefore 截至日期
     * @return
     */
    public List<User> getUser(String EnID,String dateafter,String datebefore);
}

package com.tideway.springmvc.serviceimpl;

import java.util.List;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import com.tideway.springmvc.dao.UserDao;
import com.tideway.springmvc.entity.User;
import com.tideway.springmvc.service.UserService;

@Service
public class UserServiceImpl implements UserService {

    @Autowired
    private UserDao userDao;
    
    /**
     * 查询Service层接口实现类
     */
    public List<User> getUser(String EnID,String dateafter, String datebefore){
        return userDao.getUser(EnID, dateafter, datebefore);
    }
}

package com.tideway.springmvc.controller;

import java.util.ArrayList;
import java.util.List;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;

import com.tideway.springmvc.entity.User;
import com.tideway.springmvc.service.UserService;

@Controller
public class UserController {
    
    @Autowired
    private UserService userService;
    /**
     * 控制器
     * @param EnID 工号
     * @param dateafter 起止日期
     * @param datebefore 截至日期
     * @param model 返回的数据
     * @return
     */
    @RequestMapping(value="/user/getuser.do",method=RequestMethod.GET)
    public String getUser(String EnID,String dateafter, String datebefore,Model model){
        try {
            List<User> list=new ArrayList<User>();
            list=userService.getUser(EnID, dateafter, datebefore);
            model.addAttribute("lists", list);
//            System.out.println("list.size="+list.size());
        } catch (Exception e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
        return "list";
    }

}

<body>
    <form action="/SpringMVC04/user/getuser.do">
        工号：<input type="text" name="EnID" /> 
        起止日期：<input type="date"name="dateafter" />
        截止日期：<input type="date"name="datebefore" />
        <input type="submit" value="查询" />
    </form>
</body>

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
    
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
<%@ taglib uri="http://java.sun.com/jsp/jstl/functions" prefix="fn"%>

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
</head>
<body>

    <table border="1" style="width: 50%">
        <tr>
            <th>ID</th>
            <th>工号</th>
            <th>名字</th>
            <th>签到时间</th>
            <th>操作</th>
        </tr>
        <c:forEach var="item" items="${lists}">
            <tr>
                <td>${item.id}</td>
                <td>${item.enID}</td>
                <td>${item.name}</td>
                <td>${item.datetime}</td>
                <td><a href="">编辑</a></td>
            </tr>
        </c:forEach>
    </table>
</body>
</html>