SSM整合

SSM整合

整合说明：SSM整合可以使用多种方式，咱们会选择XML（第三方对象） + 注解（自己new的对象）的方式

1562512046083

整合的思路

  • （1）：先搭建整合的环境

  • （2）：先把Spring的配置搭建完成

  • （3）：再使用Spring整合SpringMVC框架

  • （4）：最后使用Spring整合MyBatis框架

数据源:

  1. create database itcastspringmvc;
  2. use itcastspringmvc;
  3. create table account(
  4.     id int primary key auto_increment,
  5.     name varchar(20),
  6.     money double
  7. );

POM.XML整合环境:

  1. <properties>
  2.  <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
  3.  <maven.compiler.source>1.8</maven.compiler.source>
  4.  <maven.compiler.target>1.8</maven.compiler.target>
  5.  <spring.version>5.0.2.RELEASE</spring.version>
  6.  <slf4j.version>1.6.6</slf4j.version>
  7.  <log4j.version>1.2.12</log4j.version>
  8.  <mysql.version>5.1.6</mysql.version>
  9.  <mybatis.version>3.4.5</mybatis.version>
  10. </properties>
  12. <dependencies>
  14.  <!-- spring -->
  15.  <dependency>
  16.  <groupId>org.aspectj</groupId>
  17.  <artifactId>aspectjweaver</artifactId>
  18.  <version>1.6.8</version>
  19.  </dependency>
  21.  <dependency>
  22.  <groupId>org.springframework</groupId>
  23.  <artifactId>spring-aop</artifactId>
  24.  <version>${spring.version}</version>
  25.  </dependency>
  27.  <dependency>
  28.  <groupId>org.springframework</groupId>
  29.  <artifactId>spring-context</artifactId>
  30.  <version>${spring.version}</version>
  31.  </dependency>
  33.  <dependency>
  34.  <groupId>org.springframework</groupId>
  35.  <artifactId>spring-web</artifactId>
  36.  <version>${spring.version}</version>
  37.  </dependency>
  39.  <dependency>
  40.  <groupId>org.springframework</groupId>
  41.  <artifactId>spring-webmvc</artifactId>
  42.  <version>${spring.version}</version>
  43.  </dependency>
  45.  <dependency>
  46.  <groupId>org.springframework</groupId>
  47.  <artifactId>spring-test</artifactId>
  48.  <version>${spring.version}</version>
  49.  </dependency>
  51.  <dependency>
  52.  <groupId>org.springframework</groupId>
  53.  <artifactId>spring-tx</artifactId>
  54.  <version>${spring.version}</version>
  55.  </dependency>
  57.  <dependency>
  58.  <groupId>org.springframework</groupId>
  59.  <artifactId>spring-jdbc</artifactId>
  60.  <version>${spring.version}</version>
  61.  </dependency>
  63.  <dependency>
  64.  <groupId>junit</groupId>
  65.  <artifactId>junit</artifactId>
  66.  <version>4.12</version>
  67.  <scope>test</scope>
  68.  </dependency>
  70.  <dependency>
  71.  <groupId>mysql</groupId>
  72.  <artifactId>mysql-connector-java</artifactId>
  73.  <version>${mysql.version}</version>
  74.  </dependency>
  76.  <dependency>
  77.  <groupId>javax.servlet</groupId>
  78.  <artifactId>servlet-api</artifactId>
  79.  <version>2.5</version>
  80.  <scope>provided</scope>
  81.  </dependency>
  83.  <dependency>
  84.  <groupId>javax.servlet.jsp</groupId>
  85.  <artifactId>jsp-api</artifactId>
  86.  <version>2.0</version>
  87.  <scope>provided</scope>
  88.  </dependency>
  90.  <dependency>
  91.  <groupId>jstl</groupId>
  92.  <artifactId>jstl</artifactId>
  93.  <version>1.2</version>
  94.  </dependency>
  96.  <!-- log start -->
  97.  <dependency>
  98.  <groupId>log4j</groupId>
  99.  <artifactId>log4j</artifactId>
  100.  <version>${log4j.version}</version>
  101.  </dependency>
  103.  <dependency>
  104.  <groupId>org.slf4j</groupId>
  105.  <artifactId>slf4j-api</artifactId>
  106.  <version>${slf4j.version}</version>
  107.  </dependency>
  109.  <dependency>
  110.  <groupId>org.slf4j</groupId>
  111.  <artifactId>slf4j-log4j12</artifactId>
  112.  <version>${slf4j.version}</version>
  113.  </dependency>
  114.  <!-- log end -->
  115.  <dependency>
  116.  <groupId>org.mybatis</groupId>
  117.  <artifactId>mybatis</artifactId>
  118.  <version>${mybatis.version}</version>
  119.  </dependency>
  121.  <dependency>
  122.  <groupId>org.mybatis</groupId>
  123.  <artifactId>mybatis-spring</artifactId>
  124.  <version>1.3.0</version>
  125.  </dependency>
  127.  <dependency>
  128.  <groupId>c3p0</groupId>
  129.  <artifactId>c3p0</artifactId>
  130.  <version>0.9.1.2</version>
  131.  <type>jar</type>
  132.  <scope>compile</scope>
  133.  </dependency>
  135. </dependencies>
  137. <build>
  138.  <finalName>ssm</finalName>
  139.  <plugins>
  140.  <plugin>
  141.  <groupId>org.apache.maven.plugins</groupId>
  142.  <artifactId>maven-compiler-plugin</artifactId>
  143.  <version>3.2</version>
  144.  <configuration>
  145.  <source>1.8</source>
  146.  <target>1.8</target>
  147.  <encoding>UTF-8</encoding>
  148.  <showWarnings>true</showWarnings>
  149.  </configuration>
  150.  </plugin>
  151.  </plugins>
  152. </build>

创建包com.le.ssm.domain,创建类Account.java

  1. public class Account implements Serializable {
  2.  private Integer id;
  3.  private String name;
  4.  private Double money;
  5. }

DAO

创建包com.le.ssm.dao，创建类AccountDao.java

  1. /**
  2. * AccountMapper接口，不用编写实现类，框架生成代理对象
  3. */
  4. public interface AccountDao {
  6.  public List<Account> findAll();
  8.  public void saveAccount(Account account);
  10. }

Service

创建包com.le.ssm.service，创建接口AccountService.java

  1. public interface AccountService {
  3.  public List<Account> findAll();
  5.  public void saveAccount(Account account);
  8. }

