SSM整合

您所在的位置：网站首页 › ssm框架实现登录注册和增删改查 › SSM整合

SSM整合

2024-03-16 14:41| 来源: 网络整理| 查看: 265

SSM整合-对Mysql数据库中数据进行增删改查前言结构代码maven配置文件controllerdao持久层pojo实体service服务层resourcesweb前端结尾

前言

环境：

ideamysql 8JDK 1.8Tmocat 9mavenbootstrap

备注：

代码详解

效果：在这里插入图片描述

在这里插入图片描述

结构

在这里插入图片描述

代码 maven配置文件 4.0.0 org.example BookManagement 1.0-SNAPSHOT 8 8 src/main/java **/*.properties **/*.xml false src/main/resources **/*.properties **/*.xml false junit junit 4.12 mysql mysql-connector-java 8.0.25 com.mchange c3p0 0.9.5.2 javax.servlet servlet-api 2.5 javax.servlet.jsp jsp-api 2.2 javax.servlet jstl 1.2 org.mybatis mybatis 3.5.2 org.mybatis mybatis-spring 2.0.2 org.springframework spring-webmvc 5.1.9.RELEASE org.springframework spring-jdbc 5.1.9.RELEASE org.projectlombok lombok RELEASE compile org.projectlombok lombok 1.16.14 org.webjars bootstrap 3.3.7 org.webjars jquery 3.1.1 controller

BookController

package controller; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.beans.factory.annotation.Qualifier; import org.springframework.stereotype.Controller; import org.springframework.ui.Model; import org.springframework.web.bind.annotation.PathVariable; import org.springframework.web.bind.annotation.RequestMapping; import pojo.Books; import service.BookService; import java.util.List; @Controller @RequestMapping("/book") public class BookController { @Autowired @Qualifier("BookServiceImpl") private BookService bookService; @RequestMapping("/allBook") public String list(Model model) { List list = bookService.queryAllBook(); model.addAttribute("list", list); return "allBooks"; } @RequestMapping("/toAddBook") public String toAddPaper() { return "addBook"; } @RequestMapping("/addBook") public String addPaper(Books books) { System.out.println(books); bookService.addBook(books); return "redirect:/book/allBook"; } @RequestMapping("/toUpdateBook") public String toUpdateBook(Model model, int id) { Books books = bookService.queryBookById(id); System.out.println(books); model.addAttribute("book",books ); return "updateBook"; } @RequestMapping("/updateBook") public String updateBook(Model model, Books book) { System.out.println(book); bookService.updateBook(book); Books books = bookService.queryBookById(book.getBookID()); model.addAttribute("books", books); return "redirect:/book/allBook"; } @RequestMapping("/del/{bookId}") public String deleteBook(@PathVariable("bookId") int id) { bookService.deleteBookById(id); return "redirect:/book/allBook"; } } dao持久层

BookMapper

package dao; import pojo.Books; import java.util.List; public interface BookMapper { //增加一本书 int addBook(Books books); //删除一本书 int deleteBookById(int id); //更新一本书 int updateBook(Books books); //查询一本书 Books queryBookById(int id); //查询所有书 List queryAllBook(); }

BookMapper.xml

insert into ssmbuild.books(bookName,bookCounts,detail) values (#{bookName}, #{bookCounts}, #{detail}) delete from ssmbuild.books where bookID=#{bookID} update ssmbuild.books set bookName = #{bookName},bookCounts = #{bookCounts},detail = #{detail} where bookID = #{bookID} select * from ssmbuild.books where bookID = #{bookID} SELECT * from ssmbuild.books pojo实体

Books

package pojo; import lombok.AllArgsConstructor; import lombok.Data; import lombok.NoArgsConstructor; @Data @AllArgsConstructor @NoArgsConstructor public class Books { private int bookID; private String bookName; private int bookCounts; private String detail; } service服务层

BookService

package service; import pojo.Books; import java.util.List; public interface BookService { //增加一本书 int addBook(Books books); //删除一本书 int deleteBookById(int id); //更新一本书 int updateBook(Books books); //查询一本书 Books queryBookById(int id); //查询所有书 List queryAllBook(); }

BookServiceImpl

package service; import dao.BookMapper; import pojo.Books; import java.util.List; public class BookServiceImpl implements BookService { private BookMapper bookMapper; public void setBookMapper(BookMapper bookMapper) { this.bookMapper = bookMapper; } @Override public int addBook(Books books) { return bookMapper.addBook(books); } @Override public int deleteBookById(int id) { return bookMapper.deleteBookById(id); } @Override public int updateBook(Books books) { return bookMapper.updateBook(books); } @Override public Books queryBookById(int id) { return bookMapper.queryBookById(id); } @Override public List queryAllBook() { return bookMapper.queryAllBook(); } } resources

applicationContext.xml

database.properties

这里配置自己的数据库

jdbc.driver=com.mysql.jdbc.Driver jdbc.url=jdbc:mysql://localhost:3306/ssmbuild?useSSL=true&useUnicode=true&characterEncoding=utf8&serverTimezone=Asia/Shanghai jdbc.username=root jdbc.password=123456

mybatis-config.xml

spring-dao.xml

spring-mvc.xml

spring-service.xml

web前端

将下载的css和js文件保存在bootstrap文件夹下下载官网在这里插入图片描述下载css和js文件 web.xml

DispatcherServlet org.springframework.web.servlet.DispatcherServlet contextConfigLocation classpath:applicationContext.xml 1 DispatcherServlet / encodingFilter org.springframework.web.filter.CharacterEncodingFilter encoding utf-8 encodingFilter /* 15

index.jsp首页

首页 a { text-decoration: none; color: black; font-size: 18px; } h3 { width: 180px; height: 38px; margin: 100px auto; text-align: center; line-height: 38px; background: deepskyblue; border-radius: 4px; } 点击进入列表页

addBook.jsp增加书籍页面

新增书籍新增书籍书籍名称：书籍数量：书籍详情：

allBooks.jsp所有书籍页面

书籍列表书籍列表 —— 显示所有书籍新增书籍编号书籍名字书籍数量书籍详情操作 ${book.getBookID()} ${book.getBookName()} ${book.getBookCounts()} ${book.getDetail()} 更改 | 删除

updateBook.jsp更改书籍页面

修改信息修改信息书籍名称：书籍数量：书籍详情：结尾

代码是跟着视频总结的，参考地址

【本文地址】

SSM整合

SSM整合

今日新闻

推荐新闻