ssm(三)-springmvc+spring+mybatis

一:引入依赖-----pom.xml

<!--控制层开始-->
<dependency>
  <groupId>org.springframework</groupId>
  <artifactId>spring-webmvc</artifactId>
  <version>5.0.2.RELEASE</version>
</dependency>
<dependency>
  <groupId>javax.servlet</groupId>
  <artifactId>servlet-api</artifactId>
  <version>2.5</version>
  <scope>provided</scope>
</dependency>
<dependency>
  <groupId>javax.servlet</groupId>
  <artifactId>jsp-api</artifactId>
  <version>2.0</version>
  <scope>provided</scope>
</dependency>
<!-- JSTL标签库 -->
<dependency>
  <groupId>jstl</groupId>
  <artifactId>jstl</artifactId>
  <version>1.2</version>
</dependency>
<dependency>
  <groupId>taglibs</groupId>
  <artifactId>standard</artifactId>
  <version>1.1.2</version>
</dependency>
<!--控制层结束-->

二:编写控制层配置文件-------spring-mvc.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"
       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.xsd
       http://www.springframework.org/schema/mvc
       http://www.springframework.org/schema/mvc/spring-mvc.xsd">
    <!--开启注解扫描包创建对象-->
    <context:component-scan base-package="com.it.controller"></context:component-scan>
    <!--视图解析器-->
    <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
        <property name="prefix" value="/pages/"></property>
        <property name="suffix" value=".jsp"></property>
    </bean>
    <!--注解驱动-->
    <mvc:annotation-driven></mvc:annotation-driven>
    <!--文件上传-->
    <!--静态资源放行-->
    <!--<mvc:resources mapping="/js/*" location="/js/"></mvc:resources>-->
    <!--<mvc:resources mapping="/css/*" location="/css/"></mvc:resources>-->
    <!--静态资源全部放行-->
    <mvc:default-servlet-handler></mvc:default-servlet-handler>
    <!--自定义类型转换器-->
    <!--配置登录拦截器-->
    <mvc:interceptors>
        <!--配置单个拦截器对象-->
        <mvc:interceptor>
            <!--拦截所有的请求-->
            <mvc:mapping path="/**"/>
            <!--指定拦截器类-->
            <!--如果拦截了静态资源，需要配置放行-->
            <mvc:exclude-mapping path="/js/*"></mvc:exclude-mapping>
            <mvc:exclude-mapping path="/css/*"></mvc:exclude-mapping>
            <mvc:exclude-mapping path="/fonts/*"></mvc:exclude-mapping>
            <bean class="com.it.interceptor.LoginInterceptor"></bean>
        </mvc:interceptor>
    </mvc:interceptors>
</beans>

三:编写控制类------AccountController.java

@Controller
@RequestMapping("/account")
public class AccountController {
    @Autowired
    AccountService accountService;

    /*查询全部*/
    @RequestMapping("/findAll")
    public ModelAndView findAll(){
        /*创建模型视图对象*/
        ModelAndView modelAndView = new ModelAndView();
        /*添加数据*/
        List<Account> accountList = accountService.findAll();
        modelAndView.addObject("accountList",accountList);
        /*指定页面*/
        modelAndView.setViewName("show");
        return modelAndView;
    }
    /*添加*/
    @RequestMapping("/save")
    public String save(Account account){
        accountService.save(account);
        /*重定向*/
        return "redirect:findAll";
    }
    /*删除*/
    @RequestMapping("/delete")
    public String delete(Integer id){
        accountService.delete(id);
        return "redirect:findAll";
    }
    /*修改数据回显*/
    @RequestMapping("/updateUI")
    public ModelAndView updateUI(Integer id){
        ModelAndView modelAndView = new ModelAndView();
        Account account = accountService.findById(id);
        modelAndView.addObject("account",account);
        modelAndView.setViewName("update");
        return modelAndView;
    }
    /*修改*/
    @RequestMapping("/update")
    public String Update(Account account){
        System.out.println(account);
        accountService.update(account);
        return "redirect:findAll";
    }
}

四:引入相关js,css之后,编写页面代码
show.jsp