创建类AccountServiceImpl，实现接口

  1. /**
  2. * 账号的实现类
  3. */
  4. public class AccountServiceImpl implements AccountService {
  6.  private AccountDao accountDao;
  8.  public List<Account> findAll() {
  9.  System.out.println("业务层：查询所有的帐户...");
  10.  return accountDao.findAll();
  11.  }
  13.  public void saveAccount(Account account) {
  14.  System.out.println("业务层：保存帐户...");
  15.         accountDao.saveAccount(account);
  16.  }
  18. }

创建包com.le.ssm.controller，创建类AccountController.java

  1. /**
  2. * 帐户
  3. */
  4. public class AccountController {
  6.  private AccountService accountService;
  8.  /**
  9.      * 查询所有
  10.      * @return
  11.      */
  12.  public String findAll() {
  13.  System.out.println("表现层：查询所有账户...");
  14.  List<Account> list = accountService.findAll();
  15.  for (Account account : list) {
  16.  System.out.println(account);
  17.  }
  18.  return "success";
  19.  }
  21.  /**
  22.      * 保存
  23.      * @return
  24.      */
  25.  public String saveAccount(Account account) {
  26. System.out.println("表现层：保存账户...");
  27.         accountService.saveAccount(account);
  28.  return "success";
  29.  }
  31. }

1562512430210

Spring的环境

在项目中的resources文件夹下创建applicationContext.xml的配置文件，编写具体的配置信息。

  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <beans xmlns="http://www.springframework.org/schema/beans"
  3.  xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  4.  xmlns:context="http://www.springframework.org/schema/context"
  5.  xmlns:aop="http://www.springframework.org/schema/aop"
  6.  xmlns:tx="http://www.springframework.org/schema/tx"
  7.  xsi:schemaLocation="http://www.springframework.org/schema/beans
  8.    http://www.springframework.org/schema/beans/spring-beans.xsd
  9.    http://www.springframework.org/schema/context
  10.    http://www.springframework.org/schema/context/spring-context.xsd
  11.    http://www.springframework.org/schema/aop
  12.    http://www.springframework.org/schema/aop/spring-aop.xsd
  13.    http://www.springframework.org/schema/tx
  14.    http://www.springframework.org/schema/tx/spring-tx.xsd">
  15.  <!-- 开启注解扫描 -->当只使用SpringMVC的注解管理全部的时候,这里就不需要开启注解了
  16.  <!--<context:component-scan base-package="com.le.ssm">
  17.         <!-- 忽略某些注解，把Controller给忽略了 -->
  18.  <context:exclude-filter type="annotation" expression="org.springframework.stereotype.Controller"/>
  19.  </context:component-scan>-->
  20. </beans>

AccountService.java

  1. /**
  2. * 账号的实现类
  3. */
  4. @Service("accountService")
  5. public class AccountServiceImpl implements AccountService {
  7. }

在项目中编写测试方法，进行测试

创建测试类：com.le.test.TestService.java

  1. public class TestService {
  3.  /**
  4.      * 测试Service层
  5.      */
  6.  @Test
  7.  public void testService(){
  8.  ApplicationContext ac = new ClassPathXmlApplicationContext("classpath:applicationContext.xml");
  9.  AccountService as = (AccountService) ac.getBean("accountService");
  10.         as.findAll();
  11.  }
  12. }

1562512663707

SpringMVC框架

web.xml

在web.xml中配置DispatcherServlet前端控制器

  1. <!-- 配置前端控制器：服务器启动必须加载，需要加载springmvc.xml配置文件 -->
  2. <servlet>
  3.  <servlet-name>dispatcherServlet</servlet-name>
  4.  <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
  5.  <!-- 配置初始化参数，创建完DispatcherServlet对象，加载springmvc.xml配置文件 -->
  6.  <init-param>
  7.  <param-name>contextConfigLocation</param-name>
  8.  <param-value>classpath:springmvc.xml</param-value>
  9.  </init-param>
  10.  <!-- 服务器启动的时候，让DispatcherServlet对象创建 -->
  11.  <load-on-startup>1</load-on-startup>
  12. </servlet>
  13. <servlet-mapping>
  14.  <servlet-name>dispatcherServlet</servlet-name>
  15.  <url-pattern>/</url-pattern>
  16. </servlet-mapping>
  18. <!-- 在web.xml中配置CharacterEncodingFilter过滤器解决post请求中文乱码
  19.         配置解决中文乱码的过滤器 -->
  20. <filter>
  21.  <filter-name>characterEncodingFilter</filter-name>
  22.  <filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
  23.  <init-param>
  24.  <param-name>encoding</param-name>
  25.  <param-value>UTF-8</param-value>
  26.  </init-param>
  27. </filter>
  28. <filter-mapping>
  29.  <filter-name>characterEncodingFilter</filter-name>
  30.  <url-pattern>/*</url-pattern>
  31. </filter-mapping>

springmvc.xml

在resources下，创建springmvc.xml

  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <beans xmlns="http://www.springframework.org/schema/beans"
  3.  xmlns:mvc="http://www.springframework.org/schema/mvc" xmlns:context="http://www.springframework.org/schema/context"
  4.  xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  5.  xsi:schemaLocation="
  6.         http://www.springframework.org/schema/beans
  7.         http://www.springframework.org/schema/beans/spring-beans.xsd
  8.         http://www.springframework.org/schema/mvc
  9.         http://www.springframework.org/schema/mvc/spring-mvc.xsd
  10.         http://www.springframework.org/schema/context
  11.         http://www.springframework.org/schema/context/spring-context.xsd">
  13.  <!-- 扫描controller的注解，别的不扫描 -->
  14.  <context:component-scan base-package="com.le.ssm">
  15.  <!--<context:include-filter type="annotation" expression="org.springframework.stereotype.Controller"/>
  16.          排除Service注解的扫描，让spring扫描，否则事务可能会失效
  17.         <context:exclude-filter type="annotation" expression="org.springframework.stereotype.Service"></context:exclude-filter> -->
  18.  </context:component-scan><!-- 当使用下面这一句整合了APP的注解后,就不需要配上面两句了 -->
  19.  <import resource="applicationContext.xml"></import>
  22.  <!-- 配置视图解析器 -->
  23.  <bean id="viewResolver" class="org.springframework.web.servlet.view.InternalResourceViewResolver">
  24.  <!-- JSP文件所在的目录 -->
  25.  <property name="prefix" value="/WEB-INF/pages/" />
  26.  <!-- 文件的后缀名 -->
  27.  <property name="suffix" value=".jsp" />
  28.  </bean>
  30.  <!-- 设置静态资源不过滤，可以使用：-->
  31. <mvc:default-servlet-handler></mvc:default-servlet-handler>
  33. <!--
  34.      <mvc:resources location="/css/" mapping="/css/**" />
  35.     <mvc:resources location="/images/" mapping="/images/**" />
  36.     <mvc:resources location="/js/" mapping="/js/**" />
  37. -->
  40.  <!-- 开启对SpringMVC注解的支持 -->
  41.  <mvc:annotation-driven />
  45. </beans>

其中：

表示springmvc的注解包含@Controller的注解。

为什么要包含@Controller注解呢？

1）SpringMVC IOC容器 存在Controller的实例对象

2）Spring IOC容器 存在Controller的实例和Service层实例以及Dao层实例

重叠会引发一些问题：

​ 例如：事务失效、相关注解失效

​ 解决方案一：

​ SpringMVC只扫描 @Controller 注解、不扫描@Service注解

​ Spring不扫描 @Controller 注解

​ 解决方案二：（建议使用）

​ 只让SpringMVC扫描，不让Spring扫描

​ 在springMVC的配置中添加

AccountController.java

  1. /**
  2. * 帐户
  3. */
  4. @Controller
  5. @RequestMapping(path = "account")
  6. public class AccountController {
  8.  @Autowired
  9.  private AccountService accountService;
  11.  /**
  12.      * 查询所有
  13.      * @return
  14.      */
  15.  @RequestMapping(path = "/findAll")
  16.  public String findAll() {
  17.  System.out.println("表现层：查询所有账户...");
  18.  return "success";
  19.  }
  20. }

