• springMVC

    MVC：控制器(Controller)，模型(model)，视图(view)

    Controller：1.  取得表单数据

                        2. 调用业务逻辑

                        3. 转向指定的页面

    model：1. 业务逻辑

                  2. 保持数据的状态

    view：1. 显示页面

    对数据库进行增删改查，大同小异，在此进行数据库中数据删除的详细叙述

    项目结构

     项目的详细流程

     图解描述：由首页allbook.jsp文件点击链接bookService.interferce方法，由bookService.Impl对接口中的方法进行xml配置文件的bean容器来装配，bookMapper.interferce获取allbook.jsp文件中传入的数据注入到方法中，bookMapper.xml文件调用数据库SQL语句进行方法的重写，由springservice.xml文件将数据注入到bookService.java中，bookService.java返回数据，BookController.java对传入deletebook方法数据进行拦截，调用bookService.interferce中的方法，进行返回数据的重定向到首页allbook.jsp页面。

    allbook.jsp

    1. <%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
    2. <%@ page contentType="text/html;charset=UTF-8" language="java" %>
    3. <html>
    4. <head>
    5.     <title>书籍展示title>
    6.  
    7.     <link href="https://cdn.staticfile.org/twitter-bootstrap/3.3.7/css/bootstrap.min.css" rel="stylesheet">
    8. head>
    9. <body>
    10.  
    11. <div class="container">
    12.     <div class="row clearfix">
    13.         <div class="col-md-12 column">
    14.             <div class="page-header">
    15.                 <h1>
    16.                     <small>书籍列表 —————— 显示所有书籍small>
    17.                 h1>
    18.             div>
    19.         div>
    20.         <div class="row">
    21.             <div class="col-md-4 column">
    22.                 <a class="btn btn-primary" href="${pageContext.request.contextPath}/book/toAddBook">新增书籍a>
    23.                 <a class="btn btn-primary" href="${pageContext.request.contextPath}/book/allbook">全部书籍a>
    24.             div>
    25.             <div class="col-md-4 column">div>
    26.             <div class="col-md-4 column">
    27.                 <form class="form-inline" action="${pageContext.request.contextPath}/book/queryBook" method="post" style="float:right">
    28.                     <span style="color: red; font-weight: bold">${error}span>
    29.                     <input type="text" name="queryBookName" class="form-control" placeholder="请输入要查询的书籍名称">
    30.                     <input type="submit" value="查询" class="btn btn-primary">
    31.                 form>
    32.             div>
    33.         div>
    34.     div>
    35. div>
    36.  
    37. <div class="row clearfix">
    38.     <div class="col-md-12 column">
    39.         <table class="table table-hover table-striped">
    40.             <thead>
    41.             <tr>
    42.                 <th>书籍编号th>
    43.                 <th>书籍名称th>
    44.                 <th>书籍数量th>
    45.                 <th>书籍详情th>
    46.                 <th>操作th>
    47.             tr>
    48.             thead>
    49.             <tbody>
    50.             <c:forEach var="book" items="${list}">
    51.                 <tr>
    52.                     <td>${book.bookID}td>
    53.                     <td>${book.bookName}td>
    54.                     <td>${book.bookCounts}td>
    55.                     <td>${book.detail}td>
    56.                     <td>
    57.                         <img width="40px" height="45px" src="${pageContext.request.contextPath}/image/1.jpg" alt="Responsive image" class="img-rounded">
    58.                     td>
    59.                     <td>
    60.                         <a href="${pageContext.request.contextPath}/book/toUpdate?id=${book.bookID}">修改a>
    61.                           |  
    62.                         <a href="${pageContext.request.contextPath}/book/deleteBook/${book.bookID}">删除a>
    63.                     td>
    64.                 tr>
    65.             c:forEach>
    66.             tbody>
    67.         table>
    68.     div>
    69. div>
    70.  
    71.  
    72. body>
    73. html>

     bookService.interferce

    1. package com.cheng.service;
    2.  
    3. import com.cheng.pojo.books;
    4. import org.apache.ibatis.annotations.Param;
    5.  
    6. import java.util.List;
    7.  
    8. public interface bookService {
    9.  
    10.     //删除书
    11.     int deleteBookById( int id);
    12.     //增加书
    13.     int addBook(books books);
    14.     //更新书
    15.     int updateBook(books books);
    16.     //查询书
    17.     books queryBookById(int id);
    18.     //查询所有书
    19.     List queryAllBook();
    20.  
    21.     books queryBookName(String bookName);
    22. }

    bookService.Impl

    1. package com.cheng.service;
    2.  
    3. import com.cheng.dao.BookMapper;
    4. import com.cheng.pojo.books;
    5. import org.springframework.beans.factory.annotation.Autowired;
    6. import org.springframework.stereotype.Service;
    7.  
    8. import java.util.ArrayList;
    9. import java.util.List;
    10.  
    11. @Service
    12. public class bookServiceImpl implements bookService{
    13.    //service层调dao层：组合dao
    14.     @Autowired
    15.     private BookMapper bookMapper;
    16.  
    17.     public void setBookMapper(BookMapper bookMapper) {
    18.         this.bookMapper = bookMapper;
    19.     }
    20.  
    21.     public int deleteBookById(int id) {
    22.        return bookMapper.deleteBookById(id);
    23.     }
    24.  
    25.     public int addBook(books books) {
    26.        return bookMapper.addBook(books);
    27.     }
    28.  
    29.     public int updateBook(books books) {
    30.        return bookMapper.updateBook(books);
    31.     }
    32.  
    33.     public books queryBookById(int id) { return bookMapper.queryBookById(id); }
    34.  
    35.     public List queryAllBook() {
    36.         return bookMapper.queryAllBook();
    37.     }
    38.  
    39.     public books queryBookName(String bookName) {
    40.         return bookMapper.queryBookName(bookName);
    41.     }
    42. }

    bookMapper.interferce

    1. package com.cheng.dao;
    2.  
    3. import com.cheng.pojo.books;
    4. import org.apache.ibatis.annotations.Param;
    5.  
    6. import java.util.List;
    7.  
    8. public interface BookMapper {
    9.  
    10.     //删除书
    11.     int deleteBookById(@Param("bookID") int id);
    12.     //增加书
    13.     int addBook(books books);
    14.     //更新书
    15.     int updateBook(books books);
    16.     //查询书
    17.     books queryBookById(@Param("bookID") int id);
    18.     //查询所有书
    19.     List queryAllBook();
    20.  
    21.     //通过名字查询书籍
    22.     books queryBookName(@Param("bookName")String bookName);
    23. }

    bookMapper.xml

    1. "1.0" encoding="UTF-8" ?>
    2. mapper
    3.         PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
    4.         "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
    5. <mapper namespace="com.cheng.dao.BookMapper">
    6.     <delete id="deleteBookById" parameterType="books">
    7.         delete from ssmbuild.books
    8.         where bookID = #{bookID}
    9.     delete>
    10.     <insert id="addBook" parameterType="books">
    11.         insert into ssmbuild.books(bookID,bookName,bookCounts,detail)
    12.         values (#{bookID},#{bookName},#{bookCounts},#{detail})
    13.     insert>
    14.     <update id="updateBook" parameterType="books">
    15.         update ssmbuild.books
    16.         set bookName=#{bookName},bookCounts=#{bookCounts},detail=#{detail}
    17.         where bookID=#{bookID};
    18.     update>
    19.     <select id="queryBookById" resultType="books">
    20.         select * from ssmbuild.books
    21.         where bookID=#{bookID}
    22.     select>
    23.     <select id="queryAllBook" resultType="books">
    24.         select * from ssmbuild.books
    25.     select>
    26.     <select id="queryBookName" resultType="books">
    27.         select * from ssmbuild.books
    28.         where bookName=#{bookName}
    29.     select>
    30. mapper>

    springservice.xml

    1. "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:tx="http://www.springframework.org/schema/tx" xmlns:aop="http://www.springframework.org/schema/aop"
    6.        xsi:schemaLocation="http://www.springframework.org/schema/beans
    7.         http://www.springframework.org/schema/beans/spring-beans.xsd
    8.         http://www.springframework.org/schema/context
    9.          https://www.springframework.org/schema/context/spring-context.xsd
    10.           http://www.springframework.org/schema/tx
    11.           http://www.springframework.org/schema/tx/spring-tx.xsd http://www.springframework.org/schema/aop https://www.springframework.org/schema/aop/spring-aop.xsd">
    12.  
    14.     <context:component-scan base-package="com.cheng.service"/>
    15.  
    16.     <bean id="BookServiceImpl" class="com.cheng.service.bookServiceImpl">
    17.         <property name="bookMapper" ref="bookMapper"/>
    19.     bean>
    20.  
    21.     <bean id="transactionmanager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
    22.         <property name="dataSource" ref="dataSource"/>
    23.     bean>
    24.  
    25.     <tx:advice id="txAdvice" transaction-manager="transactionmanager">
    26.         <tx:attributes>
    27.             <tx:method name="*" propagation="REQUIRED"/>
    28.         tx:attributes>
    29.     tx:advice>
    30.  
    31.     <aop:config>
    32.         <aop:pointcut id="txPointCut" expression="execution(* com.cheng.dao.*.*(..))"/>
    33.         <aop:advisor advice-ref="txAdvice" pointcut-ref="txPointCut"/>
    34.     aop:config>
    35. beans>

    bookController.java

    1. package com.cheng.controller;
    2.  
    3. import com.cheng.pojo.books;
    4. import com.cheng.service.bookService;
    5. import org.springframework.beans.factory.annotation.Autowired;
    6. import org.springframework.beans.factory.annotation.Qualifier;
    7. import org.springframework.stereotype.Controller;
    8. import org.springframework.ui.Model;
    9. import org.springframework.web.bind.annotation.PathVariable;
    10. import org.springframework.web.bind.annotation.RequestMapping;
    11. import org.springframework.web.bind.annotation.RequestParam;
    12. import org.springframework.web.multipart.MultipartFile;
    13. import org.springframework.web.multipart.commons.CommonsMultipartFile;
    14. import org.springframework.web.servlet.ModelAndView;
    15.  
    16. import javax.servlet.http.HttpServletRequest;
    17. import javax.servlet.http.HttpServletResponse;
    18. import javax.servlet.http.HttpSession;
    19. import java.io.*;
    20. import java.util.ArrayList;
    21. import java.util.List;
    22.  
    23. @Controller
    24. @RequestMapping("/book")
    25. public class BookController {
    26.     @Autowired
    27.     @Qualifier("BookServiceImpl")
    28.     private bookService bookService;
    29.  
    30.     @RequestMapping("/allbook")
    31.     public String list(Model model){
    32.         List books = bookService.queryAllBook();
    33.         model.addAttribute("list",books);
    34.         return "allbook";
    35.     }
    36.  
    37. //    心得：
    38. //          1 . 先是进入index.jsp页面
    39. //          2 . 点击allBook.jsp的超链接后，跳转到allBook.jsp页面
    40. //          3 . 点击toAddBook链接，跳转到注释对应的方法（toAddPaper）
    41. //          4 . 通过注释对应的方法，获取对应的信息，跳转到对应的jsp页面（addBook.jsp）
    42. //          5 . 执行jsp页面的方法，跳转到注释对应的方法，并且传递文本框中的book信息
    43. //          6 . 通过jsp页面对应的方法，将信息整合成一个book类，使用service层接口中的方法，
    44. //
    45. //                  7 . 通过实现service层对应的方法的类，调用dao层的xml文件（BookMapper.xml）中的sql语句，修改数据库信息
    46. //
    47. //              并且重定向跳转到查询全部书籍方法，并跳转到全部书籍信息展示页面
    48.  
    49.  
    50.  
    51.  
    52.  
    53. @RequestMapping("/toAddBook")
    54.     public String toAddPaper(){
    55.         return "addBook";
    56.     }
    57.  
    58.     @RequestMapping("/addBook")
    59.     public String addBook(books books){
    60.         bookService.addBook(books);
    61.         return "redirect:/book/allbook";
    62.     }
    63.  
    64.     @RequestMapping("/toUpdate")
    65.     public String toUpdatePaper(int id,Model model){
    66.         books books = bookService.queryBookById(id);
    67.         model.addAttribute("Qbooks",books);
    68.         return "updateBook";
    69.     }
    70.  
    71.     @RequestMapping("/updateBook")  //处理到updateBook的请求
    72.     public String UpdateBook(books books){
    73.         int i = bookService.updateBook(books);
    74.         return "redirect:/book/allbook";
    75.     }
    76.     @RequestMapping("/deleteBook/{bookID}")
    77.     public String deleteBook(@PathVariable("bookID") int id){
    78.         bookService.deleteBookById(id);
    79.         return "redirect:/book/allbook";
    80.     }
    81.     @RequestMapping("/queryBook")
    82.     public String queryBook(String queryBookName,Model model){
    83.         books books = bookService.queryBookName(queryBookName);
    84.         List list = new ArrayList();
    85.         list.add(books);
    86.         model.addAttribute("list",list);
    87.         return "allbook";
    88.     }
    89.  
    90.  
    91.  
    92. }
    93.

    其余的配置文件：

    applicationContext.xml

    1. "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.        xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd http://www.springframework.org/schema/context https://www.springframework.org/schema/context/spring-context.xsd">
    6.  
    8. <bean id="multipartResolver" class="org.springframework.web.multipart.commons.CommonsMultipartResolver">
    9.     <property name="defaultEncoding" value="utf-8" />
    10.     <property name="maxUploadSize" value="10485760" />
    11.     <property name="maxInMemorySize" value="40960" />
    12. bean>
    13.  
    14.     <import resource="spring-dao.xml"/>
    15.     <import resource="spring-mvc.xml"/>
    16.     <import resource="spring.service.xml"/>
    17. beans>

    mybatis-config.xml

    1. "1.0" encoding="UTF-8" ?>
    2. configuration
    3.         PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
    4.         "http://mybatis.org/dtd/mybatis-3-config.dtd">
    5. <configuration>
    6.  
    8.     <settings>
    9.         <setting name="logImpl" value="STDOUT_LOGGING"/>
    10.     settings>
    11.  
    13. <typeAliases>
    14.     <package name="com.cheng.pojo"/>
    15. typeAliases>
    16.  
    17.  
    19. <mappers>
    20.     <mapper class="com.cheng.dao.BookMapper">mapper>
    21. mappers>
    22.  
    23. configuration>

    spring-dao.xml

    1. "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.        xsi:schemaLocation="http://www.springframework.org/schema/beans
    7.        http://www.springframework.org/schema/beans/spring-beans.xsd
    8.        http://www.springframework.org/schema/context
    9.        https://www.springframework.org/schema/context/spring-context.xsd
    10.        http://www.springframework.org/schema/aop
    11.        https://www.springframework.org/schema/aop/spring-aop.xsd">
    12.  
    14.     <context:property-placeholder location="classpath:jdbc.properties"/>
    17.         <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
    18.             <property name="driverClass" value="${jdbc.driver}" />
    19.             <property name="jdbcUrl" value="${jdbc.url}"/>
    20.             <property name="user" value="${jdbc.username}"/>
    21.             <property name="password" value="${jdbc.password}"/>
    22.  
    23.             <property name="maxPoolSize" value="30"/>
    24.             <property name="minPoolSize" value="10"/>
    25.             <property name="autoCommitOnClose" value="false" />
    26.             <property name="checkoutTimeout" value="10000"/>
    27.             <property name="acquireRetryAttempts" value="2"/>
    28.         bean>
    29.  
    30.  
    31.     <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
    32.         <property name="dataSource" ref="dataSource" />
    33.         <property name="configLocation" value="classpath:mybatis-config.xml"/>
    34.     bean>
    35.  
    36.     <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
    37.     <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/>
    38.         <property name="basePackage" value="com.cheng.dao"/>
    39.     bean>
    40.  
    41.  
    42. beans>

    spring-mvc.xml

    1. "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:mvc="http://www.springframework.org/schema/mvc"
    5.        xmlns:context="http://www.springframework.org/schema/context"
    6.        xsi:schemaLocation="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.          https://www.springframework.org/schema/context/spring-context.xsd">
    12.  
    14.     <mvc:annotation-driven/>
    16.     <mvc:default-servlet-handler/>
    18.     <context:component-scan base-package="com.cheng.controller"/>
    20.     <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
    21.         <property name="prefix" value="/WEB-INF/jsp/"/>
    22.         <property name="suffix" value=".jsp"/>
    23.     bean>
    30. beans>

    index.jsp

    1. <%@ page contentType="text/html;charset=UTF-8" language="java" %>
    2. <html>
    3. <head>
    4. <style>
    5.     a{
    6.         text-decoration: none;
    7.         color: black;
    8.         font-size: 18px;
    9.     }
    10.     h3{
    11.         width: 180px;
    12.         height: 38px;
    13.         margin: 100px auto;
    14.         text-align: center;
    15.         line-height: 38px;
    16.         background: dodgerblue;
    17.         border-radius: 5px;
    18.     }
    19. style>
    20. head>
    21. <body>
    22. <h3>
    23.     <a href="${pageContext.request.contextPath}/book/allbook">进入书籍页面a>
    24. h3>
    25. body>
    26. html>

    jdbc.properties

    1. jdbc.driver=com.mysql.jdbc.Driver
    2. jdbc.url=jdbc:mysql://localhost:3306/ssmbuild?useSSL=true&useUnicode=true&serverTimezone=UTC
    3. jdbc.username=root
    4. jdbc.password=123456

    pom.xml

    1. "1.0" encoding="UTF-8"?>
    2.  
    3. <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    4.   xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    5.   <modelVersion>4.0.0modelVersion>
    6.  
    7.   <groupId>com.chenggroupId>
    8.   <artifactId>ssmbuildartifactId>
    9.   <version>1.0-SNAPSHOTversion>
    10.   <packaging>warpackaging>
    11.  
    14.  
    16.   <dependencies>
    17.     <dependency>
    18.       <groupId>junitgroupId>
    19.       <artifactId>junitartifactId>
    20.       <version>4.13.1version>
    21.       <scope>testscope>
    22.     dependency>
    23.     <dependency>
    24.       <groupId>mysqlgroupId>
    25.       <artifactId>mysql-connector-javaartifactId>
    26.       <version>8.0.16version>
    27.     dependency>
    28.     <dependency>
    29.       <groupId>com.mchangegroupId>
    30.       <artifactId>c3p0artifactId>
    31.       <version>0.9.5.2version>
    32.       <type>jartype>
    33.       <scope>compilescope>
    34.     dependency>
    35.     <dependency>
    36.       <groupId>org.mybatisgroupId>
    37.       <artifactId>mybatisartifactId>
    38.       <version>3.5.1version>
    39.     dependency>
    40.     <dependency>
    41.       <groupId>org.mybatisgroupId>
    42.       <artifactId>mybatis-springartifactId>
    43.       <version>1.3.1version>
    44.     dependency>
    45.  
    46.     <dependency>
    47.       <groupId>javax.servlet.jspgroupId>
    48.       <artifactId>jsp-apiartifactId>
    49.       <version>2.0version>
    50.     dependency>
    51.     <dependency>
    52.       <groupId>javax.servletgroupId>
    53.       <artifactId>servlet-apiartifactId>
    54.       <version>2.5version>
    55.     dependency>
    56.     <dependency>
    57.       <groupId>jstlgroupId>
    58.       <artifactId>jstlartifactId>
    59.       <version>1.2version>
    60.     dependency>
    61.     <dependency>
    62.       <groupId>org.aspectjgroupId>
    63.       <artifactId>aspectjweaverartifactId>
    64.       <version>1.9.8.M1version>
    65.     dependency>
    66.  
    67.  
    68.     <dependency>
    69.       <groupId>org.springframeworkgroupId>
    70.       <artifactId>spring-webmvcartifactId>
    71.       <version>5.1.9.RELEASEversion>
    72.     dependency>
    73.     <dependency>
    74.       <groupId>org.springframeworkgroupId>
    75.       <artifactId>spring-jdbcartifactId>
    76.       <version>5.1.9.RELEASEversion>
    77.     dependency>
    78.  
    80.     <dependency>
    81.       <groupId>org.projectlombokgroupId>
    82.       <artifactId>lombokartifactId>
    83.       <version>1.18.8version>
    84.     dependency>
    85.     <dependency>
    86.       <groupId>commons-fileuploadgroupId>
    87.       <artifactId>commons-fileuploadartifactId>
    88.       <version>1.3.3version>
    89.     dependency>
    90.   dependencies>
    91.  
    93.   <build>
    94.     <resources>
    95.       <resource>
    96.         <directory>src/main/javadirectory>
    97.         <includes>
    98.           <include>**/*.propertiesinclude>
    99.           <include>**/*.xmlinclude>
    100.         includes>
    101.           <filtering>falsefiltering>
    102.       resource>
    103.       <resource>
    104.         <directory>src/main/resourcesdirectory>
    105.         <includes>
    106.           <include>**/*.propertiesinclude>
    107.           <include>**/*.xmlinclude>
    108.         includes>
    109.         <filtering>falsefiltering>
    110.       resource>
    111.     resources>
    112.       <plugins>
    113.           <plugin>
    114.               <groupId>org.apache.maven.pluginsgroupId>
    115.               <artifactId>maven-compiler-pluginartifactId>
    116.               <configuration>
    117.                   <source>7source>
    118.                   <target>7target>
    119.               configuration>
    120.           plugin>
    121.       plugins>
    122.   build>
    123. project>

  • 相关阅读:
    红外超声波雷达测距
    You must install at least one postgresql-client-＜version＞ package
    windows下的文件路径怎么在pycharm中使用(python)
    数字图像处理:亮度对比度-几何变换-噪声处理
    Lombok的@Data注解包含的方法（没有全参构造方法）
    FPGA零基础学习：半导体存储器和可编程逻辑器件简介
    [含毕业设计论文+PPT+源码等]ssm的房屋交易平台+Java后台管理系统|前后分离VUE
    【Docker】了解和使用Docker
    自学SAP是学习ECC版本还是S4版本？
    elasticSearch配置
  • 原文地址：https://blog.csdn.net/qq_33755492/article/details/126966746