Java 整合模板彻底解决ssm配置难题-eolink官网

Java 整合模板彻底解决ssm配置难题

Spring+SpringMVC+Mybatis

环境配置

IDEA

mysql 5.7

Tomcat 8.5

Maven 3.6

创建数据库

CREATE DATABASE `ssmbuild`;

USE `ssmbuild`;

DROP TABLE IF EXISTS `books`;

CREATE TABLE `books` (

`bookID` INT(10) NOT NULSdCTTTcL 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,'从进门到进牢');

编写数据库对应的实体类com.longdi.pojo.Books

导入lombok在pom.xml中

package com.longdi.pojo;

import lombok.AllArgsConstructor;

import lombok.Data;

import lombok.NoArgsConstructor;

/**

* @author: 龍弟

* @description

* @date: 2021/9/27 20:22

@Data

@AllArgsConstructor

@NoArgsConstructor

public class Books {

private int bookID;

private String bookName;

private int bookCounts;

private String detail;

}

导入相关的pom依赖

junit

4.12

mysql

mysql-connector-java

5.1.47

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.aspectj

aspectjweaver

1.8.4

org.springframework

spring-webmvc

5.1.9.RELEASE

org.springframework

spring-jdbc

5.1.9.RELEASE

org.projectlombok

lombok

1.18.16

compile

资源过滤设置

src/main/java

**/*.properties

**/*.xml

false

src/main/resources

**/*.properties