index.jsp

  1. <body>
  2. <h3>账号操作</h3>
  3. <a href="account/findAll">查询所有账号</a>
  4. </body>

success.jsp（WEB-INF/pages/success.jsp）

  1. <body>
  2. <h1>访问成功</h1>
  3. </body>

1562513043709

Spring整合SpringMVC框架

目的：在controller中能成功的调用service对象中的方法。（由spring创建对象，注入到Action中使用）

在项目启动的时候，就去加载applicationContext.xml的配置文件，在web.xml中配置ContextLoaderListener监听器（默认该监听器只能加载WEB-INF目录下的applicationContext.xml的配置文件）。使用contextConfigLocation的属性让它加载类路径下的applicationContext.xml。

web.xml

  1. <!-- 配置Spring的监听器，默认加载WEB-INF下的applicationContext.xml -->
  2. <listener>
  3.  <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
  4. </listener>
  5. <!-- 该监听器默认只加载WEB-INF下的applicationContext.xml配置文件，通过contextConfigLocation改变位置 -->
  6. <context-param>
  7.  <param-name>contextConfigLocation</param-name>
  8.  <param-value>classpath:applicationContext.xml</param-value>
  9. </context-param>

AccountController.java

  1. @Controller
  2. @RequestMapping(path = "account")
  3. public class AccountController {
  5.  @Autowired
  6.  private AccountService accountService;
  8.  /**
  9.      * 查询所有
  10.      * @return
  11.      */
  12.  @RequestMapping(path = "/findAll")
  13.  public String findAll() {
  14.  System.out.println("表现层：查询所有账户...");
  15.  List<Account> list = accountService.findAll();
  16.  System.out.println(list);
  17.  return "success";
  18.  }
  19. }

1562513174789

Mybatis框架

SqlMapConfig.xml

在web项目中编写SqlMapConfig.xml的配置文件，放置到resources下，编写核心配置文件

  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <!DOCTYPE configuration
  3.         PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
  4.         "http://mybatis.org/dtd/mybatis-3-config.dtd">
  6. <configuration>
  7.  <environments default="mysql">
  8.  <environment id="mysql">
  9.  <transactionManager type="JDBC"/>
  10.  <dataSource type="POOLED">
  11.  <property name="driver" value="com.mysql.jdbc.Driver"/>
  12.  <property name="url" value="jdbc:mysql:///itcastspringmvc"/>
  13.  <property name="username" value="root"/>
  14.  <property name="password" value="root"/>
  15.  </dataSource>
  16.  </environment>
  17.  </environments>
  19.  <!-- 使用的是注解 -->
  20.  <mappers>
  21.  <!-- <mapper class="com.le.ssm.dao.AccountDao"/> -->
  22.  <!-- 该包下所有的dao接口都可以使用 -->
  23.  <package name="com.le.ssm.dao"/>
  24.  </mappers>
  25. </configuration>

