基于ssm框架的图书管理系统

创建数据库环境

创建数据库ssmbuild 创建表books

CREATE DATABASE `ssmbuild`;

USE `ssmbuild`;

DROP TABLE IF EXISTS `books`;

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,'从进门到进牢');

搭建基本环境

新建maven项目导入相关依赖

<groupId>junit</groupId>

<artifactId>junit</artifactId>

</dependency>

<groupId>mysql</groupId>

<artifactId>mysql-connector-java</artifactId>

</dependency>

<groupId>com.mchange</groupId>

</dependency>

<groupId>javax.servlet</groupId>

<artifactId>servlet-api</artifactId>

</dependency>

<groupId>javax.servlet.jsp</groupId>

</dependency>

<groupId>javax.servlet</groupId>

</dependency>

<groupId>org.mybatis</groupId>

<artifactId>mybatis</artifactId>

</dependency>

<groupId>org.mybatis</groupId>

<artifactId>mybatis-spring</artifactId>

</dependency>

<groupId>org.springframework</groupId>

<artifactId>spring-webmvc</artifactId>

<version>5.1.9.RELEASE</version>

</dependency>

<groupId>org.springframework</groupId>

<artifactId>spring-jdbc</artifactId>

<version>5.1.9.RELEASE</version>

</dependency>

<groupId>org.projectlombok</groupId>

<artifactId>lombok</artifactId>

</dependency>

</dependencies>

配置maven静态资源过滤设置

里面的filtering不论是false还是true 都是可以的

<build>

<include>**/*.properties</include>

</includes>

<filtering>false</filtering>

</resource>

<directory>src/main/resources</directory>

<include>**/*.properties</include>

</includes>

<filtering>false</filtering>

</resource>

</resources>

</build>

创建目录结构

com.lin.pojo

com.lin.dao

com.lin.service

com.lin.controller

编写配置文件

到官方下载文件头

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">

</beans>

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

数据库配置文件

database.properties

jdbc.driver=com.mysql.jdbc.Driver

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

jdbc.username=root

jdbc.password=root

编写MyBatis的核心配置文件

<?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">

<!-- name:指定包名，为当前包及以下所有后代包的每一个类都起一个默认别名(类名小写)

</typeAliases>

</mappers>

</configuration>

编写数据库对应的实体类

使用Lombok

com.lin.pojo.Books

package com.lin.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.lin.dao.BookMapper

package com.lin.dao;

import java.util.List;

import org.apache.ibatis.annotations.Param;

import com.lin.pojo.Books;

public interface BookMapper {

//增加一本书

int addBook(Books books);

//删除一本书

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

//更新一本书

int updateBook(Books books);

//查询一本书

Books queryBookById(int id);

//查询全部的书

List<Books>qureyAllBook();

//根据书名查询书籍

List<Books> queryBookByName(String bookName);

}

编写接口对应的Mapper.xml文件

com.lin.dao.BookMapper.xml

<?xml version="1.0" encoding="UTF8" ?>

<!DOCTYPE mapper

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});

</insert>

delete from ssmbuild.books where bookID = #{bookID};

</delete>

update ssmbuild.books

set bookName=#{bookName},bookCounts=#{bookCounts},detail=#{detail}

where bookID=#{bookID};

</update>

select * from ssmbuild.books

where bookID=#{bookID}

</select>

select * from ssmbuild.books

</select>

