spring mybatis图书管理系统 spring+mybatis实现图书管理系统
XuDTone 人气:2本文为大家分享了spring+mybatis实现的图书管理系统,供大家参考,具体内容如下
一、流程
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" rel="external nofollow" >所有图书</a></li> <li><a href="insert" rel="external nofollow" >添加图书</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 }" rel="external nofollow" >删除</a>|<a href="findById?id=${book.id} " rel="external nofollow" >修改</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包
更多学习资料请关注专题《管理系统开发》。
加载全部内容