javaweb各种框架组合案例(三):maven+spring+springMVC+hibernate

2019-08-08 00:00:00 框架 组合 案例

1.hibernate译为“越冬”,指的是给java程序员带来春天,因为java程序员无需再关心各种sql了;

2.hibernate通过java类生成数据库表,通过操作对象来映射成SQL;

3.hibernate是真正意义上的ORM框架,因为他实现了对象(Object)—->关系(Relation)的映射(Mapping);

4.maven项目整体包结构(报错是eclipse发神经,不用管)

《javaweb各种框架组合案例(三):maven+spring+springMVC+hibernate》

因为hibernate可以根据类生成表,所以只需创建数据库即可;

create database ssh;

 

该案例实现了一个用户拥有多部手机的关系

 

5.各种配置文件

(1)pom.xml

《javaweb各种框架组合案例(三):maven+spring+springMVC+hibernate》
《javaweb各种框架组合案例(三):maven+spring+springMVC+hibernate》

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
  <modelVersion>4.0.0</modelVersion>
  <groupId>com.xiaog</groupId>
  <artifactId>testssh</artifactId>
  <version>0.0.1-SNAPSHOT</version>
  <packaging>war</packaging>
  
  <dependencies>
      <!-- spring+springmvc顶级依赖包,包含spring-webmvc、spring-aop、spring-beans、
      spring-context、spring-core、spring-jcl、spring-expression、spring-web -->
      <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-webmvc</artifactId>
      <version>5.1.5.RELEASE</version>
    </dependency>
    
    <!-- spring-aop所依赖的静态代理 ,
        使用aop方式管理事务,在service方法执行前开启事务,
        方法执行后提交事务,方法执行失败回滚事务-->
    <dependency>
        <groupId>org.aspectj</groupId>
        <artifactId>aspectjrt</artifactId>
        <version>1.8.0</version>
    </dependency>
    <dependency>
        <groupId>org.aspectj</groupId>
        <artifactId>aspectjweaver</artifactId>
        <version>1.8.0</version>
    </dependency>
    
    <!-- 使用jdbcTemplate中的事务实现 -->
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-jdbc</artifactId>
      <version>5.1.5.RELEASE</version>
    </dependency>
    
    <!-- 数据库方面 -->
    <dependency>
        <groupId>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
        <version>5.1.47</version>
    </dependency>
    <dependency>
        <groupId>com.alibaba</groupId>
        <artifactId>druid</artifactId>
        <version>1.1.10</version>
    </dependency>
    
    <!-- orm框架 -->
    <dependency>
        <groupId>org.hibernate</groupId>
        <artifactId>hibernate-core</artifactId>
        <version>4.2.2.Final</version>
    </dependency>

    <!-- spring对于orm框架的支持 -->
    <dependency>
        <groupId>org.springframework</groupId>
        <artifactId>spring-orm</artifactId>
        <version>4.2.4.RELEASE</version>
    </dependency>

    
    <!-- Logback -->
    <dependency>
        <groupId>ch.qos.logback</groupId>
        <artifactId>logback-classic</artifactId>
        <version>1.1.3</version>
    </dependency>
    <dependency>
        <groupId>org.logback-extensions</groupId>
        <artifactId>logback-ext-spring</artifactId>
        <version>0.1.2</version>
    </dependency>
    <dependency>
        <groupId>org.slf4j</groupId>
        <artifactId>jcl-over-slf4j</artifactId>
        <version>1.7.12</version>
    </dependency>
    
    <!-- jsp需要 -->
    <dependency>
      <groupId>javax.servlet</groupId>
      <artifactId>servlet-api</artifactId>
      <version>3.0-alpha-1</version>
      <scope>provided</scope>
    </dependency>
    <dependency>
      <groupId>jstl</groupId>
      <artifactId>jstl</artifactId>
      <version>1.1.2</version>
    </dependency>
  </dependencies>
  
  <build>
  <defaultGoal>compile</defaultGoal>
      <plugins>
          <!-- maven插件 -->
         <plugin> 
            <groupId>org.apache.maven.plugins</groupId> 
            <artifactId>maven-compiler-plugin</artifactId>
            <version>3.1</version> 
            <configuration>
            <source>1.8</source>
            <target>1.8</target>            
                <encoding>UTF-8</encoding> 
            </configuration> 
         </plugin> 
         
        <!-- tomcat插件 -->
        <plugin>
            <groupId>org.apache.tomcat.maven</groupId>
            <artifactId>tomcat7-maven-plugin</artifactId>
            <version>2.1</version>
            <configuration>
                <port>9999</port>
                <path>/testssh</path>
                <uriEncoding>UTF-8</uriEncoding>
                <finalName>testssh</finalName>
                <server>tomcat7</server>
            </configuration>
        </plugin> 
