• SpringMVC：整合SSM框架

    一、大致框架

    1.建立数据库，并导入数据

    create database cjgl; 
    1. create table books(
    2. bookID int(10) not null auto_increment comment '书id',
    3. bookName varchar(100) not null comment '书名',
    4. bookCounts int(11) not null comment '数量',
    5. detail varchar(200) not null comment '描述',
    6. key bookID(bookID)
    7. )engine=innodb default charset=utf8
    1. insert into books(bookID,bookName,bookCounts,detail)values
    2. (1,'java',1,'从入门到放弃'),
    3. (2,'MySQL',10,'从删库到跑路'),
    4. (3,'Linux',5,'从进门到进牢');

    2.新建maven项目SSMZH

    鼠标右键点击SSMZH，添加框架框架支持

    选中web应用程序点击确定

    3.在pom.xml中导入相关的pom依赖！

    1.  <dependencies>
    2.         <dependency>
    3.             <groupId>org.springframeworkgroupId>
    4.             <artifactId>spring-webmvcartifactId>
    5.             <version>5.3.9version>
    6.         dependency>
    7.         <dependency>
    8.             <groupId>org.springframeworkgroupId>
    9.             <artifactId>spring-jdbcartifactId>
    10.             <version>5.3.9version>
    11.         dependency>
    12.  
    13.         <dependency>
    14.             <groupId>junitgroupId>
    15.             <artifactId>junitartifactId>
    16.             <version>4.13.2version>
    17.             <scope>testscope>
    18.         dependency>
    19.         
    20.         <dependency>
    21.             <groupId>mysqlgroupId>
    22.             <artifactId>mysql-connector-javaartifactId>
    23.             <version>8.0.17version>
    24.         dependency>
    25.         
    26.         <dependency>
    27.             <groupId>com.mchangegroupId>
    28.             <artifactId>c3p0artifactId>
    29.             <version>0.9.5.2version>
    30.         dependency>
    31.  
    32.         <dependency>
    33.             <groupId>javax.servletgroupId>
    34.             <artifactId>servlet-apiartifactId>
    35.             <version>2.5version>
    36.         dependency>
    37.         <dependency>
    38.             <groupId>javax.servlet.jspgroupId>
    39.             <artifactId>jsp-apiartifactId>
    40.             <version>2.2version>
    41.         dependency>
    42.         <dependency>
    43.             <groupId>javax.servletgroupId>
    44.             <artifactId>jstlartifactId>
    45.             <version>1.2version>
    46.         dependency>
    47.         <dependency>
    48.             <groupId>org.apache.tomcatgroupId>
    49.             <artifactId>tomcatartifactId>
    50.             <version>8.5.38version>
    51.             <type>pomtype>
    52.         dependency>
    53.  
    54.         
    55.         <dependency>
    56.             <groupId>org.mybatisgroupId>
    57.             <artifactId>mybatisartifactId>
    58.             <version>3.5.6version>
    59.         dependency>
    60.         <dependency>
    61.             <groupId>org.mybatisgroupId>
    62.             <artifactId>mybatis-springartifactId>
    63.             <version>2.0.5version>
    64.         dependency>
    65.     dependencies>
    66.  
    67.     
    68.     <build>
    69.         <resources>
    70.             <resource>
    71.                 <directory>src/main/javadirectory>
    72.                 <includes>
    73.                     <include>**/*.propertiesinclude>
    74.                     <include>**/*.xmlinclude>
    75.                 includes>
    76.                 <filtering>falsefiltering>
    77.             resource>
    78.             <resource>
    79.                 <directory>src/main/resourcesdirectory>
    80.                 <includes>
    81.                     <include>**/*.propertiesinclude>
    82.                     <include>**/*.xmlinclude>
    83.                 includes>
    84.                 <filtering>falsefiltering>
    85.             resource>
    86.         resources>
    87.     build>
    88.  
    89.     <properties>
    90.         <project.build.sourceEncoding>UTF-8project.build.sourceEncoding>
    91.     properties>

    4.添加web模块， 添加web 支持

    鼠标右键点击文件选择项目结构，选择工件，在可用元素中点击第一个按住shift在点击最后一个全选，点击鼠标右键，置于/WEB-INF/lib然后点击确定

    5.建立基本结构和配置框架

    • yj.com.pojo

    • yj.com.mapper(dao)

    • yj.com.service

    • yj.com.controller

    6.在pojo包下建立Books类（和数据库中的表相对应）

     Books中一个四个属性，与表中属性必须的相对应

    全部代码如下：

    1. package yj.com.pojo;
    2. public class Books {
    3.     private int bookID;
    4.     private String bookName;
    5.     private int bookCounts;
    6.     private String detail;
    7.     //添加无参构造、有参构造、getter/setter方法和tostring方法
    8.     public Books() {
    9.     }
    10.     public Books(int bookID, String bookName, int bookCounts, String detail) {
    11.         this.bookID = bookID;
    12.         this.bookName = bookName;
    13.         this.bookCounts = bookCounts;
    14.         this.detail = detail;
    15.     }
    16.     public int getBookID() {
    17.         return bookID;
    18.     }
    19.     public void setBookID(int bookID) {
    20.         this.bookID = bookID;
    21.     }
    22.     public String getBookName() {
    23.         return bookName;
    24.     }
    25.     public void setBookName(String bookName) {
    26.         this.bookName = bookName;
    27.     }
    28.     public int getBookCounts() {
    29.         return bookCounts;
    30.     }
    31.     public void setBookCounts(int bookCounts) {
    32.         this.bookCounts = bookCounts;
    33.     }
    34.     public String getDetail() {
    35.         return detail;
    36.     }
    37.     public void setDetail(String detail) {
    38.         this.detail = detail;
    39.     }
    40.     @Override
    41.     public String toString() {
    42.         return "Books{" +
    43.                 "bookID=" + bookID +
    44.                 ", bookName='" + bookName + '\'' +
    45.                 ", bookCounts=" + bookCounts +
    46.                 ", detail='" + detail + '\'' +
    47.                 '}';
    48.     }
    49. }

    7.在mapper包下建立接口BookMapper

    创建相关操作

    1. package yj.com.mapper;
    2. import yj.com.pojo.Books;
    3. import java.util.List;
    4. public interface BookMapper{
    5.     //增加一个Book
    6.     int addBook(Books books);
    7.     //根据id删除一个Book
    8.     int deleteBookById(int id);
    9.     //更新Book
    10.     int updateBook(Books books);
    11.     //根据id查询,返回一个Book
    12.     Books queryBookById(int id);
    13.     //查询全部Book,返回list集合
    14.     List queryAllBook();
    15. }

    8.在mapper包下建立文件BookMapper.xml并配置

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

     9.在service包下创建接口BookService作业务层

    做的业务和dao层的一样

    1. package yj.com.service;
    2. import yj.com.pojo.Books;
    3. import java.util.List;
    4. public interface BookService {
    5.     //增加一个Book
    6.     int addBook(Books books);
    7.     //根据id删除一个Book
    8.     int deleteBookById(int id);
    9.     //更新Book
    10.     int updateBook(Books books);
    11.     //根据id查询,返回一个Book
    12.     Books queryBookById(int id);
    13.     //查询全部Book,返回list集合
    14.     List queryAllBook();
    15. }

    10.在service下创建类BookServiceImpl

    1. package yj.com.service;
    2. import yj.com.mapper.BookMapper;
    3. import yj.com.pojo.Books;
    4. import java.util.List;
    5. //实现BookService 重写抽象方法
    6. public class BookServiceImpl implements BookService{
    7.     //服务层连接dao层
    8.     //创建一个dao层对象
    9.     private BookMapper bookMapper;
    10.     public void setBookMapper(BookMapper bookMapper) {
    11.         this.bookMapper = bookMapper;
    12.     }
    13.     public int addBook(Books books) {
    14.         return bookMapper.addBook(books);
    15.     }
    16.     public int deleteBookById(int id) {
    17.         return bookMapper.deleteBookById(id);
    18.     }
    19.     public int updateBook(Books books) {
    20.         return bookMapper.updateBook(books);
    21.     }
    22.     public Books queryBookById(int id) {
    23.         return bookMapper.queryBookById(id);
    24.     }
    25.     public List queryAllBook() {
    26.         return bookMapper.queryAllBook();
    27.     }
    28. }

    11.在controller包下创建BookController类

    1. package yj.com.controller;
    2. import org.springframework.beans.factory.annotation.Autowired;
    3. import org.springframework.stereotype.Controller;
    4. import org.springframework.web.bind.annotation.RequestMapping;
    5. import yj.com.service.BookService;
    6. @Controller
    7. @RequestMapping("/book")
    8. public class BookController {
    9.     //控制器调用Service层
    10.     @Autowired
    11.     private BookService bookService;
    12. }

    服务层（BookService）调用dao层（BookMapper），dao层调用pojo,控制器调用服务层

    二、开始建立配置文件

    1.   在resource下建立数据库配置文件database.properties

    1. jdbc.driver=com.mysql.cj.jdbc.Driver
    2. jdbc.url=jdbc:mysql://localhost:3306/cjgl?useSSL=false&serverTimezone=UTC&allowPublicKeyRetrieval=true&characterEncoding=utf-8
    3. jdbc.username=root
    4. jdbc.password=

    2. 在resource下编写MyBatis核心配置文件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.     <typeAliases>
    7.         <package name="yj.com.pojo"/>
    8.     typeAliases>
    9.     <mappers>
    10.         <mapper resource="yj/com/mapper/BookMapper.xml"/>
    11.     mappers>
    12. configuration>

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

    4.Spring整合service层 ， resource下编写配置spring-service.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
    6.    http://www.springframework.org/schema/beans/spring-beans.xsd
    7.    http://www.springframework.org/schema/context
    8.    http://www.springframework.org/schema/context/spring-context.xsd">
    9.     
    10.     <context:component-scan base-package="yj.com.service" />
    11.     
    12.     <bean id="BookServiceImpl" class="yj.com.service.BookServiceImpl">
    13.         <property name="bookMapper" ref="bookMapper"/>
    14.     bean>
    15.     
    16.     <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
    17.         
    18.         <property name="dataSource" ref="dataSource" />
    19.     bean>
    20. beans>

    此处正常有两处应该是红的，如果不是则前面有错误（文件没配置完所以报红）

    5.整合前段 ， resource下编写配置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:context="http://www.springframework.org/schema/context"
    5.        xmlns:mvc="http://www.springframework.org/schema/mvc"
    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.    http://www.springframework.org/schema/context/spring-context.xsd
    10.    http://www.springframework.org/schema/mvc
    11.    https://www.springframework.org/schema/mvc/spring-mvc.xsd">
    12.  
    13.     
    14.     
    15.     <mvc:annotation-driven />
    16.     
    17.     <mvc:default-servlet-handler/>
    18.  
    19.     
    20.     <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
    21.         <property name="viewClass" value="org.springframework.web.servlet.view.JstlView" />
    22.         <property name="prefix" value="/WEB-INF/jsp/" />
    23.         <property name="suffix" value=".jsp" />
    24.     bean>
    25.  
    26.     
    27.     <context:component-scan base-package="yj.com.controller" />
    28. beans>

    6.全局配置文件，resource下编写配置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.        xsi:schemaLocation="http://www.springframework.org/schema/beans
    5.        http://www.springframework.org/schema/beans/spring-beans.xsd">
    6.     <import resource="spring-dao.xml"/>
    7.     <import resource="spring-service.xml"/>
    8.     <import resource="spring-mvc.xml"/>
    9. beans>

    三、配置前段

    1.配置前段控制器（中央控制器）web.xml

    1. "1.0" encoding="UTF-8"?>
    2. <web-app xmlns="http://xmlns.jcp.org/xml/ns/javaee"
    3.          xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    4.          xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_4_0.xsd"
    5.          version="4.0">
    6.  
    7.     <servlet>
    8.         <servlet-name>DispatcherServletservlet-name>
    9.         <servlet-class>org.springframework.web.servlet.DispatcherServletservlet-class>
    10.         <init-param>
    11.             <param-name>contextConfigLocationparam-name>
    12.             <param-value>classpath:applicationContext.xmlparam-value>
    13.         init-param>
    14.         <load-on-startup>1load-on-startup>
    15.     servlet>
    16.     <servlet-mapping>
    17.         <servlet-name>DispatcherServletservlet-name>
    18.         <url-pattern>/url-pattern>
    19.     servlet-mapping>
    20.  
    21.     <filter>
    22.         <filter-name>CharacterEncodingFilterfilter-name>
    23.         <filter-class>org.springframework.web.filter.CharacterEncodingFilterfilter-class>
    24.         <init-param>
    25.             <param-name>encodingparam-name>
    26.             <param-value>utf-8param-value>
    27.         init-param>
    28.     filter>
    29.     <filter-mapping>
    30.         <filter-name>CharacterEncodingFilterfilter-name>
    31.         <url-pattern>/*url-pattern>
    32.     filter-mapping>
    33.  
    34.     <session-config>
    35.         <session-timeout>15session-timeout>
    36.     session-config>
    37. web-app>

    2.在文件WEB-INF下建立目录jsp，如下

    3.配置index.jsp

    1. <%--
    2.   Created by IntelliJ IDEA.
    3.   User: yangj
    4.   Date: 2022/12/5
    5.   Time: 15:12
    6.   To change this template use File | Settings | File Templates.
    7. --%>
    8. <<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8" %>
    9. <html>
    10. <head>
    11.   <title>首页title>
    12.   <style type="text/css">
    13.     a {
    14.       text-decoration: none;
    15.       color: black;
    16.       font-size: 18px;
    17.     }
    18.     h3 {
    19.       width: 180px;
    20.       height: 38px;
    21.       margin: 100px auto;
    22.       text-align: center;
    23.       line-height: 38px;
    24.       background: deepskyblue;
    25.       border-radius: 4px;
    26.     }
    27.   style>
    28. head>
    29. <body>
    30. <h3>
    31.   <a href="${pageContext.request.contextPath}/book/allBook">点击进入图书管理列表a>
    32. h3>
    33. body>
    34. html>
    35.

     4.配置BookController

    1. package yj.com.controller;
    2. import org.springframework.beans.factory.annotation.Autowired;
    3. import org.springframework.stereotype.Controller;
    4. import org.springframework.ui.Model;
    5. import org.springframework.web.bind.annotation.RequestMapping;
    6. import yj.com.pojo.Books;
    7. import yj.com.service.BookService;
    8. import java.util.List;
    9. @Controller
    10. @RequestMapping("/book")
    11. public class BookController {
    12.     //控制器调用Service层
    13.     @Autowired
    14.     private BookService bookService;
    15.     @RequestMapping("allBook")
    16.     public String list(Model model) {
    17.         List list = bookService.queryAllBook();
    18.         model.addAttribute("list", list);
    19.         return "allBook";
    20.     }
    21. }

    5.在jsp目录下创建并配置文件allBook.jsp

    1. <%--
    2.   Created by IntelliJ IDEA.
    3.   User: yangj
    4.   Date: 2022/12/6
    5.   Time: 9:59
    6.   To change this template use File | Settings | File Templates.
    7. --%>
    8. <%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
    9. <%@ page contentType="text/html;charset=UTF-8" language="java" %>
    10. <html>
    11. <head>
    12.     <title>书籍列表title>
    13.     <meta name="viewport" content="width=device-width, initial-scale=1.0">
    14.     
    15.     <link href="https://cdn.bootcss.com/bootstrap/3.3.7/css/bootstrap.min.css"rel="stylesheet">
    16. head>
    17. <body>
    18. <div class="row clearfix">
    19.     <div class="col-md-12 column">
    20.         <div class="page-header">
    21.             <h1>
    22.                 <small>书籍列表 —— 显示所有书籍small>
    23.             h1>
    24.         div>
    25.     div>
    26. div>
    27. <div class="row">
    28.     <div class="col-md-4 column">
    29.         <a class="btn btn-primary" href="${pageContext.request.contextPath}/book/toAddBook">新增a>
    30.     div>
    31. div>
    32. <div class="row clearfix">
    33.     <div class="col-md-12 column">
    34.         <table class="table table-hover table-striped">
    35.             <thead>
    36.             <tr>
    37.                 <th>书籍编号th><th>书籍名字th><th>书籍数量th><th>书籍详情th><th>操作th>
    38.             tr>
    39.             thead>
    40.             <tbody>
    41.             <c:forEach  var="book" items="${requestScope.get('list')}">
    42.                 <tr>
    43.                     <td>${book.getBookID()}td>
    44.                     <td>${book.getBookName()}td>
    45.                     <td>${book.getBookCounts()}td>
    46.                     <td>${book.getDetail()}td>
    47.                     <td>
    48.                         <a href="${pageContext.request.contextPath}/book/toUpdateBook?id=${book.getBookID()}">更改a> |
    49.                         <a href="${pageContext.request.contextPath}/book/del/${book.getBookID()}">删除a>
    50.                     td>
    51.                 tr>
    52.             c:forEach>
    53.             tbody>
    54.         table>
    55.     div>
    56. div>
    57. body>
    58. html>
    59.  
    60.

    6.配置服务器

    添加配置，点击加号，找到Tomcat Server 本地服务，名称随便什么，应用程序服务器如下tomcat233,部署配置如下点击加号，添加工件，应用程序上下文改为：“/”,然后确定

    7.运行程序

    8.实现添加功能。

    在BookController下继续配置

    1. @RequestMapping("/toAddBook")
    2.     public String toAddpaper(){
    3.         return "addBook";
    4.     }
    5.     @RequestMapping("/addBook")
    6.     public String addPaper(Books books){
    7.         System.out.println(books);
    8.         bookService.addBook(books);
    9.         return "redirect:/book/allBook";
    10.     }

    在jsp下创建配置addBook.jsp文件

    1. <%--
    2.   Created by IntelliJ IDEA.
    3.   User: yangj
    4.   Date: 2022/12/6
    5.   Time: 10:13
    6.   To change this template use File | Settings | File Templates.
    7. --%>
    8. <%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
    9. <%@ page contentType="text/html;charset=UTF-8" language="java" %>
    10.  
    11. <html>
    12. <head>
    13.     <title>新增书籍title>
    14.     <meta name="viewport" content="width=device-width, initial-scale=1.0">
    15.     
    16.     <link href="https://cdn.bootcss.com/bootstrap/3.3.7/css/bootstrap.min.css"rel="stylesheet">
    17. head>
    18. <body>
    19. <div class="container">
    20.  
    21.     <div class="row clearfix">
    22.         <div class="col-md-12 column">
    23.             <div class="page-header">
    24.                 <h1>
    25.                     <small>新增书籍small>
    26.                 h1>
    27.             div>
    28.         div>
    29.     div>
    30.     <form action="${pageContext.request.contextPath}/book/addBook"  method="post">
    31.         书籍名称：<input type="text" name="bookName"><br><br><br>
    32.         书籍数量：<input type="text" name="bookCounts"><br><br><br>
    33.         书籍详情：<input type="text" name="detail"><br><br><br>
    34.         <input type="submit" value="添加">
    35.     form>
    36. div>
    37. body>
    38. html>

    9.实现更新和删除功能

    在BookController下继续配置

    1.    @RequestMapping("/toUpdateBook")
    2.     public String toUpdateBook(Model model,int id){
    3.         Books books=bookService.queryBookById(id);
    4.         System.out.println(books);
    5.         model.addAttribute("book",books);
    6.         return "updateBook";
    7.     }
    8.     @RequestMapping("/updateBook")
    9.     public String UpdateBook(Model model,Books book){
    10.         System.out.println(book);
    11.         bookService.updateBook(book);
    12.         Books books=bookService.queryBookById(book.getBookID());
    13.         model.addAttribute("book",books);
    14.         return "redirect:/book/allBook";
    15.     }
    16.     @RequestMapping("/del/{bookID}")
    17.     public String deleteBook(@PathVariable("bookID") int id){
    18.         bookService.deleteBookById(id);
    19.         return "redirect:/book/allBook";
    20.     }

    在jsp下创建配置updateBook.jsp文件

    1. <%--
    2.   Created by IntelliJ IDEA.
    3.   User: yangj
    4.   Date: 2022/12/6
    5.   Time: 10:24
    6.   To change this template use File | Settings | File Templates.
    7. --%>
    8. <%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
    9. <%@ page contentType="text/html;charset=UTF-8" language="java" %>
    10. <html>
    11. <head>
    12.     <title>修改信息title>
    13.     <meta name="viewport" content="width=device-width, initial-scale=1.0">
    14.     
    15.     <link href="https://cdn.bootcss.com/bootstrap/3.3.7/css/bootstrap.min.css"rel="stylesheet">
    16. head>
    17. <body>
    18. <div class="container">
    19.  
    20.     <div class="row clearfix">
    21.         <div class="col-md-12 column">
    22.             <div class="page-header">
    23.                 <h1>
    24.                     <small>修改信息small>
    25.                 h1>
    26.             div>
    27.         div>
    28.     div>
    29.  
    30.     <form action="${pageContext.request.contextPath}/book/updateBook" method="post">
    31.         <input type="hidden" name="bookID" value="${book.getBookID()}"/>
    32.         书籍名称：<input type="text" name="bookName"value="${book.getBookName()}"/>
    33.         书籍数量：<input type="text" name="bookCounts"value="${book.getBookCounts()}"/>
    34.         书籍详情：<input type="text" name="detail" value="${book.getDetail() }"/>
    35.         <input type="submit" value="提交"/>
    36.     form>
    37. div>
    38. body>
    39. html>
    40.

    注意：如果遇见这个问题，无法从底层数据库获取连接! 一般是一下几个问题：

    1. 驱动Jar包版本与注册驱动的类不匹配。
    2. 数据库连接地址有误。
    3. 数据库账户密码是否输入正确。
    4. 数据库，表，字段是否对应。
    5. 项目是否引入驱动包。

  • 相关阅读:
    C#WPF动态资源和静态资源应用实例
    软考信息系统项目管理师_历年真题_2019上半年错题集_上午综合知识题---软考高级之信息系统项目管理师054
    为什么list.sort()比Stream().sorted()更快？
    elasticsearch 客户端工具ESClientRHL
    AWS S3上传下载
    2022/12/4 胡言乱语
    工程（十三）——基于激光视觉的SLAM三维重建
    如何在Vue3中配置国际化语言i18n
    ⑯、企业快速开发平台Spring Cloud之HTML 总结
    接口自动化测试思路和实战(3)：测试库框架
  • 原文地址：https://blog.csdn.net/m0_52896041/article/details/128187060