Spring+SpringMvc+Hibernate项目

最新推荐文章于 2020-09-29 21:33:07 发布

recur-chen

最新推荐文章于 2020-09-29 21:33:07 发布

阅读量538

点赞数 1

分类专栏： Spring+SpringMvc+hibernate 文章标签： spring spring mvc

本文链接：https://blog.csdn.net/sinat_36369588/article/details/75669805

版权

Spring+SpringMvc+hibernate 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

Spring+SpringMvc+Hibernate项目

项目结构：

所用的jar包

这里写图片描述

WEB-xml的配置

<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xmlns="http://java.sun.com/xml/ns/javaee"
    xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_3_0.xsd"
    id="WebApp_ID" version="3.0">
    <display-name>SSHFramework</display-name>

    <!-- 配置spring ioc容器 -->
    <context-param>
        <param-name>contextConfigLocation</param-name>
        <param-value>classpath:config/applicationContext.xml</param-value>
    </context-param>
    <!-- 监听器的配置 -->
    <listener>
        <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
    </listener>
    <!-- 配置Servlet -->
    <!-- 配置springmvc 的DispatcherServlet -->
    <servlet>
        <servlet-name>dispatcherServlet</servlet-name>
        <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
        <init-param>
            <param-name>contextConfigLocation</param-name>
            <param-value>classpath:config/springmvc.xml</param-value>
        </init-param>
        <load-on-startup>1</load-on-startup>
    </servlet>

    <!-- Map all requests to the DispatcherServlet for handling -->
    <servlet-mapping>
        <servlet-name>dispatcherServlet</servlet-name>
        <url-pattern>/</url-pattern>
    </servlet-mapping>
    <!-- post乱码过虑器 -->
    <filter>
        <filter-name>CharacterEncodingFilter</filter-name>
        <filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
        <init-param>
            <param-name>encoding</param-name>
            <param-value>UTF-8</param-value>
        </init-param>
    </filter>
    <filter-mapping>
        <filter-name>CharacterEncodingFilter</filter-name>
        <url-pattern>/*</url-pattern>
    </filter-mapping>

    <!-- 配置Session -->
    <filter>
        <filter-name>openSession</filter-name>
        <filter-class>org.springframework.orm.hibernate4.support.OpenSessionInViewFilter</filter-class>
    </filter>
    <filter-mapping>
        <filter-name>openSession</filter-name>
        <url-pattern>/*</url-pattern>
    </filter-mapping>
    <!-- 过滤器 -->
    <!-- <filter>
        <filter-name>LoginFilter</filter-name>
        <filter-class>com.chen.filter.LoginFilter</filter-class>
    </filter>
    <filter-mapping>
        <filter-name>LoginFilter</filter-name>
        <url-pattern>/*</url-pattern>

    </filter-mapping> -->

    <welcome-file-list>
        <welcome-file>index.html</welcome-file>
        <welcome-file>index.htm</welcome-file>
        <welcome-file>index.jsp</welcome-file>
        <welcome-file>default.html</welcome-file>
        <welcome-file>default.htm</welcome-file>
        <welcome-file>default.jsp</welcome-file>
    </welcome-file-list>
</web-app>

applicationContext.xml的配置

<?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:tx="http://www.springframework.org/schema/tx"
    xmlns:aop="http://www.springframework.org/schema/aop"
    xsi:schemaLocation="http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-3.2.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.2.xsd
        http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.2.xsd">


    <!-- 配置自动扫描的包 -->
    <!--<context:component-scan base-package="com.chen">-->
    <!--</context:component-scan>-->

    <!--自动扫描含有@Service将其注入为bean -->
    <context:component-scan base-package="com.chen">
    </context:component-scan>


    <!-- 加载外在化配置应用参数 -->
    <context:property-placeholder location="classpath:config/db.properties"/>
    <!-- 配置数据库连接 -->
    <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource" >
        <property name="user" value="${jdbc.user}"></property>
        <property name="password" value="${jdbc.password}"></property>
        <property name="driverClass" value="${jdbc.driverClass}"></property>
        <property name="jdbcUrl" value="${jdbc.jdbcUrl}"></property>   
    </bean>
     <!-- 配置hibernate相关信息  -->
    <bean id="sessionFactory" class="org.springframework.orm.hibernate4.LocalSessionFactoryBean" >
        <property name="dataSource" ref="dataSource"></property>
        <!-- 实现动态表名映射 -->
        <property name="namingStrategy"> 
            <bean class="org.hibernate.cfg.ImprovedNamingStrategy"></bean>
        </property>
        <!-- 写入实体类 -->
        <property name="packagesToScan" value="com.chen.entities"></property>
        <!-- 配置hibernate基本属性 -->
        <property name="hibernateProperties">
            <props>
                <prop key="hibernate.dialect">org.hibernate.dialect.MySQL5InnoDBDialect </prop>
                <prop key="hibernate.show_sql">true</prop>
                <prop key="hibernate.format_sql">true</prop>
                <prop key="hibernate.hbm2ddl.auto">update</prop>
                <prop key="hibernate.temp.use_jdbc_metadata_defaults">false</prop>
            </props>
        </property>
        <property name="mappingResources" >
            <list>
                <value>com/chen/entities/User.hbm.xml</value>
            </list>
        </property>
    </bean>
    <!-- 配置Spring的声明式事务 -->
    <!-- 1.配置事务管理器 -->
    <bean id="transactionManager" class="org.springframework.orm.hibernate4.HibernateTransactionManager">
        <property name="sessionFactory" ref="sessionFactory"></property>
    </bean>
    <!-- 2.配置事务属性，需要事务管理器 -->
    <tx:advice id="txAdvice" transaction-manager="transactionManager">
        <tx:attributes>
            <tx:method name="get*" read-only="true"/>
            <tx:method name="newTx*" propagation="REQUIRES_NEW"/>
            <tx:method name="save*" propagation="REQUIRED"/>  
            <tx:method name="del*" propagation="REQUIRED" /> 
            <tx:method name="update*" propagation="REQUIRED" /> 
            <tx:method name="add*" propagation="REQUIRED" /> 
            <tx:method name="find*" propagation="REQUIRED" /> 
            <tx:method name="apply*" propagation="REQUIRED" />  
            </tx:attributes>
    </tx:advice>
    <!-- 3.配置事务切点，并把事务属性和切点关联起来 -->
    <aop:config>
        <aop:pointcut expression="execution(* com.chen.service.impl.*.*(..))" id="txPointcut"/>
        <aop:advisor advice-ref="txAdvice" pointcut-ref="txPointcut"/>
    </aop:config>

</beans>

springmvc.xml的配置

<?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"
    xsi:schemaLocation="http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc-4.2.xsd
        http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd
        http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.2.xsd
        http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.2.xsd">

    <!-- 配置自动扫描包 -->
    <!--<context:component-scan base-package="com.chen">-->
    <!--</context:component-scan>-->


    <!-- 解决了@Controller注解的使用前提配置 -->
    <mvc:annotation-driven />  
    <context:component-scan base-package="com.chen">  
    <context:exclude-filter type="annotation" expression="org.springframework.stereotype.Service"/>   
    </context:component-scan>
    <!-- 静态资源默认不可访问，需要下面配置 -->  
     <mvc:resources location="/img/" mapping="/img/**"/> 
     <mvc:resources location="/js/" mapping="/js/**"/>

    <!-- 配置视图解析器 ，即在模型视图名称添加前后缀-->
    <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
        <!-- 配置jsp路径的前缀 -->
        <property name="prefix" value="/"></property>
        <!-- 配置jsp路径的后缀 -->
        <property name="suffix" value=".jsp"></property>
    </bean>
    <!-- 上传文件的分解器，主要的作用是配置文件上传的一些属性 -->
    <bean id="multipartResolver" class="org.springframework.web.multipart.commons.CommonsMultipartResolver">  
          <property name="defaultEncoding" value="utf-8" />  
          <!-- 文件上传 -->  
          <property name="maxUploadSize" value="10485760000" />  
          <!-- 配置缓存 -->
          <property name="maxInMemorySize" value="40960" />  
    </bean>  
    <!-- 可以正常访问静态文件，不要找不到静态文件报404 -->
    <mvc:default-servlet-handler/>


</beans>

log4j.xml的配置

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE log4j:configuration SYSTEM "log4j.dtd">
<log4j:configuration xmlns:log4j="http://jakarta.apache.org/log4j/" debug="false">
    <appender name="DEBUG" class="org.apache.log4j.RollingFileAppender">
        <param name="File" value="e:\\logs\\sys-debug_daily.log"/>
        <param name="Append" value="true"/>
        <param name="MaxFileSize" value="500KB"/>
        <param name="MaxBackupIndex" value="1"/>
        <layout class="org.apache.log4j.PatternLayout">
            <param name="ConversionPattern" value="%c %d{ISO8601}-- %p -- %m%n"/>
        </layout>
        <filter class="org.apache.log4j.varia.LevelRangeFilter">
            <param name="LevelMin" value="DEBUG" />
            <param name="LevelMax" value="DEBUG" />
        </filter>
    </appender>
    <appender name="INFO" class="org.apache.log4j.RollingFileAppender">
        <param name="File" value="e:\\logs\\sys-info_daily.log"/>
        <param name="Append" value="true"/>
        <param name="MaxFileSize" value="500KB"/>
        <param name="MaxBackupIndex" value="1"/>
        <layout class="org.apache.log4j.PatternLayout">
            <param name="ConversionPattern" value="%c %d{ISO8601}-- %p -- %m%n"/>
        </layout>
        <filter class="org.apache.log4j.varia.LevelRangeFilter">
            <param name="LevelMin" value="INFO" />
            <param name="LevelMax" value="INFO" />
        </filter>
    </appender>
    <appender name="WARN" class="org.apache.log4j.RollingFileAppender">
        <param name="File" value="e:\\logs\\sys-warn_daily.log"/>
        <param name="Append" value="true"/>
        <param name="MaxFileSize" value="500KB"/>
        <param name="MaxBackupIndex" value="1"/>
        <layout class="org.apache.log4j.PatternLayout">
            <param name="ConversionPattern" value="%c %d{ISO8601}-- %p -- %m%n"/>
        </layout>
        <filter class="org.apache.log4j.varia.LevelRangeFilter">
            <param name="LevelMin" value="WARN" />
            <param name="LevelMax" value="WARN" />
        </filter>
    </appender>

    <appender name="ERROR" class="org.apache.log4j.RollingFileAppender">
        <param name="File" value="e:\\logs\\sys-error_daily.log"/>
        <param name="Append" value="true"/>
        <param name="MaxFileSize" value="500KB"/>
        <param name="MaxBackupIndex" value="1"/>
        <layout class="org.apache.log4j.PatternLayout">
            <param name="ConversionPattern" value="%c %d{ISO8601}-- %p -- %m%n"/>
        </layout>
        <filter class="org.apache.log4j.varia.LevelRangeFilter">
            <param name="LevelMin" value="ERROR" />
            <param name="LevelMax" value="ERROR" />
        </filter>
    </appender>
    <appender name="CONSOLE" class="org.apache.log4j.ConsoleAppender">  
       <layout class="org.apache.log4j.PatternLayout">  
            <param name="ConversionPattern"  
                value="%d{yyyy-MM-dd HH:mm:ss} %-5p: %m%n" />  
           <!-- "%-5p: [%t] [%c{3}.%M(%L)] | %m%n" -->  
        </layout>  
        <filter class="org.apache.log4j.varia.LevelRangeFilter">
            <param name="LevelMin" value="INFO" />
            <param name="LevelMax" value="ERROR" />
        </filter>
    </appender>  

    <root>
        <!--
        <priority value="debug"/>
        <appender-ref ref="WARN"/>
        <appender-ref ref="DEBUG"/>
        <appender-ref ref="STDOUT"/>
        -->   
        <appender-ref ref="INFO"/>
        <appender-ref ref="ERROR"/>

        <appender-ref ref="CONSOLE"/>

    </root>
</log4j:configuration>

db.properties

jdbc.user=root
jdbc.password=5201045
jdbc.driverClass=com.mysql.jdbc.Driver
jdbc.jdbcUrl=jdbc\:mysql\:///ssh

Java代码

实体类（com.chen.entities）

User.java

package com.chen.entities;

import java.sql.Blob;

public class User {

    private Integer id;
    private String name;
    private String password;
    private String headImg;
    private Blob image;

    public String getHeadImg() {
        return headImg;
    }

    public void setHeadImg(String headImg) {
        this.headImg = headImg;
    }

    public Integer getId() {
        return id;
    }

    public void setId(Integer id) {
        this.id = id;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public String getPassword() {
        return password;
    }

    public void setPassword(String password) {
        this.password = password;
    }

    public Blob getImage() {
        return image;
    }

    public void setImage(Blob image) {
        this.image = image;
    }
}

User.hbm.xml

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<!-- Generated 2016-7-12 10:59:16 by Hibernate Tools 3.5.0.Final -->
<hibernate-mapping>
    <class name="com.chen.entities.User" table="USER">
        <id name="id" type="java.lang.Integer">
            <column name="ID" />
            <generator class="native" />
        </id>
        <property name="name" type="java.lang.String">
            <column name="NAME" />
        </property>
        <property name="password" type="java.lang.String">
            <column name="PASSWORD" />
        </property>
        <property name="headImg" type="java.lang.String">
            <column name="HEADIMG" />
        </property>
         <property name="image" type="blob">
            <column name="IMAGE" />
        </property>
    </class>
</hibernate-mapping>

DAO层以及其实现类（com.chen.dao/com.chen.dao.impl）
UserDao.java

package com.chen.dao;

import com.chen.entities.User;

public interface UserDao {
    //注册用户
    public void addUser(User user);
    //查询用户(根据用户名查询用户)
    public User selectUser(String name);    
}

UserDaoImpl.java

package com.chen.dao.impl;

import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Repository;


import com.chen.dao.UserDao;
import com.chen.entities.User;

@Repository("userDao")
public class UserDaoImpl implements UserDao {

    @Autowired
    private SessionFactory sessionFactory;

    public SessionFactory getSessionFactory() {
        return sessionFactory;
    }
    public Session getSession(){
        return sessionFactory.getCurrentSession();
    }
    public void addUser(User user) {

        sessionFactory.getCurrentSession().save(user);

    }

    @Override
    public User selectUser(String name) {
        String hql = "SELECT u FROM User u WHERE u.name = ?";
        User user = (User) sessionFactory.getCurrentSession().createQuery(hql).setString(0, name).uniqueResult();
        return user;
    }

}

Service层以及其实现类（com.chen.service/com.chen.service.impl）
UserService.java

package com.chen.service;

import com.chen.entities.User;

public interface UserService {

    public void addUser(User user);

    public User selectUser(String name);
}

UserServiceImpl.java

package com.chen.service.impl;

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

import com.chen.dao.UserDao;
import com.chen.entities.User;
import com.chen.service.UserService;

@Service("userService")
public class UserServiceImpl implements UserService {

    @Autowired
    private UserDao userDao;

    public void setUserDao(UserDao userDao) {
        this.userDao = userDao;
    }

    @Override
    public void addUser(User user) {
        // TODO Auto-generated method stub
        userDao.addUser(user);
    }

    @Override
    public User selectUser(String name) {

        return userDao.selectUser(name);
    }

}

Controller（com.chen.controller）
UserController.java

package com.chen.controller;

import java.io.File;
import java.io.FileInputStream;
import java.io.InputStream;
import java.sql.Blob;
import java.util.List;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;

import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.hibernate.Hibernate;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.ui.ModelMap;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.multipart.MultipartFile;
import org.springframework.web.servlet.ModelAndView;
import org.springframework.web.servlet.mvc.support.RedirectAttributes;

import com.chen.dao.impl.Page;
import com.chen.dao.impl.UserDaoImpl;
import com.chen.entities.StudentMessage;
import com.chen.entities.User;
import com.chen.service.StudentMessageService;
import com.chen.service.UserService;

@Controller
public class UserController {

    @Autowired
    private UserService userService;
    @Autowired
    private UserDaoImpl userDaoImpl;
    @Autowired
    public StudentMessageService studentMessageService;

    protected final transient Log log = LogFactory.getLog(UserController.class);
    @RequestMapping(value = "/register")
    public String register(HttpServletRequest request, MultipartFile items_pic)
            throws Exception {
        String username = request.getParameter("username");
        String password = request.getParameter("password");
        String headImg = "";
        String pic_path = "";
        // 原始名称
        String originalFilename = items_pic.getOriginalFilename();
        // 上传图片
        if (items_pic != null && originalFilename != null
                && originalFilename.length() > 0) {
            // 存储图片的物理路径
            pic_path = "F:\\myeclipse-workspace\\SSHFramework\\WebRoot\\img\\";
            // 新的图片名称
            headImg = username + ".jpg";
            // 新图片
            File newFile = new File(pic_path + headImg);
            // 将内存中的数据写入磁盘
            items_pic.transferTo(newFile);

        }
        User user = new User();

        InputStream in = null;
        in = new FileInputStream(pic_path + headImg);
        // byte[] b = new byte[in.available()];
        Blob image = Hibernate.getLobCreator(userDaoImpl.getSession())
                .createBlob(in, in.available());
        // in.read(b);

        user.setImage(image);
        //in.close();

        user.setName(username);
        user.setPassword(password);
        user.setHeadImg(headImg);
        userService.addUser(user);
        return "success";

    }

    @RequestMapping(value = "/login", method = RequestMethod.POST)
    public String login(RedirectAttributes model, String username,
            String password, HttpServletRequest request) {
        User u = userService.selectUser(username);
        if (password.equals(u.getPassword())) {

            model.addFlashAttribute("msg", "登录成功");
            HttpSession session = request.getSession();
            session.setAttribute("currentUser", u);
            return "redirect:/index";
        } else {
            model.addFlashAttribute("msg", "登录失败");
            return "redirect:/toLogin";
        }

    }

    @RequestMapping(value = "/toLogin")
    public String toLogin(Model model) {

        return "login";
    }

    @RequestMapping(value = "/index")
    public String index(Model model) {

        return "index";
    }


    @RequestMapping(value = "/message")
    //找到所有的记录并实现了分页
    public String findAll(HttpServletRequest request,HttpServletResponse response,ModelMap modelMap) {   
            String pageNo = request.getParameter("pageNo");
            if (pageNo == null) {
                pageNo = "1";
            }
            Page page = studentMessageService.queryForPage(Integer.valueOf(pageNo), 5);
            request.setAttribute("page", page);
            List<StudentMessage> list = page.getList();
            modelMap.put("list", list);
        return "message";
    }

    //添加留言信息
    @RequestMapping(value = "/add")
    public String add(HttpServletRequest request, ModelMap modelMap) throws Exception{
        return "student_add";
    }
    //保存留言信息
    @RequestMapping(value = "/save")
    public String save(HttpServletRequest request, ModelMap modelMap) throws RuntimeException{
        StudentMessage st = new StudentMessage();
        String name = request.getParameter("name");
        String title=request.getParameter("title"); 
        String phone=request.getParameter("phone");
        String content=request.getParameter("content");
        st.setName(name);
        st.setPhone(phone);
        st.setTitle(title);
        st.setContent(content);
        try{
            studentMessageService.saveService(st);
            modelMap.put("addstate", "添加成功");
        }
        catch(Exception e){
            e.printStackTrace();
            log.error(e.getMessage());
            modelMap.put("addstate", "添加失败");
            //throw new RuntimeException();
            //TransactionAspectSupport.currentTransactionStatus().setRollbackOnly();//捕获异常后进行回滚
        }       
       /* studentMessageService.saveService(st);
        modelMap.put("addstate", "添加成功");*/
         return "redirect:/message";
    }
    //删除留言信息
    @RequestMapping(value = "/del")
    public String del(@RequestParam("id") String id) throws Exception{
        StudentMessage st=new StudentMessage();
        st.setId(Integer.valueOf(id));
        studentMessageService.Servicedelete(st);
        return "redirect:/message";
    }

    //修改留言信息获得原来的留言信息并跳转页面
    @RequestMapping(value = "/edit")
    public ModelAndView edit(@RequestParam("id") String id,HttpServletRequest request) throws Exception{
             ModelAndView modelAndView =  new ModelAndView();
             int idd=Integer.valueOf(id);
             StudentMessage st=studentMessageService.QueryById(idd);
             String name=st.getName();
             String phone=st.getPhone();
             String content=st.getContent();
             String title=st.getTitle();
             request.setAttribute("id", id);
             request.setAttribute("name", name);
             request.setAttribute("phone", phone);
             request.setAttribute("content", content);
             request.setAttribute("title", title);
             modelAndView.setViewName("/edit");
             return modelAndView;
    }
    //修改留言信息确认提交
    @RequestMapping(value = "/editsubmit")
    public String editsubmit(HttpServletRequest request) throws Exception{
         String name=request.getParameter("name");
         String phone=request.getParameter("phone");
         String title=request.getParameter("title");
         String content=request.getParameter("content");
         String id=request.getParameter("id");
         StudentMessage st=new StudentMessage();
         st.setId(Integer.valueOf(id));
         st.setName(name);
         st.setPhone(phone);
         st.setTitle(title);
         st.setContent(content);
         studentMessageService.Serviceupdate(st);
         return "redirect:/message";
    }
}