<!--           <plugin>
          <groupId>org.eclipse.jetty</groupId>
          <artifactId>jetty-maven-plugin</artifactId>
          <version>9.3.7.v20160115</version>
        </plugin> -->
      </plugins>
  </build>
</project>

pom.xml

 

(2)spring-context.xml

《javaweb各种框架组合案例(三):maven+spring+springMVC+hibernate》
《javaweb各种框架组合案例(三):maven+spring+springMVC+hibernate》

<?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-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
        http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.0.xsd"
        default-autowire="byName" default-lazy-init="true">
    <description>Spring公共配置 </description>
    <!-- 1.扫描包: @Repository @Service @Autowired @Resource  -->
    <context:component-scan base-package="com.xiaog.dao,com.xiaog.service" />
    
    <!-- 2.加载配置文件 -->
    <context:property-placeholder location="classpath:jdbc.properties" />
    
    <!-- 3.配置连接池 :druid连接池 -->
    <bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource">
        <property name="driverClassName" value="${jdbc.driver}" />
        <property name="url" value="${jdbc.url}" />
        <property name="username" value="${jdbc.username}" />
        <property name="password" value="${jdbc.password}" />
        <!-- 初始化连接数量 -->
       <property name="initialSize" value="5" />
       <!-- 最大连接数 -->
       <property name="maxActive" value="100" />
       <!-- 最小连接数 -->
       <property name="minIdle" value="5" />
       <!-- 配置获取连接等待超时的时间 -->
       <property name="maxWait" value="120000" />
       <!-- 超过时间限制是否回收 -->
       <property name="removeAbandoned" value="true" />
       <!-- 超过时间限制多长 -->
       <property name="removeAbandonedTimeout" value="1800" />
       <!-- 配置间隔多久才进行一次检测,检测需要关闭的空闲连接,单位是毫秒 -->
       <property name="timeBetweenEvictionRunsMillis" value="120000" />
       <!-- 配置一个连接在池中最小生存的时间,单位是毫秒 -->
       <property name="minEvictableIdleTimeMillis" value="300000" />
       <!-- 用来检测连接是否有效的sql,要求是一个查询语句 -->
       <property name="validationQuery" value="SELECT 1" />
       <!-- 申请连接的时候检测 -->
       <property name="testWhileIdle" value="true" />
       <!-- 申请连接时执行validationQuery检测连接是否有效,配置为true会降低性能 -->
       <property name="testOnBorrow" value="false" />
       <!-- 归还连接时执行validationQuery检测连接是否有效,配置为true会降低性能 -->
       <property name="testOnReturn" value="false" />
       <!-- 打开PSCache,并且指定每个连接上PSCache的大小 -->
       <property name="poolPreparedStatements" value="true" />
       <property name="maxPoolPreparedStatementPerConnectionSize" value="20" />
       <property name="defaultAutoCommit" value="false" />
       <!-- 配置监控统计拦截的filters -->
       <property name="filters" value="stat"/>
    </bean>

    <!-- 4.spring集成hibernate  -->
    <!-- 配置hibernate的SessionFactory -->
    <bean id="sessionFactory"
        class="org.springframework.orm.hibernate4.LocalSessionFactoryBean">
        <!-- 注入数据源 相关信息看源码 -->
        <property name="dataSource" ref="dataSource" />
        <!-- hibernate配置信息 -->
        <property name="hibernateProperties">
            <props>
                <prop key="hibernate.dialect">org.hibernate.dialect.MySQLDialect</prop>
                <prop key="hibernate.show_sql">true</prop>
                <prop key="hibernate.format_sql">false</prop>
                <prop key="hibernate.hbm2ddl.auto">update</prop>
            </props>
        </property>
        <!-- 扫描hibernate注解配置的entity -->
        <property name="packagesToScan" value="com.xiaog.entity" />
    </bean>

    
    <!-- 5.配置事务管理器 -->
    <bean id="transactionManager"
        class="org.springframework.orm.hibernate4.HibernateTransactionManager">
        <property name="sessionFactory" ref="sessionFactory" />
    </bean>
    
    <!-- 6.配置aop -->
    <!-- 配置通知: 定位方法 -->
    <tx:advice id="txAdvice" transaction-manager="transactionManager">
        <tx:attributes>
            <tx:method name="*" />
        </tx:attributes>
    </tx:advice>
    <!-- 配置切面 -->
    <aop:config>
        <!-- 定位具体的类:完整类名,使用通配符 -->
        <aop:advisor advice-ref="txAdvice" pointcut="execution(* com.xiaog.service.*.*(..))" />
    </aop:config>        
   
