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

来源：互联网发布：unity3d 太空场景编辑：程序博客网时间：2024/05/29 11:29

一、流程

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;@Controllerpublic class BookController {@AutowiredBookService 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;@Autowiredprivate 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.xsdhttp://mybatis.org/schema/mybatis-spring http://mybatis.org/schema/mybatis-spring-1.2.xsdhttp://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.0.xsdhttp://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.Driverjdbc.url=jdbc:mysql://localhost:3306/login?allowMultiQueries=true&useUnicode=true&characterEncoding=UTF-8jdbc.username=rootjdbc.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.xsdhttp://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsdhttp://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="返回首页" onclick="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="返回首页" onclick="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="返回首页" onclick="javascript:window.location.href ='index.jsp';"/>            </td>        </tr>    </table>   </form>  </body></html>

13、所需的jar包

阅读全文

0 0