Xml的回顾：我们采用的是注解

  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <!DOCTYPE mapper
  3.         PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
  4.         "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
  5. <mapper namespace="com.le.ssm.dao.AccountDao">
  6.  <!--查询所有-->
  7.  <select id="findAll" resultType="com.le.ssm.domain.Account">
  8.         select * from account
  9.  </select>
  10.  <!--保存-->
  11.  <insert id="save" parameterType="com.le.ssm.domain.Account">
  12.         insert into account(name,money) values (#{name},#{money})
  13.  </insert>
  14. </mapper>

AccountDao.java

在AccountDao接口的方法上添加注解，编写SQL语句

  1. /**
  2. * AccountDao接口，不用编写实现类，框架生成代理对象
  3. */
  4. public interface AccountDao {
  6.  @Select(value = "select * from account")
  7.  public List<Account> findAll();
  9.  @Insert(value = "insert into account (name,money) values (#{name},#{money})")
  10.  public void saveAccount(Account account);
  12. }

在测试环境下，com.le.test中，编写测试方法

  1. public class TestMybatis {
  2.  @Test
  3.  public void testFindAll() throws Exception {
  4.  // 加载配置文件
  5.  InputStream in = Resources.getResourceAsStream("sqlMapConfig.xml");
  6.  // 创建工厂
  7.  SqlSessionFactory sessionFactory = new SqlSessionFactoryBuilder().build(in);
  8.  // 创建sqlSession对象
  9.  SqlSession sqlSession = sessionFactory.openSession();
  10.  // 获取代理对象
  11.  AccountDao accountDao = sqlSession.getMapper(AccountDao.class);
  12.  // 获取查询所有的方法
  13.  List<Account> list = accountDao.findAll();
  14.  for(Account account:list){
  15.  System.out.println(account);
  16.  }
  17.  // 释放资源
  18.         sqlSession.close();
  19.         in.close();
  20.  }
  22.  @Test
  23.  public void testSave() throws Exception {
  24.  Account account = new Account();
  25.         account.setName("小菲");
  26.         account.setMoney(400d);
  28.  // 加载配置文件
  29.  InputStream in = Resources.getResourceAsStream("sqlMapConfig.xml");
  30.  // 创建工厂
  31.  SqlSessionFactory sessionFactory = new SqlSessionFactoryBuilder().build(in);
  32.  // 创建sqlSession对象
  33.  SqlSession sqlSession = sessionFactory.openSession();
  34.  // 获取代理对象
  35.  AccountDao accountDao = sqlSession.getMapper(AccountDao.class);
  37.         accountDao.saveAccount(account);
  39.  // 提交事务
  40.         sqlSession.commit();
  41.  // 释放资源
  42.         sqlSession.close();
  43.         in.close();
  44.  }
  45. }

Spring整合MyBatis框架

applicationContext.xml

目的：把SqlMapConfig.xml配置文件中的内容配置到applicationContext.xml配置文件中

  1. <!-- 配置C3P0的连接池对象 -->
  2. <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
  3.  <property name="driverClass" value="com.mysql.jdbc.Driver"></property>
  4.  <property name="jdbcUrl" value="jdbc:mysql:///itcastspringmvc" />
  5.  <property name="user" value="root" />
  6.  <property name="password" value="root" />
  7. </bean>
  9. <!-- 配置SqlSession的工厂 -->
  10. <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
  11.  <property name="dataSource" ref="dataSource" />
  12. </bean>
  14. <!-- 配置扫描dao的包 -->
  15. <bean id="mapperScanner" class="org.mybatis.spring.mapper.MapperScannerConfigurer">
  16.  <property name="basePackage" value="com.le.ssm.dao"/>
  17. </bean>

SqlMapConfig.xml配置文件可以删除。

AccountDao.java

在AccountDao接口中添加@Repository注解，也可以不填加。

  1. @Repository
  2. public interface AccountDao {
  4.  @Select(value = "select * from account")
  5.  public List<Account> findAll();
  7.  @Insert(value = "insert into account (name,money) values (#{name},#{money})")
  8.  public void saveAccount(Account account);
  10. }

TestSpringMybatis

  1. @Test
  2. public void testFindAllSpring() throws Exception {
  3.  ApplicationContext ac = new ClassPathXmlApplicationContext("applicationContext.xml");
  4.  AccountDao accountDao = ac.getBean(AccountDao.class);
  5.  List<Account> list = accountDao.findAll();
  6.  for(Account account:list){
  7.  System.out.println(account);
  8.  }
  9. }

AccountServiceImpl.java

在service中注入dao对象

  1. /**
  2. * 账号的实现类
  3. */
  4. @Service("accountService")
  5. public class AccountServiceImpl implements AccountService {
  7.  @Autowired
  8.  private AccountDao accountDao;
  10.  public List<Account> findAll() {
  11.  System.out.println("业务层：查询所有的帐户...");
  12.  return accountDao.findAll();
  13.  }
  15.  public void saveAccount(Account account) {
  16.         accountDao.saveAccount(account);
  17.  }
  19. }

AccountController.java

  1. @Controller
  2. @RequestMapping(path = "account")
  3. public class AccountController {
  5.  @Autowired
  6.  private AccountService accountService;
  8.  /**
  9.      * 查询所有
  10.      * @return
  11.      */
  12.  @RequestMapping(path = "/findAll")
  13.  public String findAll(Model model) {
  14.  System.out.println("表现层：查询所有账户...");
  15.  List<Account> list = accountService.findAll();
  16.  System.out.println(list);
  17.         model.addAttribute("list",list);
  18.  return "success";
  19.  }
  22.  /**
  23.      * 保存
  24.      * @return
  25.      */
  26.  @RequestMapping(path = "/save")
  27.  public String saveAccount(Account account) {
  28.         accountService.saveAccount(account);
  29.  return "success";
  30.  }
  32. }

success.jsp

  1. <%@ page contentType="text/html;charset=UTF-8" language="java" isELIgnored="false" %>
  2. <%@taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
  3. <html>
  4. <head>
  5.  <title>Title</title>
  6. </head>
  7. <body>
  8. <h1>访问成功</h1>
  9. <c:forEach items="${list}" var="account">
  10.     ${account.id}---
  11.     ${account.name}---
  12.     ${account.money}<br>
  13. </c:forEach>
  14. </body>
  15. </html>

配置Spring的声明式事务管理

applicationContext.xml

  1. <!-- 配置事务管理器 -->
  2. <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
  3.  <property name="dataSource" ref="dataSource"/>
  4. </bean>
  6. <!-- 配置事务通知 -->
  7. <tx:advice id="txAdvice" transaction-manager="transactionManager">
  8.  <tx:attributes>
  9.  <tx:method name="*" read-only="true"/>
  10.  <tx:method name="save*" isolation="DEFAULT" propagation="REQUIRED" read-only="false"/>
  11.  <tx:method name="update*" isolation="DEFAULT" propagation="REQUIRED" read-only="false"/>
  12.  <tx:method name="delete*" isolation="DEFAULT" propagation="REQUIRED" read-only="false"/>
  13.  </tx:attributes>
  14. </tx:advice>
  16. <!-- 配置AOP增强事务 -->
  17. <aop:config>
  18.  <aop:advisor advice-ref="txAdvice" pointcut="execution(* com.le.ssm.service..*.*(..))"/>
  19. </aop:config>

Spring的声明式事务处理（注解方式）

  1. <!--使用注解的方式，配置spring的声明式事务处理-->
  2. <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
  3.  <property name="dataSource" ref="dataSource"></property>
  4. </bean>
  6. <!--开启注解的方式使用事务-->
  7. <tx:annotation-driven transaction-manager="transactionManager"></tx:annotation-driven>

在Service的类上，配置@Transactional

  1. @Service
  2. @Transactional
  3. public class AccountServiceImpl implements AccountService {

index.jsp

  1. <hr>
  2. <form action="account/save" method="post">
  3.     姓名：<input type="text" name="name"/><br/>
  4.     金额：<input type="text" name="money"/><br/>
  5.  <input type="submit" value="保存"/><br/>
  6. </form>

AccountController.java

  1. /**
  2. * 保存
  3. * @return
  4. */
  5. @RequestMapping(path = "/save")
  6. public void saveAccount(Account account, HttpServletRequest request, HttpServletResponse response) throws Exception {
  7.  System.out.println("表现层：保存账户...");
  8.     accountService.saveAccount(account);
  9.     response.sendRedirect(request.getContextPath()+"/account/findAll");
  10.  return;
  11. }

建议使用redirect关键字

  1. @RequestMapping(path = "/save")
  2. public String saveAccount(Account account) throws Exception {
  3.  System.out.println("表现层：保存账户...");
  4.     accountService.saveAccount(account);
  5.  return "redirect:/account/findAll";
  6. }

让SpringMVC扫描，不让Spring扫描

配置springmvc.xml

  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <beans xmlns="http://www.springframework.org/schema/beans"
  3.  xmlns:mvc="http://www.springframework.org/schema/mvc" xmlns:context="http://www.springframework.org/schema/context"
  4.  xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  5.  xsi:schemaLocation="
  6.         http://www.springframework.org/schema/beans
  7.         http://www.springframework.org/schema/beans/spring-beans.xsd
  8.         http://www.springframework.org/schema/mvc
  9.         http://www.springframework.org/schema/mvc/spring-mvc.xsd
  10.         http://www.springframework.org/schema/context
  11.         http://www.springframework.org/schema/context/spring-context.xsd">
  12.  <!-- 开启注解扫描 -->
  13.  <context:component-scan base-package="com.le.ssm">
  15.  </context:component-scan>
  17.  <!-- 配置视图解析器 -->
  18.  <bean id="viewResolver" class="org.springframework.web.servlet.view.InternalResourceViewResolver">
  19.  <!-- JSP文件所在的目录 -->
  20.  <property name="prefix" value="/WEB-INF/pages/" />
  21.  <!-- 文件的后缀名 -->
  22.  <property name="suffix" value=".jsp" />
  23.  </bean>
  25.  <!-- 设置静态资源不过滤 -->
  26.  <mvc:resources location="/css/" mapping="/css/**" />
  27.  <mvc:resources location="/images/" mapping="/images/**" />
  28.  <mvc:resources location="/js/" mapping="/js/**" />
  30.  <!-- 开启对SpringMVC注解的支持 -->
  31.  <mvc:annotation-driven />
  32.  <!-- 加载springMVC的同时，同时加载spring -->
  33.  <import resource="applicationContext.xml"></import>
  34. </beans>

applicationContext.xml

  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <beans xmlns="http://www.springframework.org/schema/beans"
  3.  xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  4.  xmlns:context="http://www.springframework.org/schema/context"
  5.  xmlns:aop="http://www.springframework.org/schema/aop"
  6.  xmlns:tx="http://www.springframework.org/schema/tx"
  7.  xsi:schemaLocation="http://www.springframework.org/schema/beans
  8.    http://www.springframework.org/schema/beans/spring-beans.xsd
  9.    http://www.springframework.org/schema/context
  10.    http://www.springframework.org/schema/context/spring-context.xsd
  11.    http://www.springframework.org/schema/aop
  12.    http://www.springframework.org/schema/aop/spring-aop.xsd
  13.    http://www.springframework.org/schema/tx
  14.    http://www.springframework.org/schema/tx/spring-tx.xsd">
  16.  <!-- 删除组件扫描的配置 -->
  18.  <!-- 配置C3P0的连接池对象 -->
  19.  <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
  20.  <property name="driverClass" value="com.mysql.jdbc.Driver"></property>
  21.  <property name="jdbcUrl" value="jdbc:mysql:///itcastspringmvc" />
  22.  <property name="user" value="root" />
  23.  <property name="password" value="root" />
  24.  </bean>
  26.  <!-- 配置SqlSession的工厂 -->
  27.  <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
  28.  <property name="dataSource" ref="dataSource" />
  29.  </bean>
  31.  <!-- 配置扫描dao的包 -->
  32.  <bean id="mapperScanner" class="org.mybatis.spring.mapper.MapperScannerConfigurer">
  33.  <property name="basePackage" value="com.le.ssm.dao"/>
  34.  </bean>
  37.  <!-- 配置事务管理器 -->
  38.  <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
  39.  <property name="dataSource" ref="dataSource"/>
  40.  </bean>
  42.  <!-- 配置事务通知 -->
  43.  <tx:advice id="txAdvice" transaction-manager="transactionManager">
  44.  <tx:attributes>
  45.  <tx:method name="find*" read-only="true"/>
  46.  <tx:method name="save*" isolation="DEFAULT" propagation="REQUIRED" read-only="false"/>
  47.  <tx:method name="update*" isolation="DEFAULT" propagation="REQUIRED" read-only="false"/>
  48.  <tx:method name="delete*" isolation="DEFAULT" propagation="REQUIRED" read-only="false"/>
  49.  </tx:attributes>
  50.  </tx:advice>
  52.  <!-- 配置AOP增强事务 -->
  53.  <aop:config>
  54.  <aop:advisor advice-ref="txAdvice" pointcut="execution(* com.le.service..*.*(..))"/>
  55.  </aop:config>
  56. </beans>

去掉web.xml中的监听器

  1. <!-- 配置Spring的监听器，默认加载WEB-INF下的applicationContext.xml
  2. <listener>
  3.     <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
  4. </listener>
  5. 该监听器默认只加载WEB-INF下的applicationContext.xml配置文件，通过contextConfigLocation改变位置
  6. <context-param>
  7.     <param-name>contextConfigLocation</param-name>
  8.     <param-value>classpath:applicationContext.xml</param-value>
  9. </context-param> -->

SSM用户注册登录案例

web.xml

  1. <!-- 配置前端控制器：服务器启动必须加载，需要加载springmvc.xml配置文件 -->
  2. <servlet>
  3.  <servlet-name>dispatcherServlet</servlet-name>
  4.  <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
  5.  <!-- 配置初始化参数，创建完DispatcherServlet对象，加载springmvc.xml配置文件 -->
  6.  <init-param>
  7.  <param-name>contextConfigLocation</param-name>
  8.  <param-value>classpath:springmvc.xml</param-value>
  9.  </init-param>
  10.  <!-- 服务器启动的时候，让DispatcherServlet对象创建 -->
  11.  <load-on-startup>1</load-on-startup>
  12. </servlet>
  13. <servlet-mapping>
  14.  <servlet-name>dispatcherServlet</servlet-name>
  15.  <url-pattern>/</url-pattern>
  16. </servlet-mapping>
  18. <!-- 配置解决中文乱码的过滤器 -->
  19. <filter>
  20.  <filter-name>characterEncodingFilter</filter-name>
  21.  <filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
  22.  <init-param>
  23.  <param-name>encoding</param-name>
  24.  <param-value>UTF-8</param-value>
  25.  </init-param>
  26. </filter>
  27. <filter-mapping>
  28.  <filter-name>characterEncodingFilter</filter-name>
  29.  <url-pattern>/*</url-pattern>
  30. </filter-mapping>

applicationContext.xml

  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <beans xmlns="http://www.springframework.org/schema/beans"
  3.  xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  4.  xmlns:context="http://www.springframework.org/schema/context"
  5.  xmlns:aop="http://www.springframework.org/schema/aop"
  6.  xmlns:tx="http://www.springframework.org/schema/tx"
  7.  xsi:schemaLocation="http://www.springframework.org/schema/beans
  8.    http://www.springframework.org/schema/beans/spring-beans.xsd
  9.    http://www.springframework.org/schema/context
  10.    http://www.springframework.org/schema/context/spring-context.xsd
  11.    http://www.springframework.org/schema/aop
  12.    http://www.springframework.org/schema/aop/spring-aop.xsd
  13.    http://www.springframework.org/schema/tx
  14.    http://www.springframework.org/schema/tx/spring-tx.xsd">
  17.  <!-- Spring整合Mybatis -->
  18.  <!-- 配置C3P0的连接池对象 -->
  19.  <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
  20.  <property name="driverClass" value="com.mysql.jdbc.Driver"></property>
  21.  <property name="jdbcUrl" value="jdbc:mysql:///itcastspringmvc" />
  22.  <property name="user" value="root" />
  23.  <property name="password" value="root" />
  24.  </bean>
  26.  <!-- 配置SqlSession的工厂 -->
  27.  <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
  28.  <property name="dataSource" ref="dataSource" />
  29.  </bean>
  31.  <!-- 配置扫描dao的包 -->
  32.  <bean id="mapperScanner" class="org.mybatis.spring.mapper.MapperScannerConfigurer">
  33.  <property name="basePackage" value="com.le.ssm.dao"/>
  34.  </bean>
  36.  <!-- spring的声明式事务处理 -->
  37.  <!-- 配置事务管理器 -->
  38.  <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
  39.  <property name="dataSource" ref="dataSource"/>
  40.  </bean>
  42.  <!-- 配置事务通知 -->
  43.  <tx:advice id="txAdvice" transaction-manager="transactionManager">
  44.  <tx:attributes>
  45.  <tx:method name="find*" read-only="true"/>
  46.  <tx:method name="save*" isolation="DEFAULT" propagation="REQUIRED" read-only="false"/>
  47.  <tx:method name="update*" isolation="DEFAULT" propagation="REQUIRED" read-only="false"/>
  48.  <tx:method name="delete*" isolation="DEFAULT" propagation="REQUIRED" read-only="false"/>
  49.  </tx:attributes>
  50.  </tx:advice>
  52.  <!-- 配置AOP增强事务 -->
  53.  <aop:config>
  54.  <aop:advisor advice-ref="txAdvice" pointcut="execution(* com.le.ssm.service..*.*(..))"/>
  55.  </aop:config>
  56. </beans>

springmvc.xml

  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <beans xmlns="http://www.springframework.org/schema/beans"
  3.  xmlns:mvc="http://www.springframework.org/schema/mvc" xmlns:context="http://www.springframework.org/schema/context"
  4.  xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  5.  xsi:schemaLocation="
  6.         http://www.springframework.org/schema/beans
  7.         http://www.springframework.org/schema/beans/spring-beans.xsd
  8.         http://www.springframework.org/schema/mvc
  9.         http://www.springframework.org/schema/mvc/spring-mvc.xsd
  10.         http://www.springframework.org/schema/context
  11.         http://www.springframework.org/schema/context/spring-context.xsd">
  13.  <!-- 开启注解扫描 -->
  14.  <context:component-scan base-package="com.le.ssm"></context:component-scan>
  16.  <!-- 配置视图解析器 -->
  17.  <bean id="viewResolver" class="org.springframework.web.servlet.view.InternalResourceViewResolver">
  18.  <!-- JSP文件所在的目录 -->
  19.  <property name="prefix" value="/WEB-INF/pages/" />
  20.  <!-- 文件的后缀名 -->
  21.  <property name="suffix" value=".jsp" />
  22.  </bean>
  24.  <!-- 设置静态资源不过滤 -->
  25.  <!--<mvc:resources location="/css/" mapping="/css/**" />-->
  26.  <!--<mvc:resources location="/img/" mapping="/img/**" />-->
  27.  <!--<mvc:resources location="/plugins/" mapping="/plugins/**" />-->
  29.  <!--静态资源一律不拦截，包括html-->
  30.  <mvc:default-servlet-handler />
  33.  <!-- 开启对SpringMVC注解的支持 -->
  34.  <mvc:annotation-driven />
  36.  <import resource="applicationContext.xml"></import>
  37. </beans>

用户注册

表结构：

​ number varchar // 登录名

​ name varchar

​ password varchar // 密码

​ mobile varchar

​ qq varchar

​ email varchar

  1. create table `user` (
  2.  `number` varchar(40) not null,
  3.  `name` VARCHAR(20) DEFAULT NULL,
  4.  `password` VARCHAR(60) DEFAULT NULL,
  5.  `mobile` VARCHAR(11) DEFAULT NULL,
  6.  `qq` VARCHAR(11) DEFAULT NULL,
  7.  `email` VARCHAR(60) DEFAULT NULL,
  8.     primary key (`number`)
  9. ) ENGINE=INNODB DEFAULT CHARSET = utf8;

pom.xml

  1. <properties>
  2.  <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
  3.  <maven.compiler.source>1.8</maven.compiler.source>
  4.  <maven.compiler.target>1.8</maven.compiler.target>
  5.  <spring.version>5.0.2.RELEASE</spring.version>
  6.  <slf4j.version>1.6.6</slf4j.version>
  7.  <log4j.version>1.2.12</log4j.version>
  8.  <mysql.version>5.1.6</mysql.version>
  9.  <mybatis.version>3.4.5</mybatis.version>
  10. </properties>
  12. <dependencies>
  14.  <!-- spring -->
  15.  <dependency>
  16.  <groupId>org.aspectj</groupId>
  17.  <artifactId>aspectjweaver</artifactId>
  18.  <version>1.6.8</version>
  19.  </dependency>
  21.  <dependency>
  22.  <groupId>org.springframework</groupId>
  23.  <artifactId>spring-aop</artifactId>
  24.  <version>${spring.version}</version>
  25.  </dependency>
  27.  <dependency>
  28.  <groupId>org.springframework</groupId>
  29.  <artifactId>spring-context</artifactId>
  30.  <version>${spring.version}</version>
  31.  </dependency>
  33.  <dependency>
  34.  <groupId>org.springframework</groupId>
  35.  <artifactId>spring-web</artifactId>
  36.  <version>${spring.version}</version>
  37.  </dependency>
  39.  <dependency>
  40.  <groupId>org.springframework</groupId>
  41.  <artifactId>spring-webmvc</artifactId>
  42.  <version>${spring.version}</version>
  43.  </dependency>
  45.  <dependency>
  46.  <groupId>org.springframework</groupId>
  47.  <artifactId>spring-test</artifactId>
  48.  <version>${spring.version}</version>
  49.  </dependency>
  51.  <dependency>
  52.  <groupId>org.springframework</groupId>
  53.  <artifactId>spring-tx</artifactId>
  54.  <version>${spring.version}</version>
  55.  </dependency>
  57.  <dependency>
  58.  <groupId>org.springframework</groupId>
  59.  <artifactId>spring-jdbc</artifactId>
  60.  <version>${spring.version}</version>
  61.  </dependency>
  63.  <dependency>
  64.  <groupId>junit</groupId>
  65.  <artifactId>junit</artifactId>
  66.  <version>4.12</version>
  67.  <scope>compile</scope>
  68.  </dependency>
  70.  <dependency>
  71.  <groupId>mysql</groupId>
  72.  <artifactId>mysql-connector-java</artifactId>
  73.  <version>${mysql.version}</version>
  74.  </dependency>
  76.  <dependency>
  77.  <groupId>javax.servlet</groupId>
  78.  <artifactId>servlet-api</artifactId>
  79.  <version>2.5</version>
  80.  <scope>provided</scope>
  81.  </dependency>
  83.  <dependency>
  84.  <groupId>javax.servlet.jsp</groupId>
  85.  <artifactId>jsp-api</artifactId>
  86.  <version>2.0</version>
  87.  <scope>provided</scope>
  88.  </dependency>
  90.  <dependency>
  91.  <groupId>jstl</groupId>
  92.  <artifactId>jstl</artifactId>
  93.  <version>1.2</version>
  94.  </dependency>
  96.  <!-- log start -->
  97.  <dependency>
  98.  <groupId>log4j</groupId>
  99.  <artifactId>log4j</artifactId>
  100.  <version>${log4j.version}</version>
  101.  </dependency>
  103.  <dependency>
  104.  <groupId>org.slf4j</groupId>
  105.  <artifactId>slf4j-api</artifactId>
  106.  <version>${slf4j.version}</version>
  107.  </dependency>
  109.  <dependency>
  110.  <groupId>org.slf4j</groupId>
  111.  <artifactId>slf4j-log4j12</artifactId>
  112.  <version>${slf4j.version}</version>
  113.  </dependency>
  114.  <!-- log end -->
  115.  <dependency>
  116.  <groupId>org.mybatis</groupId>
  117.  <artifactId>mybatis</artifactId>
  118.  <version>${mybatis.version}</version>
  119.  </dependency>
  121.  <dependency>
  122.  <groupId>org.mybatis</groupId>
  123.  <artifactId>mybatis-spring</artifactId>
  124.  <version>1.3.0</version>
  125.  </dependency>
  127.  <dependency>
  128.  <groupId>c3p0</groupId>
  129.  <artifactId>c3p0</artifactId>
  130.  <version>0.9.1.2</version>
  131.  <type>jar</type>
  132.  <scope>compile</scope>
  133.  </dependency>
  135. </dependencies>
  137. <build>
  138.  <finalName>ssm</finalName>
  139.  <plugins>
  140.  <plugin>
  141.  <groupId>org.apache.maven.plugins</groupId>
  142.  <artifactId>maven-compiler-plugin</artifactId>
  143.  <version>3.2</version>
  144.  <configuration>
  145.  <source>1.8</source>
  146.  <target>1.8</target>
  147.  <encoding>UTF-8</encoding>
  148.  <showWarnings>true</showWarnings>
  149.  </configuration>
  150.  </plugin>
  151.  <plugin>
  152.  <groupId>org.apache.tomcat.maven</groupId>
  153.  <artifactId>tomcat7-maven-plugin</artifactId>
  154.  <version>2.2</version>
  155.  <!--插件使用的相关配置-->
  156.  <configuration>
  157.  <!--端口号-->
  158.  <port>18881</port>
  159.  <!--写当前项目的名字(虚拟路径),如果写/，那么每次访问项目就不需要加项目名字了-->
  160.  <path>/</path>
  161.  <!--解决get请求乱码-->
  162.  <uriEncoding>UTF-8</uriEncoding>
  163.  </configuration>
  164.  </plugin>
  165.  </plugins>
  166. </build>

实体类User

  1. public class User implements Serializable {
  2.  private String number;
  3.  private String name;
  4.  private String password;
  5.  private String mobile;
  6.  private String qq;
  7.  private String email;
  8. }

拷贝页面到项目

创建UserController.java

页面数据发送到Controller，创建Controller

  1. @Controller
  2. @RequestMapping(value = "/user")
  3. public class UserController {
  5.  @Autowired
  6.  private UserService userService;
  8.  /***
  9.      * 增加用户
  10.      * @param user
  11.      * @return
  12.      */
  13.  @RequestMapping(value = "/save")
  14.  public String save(User user){
  15.  //增加
  16.  int acount = userService.saveUser(user);
  18.  if(acount>0){
  19.  //新增成功，返回登录页面
  20.  return "redirect:/login.html";
  21.  }else{
  22.  //新增失败，返回注册页面
  23.  return "redirect:/register.html";
  24.  }
  25.  }
  27. }

创建接口UserService.java和实现类UserServiceImpl.java

  1. public interface UserService {
  3.  /***
  4.      * 增加用户
  5.      * @param user
  6.      * @return
  7.      */
  8.  int saveUser(User user);
  9. }
  1. @Service
  2. public class UserServiceImpl implements UserService {
  4.  @Autowired
  5.  private UserDao userDao;
  7.  public int saveUser(User user) {
  8.  return userDao.save(user);
  9.  }
  10. }

如果是注解的方式配置声明式事务处理，需要添加在UserServiceImpl的类上添加：@Transactional

创建接口UserDao.java

  1. //@Repository
  2. public interface UserDao {
  4.  /***
  5.      * 增加操作
  6.      * @param user
  7.      * @return
  8.      */
  9.  @Insert("insert into user(number,password,mobile)values(#{number},#{password},#{mobile})")
  10.  int save(User user);
  12. }

修改页面

  1. <form id="subform" action="/user/save" method="post" class="sui-form form-horizontal">
  2.  <div class="control-group">
  3.  <label class="control-label">用户名：</label>
  4.  <div class="controls">
  5.  <input type="text" name="number" placeholder="请输入你的用户名" class="input-xfat input-xlarge">
  6.  </div>
  7.  </div>
  8.  <div class="control-group">
  9.  <label for="inputPassword" class="control-label">登录密码：</label>
  10.  <div class="controls">
  11.  <input type="password" id="pwd" name="password" placeholder="设置登录密码" class="input-xfat input-xlarge">
  12.  </div>
  13.  </div>
  14.  <div class="control-group">
  15.  <label for="inputPassword" class="control-label">确认密码：</label>
  16.  <div class="controls">
  17.  <input type="password" id="rpwd" placeholder="再次确认密码" class="input-xfat input-xlarge">
  18.  </div>
  19.  </div>
  21.  <div class="control-group">
  22.  <label class="control-label">手机号：</label>
  23.  <div class="controls">
  24.  <input type="text" name="mobile" placeholder="请输入你的手机号" class="input-xfat input-xlarge">
  25.  </div>
  26.  </div>
  28.  <div class="control-group">
  29.  <label for="inputPassword" class="control-label">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</label>
  30.  <div class="controls">
  31.  <input name="m1" type="checkbox" value="2" checked=""><span>同意协议并注册《品优购用户协议》</span>
  32.  </div>
  33.  </div>
  34.  <div class="control-group">
  35.  <label class="control-label"></label>
  36.  <div class="controls btn-reg">
  37.  <button class="sui-btn btn-block btn-xlarge btn-danger" type="button" id="btn">完成注册</button>
  38.  </div>
  39.  </div>
  40. </form>
  1. <script src="plugins/jQuery/jquery-2.2.3.min.js"></script>
  2. <script>
  3.     $(function () {
  4.  /*
  5.         * 点击注册按钮
  6.         *     判断2次密码是否一致
  7.         *     如果一致，提交到后台，否则提示错误
  8.         * */
  9.         $('#btn').click(function () {
  10.  //获取2次密码
  11.  var pwd = $('#pwd').val();
  13.  var rpwd=$('#rpwd').val();
  15.  if(pwd==rpwd){
  16.  //提交到后台
  17.                 $('#subform').submit();
  18.  }else{
  19.  //提示
  20.                 alert("2次密码输入有误")
  21.  }
  22.  });
  24.  });
  25. </script>

1562514308085

用户登录

login.html登录页面

  1. <form class="sui-form" action="/user/login" method="post">
  2.  <div class="input-prepend"><span class="add-on loginname"></span>
  3.  <input id="prependedInput" type="text" name="number" placeholder="邮箱/用户名/手机号" class="span2 input-xfat">
  4.  </div>
  5.  <div class="input-prepend"><span class="add-on loginpwd"></span>
  6.  <input id="prependedInput" type="password" name="password" placeholder="请输入密码" class="span2 input-xfat">
  7.  </div>
  8.  <div class="setting">
  9.  <label class="checkbox inline"><input name="m1" type="checkbox" value="2" checked="">自动登录</label>
  10.  <span class="forget">忘记密码？</span>
  11.  </div>
  12.  <div class="logined">
  13.  <button class="sui-btn btn-block btn-xlarge btn-danger" type="submit">登&nbsp;&nbsp;录</button>
  14.  </div>
  15. </form>

UserController.java

  1. /***
  2. * 用户登录
  3. * @return
  4. */
  5. @RequestMapping(value = "/login")
  6. public String login(User user, HttpSession session){
  7.  //数据库查询登录
  8.  User loginUser = userService.findByNumberAndPassword(user);
  10.  //判断loginUser是否为空
  11.  if(loginUser!=null){
  12.  //登录成功跳转到欢迎页
  13.         session.setAttribute("loginUser",user);
  14.  return "redirect:/index/welcome";
  15.  }else{
  16.  //为空，登录失败，继续登录
  17.  return "redirect:/login.html";
  18.  }
  19. }

UserServiceImpl.java

  1. public User findByNumberAndPassword(User user) {
  2.  return userDao.findByNumberAndPassword(user);
  3. }

UserDao.java

  1. /****
  2. * 登录
  3. * @param user
  4. * @return
  5. */
  6. @Select("select * from user where number=#{number} and password=#{password}")
  7. User findByNumberAndPassword(User user);
  8. //@Select(value = "select * from user where number = #{number} and password=#{password}")
  9. //User findByNumberAndPassword(@Param("number") String number, @Param("password") String password);

登录成功--->重定向到欢迎页WelcomeController.java

  1. @Controller
  2. @RequestMapping(value = "/index")
  3. public class WelcomeController {
  5.  /***
  6.      * 欢迎页
  7.      * @return
  8.      */
  9.  @RequestMapping(value = "/welcome")
  10.  public String welcome(){
  11.  return "index";
  12.  }
  13. }

将admin下的index.html拷贝到WEB-INF\pages下

同时创建index.jsp，将index.html的内容放置到index.jsp

img

img

在index.jsp中获取登录信息

  1. <!-- Sidebar toggle button-->
  2. <a href="#" class="sidebar-toggle" data-toggle="offcanvas" role="button">
  3.  <span class="sr-only">Toggle navigation</span>
  4. </a>
  5. 欢迎你：${sessionScope.loginUser.number}

整合拦截器

【需求】：用户如果已经登录

​ 用户如果没有登录，则不能访问欢迎页

LoginInterceptor.java

声明拦截器

创建包com.le.ssm.interceptor

创建类LoginInterceptor.java

  1. public class LoginInterceptor implements HandlerInterceptor {
  3.  @Override
  4.  public boolean preHandle(HttpServletRequest request, HttpServletResponse response, Object handler) throws Exception {
  6.  /****
  7.          * 用户是否在线
  8.          * 如果不在线，不允许访问欢迎页
  9.          */
  10.  Object loginUser = request.getSession().getAttribute("loginUser");
  12.  if(loginUser==null){
  13.             response.sendRedirect(request.getContextPath()+"/login.html");
  14.  return false;
  15.  }
  17.  return true;
  18.  }
  19. }

springmvc.xml

  1. <!--配置拦截器-->
  2.  <mvc:interceptors>
  3.  <mvc:interceptor>
  4.  <!--拦截 的url，所有拦截-->
  5.  <mvc:mapping path="/**"/>
  6.  <!--排除-->
  7.  <mvc:exclude-mapping path="/*.html"></mvc:exclude-mapping>
  8.  <mvc:exclude-mapping path="/js/**"></mvc:exclude-mapping>
  9.  <mvc:exclude-mapping path="/css/**"></mvc:exclude-mapping>
  10.  <mvc:exclude-mapping path="/img/**"></mvc:exclude-mapping>
  11.  <mvc:exclude-mapping path="/plugins/**"></mvc:exclude-mapping>
  12.  <mvc:exclude-mapping path="/user/save"></mvc:exclude-mapping>
  13.  <mvc:exclude-mapping path="/user/login"></mvc:exclude-mapping>
  14.  <bean class="com.le.ssm.interceptor.SessionInterceptor"></bean>
  15.  </mvc:interceptor>
  16.  </mvc:interceptors>

【测试】重新启动，在没有Session的情况下，访问/index/welcome，此时重定向到登录页面。

posted @ 2019-07-07 23:56  不穿格子衫的徍爺  阅读(262)  评论(0)  编辑  收藏  举报