</beans>

spring-context.xml

 

 

 

(3)spring-mvc.xml

《javaweb各种框架组合案例(三):maven+spring+springMVC+hibernate》
《javaweb各种框架组合案例(三):maven+spring+springMVC+hibernate》

<?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"
    xsi:schemaLocation="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.0.xsd
        http://www.springframework.org/schema/mvc 
        http://www.springframework.org/schema/mvc/spring-mvc-4.0.xsd">
        
        <!-- 1.启动自动扫描 -->
        <context:component-scan base-package="com.xiaog.controller" />
        
        <!-- 2.注册MVC注解驱动 -->
        <mvc:annotation-driven />
        
        <!-- 3.配置静态资源    css js imgs -->
        <mvc:resources location="/resources/**" mapping="/resources"/>        
        <mvc:resources location="/webapp/static/**" mapping="/webapp/static"/>     
       
        <!-- 4.附件上传 -->   
        <!-- <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" /> -->
            <!-- 启用是为了推迟文件解析,以便捕获文件大小异常 -->
            <!-- <property name="resolveLazily" value="true"/> -->
        <!-- </bean>  -->
                 
        <!-- 5.配置视图解析器 -->
        <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
            <property name = "prefix" value="/" /><!-- 前缀 -->
            <property name = "suffix" value = ".jsp" /><!-- 后缀 -->
             <property name="viewClass" value="org.springframework.web.servlet.view.JstlView" />  
        </bean>

</beans>

spring-mvc.xml

 

(4)logback.xml

《javaweb各种框架组合案例(三):maven+spring+springMVC+hibernate》
《javaweb各种框架组合案例(三):maven+spring+springMVC+hibernate》

<?xml version="1.0" encoding="UTF-8"?>
<configuration>
    <!-- 控制台输出 -->   
    <appender name="STDOUT" class="ch.qos.logback.core.ConsoleAppender">
       <!-- 日志输出编码 -->  
       <!-- <Encoding>UTF-8</Encoding>    -->
        <layout class="ch.qos.logback.classic.PatternLayout">   
             <!--格式化输出:%d表示日期,%thread表示线程名,%-5level:级别从左显示5个字符宽度%msg:日志消息,%n是换行符--> 
            <pattern>%d{yyyy-MM-dd HH:mm:ss.SSS} [%thread] %-5level %logger{50} - %msg%n   
            </pattern>   
        </layout>   
    </appender>   
    <!-- 日志输出级别 -->
    <root level="INFO"> 
        <appender-ref ref="STDOUT" />   
    </root> 
    <!-- 打印sql语句 -->
    <logger name="org.hibernate.type.descriptor.sql.BasicBinder" level="TRACE" />  
    <logger name="org.hibernate.type.descriptor.sql.BasicExtractor" level="DEBUG" />  
    <logger name="org.hibernate.SQL" level="DEBUG" />
     <logger name="org.hibernate.type" level="INFO" />
    <logger name="org.hibernate.engine.QueryParameters" level="DEBUG" />  
     <logger name="org.hibernate.engine.query.HQLQueryPlan" level="DEBUG" />
