基于spring、mybatis的图书管理系统

最新推荐文章于 2024-06-15 16:54:27 发布

XuDTone

最新推荐文章于 2024-06-15 16:54:27 发布

阅读量2.2k

点赞数 3

分类专栏： spring、spring mvc与mybatis

本文链接：https://blog.csdn.net/XuDTone/article/details/76228313

版权

spring、spring mvc与mybatis 专栏收录该内容

5 篇文章 0 订阅

订阅专栏

一、流程

jsp页面发起请求-->控制器-->控制器通过一个service对象调用service方法-->service中通过xxxMapper对象调用dao中的方法-->查询数据库

二、图书管理系统

1、目录结构

2、Book实体类

package com.entity;

import java.io.Serializable;
import java.util.Map;
import org.apache.ibatis.type.Alias;

public class Book implements Serializable{


	private static final long serialVersionUID = 1L;
	private Integer id;
	private String name;
	private String author;
	private String bookconcern;
	private String date;
	private String synopsis;	
	private String pic;
		
	public String getPic() {
		return pic;
	}
	public void setPic(String pic) {
		this.pic = pic == null ? null : pic.trim();
	}
	
	public Book() {
		super();
	}
	public Book(Integer id, String name, String author,String bookconcern,String date,String synopsis,String pic) {
		super();
		this.id = id;
		this.name = name;
		this.author = author;
		this.bookconcern = bookconcern;
		this.date =date;
		this.synopsis = synopsis;
		this.pic = pic == null ? null : pic.trim();
	}


	public Integer getId() {
		return id;
	}
	public void setId(Integer id) {
		this.id = id;
	}
	public String getName() {
		return name;
	}
	public void setName(String name) {
		this.name = name;
	}
	public String getAuthor() {
		return author;
	}
	public void setAuthor(String author) {
		this.author = author;
	}
	public String getBookconcern() {
		return bookconcern;
	}
	public void setBookconcern(String bookconcern) {
		this.bookconcern = bookconcern;
	}
	public String getDate() {
		return date;
	}


	public void setDate(String date) {
		this.date = date;
	}


	public String getSynopsis() {
		return synopsis;
	}


	public void setSynopsis(String synopsis) {
		this.synopsis = synopsis;
	}
	public String toString() {
		return "Book [id=" + id + ", name=" + name + ", author="
				+ author + ", bookconcern=" + bookconcern + ", date=" + date + ", synopsis=" + synopsis +", pic=" + pic+"]";
	}

}

3、BookMapper增删改查接口

package com.dao;

import java.util.List;
import org.springframework.web.multipart.MultipartFile;
import com.entity.Book;

public interface BookMapper {
	
	public Book getBookById(Integer id);
	public List<Book> getBooks();	
	public void insertBook(Book book);
	public void deleteBookById(Integer id);
	public void updateBook(Book book);
	public Book findById(Integer id);

}

