| SpringMVC实现增删改查 | 您所在的位置：网站首页 › layui表格增删改查逻辑 › SpringMVC实现增删改查 |
SpringMVC实现增删改查
|
SpringMVC项目实现增删改查
一、创建MAVEN项目 二、把项目设置成WEB项目 选择项目–>右键–>Add Framework Support 静态资源导出 src/main/java **/*.properties **/*.xml false src/main/resources **/*.properties **/*.xml false等待依赖下载完成即可 四、添加配置文件 打开web文件夹下的web.xml，添加DispatchServlet以及乱码过滤 springmvc org.springframework.web.servlet.DispatcherServlet contextConfigLocation classpath:applicationContext.xml 1 springmvc / encodingFilter org.springframework.web.filter.CharacterEncodingFilter encoding utf-8 encodingFilter /* 15在src/main/resources下创建applicationContext.xml 在src/main/resources创建database.properties并配置 jdbc.driver=com.mysql.cj.jdbc.Driver jdbc.url=jdbc:mysql://127.0.0.1:3306/数据库名?autoReconnect=true&useUnicode=true&characterEncoding=utf-8&useSSL=false&serverTimezone=Asia/Shanghai jdbc.username=数据库账号 jdbc.password=数据库密码这里注意：mysql8.0以上建议使用jdbc.driver=com.mysql.cj.jdbc.Driver，8.0以下建议使用jdbc.driver=com.mysql.jdbc.Driver 创建要使用的package：controller、dao、pojo、service 在pojo包下创建Books实体类 @Data @AllArgsConstructor @NoArgsConstructor public class Books { private int bookID; private String bookName; private int bookCounts; private String detail; }在service下创建接口BookService public interface BookService { //增加 int addBook(Books books); //删除 int deleteBookById(int id); //更新 int updateBook(Books books); //查询 Books queryBookById(int id); //查询全部 List queryAllBooks(); //模糊查询 List queryBookByName(String bookName); }创建BookService的实现类BookServiceImpl public class BookServiceImpl implements BookService { //service调dao层：组合Dao 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 queryAllBooks() { return bookMapper.queryAllBooks(); } @Override public List queryBookByName(String bookName) { return bookMapper.queryBookByName(bookName); } }在dao包下创建接口类BookMapper public interface BookMapper { //增加 int addBook(Books books); //删除 int deleteBookById(@Param("bookId") int id); //更新 int updateBook(Books books); //查询 Books queryBookById(@Param("bookId") int id); //查询全部 List queryAllBooks(); //模糊查询 List queryBookByName(@Param("bookName") String bookName); }创建BookMapper.xml实现sql 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; select * from ssmbuild.books where bookName like concat('%',#{bookName},'%');在src/main/resources创建spring-dao.xml 在src/main/resources创建mybatis-config.xml 在src/main/resources创建spring-service.xml web/WEB-INF下创建jsp文件夹 最后在applicationContext.xml中加入 配置文件完成！ 五、创建数据库，添加数据 打开数据库可视化界面，执行以下SQL CREATE DATABASE `ssmbuild`; USE `ssmbuild`; CREATE TABLE `books`( `bookID` INT(10) NOT NULL AUTO_INCREMENT COMMENT '书id', `bookName` VARCHAR(100) NOT NULL COMMENT '书名', `bookCounts` INT(11) NOT NULL COMMENT '数量', `detail` VARCHAR(200) NOT NULL COMMENT '描述', KEY `bookID`(`bookID`) )ENGINE=INNODB DEFAULT CHARSET=utf8; INSERT INTO `books`(`bookID`,`bookName`,`bookCounts`,`detail`) VALUES (1,'Java',1,'从入门到放弃'), (2,'MySQL',10,'从删库到跑路'), (3,'Linux',5,'从进门到进牢');注意：此数据库名和database.properties配置文件夹中的文件名必须保持一致 六、创建jsp文件 创建之前首先先在index.jsp中添加进入书籍按钮 首页 a{ text-decoration: none; color: black; font-size: 18px; } h3{ width: 150px; height: 38px; margin: 100px auto; text-align: center; line-height: 38px; background: deepskyblue; border-radius: 5px; } 进入书籍页面在web/WEB-INF/jsp下创建allBooks.jsp 书籍展示页面 书籍列表 -------- 显示所有书籍 新增书籍 书籍编号 书籍名称 书籍数量 书籍详情 操作 ${book.bookID} ${book.bookName} ${book.bookCounts} ${book.detail} ${error} 修改 ; | ; 删除addBook.jsp 新增书籍 新增书籍 书籍名称： 书籍数量： 书籍描述：updateBook.jsp 修改书籍 修改书籍 书籍名称： 书籍数量： 书籍描述：最后，创建BookController实现类并配置tomcat启动就可以了 package com.swt.controller; import com.swt.pojo.Books; import com.swt.service.BookService; 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 java.util.ArrayList; import java.util.List; @Controller @RequestMapping("/book") public class BookController { //controller 调 service层 @Autowired @Qualifier("BookServiceImpl") private BookService bookService; //查询全部的书籍，并且返回到一个书籍的展示页面 @RequestMapping("/allBooks") public String getAllBooks(Model model) { List list = bookService.queryAllBooks(); model.addAttribute("list", list); return "allBooks"; } //跳转到增加书籍页面 @RequestMapping("/toAddBook") public String toAddPaper() { return "addBook"; } //添加书籍的请求 @RequestMapping("addBook") public String addBook(Books books) { System.out.println("addBook===" + books); bookService.addBook(books); //重定向到我们的 @RequestMapping("/allBooks") 请求 return "redirect:/book/allBooks"; } //跳转到修改页面 @RequestMapping("/toUpdate") public String toUpdatePaper(int id, Model model) { Books books = bookService.queryBookById(id); model.addAttribute("QBook", books); return "updateBook"; } //修改书籍 @RequestMapping("/updateBook") public String updateBook(Books books) { System.out.println("updateBook===" + books); bookService.updateBook(books); //重定向到我们的 @RequestMapping("/allBooks") 请求 return "redirect:/book/allBooks"; } //删除书籍 @RequestMapping("/deleteBook/{bookID}") public String deleteBook(@PathVariable("bookID") int id) { bookService.deleteBookById(id); //重定向到我们的 @RequestMapping("/allBooks") 请求 return "redirect:/book/allBooks"; } //书籍查询 @RequestMapping("/queryBook") public String queryBookName(String queryBookName, Model model) { List list = bookService.queryBookByName(queryBookName); if (list.size() == 0) { return "redirect:/book/allBooks"; } model.addAttribute("list", list); return "allBooks"; } } |
选中Web Application 点击确定 
有这个web/WEB-INF文件夹说明创建成功 
三、打开pom.xml添加依赖，静态资源导出 依赖：junit，数据库驱动，连接池，servlet，jsp，mybatis，mybatis-spring，spring
在src/main/resources创建spring-mvc.xml【本文地址】
公司简介
联系我们