select * from ssmbuild.books where bookName like concat('%',#{bookName},'%')

</select>

</mapper>

编写Service层的接口和实现类

接口

com.lin.service.BookService

package com.lin.service;

import java.util.List;

import com.lin.pojo.Books;

//BookService:底下需要去实现,调用dao层

public interface BookService {

//增加一本书

int addBook(Books books);

//删除一本书

int deleteBookById(int id);

//更新一本书

int updateBook(Books books);

//查询一本书

Books queryBookById(int id);

//查询全部的书

List<Books> qureyAllBook();

//根据书名查询对应书籍书

List<Books> queryBookByName(String bookName);

}

实现类

com.lin.service.BookServiceImpl

package com.lin.service;

import java.util.List;

import com.lin.dao.BookMapper;

import com.lin.pojo.Books;

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<Books> qureyAllBook() {

return bookMapper.qureyAllBook();

}

@Override

public List<Books> queryBookByName(String bookName) {

return bookMapper.queryBookByName(bookName);

}

Spring层

配置Spring整合MyBatis 这里使用c3p0连接池

spring-dao.xml

<?xml version="1.0" encoding="UTF8"?>

<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

http://www.springframework.org/schema/context/spring-context-4.2.xsd">

<context:property-placeholder location="classpath:database.properties"></context:property-placeholder>

</bean>

</bean>

</bean>

</beans>

spring整合service层

spring-service.xml

<?xml version="1.0" encoding="UTF8"?>

<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:component-scan base-package="com.lin.service"></context:component-scan>

</bean>

</bean>

</beans>

加入web框架支持

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

spring-mvc.xml

<?xml version="1.0" encoding="UTF8"?>

<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:mvc="http://www.springframework.org/schema/mvc"

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

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

http://www.springframework.org/schema/context

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

http://www.springframework.org/schema/mvc

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

<mvc:annotation-driven></mvc:annotation-driven>

<mvc:default-servlet-handler></mvc:default-servlet-handler>

<context:component-scan base-package="com.lin.controller"></context:component-scan>

</bean>

</beans>

spring配置整合文件 applicationContext.xml

<?xml version="1.0" encoding="UTF8"?>

<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">

</beans>

Controller和视图层的编写

com.lin.controller.BookController

package com.lin.controller;

import java.lang.ProcessBuilder.Redirect;

import java.util.ArrayList;

import java.util.List;

import org.springframework.beans.factory.annotation.Autowired;

import org.springframework.beans.factory.annotation.Qualifier;

import org.springframework.stereotype.Controller;

import org.springframework.stereotype.Service;

import org.springframework.ui.Model;

import org.springframework.web.bind.annotation.PathVariable;

import org.springframework.web.bind.annotation.RequestMapping;

import com.lin.pojo.Books;

import com.lin.service.BookService;

@Controller

@RequestMapping("/book")

public class BookController {

//controller层调用service层

@Autowired

@Qualifier("BookServiceImpl")

private BookService bookService;

//查询全部书籍并且返回到书籍展示界面

@RequestMapping("/allBook")

public String list(Model model){

List<Books> list = bookService.qureyAllBook();

model.addAttribute("list",list);

return "allBook";

}

//跳转到增加书籍页面

@RequestMapping("/toAddBook")

public String toAddPaper(){

return "addBook";

}

//添加书籍请求

@RequestMapping("/addBook")

public String addPaper(Books books){

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

bookService.addBook(books);

return "redirect:/book/allBook";//重定向到@RequestMapping("/allBook")请求

}

//跳转到修改页面

@RequestMapping("/toUpdate")

public String toUpdatePaper(int id,Model model){

Books books = bookService.queryBookById(id);

model.addAttribute("QBooks",books);

return "updateBook";

}

//修改书籍

@RequestMapping("/updateBook")

public String updateBook(Books books){

System.out.println("updataBook=="+books);

bookService.updateBook(books);

return "redirect:/book/allBook";

}

//删除书籍

@RequestMapping("/deleteBook")

public String deleteBook(int id){

bookService.deleteBookById(id);

return "redirect:/book/allBook";

}

//查询书籍

@RequestMapping("/queryBook")

public String queryBook(String queryBookName,Model model){

List<Books> list = bookService.queryBookByName(queryBookName);

//若list为空,表示没有查询到，输出查询结果为空并跳转到开始页面

if(null == list || list.size() ==0){

list = bookService.qureyAllBook();

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

}

model.addAttribute("list",list);

return "allBook";

}

编写首页index.jsp

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

<html>

<head>

<style>

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: 5px;

}

</style>

</head>

<body>

<h3>

<a href="${pageContext.request.contextPath}/book/allBook">进入书籍页面</a>

</h3>

</body>

</html>

书籍列表页面 allbook.jsp

<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>

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

<html>

<head>

<title>书籍展示页面</title>

<%--BootStrap美化界面 --%>

</head>

<body>

<h1>

<small>书籍列表 --------- 显示所有书籍</small>

</h1>

</div>

<%--toAddBook--%>

<a class="btn btn-primary" href="${pageContext.request.contextPath}/book/allBook">显示全部书籍</a>

</div>

<span style="color: red;font-weight: bold">${error}</span>

</form>

</div>

<thead>

<tr>

</tr>

</thead>

<%--书籍从数据库中查询出来,从这个list中遍历出来 foreach--%>

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

</td>

</tr>

</c:forEach>

</tbody>

</table>

</div>

</body>

</html>

修改书籍页面 updateBook.jsp

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

<html>

<head>

</head>

<body>

<h1>

</h1>

</div>

</div>

</div>

</div>

</div>

</div>

</form>

</div>

</body>

</html>

添加书籍页面：addBook.jsp

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

<html>

<head>

</head>

<body>

<h1>

</h1>

</div>

</div>

</div>

</div>

</div>

</form>

</div>

</body>

</html>

基于ssm框架的图书管理系统

推荐阅读更多精彩内容