<%@page isELIgnored="false" contentType="text/html;charset=UTF-8" language="java" %>
<%--引入c 标签--%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<html>
<!-- 引入JS文件 -->
<script type="text/javascript" src="${pageContext.request.contextPath}/js/jquery-1.9.1.js"></script>
<script type="text/javascript" src="${pageContext.request.contextPath}/js/bootstrap.min.js"></script>
<!-- 引入CSS样式 -->
<link rel="stylesheet" href="${pageContext.request.contextPath}/css/bootstrap.min.css">
<head>
    <title>Title</title>
</head>
<body>
<table class="table table-striped">
    <caption>
        <a href="${pageContext.request.contextPath}/pages/add.jsp" class="btn btn-primary" >添加</a>
    </caption>
    <thead>
    <tr>
        <th>编号</th>
        <th>账户名</th>
        <th>金额</th>
        <th>删除</th>
        <th>修改</th>
    </tr>
    </thead>
    <tbody>
    <%--foreach循环
        items: 要循环的集合对象
        var：循环中的每一个对象
    --%>
    <c:forEach items="${accountList}" varStatus="i" var="account">
        <tr>
            <td>${i.count}</td>
            <td>${account.name}</td>
            <td>${account.money}</td>
            <td><a href="${pageContext.request.contextPath}/account/delete?id=${account.id}" class="btn btn-primary" >删除</a></td>
            <td><a href="${pageContext.request.contextPath}/account/updateUI?id=${account.id}" class="btn btn-primary" >修改</a></td>
        </tr>
    </c:forEach>
    </tbody>
</table>
</body>
</html>

add.jsp

<%@page isELIgnored="false" contentType="text/html;charset=UTF-8" language="java" %>
<html>
<!-- 引入JS文件 -->
<script type="text/javascript" src="${pageContext.request.contextPath}/js/jquery-1.9.1.js"></script>
<script type="text/javascript" src="${pageContext.request.contextPath}/js/bootstrap.min.js"></script>
<!-- 引入CSS样式 -->
<link rel="stylesheet" href="${pageContext.request.contextPath}/css/bootstrap.min.css">
<head>
    <title>Title</title>
</head>
<body>
<form class="form-horizontal" role="form" action="${pageContext.request.contextPath}/account/save">
    <div class="form-group">
        <label for="name" class="col-sm-2 control-label">账户名</label>
        <div class="col-sm-10">
            <input type="text" class="form-control" id="name" name="name"
                   placeholder="请输入账户名">
        </div>
    </div>
    <div class="form-group">
        <label for="money" class="col-sm-2 control-label">金额</label>
        <div class="col-sm-10">
            <input type="text" class="form-control" id="money" name="money"
                   placeholder="请输入金额">
        </div>
    </div>
    <div class="form-group">
        <div class="col-sm-offset-2 col-sm-10">
            <button type="submit" class="btn btn-default">保存</button>
        </div>
    </div></form>
</body>
</html>

update.jsp

<%@page isELIgnored="false" contentType="text/html;charset=UTF-8" language="java" %>
<html>
<!-- 引入JS文件 -->
<script type="text/javascript" src="${pageContext.request.contextPath}/js/jquery-1.9.1.js"></script>
<script type="text/javascript" src="${pageContext.request.contextPath}/js/bootstrap.min.js"></script>
<!-- 引入CSS样式 -->
<link rel="stylesheet" href="${pageContext.request.contextPath}/css/bootstrap.min.css">
<head>
    <title>Title</title>
</head>
<body>
<form class="form-horizontal" role="form" action="${pageContext.request.contextPath}/account/update">
    <div class="form-group">
        <%--使用隐藏域，保存id的值，更新时作为条件--%>
        <input type="hidden" value="${account.id}" name="id">
    </div>
    <div class="form-group">
        <label for="name" class="col-sm-2 control-label">账户名</label>
        <div class="col-sm-10">
            <input type="text" class="form-control" id="name" name="name"
                   placeholder="请输入账户名" value="${account.name}">
        </div>
    </div>
    <div class="form-group">
        <label for="money" class="col-sm-2 control-label">金额</label>
        <div class="col-sm-10">
            <input type="text" class="form-control" id="money" name="money"
                   placeholder="请输入金额" value="${account.money}">
        </div>
    </div>
    <div class="form-group">
        <div class="col-sm-offset-2 col-sm-10">
            <button type="submit" class="btn btn-default">修改</button>
        </div>
    </div>