**/*.xml

false

Mybatis层编写

创建mybatis-config.xml

PUBLIC "-//mybatis.org//DTD Config 3.0//EN"

"http://mybatis.org/dtd/mybatis-3-config.dtd">

jdbc.driver=com.mysql.jdbc.Driver

jdbc.url=jdbc:mysql://localhost:3306/ssmbuild?useSSL=true&useUnicode=true&characterEncoding=utf8

jdbc.username=root

jdbc.password=123456

编写Dao层的Mapper接口

package com.longdi.dao;

import com.longdi.pojo.Books;

import org.apache.ibatis.annotations.Param;

import java.util.List;

/**

* @author: 龍弟

* @description

* @date: 2021/9/27 20:32

public interface BookMapper {

//增加一本书

int addBook(Books books);

//删除一本书

int deleteBookById(@Param("bookId") int id);

//更新一本书

int updateBook(Books books);

//查询一本书

Books queryBookById(@Param("bookId")int id);

//查询全部的书

List queryAllBook();

Books queryBookByName(@Param("bookName")String bookName);

}

编写接口对应的 Mapper.xml 文件。需要导入MyBatis的包；

PUBLIC "-//mybatis.org//DTD Config 3.0//EN"

"http://mybatis.org/dtd/mybatis-3-mapper.dtd">

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=#{bookName}

编写Service层的接口

package com.longdi.service;

import com.longdi.pojo.Books;

import java.util.List;

/**

* @author: 龍弟

* @description

* @date: 2021/9/27 21:03

public interface BookService {

//增加一本书

int addBook(Books books);

//删除一本书

int deleteBookById( int id);

//更新一本书

int updateBook(Books books);

//查询一本书

Books queryBookById(int id);

//查询全部的书

List queryAllBook();

Books queryBookByName(String bookName);

}

Service层的实现类

package com.longdi.service;

import com.longdi.dao.BookMapper;

import com.longdi.pojo.Books;

import org.springframework.stereotype.Service;

import java.util.List;

/**

* @author: 龍弟

* @description

* @date: 2021/9/27 21:05

public class BookServiceImpl implements BookService{

private BookMapper bookMapper;

public void setBookMapper(BookMapper bookMapper) {

this.bookMapper = bookMapper;

}

public int addBook(Books books) {

return bookMapper.addBook(books);

}

public int deleteBookById(int id) {

return bookMapper.deleteBookById(id);

}

public int updateBook(Books books) {

System.out.println("BookServiceImpl:updateBook=>"+books);

return bookMapper.updateBook(books);

}

public Books queryBookById(int id) {

return bookMapper.queryBookById(id);

}

public List queryAllBook() {

return bookMapper.queryAllBook();

}

public Books queryBookByName(String bookName) {

return bookMapper.queryBookByName(bookName);

}

Spring整合Mybatis spring-dao.xml

以下为spring层

xmlns:xsi="http://w3.org/2001/XMLSchema-instance"

xmlns:context="http://springframework.org/schema/context"

xsi:schemaLocation="http://springframework.org/schema/beans

http://springframework.org/schema/beans/spring-beans.xsd

http://springframework.org/schema/context

https://springframework.org/schema/context/spring-context.xsd">

xmlns:xsi="http://w3.org/2001/XMLSchema-instance"

xmlns:context="http://springframework.org/schema/context"

xsi:schemaLocation="http://springframework.org/schema/beans

http://springframework.org/schema/beans/spring-beans.xsd

http://springframework.org/schema/context

https://springframework.org/schema/context/spring-context.xsd">

spring-service.xml文件

xmlns:xsi="http://w3.org/2001/XMLSchema-instance"

xmlns:context="http://springframework.org/schema/context"

xmlns:aop="http://springframework.org/schema/aop"

xmlns:tx="http://springframework.org/schema/tx"

xsi:schemaLocation="http://springframework.org/schema/beans

http://springframework.org/schema/beans/spring-beans.xsd

http://springframework.org/schema/context

http://springframework.org/schema/context/spring-context.xsd

http://springframework.org/schema/aop

http://springframework.org/schema/aop/spring-aop.xsd

http://springframework.org/schema/tx

http://springframework.org/schema/tx/spring-tx.xsd">

xmlns:xsi="http://w3.org/2001/XMLSchema-instance"

xmlns:context="http://springframework.org/schema/context"

xmlns:aop="http://springframework.org/schema/aop"

xmlns:tx="http://springframework.org/schema/tx"

xsi:schemaLocation="http://springframework.org/schema/beans

http://springframework.org/schema/beans/spring-beans.xsd

http://springframework.org/schema/context

http://springframework.org/schema/context/spring-context.xsd

http://springframework.org/schema/aop

http://springframework.org/schema/aop/spring-aop.xsd

http://springframework.org/schema/tx

http://springframework.org/schema/tx/spring-tx.xsd">

以下为SpringMVC层

配置web.xml

xmlns:xsi="http://w3.org/2001/XMLSchema-instance"

xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_4_0.xsd"

version="4.0">

DispatcherServlet

org.springframework.web.servlet.DispatcherServlet

contextConfigLocation

classpath:applicationContext.xml

DispatcherServlet

encodingFilter

org.springframework.web.filter.CharacterEncodingFilter

encoding

utf-8

encodingFilter

xmlns:xsi="http://w3.org/2001/XMLSchema-instance"

xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_4_0.xsd"

version="4.0">

DispatcherServlet

org.springframework.web.servlet.DispatcherServlet

contextConfigLocation

classpath:applicationContext.xml

DispatcherServlet

encodingFilter

org.springframework.web.filter.CharacterEncodingFilter

encoding

utf-8

encodingFilter

spring-mvc.xml

xmlns:xsi="http://w3.org/2001/XMLSchema-instance"

xmlns:context="http://springframework.org/schema/context"

xmlns:mvc="http://springframework.org/schema/mvc"

xsi:schemaLocation="http://springframework.org/schema/beans

http://springframework.org/schema/beans/spring-beans.xsd

http://springframework.org/schema/context

http://springframework.org/schema/context/spring-context.xsd

http://springframework.org/schema/mvc

https://springframework.org/schema/mvc/spring-mvc.xsd">

xmlns:xsi="http://w3.org/2001/XMLSchema-instance"

xmlns:context="http://springframework.org/schema/context"

xmlns:mvc="http://springframework.org/schema/mvc"

xsi:schemaLocation="http://springframework.org/schema/beans

http://springframework.org/schema/beans/spring-beans.xsd

http://springframework.org/schema/context

http://springframework.org/schema/context/spring-context.xsd

http://springframework.org/schema/mvc

https://springframework.org/schema/mvc/spring-mvc.xsd">

Spring配置整合文件，创建applicationContext.xml

xmlns:xsi="http://w3.org/2001/XMLSchema-instance"

xsi:schemaLocation="http://springframework.org/schema/beans

http://springframework.org/schema/beans/spring-beans.xsd">

xmlns:xsi="http://w3.org/2001/XMLSchema-instance"

xsi:schemaLocation="http://springframework.org/schema/beans

http://springframework.org/schema/beans/spring-beans.xsd">

以上为SSM的环境配置，下面编写Controller层和视图层，实现书籍的CRUD功能

controller层书籍的增删改查功能

import java.util.ArrayList;

import java.util.List;

/**

* @author: 龍弟

* @description

* @date: 2021/9/27 22:47

@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 "allBook";

}

//跳转到增加书籍页面

@RequestMapping("/toAddBook")

public String toAddPaper(){

return "addBook";

}

//添加书籍的请求

@RequestMapping("/addBook")

public String addBook(Books books){

System.out.println("addBook=>"+books);

bookService.addBook(books);

return "redirect:/book/allBook";

}

//跳转到修改页面

@RequestMapping("toUpdateBook")

public String toUpdatePaper(int id,Model model){

Books books = bookService.queryBookById(id);

model.addAttribute("book",books);

return "updateBook";

}

//修改书籍

@RequestMapping("updateBook")

public String updateBook(Books books){

System.out.println("updateBook=>"+books);

int i=bookService.updateBook(books);

if(i>0){

System.out.println("添加books成功"+books);

}

return "redirect:/book/allBook";

}

//删除书籍

@RequestMapping("/deleteBook/{bookId}")

public String deleBook(@PathVariable("bookId") int id){

bookService.deleteBookById(id);

return "redirect:/book/allBook";

}

//查询书籍

@RequestMapping("/queryBook")

public String queryBook(String queryBookName,Model model){

Books books=bookService.queryBookByName(queryBookName);

System.err.println("queryBook=>"+books);

List list=new ArrayList();

list.add(books);

if(books==null){

list=bookService.queryAllBook();

model.addAttribute("error","未查到");

}

model.addAttribute("list",list);

return "allBook";

}

编写首页index.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8" %>

进入到书籍页面

使用SpringBoot实现API接口

283 2022-09-20

Java 整合模板彻底解决ssm配置难题

java 单机接口限流处理方案

使用SpringBoot实现API接口

Python怎么调用GPT3.5接口

推荐文章

接口调用是什么意思？几种常用接口调用方式

接口设计原则

8款在线 API 接口文档管理工具

api管理系统是什么？

什么是接口调试？接口调试的步骤有哪些？

api 接口管理系统有哪些？

接口测试有几种测试方法

API文档生成工具有哪些？

微服务和api网关区别

交换机配置步骤

最近发表

热评文章

在线接口文档管理工具推荐，支持在线测试，HTTP接口

开源的在线接口文档wiki工具Mindoc的介绍与使

如何优雅的进行接口设计？接口设计的六大原则是什么？

什么是API测试,api检测公司

遇到百度网址安全中心提醒您该页面可能存在钓鱼欺诈信息

软件接口设计怎么做？前后端分离软件接口设计思路

Java 整合模板彻底解决ssm配置难题

微信扫一扫：分享

推荐文章

最近发表

热评文章