</configuration>

logback.xml

 

(5)jdbc.properties

《javaweb各种框架组合案例(三):maven+spring+springMVC+hibernate》
《javaweb各种框架组合案例(三):maven+spring+springMVC+hibernate》

jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/ssh?useSSL=false&amp;useUnicode=true&amp;characterEncoding=utf8
jdbc.username=root
jdbc.password=root

jdbc.properties

 

(6)web.xml

《javaweb各种框架组合案例(三):maven+spring+springMVC+hibernate》
《javaweb各种框架组合案例(三):maven+spring+springMVC+hibernate》

<?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" version="3.0">
  <display-name>testssh</display-name>
  <!-- spring配置文件 -->
      <context-param>
        <param-name>contextConfigLocation</param-name>
        <param-value>classpath:spring-context.xml</param-value>
    </context-param>  
  <!-- spring监听器 -->
      <listener>
        <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
    </listener>
    
     <!-- 字符编码过滤器   spring web自动提供一个 -->
    <filter>
        <filter-name>encodingFilter</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>
        <init-param>
            <param-name>forceEncoding</param-name>
            <param-value>true</param-value>
        </init-param>
    </filter>
    <filter-mapping>
        <filter-name>encodingFilter</filter-name>
        <url-pattern>/*</url-pattern>
    </filter-mapping>
    
        

    <!-- spring  mvc 配置  【中央控制器/前端控制器/总控】 -->
    <servlet>  
        <servlet-name>spring-mvc</servlet-name>  
        <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>  
         <!-- 配置Spring mvc下的配置文件的位置和名称 -->
        <init-param>
             <param-name>contextConfigLocation</param-name>
             <param-value>classpath:spring-mvc.xml</param-value>
         </init-param>
        <load-on-startup>1</load-on-startup>
    </servlet>
    <!-- 可以配置扩展名,*.do -->  
    <servlet-mapping>  
        <servlet-name>spring-mvc</servlet-name>  
        <url-pattern>/</url-pattern>  
    </servlet-mapping>
  
       <!-- 添加日志监听器 -->  
    <context-param>  
        <param-name>logbackConfigLocation</param-name>  
        <param-value>classpath:logback.xml</param-value>  
    </context-param>  
    <listener>  
        <listener-class>ch.qos.logback.ext.spring.web.LogbackConfigListener</listener-class>  
    </listener> 
  
  <welcome-file-list>
    <welcome-file>index.jsp</welcome-file>
  </welcome-file-list>
</web-app>

web.xml

 

 

6.实体类User和Phone

《javaweb各种框架组合案例(三):maven+spring+springMVC+hibernate》
《javaweb各种框架组合案例(三):maven+spring+springMVC+hibernate》

package com.xiaog.entity;

import java.util.List;

import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.JoinColumn;
import javax.persistence.OneToMany;
import javax.persistence.Table;

@Entity
@Table(name="user")
public class User {
    
    @Id
    @GeneratedValue(strategy=GenerationType.IDENTITY)
    private Integer id;
    
    private String username;
    
    private String password;
    
    @OneToMany(targetEntity=Phone.class)
    @JoinColumn(name="user_id")
    private List<Phone> phones;//一个用户拥有多部手机

    public Integer getId() {
        return id;
    }

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

    public String getUsername() {
        return username;
    }

    public void setUsername(String username) {
        this.username = username;
    }

    public String getPassword() {
        return password;
    }

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

    public List<Phone> getPhones() {
        return phones;
    }

    public void setPhones(List<Phone> phones) {
        this.phones = phones;
    }

    @Override
    public String toString() {
        return "User [id=" + id + ", username=" + username + ", password=" + password + ", phones=" + phones + "]";
    }
    
}

User

 

《javaweb各种框架组合案例(三):maven+spring+springMVC+hibernate》
《javaweb各种框架组合案例(三):maven+spring+springMVC+hibernate》

package com.xiaog.entity;

import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;

@Entity
@Table(name="phone")
public class Phone {
    
    @Id
    @GeneratedValue(strategy=GenerationType.IDENTITY)
    private Integer id;
    
    private String brand;//品牌

    public Integer getId() {
        return id;
    }

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

    public String getBrand() {
        return brand;
    }

    public void setBrand(String brand) {
        this.brand = brand;
    }

    @Override
    public String toString() {
        return "Phone [id=" + id + ", brand=" + brand + "]";
    }

}

Phone

 

 

7.核心dao接口及其实现

《javaweb各种框架组合案例(三):maven+spring+springMVC+hibernate》
《javaweb各种框架组合案例(三):maven+spring+springMVC+hibernate》

package com.xiaog.core.dao;

import java.util.List;

public interface CoreDao<T> {
    
    int insert(T t);
    
    int delete(int id);
    
    int update(T t);
    
    T getOne(int id);
    
    List<T> getList(T t);
    
}

CoreDao
《javaweb各种框架组合案例(三):maven+spring+springMVC+hibernate》
《javaweb各种框架组合案例(三):maven+spring+springMVC+hibernate》

package com.xiaog.core.dao.impl;

import java.lang.reflect.ParameterizedType;
import java.util.List;

import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.orm.hibernate4.support.HibernateDaoSupport;

import com.xiaog.core.dao.CoreDao;
import com.xiaog.entity.User;

//继承HibernateDaoSupport 可以直接使用CRUD操作
public class CoreDaoImpl<T> extends HibernateDaoSupport implements CoreDao<T> {
    
    private Class<T> clazz;
    
    private final static Logger logger = LoggerFactory.getLogger(CoreDaoImpl.class);
    
    @SuppressWarnings("unchecked")
    public CoreDaoImpl() {
        this.clazz =  (Class<T>)((ParameterizedType) getClass().getGenericSuperclass()).getActualTypeArguments()[0];
    }
    
    @Override
    public int insert(T t) {
        return (int) super.getHibernateTemplate().save(t);
    }

    @Override
    public int delete(int id) {
        super.getHibernateTemplate().delete(new User() {{setId(id);}});
        return 1;
    }

    @Override
    public int update(T t) {
        super.getHibernateTemplate().update(t);
        return 1;
    }

    @Override
    public T getOne(int id) {
        return super.getHibernateTemplate().get(clazz, id);
    }

    @Override
    public List<T> getList(T t) {
        //logger.info("进入CoreDaoImpl......");
        return super.getHibernateTemplate().findByExample(t);
    }

}

CoreDaoImpl

 

 

8.模块dao接口及其实现(只需继承核心dao即可)

《javaweb各种框架组合案例(三):maven+spring+springMVC+hibernate》
《javaweb各种框架组合案例(三):maven+spring+springMVC+hibernate》

package com.xiaog.dao;

import com.xiaog.core.dao.CoreDao;
import com.xiaog.entity.User;

public interface UserDao extends CoreDao<User> {

}

UserDao
《javaweb各种框架组合案例(三):maven+spring+springMVC+hibernate》
《javaweb各种框架组合案例(三):maven+spring+springMVC+hibernate》

package com.xiaog.dao;

import com.xiaog.core.dao.CoreDao;
import com.xiaog.entity.Phone;

public interface PhoneDao extends CoreDao<Phone> {

}

PhoneDao

 

《javaweb各种框架组合案例(三):maven+spring+springMVC+hibernate》
《javaweb各种框架组合案例(三):maven+spring+springMVC+hibernate》

package com.xiaog.dao.impl;

import org.springframework.stereotype.Repository;

import com.xiaog.core.dao.impl.CoreDaoImpl;
import com.xiaog.dao.UserDao;
import com.xiaog.entity.User;

@Repository
public class UserDaoImpl extends CoreDaoImpl<User> implements UserDao {

}

UserDaoImpl
《javaweb各种框架组合案例(三):maven+spring+springMVC+hibernate》
《javaweb各种框架组合案例(三):maven+spring+springMVC+hibernate》

package com.xiaog.dao.impl;

import org.springframework.stereotype.Repository;

import com.xiaog.core.dao.impl.CoreDaoImpl;
import com.xiaog.dao.PhoneDao;
import com.xiaog.entity.Phone;

@Repository
public class PhoneDaoImpl extends CoreDaoImpl<Phone> implements PhoneDao {


}

PhoneDaoImpl

 

 

9.service接口及其实现

《javaweb各种框架组合案例(三):maven+spring+springMVC+hibernate》
《javaweb各种框架组合案例(三):maven+spring+springMVC+hibernate》

package com.xiaog.service;

import com.xiaog.entity.User;

public interface UserService {
    User login(User user);
}

UserService
《javaweb各种框架组合案例(三):maven+spring+springMVC+hibernate》
《javaweb各种框架组合案例(三):maven+spring+springMVC+hibernate》

package com.xiaog.service.impl;

import java.util.List;

import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import com.xiaog.dao.UserDao;
import com.xiaog.entity.User;
import com.xiaog.service.UserService;

@Service
public class UserServiceImpl implements UserService {

    @Autowired
    private UserDao userDao;
    
    private final static Logger logger = LoggerFactory.getLogger(UserServiceImpl.class);
    
    @Override
    public User login(User user) {
        //logger.info("进入UserServiceImpl......");
        List<User> users = userDao.getList(user);
        logger.info("users="+users);
        if(users!=null&&users.size()>0) {
            return users.get(0);
        }else {
            return null;
        }
    }

}

UserServiceImpl

 

 

10.controller

《javaweb各种框架组合案例(三):maven+spring+springMVC+hibernate》
《javaweb各种框架组合案例(三):maven+spring+springMVC+hibernate》

package com.xiaog.controller;

import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
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 com.xiaog.entity.User;
import com.xiaog.service.UserService;

@Controller
@RequestMapping("/user")
public class UserController {

    @Autowired
    private UserService userService;
    
    private final static Logger logger = LoggerFactory.getLogger(UserController.class);
    
    @RequestMapping(value = "/login",params= {"username","password","username!=","password!="})
    public String login(Model model,User user) {
        logger.info("user(request)="+user);
        user = userService.login(user);
        logger.info("user="+user);
        model.addAttribute("user", user);
        return "result";
    }
    
}

UserController

 

 

11.jsp页面测试登录

《javaweb各种框架组合案例(三):maven+spring+springMVC+hibernate》
《javaweb各种框架组合案例(三):maven+spring+springMVC+hibernate》

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<!doctype html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
    <form action="user/login" method="post">
        <div>
            <label>username</label>
            <input type="text" name="username"/>
        </div>
        <div>
            <label>password</label>
            <input type="password" name="password"/>
        </div>
        <div>
            <input type="submit" value="登录">
        </div>
    </form>
</body>
</html>

index.jsp
《javaweb各种框架组合案例(三):maven+spring+springMVC+hibernate》
《javaweb各种框架组合案例(三):maven+spring+springMVC+hibernate》

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<!doctype html>
<html>
<head>
<meta charset="UTF-8">
<title></title>
</head>
<body>
    username=${user}
</body>
</html>

result.jsp

 

 

12.项目启动后,你会发现你的ssh数据库中多了两张表User和Phone,自己在插入几条数据

user表                                                 phone表

《javaweb各种框架组合案例(三):maven+spring+springMVC+hibernate》      《javaweb各种框架组合案例(三):maven+spring+springMVC+hibernate》

 

13.测试

index.jsp表单中输入1001和123

《javaweb各种框架组合案例(三):maven+spring+springMVC+hibernate》

result.jsp

《javaweb各种框架组合案例(三):maven+spring+springMVC+hibernate》

 

控制台打印

2019-06-22 09:40:24.477 [http-bio-9999-exec-9] INFO  com.xiaog.controller.UserController - user(request)=User [id=null, username=1002, password=456, phones=null]
2019-06-22 09:40:24.519 [http-bio-9999-exec-9] DEBUG org.hibernate.SQL - select this_.id as id1_1_0_, this_.password as password2_1_0_, this_.username as username3_1_0_ from user this_ where (this_.password=? and this_.username=?)
Hibernate: select this_.id as id1_1_0_, this_.password as password2_1_0_, this_.username as username3_1_0_ from user this_ where (this_.password=? and this_.username=?)
2019-06-22 09:40:24.520 [http-bio-9999-exec-9] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [VARCHAR] - 456
2019-06-22 09:40:24.520 [http-bio-9999-exec-9] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [2] as [VARCHAR] - 1002
2019-06-22 09:40:24.523 [http-bio-9999-exec-9] DEBUG org.hibernate.SQL - select phones0_.user_id as user3_1_1_, phones0_.id as id1_0_1_, phones0_.id as id1_0_0_, phones0_.brand as brand2_0_0_ from phone phones0_ where phones0_.user_id=?
Hibernate: select phones0_.user_id as user3_1_1_, phones0_.id as id1_0_1_, phones0_.id as id1_0_0_, phones0_.brand as brand2_0_0_ from phone phones0_ where phones0_.user_id=?
2019-06-22 09:40:24.524 [http-bio-9999-exec-9] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [INTEGER] - 2
2019-06-22 09:40:24.533 [http-bio-9999-exec-9] INFO  com.xiaog.service.impl.UserServiceImpl - users=[User [id=2, username=1002, password=456, phones=[Phone [id=3, brand=三星], Phone [id=4, brand=小米], Phone [id=5, brand=魅族]]]]
2019-06-22 09:40:24.557 [http-bio-9999-exec-9] INFO  com.xiaog.controller.UserController - user=User [id=2, username=1002, password=456, phones=[Phone [id=3, brand=三星], Phone [id=4, brand=小米], Phone [id=5, brand=魅族]]]
2019-06-22 10:38:09.540 [http-bio-9999-exec-5] INFO  com.xiaog.controller.UserController - user(request)=User [id=null, username=1001, password=123, phones=null]
2019-06-22 10:38:09.549 [http-bio-9999-exec-5] DEBUG org.hibernate.SQL - select this_.id as id1_1_0_, this_.password as password2_1_0_, this_.username as username3_1_0_ from user this_ where (this_.password=? and this_.username=?)
Hibernate: select this_.id as id1_1_0_, this_.password as password2_1_0_, this_.username as username3_1_0_ from user this_ where (this_.password=? and this_.username=?)
2019-06-22 10:38:09.550 [http-bio-9999-exec-5] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [VARCHAR] - 123
2019-06-22 10:38:09.550 [http-bio-9999-exec-5] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [2] as [VARCHAR] - 1001
2019-06-22 10:38:09.554 [http-bio-9999-exec-5] DEBUG org.hibernate.SQL - select phones0_.user_id as user3_1_1_, phones0_.id as id1_0_1_, phones0_.id as id1_0_0_, phones0_.brand as brand2_0_0_ from phone phones0_ where phones0_.user_id=?
Hibernate: select phones0_.user_id as user3_1_1_, phones0_.id as id1_0_1_, phones0_.id as id1_0_0_, phones0_.brand as brand2_0_0_ from phone phones0_ where phones0_.user_id=?
2019-06-22 10:38:09.556 [http-bio-9999-exec-5] TRACE org.hibernate.type.descriptor.sql.BasicBinder - binding parameter [1] as [INTEGER] - 1
2019-06-22 10:38:09.563 [http-bio-9999-exec-5] INFO  com.xiaog.service.impl.UserServiceImpl - users=[User [id=1, username=1001, password=123, phones=[Phone [id=1, brand=华为], Phone [id=2, brand=iphone]]]]
2019-06-22 10:38:09.570 [http-bio-9999-exec-5] INFO  com.xiaog.controller.UserController - user=User [id=1, username=1001, password=123, phones=[Phone [id=1, brand=华为], Phone [id=2, brand=iphone]]]

 

 

14.注意点:我个人觉得ssh框架坑实在是多,我在搭建的过程中出现了各种各样的问题,不过最恶心的问题是spring和hibernate存在版本不兼容问题,一开始使用的是spring5+hibernate5,发现报错,就将hibernate5换成4(应该没问题了吧),结果还是报错,折腾半天,发现虽然Pom版本虽然换成4,但是之前dao层用到的HibernateDaoSupport和spring-context.xml配置中SessionFactory还是5的版本,诶,智障问题。

 

相关文章