</form>
</body>
</html>

五:编写web应用中的配置文件-----web.xml

<!DOCTYPE web-app PUBLIC
        "-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN"
        "http://java.sun.com/dtd/web-app_2_3.dtd" >

<web-app>
    <display-name>Archetype Created Web Application</display-name>

    <!--配置一个全局的参数：指定spring容器的配置文件-->
    <context-param>
        <param-name>contextConfigLocation</param-name>
        <param-value>classpath:applicationContext.xml</param-value>
    </context-param>

    <!--编码过滤器-->
    <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>
        <init-param>
            <param-name>forceEncoding</param-name>
            <param-value>true</param-value>
        </init-param>
    </filter>
    <filter-mapping>
        <filter-name>CharacterEncodingFilter</filter-name>
        <url-pattern>/*</url-pattern>
    </filter-mapping>

    <!--配置监听器：创建spring容器对象-->
    <listener>
        <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
    </listener>

    <!--前端控制器-->
    <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:spring-mvc.xml</param-value>
        </init-param>
    </servlet>
    <servlet-mapping>
        <servlet-name>DispatcherServlet</servlet-name>
        <url-pattern>/</url-pattern>
    </servlet-mapping>

</web-app>

六:添加拦截器类-----LoginInterceptor.java

public class LoginInterceptor implements HandlerInterceptor{
    @Override
    public boolean preHandle(HttpServletRequest request, HttpServletResponse response, Object handler) throws Exception {
        String requestURI = request.getRequestURI();
        //System.out.println(requestURI);//获取到的请求路径为:/user/login
        if (requestURI.contains("login")){
            //如果是登录请求,直接放行
            return true;
        }
        //如果不是登录请求
        //判断session中是否有数据
        Object username = request.getSession().getAttribute("username");
        if (username==null && "".equals(username)){//未登录
            //session没有登录信息，跳转到登录页面
            response.sendRedirect("/login.jsp");
            return false;
        }else{
            return true;
        }
    }
}

七:编写测试拦截器的控制类-----UserController.java

@Controller
@RequestMapping("/user")
@SessionAttributes
public class UserController {
    /**
     *  模拟登录操作
     *   判断用户名和密码是否在数据库中存在，如果存在，登录成功，跳转到查询全部账户页面
     *          如果不存在，登录失败，跳转到登录页面
     *  假设：用户名：zhangsan 密码：123
     * @param username
     * @param password
     * @return
     */
    @RequestMapping("/login")
    public String login(String username, String password, Model model){
        if ("zhangsan".equals(username)&&"123456".equals(password)){
            model.addAttribute("username",username);
            System.out.println("登录成功");
            return "forward:/account/findAll";
        }else{
            System.out.println("登录失败");
            return "redirect:/login.jsp";
        }
    }
}

八:编写测试拦截器的页面------login.jsp

<%@page isELIgnored="false" contentType="text/html;charset=UTF-8" language="java" %>
<html>
<!-- 引入JS文件 -->
<script type="text/javascript" src="${pageContext.request.contextPath}/js/jquery-1.9.1.js"></script>
<script type="text/javascript" src="${pageContext.request.contextPath}/js/bootstrap.min.js"></script>
<!-- 引入CSS样式 -->
<link rel="stylesheet" href="${pageContext.request.contextPath}/css/bootstrap.min.css">
<head>
    <title>Title</title>
</head>
<body>
<form class="form-horizontal" role="form" action="${pageContext.request.contextPath}/user/login">
    <div class="form-group">
        <label for="username" class="col-sm-2 control-label">姓名</label>
        <div class="col-sm-10">
            <input type="text" class="form-control" id="username" name="username"
                   placeholder="请输入姓名">
        </div>
    </div>
    <div class="form-group">
        <label for="password" class="col-sm-2 control-label">姓</label>
        <div class="col-sm-10">
            <input type="password" class="form-control" id="password" name="password"
                   placeholder="请输入密码">
        </div>
    </div>
    <div class="form-group">
        <div class="col-sm-offset-2 col-sm-10">
            <button type="submit" class="btn btn-default">登录</button>
        </div>
    </div>
</form>
</body>
</html>