【摘要】 最近把ssm框架基本上学习了一遍，这里以ssm框架为基础实现一些简单的图书管理系统，加深对ssm的理解。 一、环境要求：
IDEA版本不限，本人用的2019.3.5 x64MySQL 8.0.22 winx64 （5.7版本以上的都可以）Tomcat 9Maven 3.6
如果想对系统有个比较好的理解，最好对MySQL数据库，spring，JavaWeb和Mybat…
最近把ssm框架基本上学习了一遍，这里以ssm框架为基础实现一些简单的图书管理系统，加深对ssm的理解。
一、环境要求：
- IDEA版本不限，本人用的2019.3.5 x64
- MySQL 8.0.22 winx64 （5.7版本以上的都可以）
- Tomcat 9
- Maven 3.6
如果想对系统有个比较好的理解，最好对MySQL数据库，spring，JavaWeb和Mybatis有一定的了解，以及简单的前端知识。
二：准备数据库
创建一个存放书籍的数据库表
CREATE DATABASE ssmbuild;
CREATE TABLE books(
bookID INT(10) NOT NULL AUTO_INCREMENT COMMENT '书id',
bookName VARCHAR(100) NOT NULL COMMENT '书名',
bookCount 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,'从进门到坐牢');
数据表创建好了之后如下图所示
三：Maven和Web环境搭建
在idea里面新建一个Maven项目
名字叫做ssmbuild，当然这个名字直随便
完成上述操作后可以看到ssmbuild这个文件夹右下角有个蓝色的部分。
接下来添加一下web的支持，鼠标放在ssmbuild这个文件夹上面，鼠标右键选择如下图所示选项
进去后选择Web Application
可以看到项目文件夹下面有个web文件夹，中间有个蓝色圆点。
配置pom.xml
<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd"> <modelVersion>4.0.0</modelVersion> <groupId>org.example</groupId> <artifactId>wb_ssmbuild</artifactId> <version>1.0-SNAPSHOT</version> <dependencies> <dependency> <groupId>junit</groupId> <artifactId>junit</artifactId> <version>4.12</version> <scope>test</scope> </dependency> <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <version>8.0.22</version> </dependency> <dependency> <groupId>com.mchange</groupId> <artifactId>c3p0</artifactId> <version>0.9.5.2</version> </dependency> <dependency> <groupId>javax.servlet</groupId> <artifactId>servlet-api</artifactId> <version>2.5</version> </dependency> <dependency> <groupId>javax.servlet.jsp</groupId> <artifactId>jsp-api</artifactId> <version>2.2</version> </dependency> <dependency> <groupId>javax.servlet</groupId> <artifactId>jstl</artifactId> <version>1.2</version> </dependency> <dependency> <groupId>org.mybatis</groupId> <artifactId>mybatis</artifactId> <version>3.5.5</version> </dependency> <dependency> <groupId>org.mybatis</groupId> <artifactId>mybatis-spring</artifactId> <version>2.0.2</version> </dependency> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-webmvc</artifactId> <version>5.1.9.RELEASE</version> </dependency> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-jdbc</artifactId> <version>5.1.9.RELEASE</version> </dependency> <dependency> <groupId>org.aspectj</groupId> <artifactId>aspectjweaver</artifactId> <version>1.8.13</version> </dependency> <dependency> <groupId>org.projectlombok</groupId> <artifactId>lombok</artifactId> <version>1.18.10</version> </dependency> </dependencies> <build> <resources> <resource> <directory>src/main/java</directory> <includes> <include>**/*.properties</include> <include>**/*.xml</include> </includes> <filtering>false</filtering> </resource> <resource> <directory>src/main/resources</directory> <includes> <include>**/*.properties</include> <include>**/*.xml</include> </includes> <filtering>false</filtering> </resource> </resources> </build>
</project>
接下来建立基本结构和配置框架，文件夹结构如下图所示：
在resources这个文件夹下面新建mybatis-config.xml，配置如下：
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration> <settings> <setting name="logImpl" value="STDOUT_LOGGING"/> </settings> <typeAliases> <package name="com.wb.pojo"/> </typeAliases> <mappers> <mapper class="com.wb.dao.BookMapper"/> </mappers>
</configuration>
在resources这个文件夹下面新建applicationContext.xml，配置如下：
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd"> <import resource="classpath:spring-dao.xml"/> <import resource="classpath:spring-service.xml"/> <import resource="classpath:spring-mvc.xml"/>
</beans>
Mybatis层编写:
在resources这个文件夹下面新建数据库配置文件database.properties，配置如下：
jdbc.driver = com.mysql.jdbc.Driver
jdbc.url = jdbc:mysql://localhost:3306/ssmbuild?serverTimezone=Asia/Shanghai&characterEncoding=utf8&autoReconnect=true&zeroDateTimeBehavior=convertToNull
jdbc.username = root
jdbc.password = root
上面分别是你自己的数据库基本设置，mysql8.0以上的按这个配置就可以，5.7和5.8的可以不加时区设置。
Idea关联数据库：
从这里进去设置选择mysql，步骤如下
关联好了之后可以看到刚才创建的数据库
编写数据库对应的实体类 com.wb.pojo.Books
package com.wb.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;
}
编写Dao层的 Mapper接口！com.wb.dao.BookMapper
package com.wb.dao;
import com.wb.pojo.Books;
import org.apache.ibatis.annotations.Param;
import java.util.List;
/**
* 增删改查
*/
public interface BookMapper { int addBook(Books books); int deleteBookById(@Param("bookId") int id); int updateBook(Books books); Books queryBookById(@Param("bookId")int id); List<Books> queryAllBook(); Books queryBookByName(@Param("bookName")String bookName);
}
编写接口对应的 Mapper.xml 文件。需要导入MyBatis的包；com.wb.dao.Mapper.xml
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.wb.dao.BookMapper"> <insert id="addBook"> insert into ssmbuild.books (bookName,bookCounts,detail) values (#{bookName},#{bookCounts},#{detail}); </insert> <delete id="deleteBookById" parameterType="int"> delete from ssmbuild.books where bookID = #{bookId}; </delete> <update id="updateBook" parameterType="Books"> update ssmbuild.books set bookName = #{bookName},bookCounts = #{bookCounts},detail = #{detail} where bookID = #{bookID}; </update> <select id="queryBookById" resultType="Books"> select * from ssmbuild.books where bookID = #{bookId} </select> <select id="queryAllBook" resultType="Books"> select * from ssmbuild.books </select> <select id="queryBookByName" resultType="Books"> select * from ssmbuild.books where bookName = #{bookName} </select>
</mapper>
编写Service层的接口com.wb.servive.BookService
package com.wb.service;
import com.wb.pojo.Books;
import org.apache.ibatis.annotations.Param;
import java.util.List;
public interface BookService { int addBook(Books books); int deleteBookById(int id); int updateBook(Books books); Books queryBookById(int id); List<Books> queryAllBook(); Books queryBookByName(String bookName);
}
编写Service层的实现类com.wb.servive.BookServiceImpl
package com.wb.service;
import com.wb.dao.BookMapper;
import com.wb.pojo.Books;
import java.util.List;
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) { return bookMapper.updateBook(books); } public Books queryBookById(int id) { return bookMapper.queryBookById(id); } public List<Books> queryAllBook() { return bookMapper.queryAllBook(); } public Books queryBookByName(String bookName) { return bookMapper.queryBookByName(bookName); }
}
接下来配置spring层，刚才在ApplicationContext.xml里面已经引入了下面的文件。
我们去编写Spring整合Mybatis的相关的配置文件；resources文件夹下面spring-dao.xml
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:context="http://www.springframework.org/schema/context" 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"> <context:property-placeholder location="classpath:database.properties"/> <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource"> <property name="driverClass" value="${jdbc.driver}"/> <property name="jdbcUrl" value="${jdbc.url}"/> <property name="user" value="${jdbc.username}"/> <property name="password" value="${jdbc.password}"/> <property name="maxPoolSize" value="30"/> <property name="minPoolSize" value="10"/> <property name="autoCommitOnClose" value="false"/> <property name="checkoutTimeout" value="10000"/> <property name="acquireRetryAttempts" value="2"/> </bean> <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean"> <property name="dataSource" ref="dataSource"/> <property name="configLocation" value="classpath:mybatis-config.xml"/> </bean> <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer"> <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"/> <property name="basePackage" value="com.wb.dao"/> </bean>
</beans>
Spring整合service层，在resources下新建spring-service.xml
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:context="http://www.springframework.org/schema/context" xmlns:aop="http://www.springframework.org/schema/aop" xmlns:tx="http://www.springframework.org/schema/tx" 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 http://www.springframework.org/schema/aop https://www.springframework.org/schema/aop/spring-aop.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx.xsd"> <context:component-scan base-package="com.wb.service"/> <bean id="BookServiceImpl" class="com.wb.service.BookServiceImpl"> <property name="bookMapper" ref="bookMapper"/> </bean> <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager"> <property name="dataSource" ref="dataSource"/> </bean> <tx:advice id="txAdvice" transaction-manager="transactionManager"> <tx:attributes> <tx:method name="*" propagation="REQUIRED"/> </tx:attributes> </tx:advice> <aop:config> <aop:pointcut id="txPointCut" expression="execution(* com.wb.dao.*.*(..))"/> <aop:advisor advice-ref="txAdvice" pointcut-ref="txPointCut"/> </aop:config>
</beans>
配置springMVC层的web.xml，在web->WEN-INF目录下有web.xml
<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns="http://xmlns.jcp.org/xml/ns/javaee" xmlns:xsi="http://www.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"> <servlet> <servlet-name>springmvc</servlet-name> <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class> <init-param> <param-name>contextConfigLocation</param-name> <param-value>classpath:ApplicationContext.xml</param-value> </init-param> <load-on-startup>1</load-on-startup> </servlet> <servlet-mapping> <servlet-name>springmvc</servlet-name> <url-pattern>/</url-pattern> </servlet-mapping> <filter> <filter-name>encodingFilter</filter-name> <filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class> <init-param> <param-name>encoding</param-name> <param-value>utf-8</param-value> </init-param> </filter> <filter-mapping> <filter-name>encodingFilter</filter-name> <url-pattern>/*</url-pattern> </filter-mapping> <session-config> <session-timeout>15</session-timeout> </session-config>
</web-app>
在resources下新建spring-mvc.xml
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:mvc="http://www.springframework.org/schema/mvc" xmlns:context="http://www.springframework.org/schema/context" xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc.xsd http://www.springframework.org/schema/context https://www.springframework.org/schema/context/spring-context.xsd"> <mvc:annotation-driven/> <mvc:default-servlet-handler/> <context:component-scan base-package="com.wb.controller"/> <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver"> <property name="prefix" value="/WEB-INF/jsp/"/> <property name="suffix" value=".jsp"/> </bean>
</beans>
Controller 和 视图层编写
com.wb.controller
package com.wb.controller;
import com.wb.pojo.Books;
import com.wb.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 { @Autowired @Qualifier("BookServiceImpl") private BookService bookService; //查询全部的书籍，并且返回到一个书籍展示页面 @RequestMapping("/allBook") public String list(Model model){ List<Books> 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("/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); return "redirect:/book/allBook"; } //删除书籍 @RequestMapping("/deleteBook/{bookId}") public String deleteBook(@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); List<Books> list = new ArrayList<>(); list.add(books); if(books==null){ list=bookService.queryAllBook(); model.addAttribute("error","未查到"); } model.addAttribute("list",list); return "allBook"; }
}
编写首页 index.jsp,在web目录下
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head> <title>首页</title> <style> h3{ width: 120px; height: 38px; margin: 100px auto; text-align: center; line-height: 38px; background: deepskyblue; border-radius: 5px; } a{ text-decoration: none; color: black; font-size: 18px; } </style>
</head>
<body>
<h3> <a href="${pageContext.request.contextPath}/book/allBook">书籍展示界面</a>
</h3>
</body>
</html>
书籍列表页面 allBook.jsp,放在web-->WEB-INF目录下面
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head> <title>书籍展示界面</title> <link href="https://cdn.staticfile.org/twitter-bootstrap/3.3.7/css/bootstrap.min.css" rel="stylesheet">
</head>
<body>
<div class="container"> <div class="row clearfix"> <div class="col-md-12 column"> <div class="page-header"> <h1> <small>书籍列表-----显示所有书籍列表</small> </h1> </div> </div> <div class="row"> <div class="col-md-4 column"> <a class="btn btn-primary" href="${pageContext.request.contextPath}/book/toAddBook">新增书籍</a> <a class="btn btn-primary" href="${pageContext.request.contextPath}/book/allBook">显示全部书籍</a> </div> <div class="col-md-4 column"></div> <div class="col-md-4 column"> <form class="form-inline" method="post" action="${pageContext.request.contextPath}/book/queryBook" style="float:right"> <span style="color:red;font-weight: bold">${error}</span> <input type="text" name="queryBookName" class="form-control" placeholder="请输入要查询的书籍名称"> <input type="submit" value="查询" class="btn btn-primary"> </form> </div> </div> </div> <div class="row clearfix"> <div class="col-md-12 column"> <table class="table table-hover table-striped"> <thead> <tr> <th>书籍编号</th> <th>书籍名称</th> <th>书籍数量</th> <th>书籍详情</th> <th>操作</th> </tr> </thead> <tbody> <c:forEach var="book" items="${list}"> <tr> <td>${book.bookID}</td> <td>${book.bookName}</td> <td>${book.bookCounts}</td> <td>${book.detail}</td> <td> <a href="${pageContext.request.contextPath}/book/toUpdate?id=${book.bookID}">修改</a> | <a href="${pageContext.request.contextPath}/book/deleteBook/${book.bookID}">删除</a> </td> </tr> </c:forEach> </tbody> </table> </div> </div>
</div>
</body>
</html>
添加书籍页面 addBook.jsp,放在web-->WEB-INF目录下面
<%--
Created by IntelliJ IDEA.
User: dd
Date: 2021/5/7
Time: 15:23
To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head> <title>Title</title> <link href="https://cdn.staticfile.org/twitter-bootstrap/3.3.7/css/bootstrap.min.css" rel="stylesheet">
</head>
<body>
<div class="container"> <div class="row clearfix"> <div class="col-md-12 column"> <div class="page-header"> <h1> <small>新增书籍</small> </h1> </div> </div> </div> <form action="${pageContext.request.contextPath}/book/addBook" method="post"> <div class="form-group"> <label>书籍名称</label> <input type="text" name="bookName" class="form-control" required> </div> <div class="form-group"> <label>书籍数量</label> <input type="text" name="bookCounts" class="form-control" required> </div> <div class="form-group"> <label>书籍详情</label> <input type="text" name="detail" class="form-control" required> </div> <div class="form-group"> <input type="submit" class="form-control" value="添加"> </div> </form>
</div>
</body>
</html>
更新书籍页面 updateBook.jsp,放在web-->WEB-INF目录下面
<%--
Created by IntelliJ IDEA.
User: dd
Date: 2021/5/7
Time: 17:22
To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head> <title>修改书籍</title> <link href="https://cdn.staticfile.org/twitter-bootstrap/3.3.7/css/bootstrap.min.css" rel="stylesheet">
</head>
<body>
<div class="container"> <div class="row clearfix"> <div class="col-md-12 column"> <div class="page-header"> <h1> <small>修改书籍</small> </h1> </div> </div> </div> <form action="${pageContext.request.contextPath}/book/updateBook" method="post"> <%-- 需要id，前端传递隐藏域--%> <input type="hidden" name="bookID" value="${QBook.bookID}"> <div class="form-group"> <label>书籍名称</label> <input type="text" name="bookName" value="${QBook.bookName}" class="form-control" required> </div> <div class="form-group"> <label>书籍数量</label> <input type="text" name="bookCounts" value="${QBook.bookCounts}" class="form-control" required> </div> <div class="form-group"> <label>书籍详情</label> <input type="text" name="detail" value="${QBook.detail}" class="form-control" required> </div> <div class="form-group"> <input type="submit" class="form-control" value="修改"> </div> </form>
</div>
</body>
</html>
看一下完整目录结构：
配置Tomcat，进行运行！（后面有配置tomcat的链接）
看一下效果：
首页
书籍展示界面
其他功能就不一 一展示了。
如果配置有问题，可以参考以下链接
项目配置以及tomcat配置
文章来源: blog.csdn.net，作者：谦谦均，版权归原作者所有，如需转载，请联系作者。
原文链接：blog.csdn.net/will__be/article/details/116503366
© 版权声明
文章版权归作者所有，未经允许请勿转载。
THE END
![[桜井宁宁]COS和泉纱雾超可爱写真福利集-一一网](https://www.proyy.com/skycj/data/images/2020-12-13/4d3cf227a85d7e79f5d6b4efb6bde3e8.jpg)
![[桜井宁宁] 爆乳奶牛少女cos写真-一一网](https://www.proyy.com/skycj/data/images/2020-12-13/d40483e126fcf567894e89c65eaca655.jpg)