4、BookMapper.xml实现增删改查操作

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.dao.BookMapper">
	<select id="getBooks" resultType="com.entity.Book">
		select * from book
	</select>
		
    <insert id="insertBook" >
        insert into book
        (name,author,bookconcern,date,synopsis,pic)values(#{name},#{author},#{bookconcern},#{date},#{synopsis},#{pic});
    </insert>

    <delete id="deleteBookById" >
        delete from book
        where id=#{id}
    </delete>
  
    <update id="updateBook">
        update  book set
        name=#{name},author=#{author},bookconcern=#{bookconcern},date=#{date},synopsis=#{synopsis},pic=#{pic} where
        id=#{id} 
    </update>
    
    <select id="findById" parameterType="int" resultType="com.entity.Book">
        select *
        from book where id=#{id};
    </select>
    
</mapper>

5、控制类

package com.controller;


import java.io.File;
import java.io.IOException;
import java.util.List;
import java.util.Map;
import java.util.UUID;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.multipart.MultipartFile;
import com.entity.Book;
import com.service.BookService;


@Controller
public class BookController {
	
	@Autowired
	BookService bookService;
	
	@RequestMapping("/getbooks")
	public String books(Map<String,Object> map){		
		List<Book> books = bookService.getBooks();
		map.put("allBooks", books);
		return "allbooks";
	}
	
	@RequestMapping(value="/insert",produces="text/html;charset=UTF-8")
    public String insert(){	
        return "insert";
    }

    @RequestMapping(value="/insertBook")
    public String insertBook(Book book,MultipartFile book_pic) throws IllegalStateException, IOException{
    	
       	String originalFilename = book_pic.getOriginalFilename();
    		if(book_pic!=null && originalFilename!=null && originalFilename.length()>0){   			
    			String pic_path = "E:\\spring_mybatis\\picture\\";				
    			String newFileName = UUID.randomUUID() + originalFilename.substring(originalFilename.lastIndexOf("."));
    			File newFile = new File(pic_path+newFileName);		
    			book_pic.transferTo(newFile);		
    			book.setPic(newFileName);		
    		}
       bookService.insertBook(book);
       return "redirect:getbooks";
       }
 
    @RequestMapping(value="/deleteBookById")
    public String deleteBookById(Integer id){
        bookService.deleteBookById(id);
        return "redirect:getbooks";
    }
    
    @RequestMapping(value="/findById")
    public String findById(Model model,Integer id){
        Book book=bookService.findById(id);
        model.addAttribute("book",book);
        return "update";
    }
 
    @RequestMapping(value="/updateBook")
    public String updateBook(Book book,MultipartFile book_pic) throws IllegalStateException, IOException{ 
    	
    	String originalFilename = book_pic.getOriginalFilename();
		if(book_pic!=null && originalFilename!=null && originalFilename.length()>0){
			String pic_path = "E:\\spring_mybatis\\picture\\";				
			String newFileName = UUID.randomUUID() + originalFilename.substring(originalFilename.lastIndexOf("."));
			File newFile = new File(pic_path+newFileName);		
			book_pic.transferTo(newFile);		
			book.setPic(newFileName);		
		}	
       bookService.updateBook(book);     
      return "redirect:getbooks";
    
    }

}

6、BookService操作

package com.service;

import java.util.List;
import org.apache.ibatis.session.SqlSession;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.web.multipart.MultipartFile;
import com.dao.BookMapper;
import com.entity.Book;

@Service    //标识这是一个业务类
public class BookService {
	
	@Autowired     //用@Autowired将BookMapper的接口对象注入到spring中
	private BookMapper bookMapper;	
	@Autowired
	private SqlSession sqlSession;
	
	public List<Book> getBooks(){
		return bookMapper.getBooks();
	}
	
	 public void insertBook(Book book) {
	        bookMapper.insertBook(book);    
	    }
	 
	 public void deleteBookById(Integer id) {
	        bookMapper.deleteBookById(id);
	    }

	 public void updateBook(Book book) {
	        bookMapper.updateBook(book);
	    }
	 
	 public Book findById(Integer id) {	       
	        return bookMapper.findById(id);
	    }	
}

7、mybatis配置文件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="mapUnderscoreToCamelCase" value="true"/>
		<setting name="jdbcTypeForNull" value="NULL"/>		
		<setting name="cacheEnabled" value="true"/>
		<setting name="lazyLoadingEnabled" value="true"/>
		<setting name="aggressiveLazyLoading" value="false"/>
	</settings>
	
	<databaseIdProvider type="DB_VENDOR">
		<property name="MySQL" value="mysql"/>
		<property name="SQL Server" value="sqlserver"/>
	</databaseIdProvider>
	
</configuration>

8、spring配置文件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"
	xmlns:context="http://www.springframework.org/schema/context"
	xmlns:mybatis-spring="http://mybatis.org/schema/mybatis-spring"
	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://mybatis.org/schema/mybatis-spring http://mybatis.org/schema/mybatis-spring-1.2.xsd
		http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.0.xsd
		http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.0.xsd">

	<context:component-scan base-package="com">
		<context:exclude-filter type="annotation"
			expression="org.springframework.stereotype.Controller" />
	</context:component-scan>

	<!-- 引入数据库的配置文件 -->
	<context:property-placeholder location="classpath:dbconfig.properties" />
	
	<!-- spring用来控制业务逻辑 -->
	<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
		<property name="jdbcUrl" value="${jdbc.url}"></property>
		<property name="driverClass" value="${jdbc.driver}"></property>
		<property name="user" value="${jdbc.username}"></property>
		<property name="password" value="${jdbc.password}"></property>
	</bean>
	
	<!-- spring事务管理 -->
	<bean id="dataSourceTransactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
		<property name="dataSource" ref="dataSource"></property>
	</bean>

	<!-- 基于注解的事务 -->
	<tx:annotation-driven transaction-manager="dataSourceTransactionManager"/>
	
	<!--创建出SqlSessionFactory对象  -->
	<bean id="sqlSessionFactoryBean" class="org.mybatis.spring.SqlSessionFactoryBean">
		<property name="dataSource" ref="dataSource"></property>
		
		<!-- configLocation指定全局配置文件的位置 -->
		<property name="configLocation" value="classpath:mybatis-config.xml"></property>
		
		<!--mapperLocations: 指定mapper文件的位置-->
		<property name="mapperLocations" value="classpath:mybatis/mapper/*.xml"></property>
	</bean>
	
	<!--配置一个可以进行批量执行的sqlSession  -->
	<bean id="sqlSession" class="org.mybatis.spring.SqlSessionTemplate">
		<constructor-arg name="sqlSessionFactory" ref="sqlSessionFactoryBean"></constructor-arg>
		<constructor-arg name="executorType" value="BATCH"></constructor-arg>
	</bean>
	
	<!-- base-package：指定mapper接口的包名 -->
	<mybatis-spring:scan base-package="com.dao"/>

</beans>

9、连接数据库信息dbconfig.properties

jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/login?allowMultiQueries=true&useUnicode=true&characterEncoding=UTF-8
jdbc.username=root
jdbc.password=123456

10、web.xml配置

<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://java.sun.com/xml/ns/javaee" xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd" id="WebApp_ID" version="2.5">
  <display-name>spring_mybatis</display-name>
  
	<context-param>
		<param-name>contextConfigLocation</param-name>
		<param-value>classpath:applicationContext.xml</param-value>
	</context-param>

	<listener>
		<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
	</listener>
	
	<filter>
		<filter-name>characterEncodingFilter</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>
		<init-param>
			<param-name>forceEncoding</param-name>
			<param-value>true</param-value>
		</init-param>
	</filter>

	<filter-mapping>
    	<filter-name>characterEncodingFilter</filter-name>
    	<url-pattern>/*</url-pattern>
  	</filter-mapping>
	
	<servlet>
		<servlet-name>spring</servlet-name>
		<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
		<load-on-startup>1</load-on-startup>
	</servlet>

	<servlet-mapping>
		<servlet-name>spring</servlet-name>
		<url-pattern>/</url-pattern>
	</servlet-mapping>
  
</web-app>

11、spring mvc配置文件spring-servlet.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:mvc="http://www.springframework.org/schema/mvc"
	xsi:schemaLocation="http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc-4.0.xsd
		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.0.xsd">

	<!-- 只扫描控制器 -->
	<context:component-scan base-package="com" use-default-filters="false">
		<context:include-filter type="annotation" expression="org.springframework.stereotype.Controller"/>
	</context:component-scan>
	
	<!-- 视图解析器 -->
	<bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
		<property name="prefix" value="/WEB-INF/jsp/"></property>
		<property name="suffix" value=".jsp"></property>
	</bean>
	
	<mvc:annotation-driven></mvc:annotation-driven>
	<mvc:default-servlet-handler/>
</beans>

12、jsp页面

（1）index.jsp

<%@ page language="java" contentType="text/html; charset=utf-8"
    pageEncoding="utf-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>首页</title>
    <style type="text/css">    
    #top{
    border:1px solid gainsboro;
	width:100%;
	height:100px;
    }      
	#left{
	border:1px solid gainsboro;
	float:left;
	width:10%;
	height:400px;
	}
    #left ul{
    width:980px;
    margin:0px auto;
    height:38px;
    padding:0;
    }
    #left ul li a{
    width:80px;
    height:28px;
    line-height:28px;
    background:gray;
    color:#FFF;
    margin:5px 10px;
    font-size:16px;
    display:block;
    text-align:center;
    text-decoration:none;
    }
    #left ul li a:hover{
    width:78px;
    height:26px;
    line-height:28px;
    color:gray;
    background:#FFF;
    }
	#right{
	border:1px solid gainsboro;	
	width:89%;
	height:400px;
	float:right;
	}	
    </style>
</head>
<body>


   <div id="top">
   <img src="img/title.jpg"  />
   </div>
  	<div id="left"> 
  	<ul>
<li><a href="getbooks" >所有图书</a></li>
  	<li><a href="insert" >添加图书</a></li>	
         </ul>  
  	</div> 
	     <div id="right">	                          
	    <img src="img/3.jpg" width=100% height=100%>	
     </div>     
</body>
</html>

（2）allbooks.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<%@taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>所有图书</title>

</head>
<body>
    <table align="center" border="5"  width=70% height=60%>  
   <tr>
            <td colspan="7"><h1>所有图书</h1></td>
        </tr>
        <tr>  
            <td align="center" >编号</td>  
            <td align="center">书名</td>  
            <td align="center" width=10% >作者</td>   
            <td align="center">出版社</td> 
            <td align="center" width=15% >出版时间</td> 
            <td align="center">简介</td> 
            <td align="center">图书图片</td>
            <td align="center" width=12%>操作</td>  
        </tr>  
  
       <c:forEach items="${allBooks }" var="book">
			<tr>
				<td>${book.id }</td>
				<td>${book.name }</td>
				<td>${book.author }</td>
				<td>${book.bookconcern }</td>
				<td>${book.date }</td>
				<td>${book.synopsis }</td>
				<td>
				<c:if test="${book.pic !=null}">
			<img src="/pic/${book.pic}" width=100 height=100/>
			<br/>
		</c:if>
		</td>
				<td align="center"><a href="deleteBookById?id=${book.id }">删除</a>|<a href="findById?id=${book.id} ">修改</a></td> 
			</tr>
			
		</c:forEach>   
   <tr><td border="0"><input type="button" value="返回首页" οnclick="javascript:window.location.href ='index.jsp';"/></td></tr>
 </table>    
</body>
</html>

`（3）insert.jsp`

<%@ page language="java" import="java.util.*" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>    
    <title>添加图书</title>
  </head>
  <body>
  <form action="insertBook" method="post" enctype="multipart/form-data" enctype="multipart/form-data">
    <table border="5" align="center" width=70% height=60%>
        <tr>
            <td colspan="2"><h1>添加图书</h1></td>
        </tr>
        <tr>
            <td>书籍名称:</td>
            <td><input  type="text" name="name" size=85/></td>
        </tr>
        <tr>
            <td>书籍作者:</td>
            <td><input  type="text" name="author" size=85/></td>
        </tr>
         <tr>
            <td>出版社:</td>
            <td><input  type="text" name="bookconcern" size=85/></td>
        </tr>
        <tr>
            <td>出版时间:</td>
            <td><input  type="text" name="date" size=85/></td>
        </tr>
        <tr>
            <td>简介:</td>
            <td><input  type="text"  name="synopsis" size=85/></td>
        </tr>
        
          <tr>                
<td>图书图片</td>
<td>
<input type="file"  name="book_pic"/> 
</td>
</tr>
     
        <tr>
            <td colspan="2">
                <input  type="submit" value="提交"/>
                <input  type="reset" value="清空"/>
                <input type="button" value="返回首页" οnclick="javascript:window.location.href ='index.jsp';"/>
            </td>
        </tr>
    </table>
   </form>
  </body>
</html>

（4）update.jsp

<%@ page language="java" import="java.util.*" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<%@taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>    
  <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> 
    <title>修改图书信息</title>
  </head>
  
  <body>
    <form action="updateBook" method="post" enctype="multipart/form-data" >
    <table  border="5" align="center" width=70% height=60%>
        <tr>
            <td colspan="2"><h1>修改图书信息</h1></td>
        </tr>
        <tr>
            <td>编号:</td>
            <td><input  type="text" name="id" value="${book.id}" readonly="readonly" size=85/></td>
        </tr>
        
        <tr>
            <td>书名:</td>
            <td><input  type="text" name="name" value="${book.name}" size=85/></td>
        </tr>
        <tr>
            <td>作者:</td>
            <td><input  type="text" name="author" value="${book.author}" size=85/></td>
        </tr>
         <tr>
            <td>出版社:</td>
            <td><input  type="text" name="bookconcern" value="${book.bookconcern}" size=85/></td>
        </tr>
         <tr>
            <td>出版时间:</td>
            <td><input  type="text" name="date" value="${book.date}" size=85/></td>
        </tr>
         <tr>
             <td>简介:</td>
            <td><input  type="text" name="synopsis" value="${book.synopsis}" size=85/></td>
        </tr>        
        <tr>
<td>图书图片</td>
<td>
<c:if test="${book.pic !=null}">
<img src="/pic/${book.pic}" width=100 height=100/>
<br/>
</c:if>
<input type="file"  name="book_pic"/> 
</td>
</tr>
        <tr>
            <td colspan="2">
                <input  type="submit" value="提交"/>
               <input type="button" value="返回首页" οnclick="javascript:window.location.href ='index.jsp';"/>
            </td>
        </tr>
    </table>
   </form>
  </body>
</html>

13、所需的jar包

XuDTone

关注

3
点赞
踩
33

收藏

觉得还不错? 一键收藏
0
评论
基于spring、mybatis的图书管理系统

一、流程jsp页面发起请求-->控制器-->控制器通过一个service对象调用service方法-->service中通过xxxMapper对象调用dao中的方法-->查询数据库二、图书管理系统1、目录结构2、Book实体类package com.entity;import java.io.Serializable;import java.util.Map;
复制链接

扫一扫

专栏目录