利用Servlet和JSP设计并实现简单的图书管理系统

实验六 利用Servlet和JSP设计并实现简单的图书管理系统1、实验目的1）掌握对JDBC基本操作步骤的简单封装 2）掌握Servlet和JSP结合使用3）掌握MVC设计模式4）掌握监听器、过滤器的使用2、实验设备与环境硬件：安装有Windows XP系统的微机一台。软件：JDK1.6、MyEclipse 6.0以上、Oracle或者SQL Server2000（2005、2008）和Tomcat 6。3、实验内容设计一个通用的基于浏览器/服务器的简单的图书管理系统。系统包括用户登录、图书基本信息维护（图书的增删改查）等简单功能。4、实验要求1）用户、图书的基本信息采用数据库存放2）使用Servlet作为业务流程控制器3）使用session、JavaBean进行数据传递5、实验要求1）实验前充分预习实验指导书内容及相关理论知识内容；实验时提交本次实验的预习报告。2）实验中严格遵守实验室规范和制度，调试程序出现的问题并给出解决方法。认真完成实验内容并做好实验纪录3）实验后必须按照要求独立完成实验报告4）打印的源程序清单和测试结果附在实验报告的后面。源程序必须有注释以及必要的测试数据和运行结果数据6、实验程序 登录界面 package com.imut.servlet;import java.io.IOException;import javax.servlet.ServletException;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import javax.servlet.http.HttpSession;import com.imut.javabean.User;import com.imut.javabean.UserDBAccess;public class LoginServlet extends HttpServlet public void doGet(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException doPost(request, response);public void doPost(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException HttpSession session=request.getSession();request.setCharacterEncoding(UTF-8);response.setCharacterEncoding(UTF-8); String name=request.getParameter(name); String passwd=request.getParameter(password); UserDBAccess dbAccess=new UserDBAccess(); User user=dbAccess.login(name,passwd); if(user!=null)session.setAttribute(user,user);response.sendRedirect(http:/localhost:8081/book/index.jsp);elsesession.setAttribute(message,登录信息有误，请重新登录！);response.sendRedirect(http:/localhost:8081/book/login.jsp);添加package com.imut.servlet;import java.io.IOException;import java.util.Date;import java.util.List;import javax.servlet.ServletException;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import javax.servlet.http.HttpSession;import com.imut.javabean.Book;import com.imut.javabean.BookDBAccess;import com.imut.javabean.User;import com.imut.javabean.UserDBAccess;public class AddBookServlet extends HttpServlet public void doGet(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException doPost(request, response);public void doPost(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException HttpSession session=request.getSession();request.setCharacterEncoding(UTF-8);response.setCharacterEncoding(UTF-8);String bookName=request.getParameter(bookName);String ISBN=request.getParameter(ISBN);String author=request.getParameter(author);String publishCom=request.getParameter(publishCom);String strPrice=request.getParameter(price);String publishDate=request.getParameter(publishDate);String remark=request.getParameter(remark);float price=Float.parseFloat(strPrice);BookDBAccess dbAccess=new BookDBAccess();Book book=new Book(dbAccess.getBookId(),bookName,ISBN,author,publishCom,price,publishDate,remark);dbAccess.addBook(book); session.setAttribute(message, 图书信息添加成功！); request.getRequestDispatcher(/listAllBookServlet).forward(request, response);删除 package com.imut.servlet;import java.io.IOException;import java.util.List;import javax.servlet.ServletException;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import javax.servlet.http.HttpSession;import com.imut.javabean.Book;import com.imut.javabean.BookDBAccess;import com.imut.javabean.User;import com.imut.javabean.UserDBAccess;public class DeleteBookServlet extends HttpServlet public void doGet(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException doPost(request, response);public void doPost(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException HttpSession session=request.getSession();request.setCharacterEncoding(UTF-8);response.setCharacterEncoding(UTF-8);String id=request.getParameter(bookId);int bookId=Integer.parseInt(id); BookDBAccess dbAccess=new BookDBAccess(); dbAccess.delBookById(bookId); session.setAttribute(message, 删除图书信息成功！); request.getRequestDispatcher(/listAllBookServlet).forward(request, response);更新package com.imut.servlet;import java.io.IOException;import java.util.List;import javax.servlet.ServletException;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import javax.servlet.http.HttpSession;import com.imut.javabean.Book;import com.imut.javabean.BookDBAccess;import com.imut.javabean.User;import com.imut.javabean.UserDBAccess;public class UpdateBookServlet extends HttpServlet public void doGet(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException doPost(request, response);public void doPost(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException HttpSession session=request.getSession();request.setCharacterEncoding(UTF-8);response.setCharacterEncoding(UTF-8);String id=request.getParameter(bookId);String bookName=request.getParameter(bookName);String ISBN=request.getParameter(ISBN);String author=request.getParameter(author);String publishCom=request.getParameter(publishCom);String strPrice=request.getParameter(price);String publishDate=request.getParameter(publishDate);String remark=request.getParameter(remark);int bookId=Integer.parseInt(id);float price=Float.parseFloat(strPrice); BookDBAccess dbAccess=new BookDBAccess(); Book book=dbAccess.findBookById(bookId); book.setAuthor(author); book.setBookName(bookName); book.setISBN(ISBN); book.setPrice(price); book.setPublishCom(publishCom); book.setPublishDate(publishDate); book.setRemark(remark); dbAccess.updateBook(book); session.setAttribute(message, 修改图书信息成功！); request.getRequestDispatcher(/listAllBookServlet).forward(request, response);书籍管理界面package com.imut.servlet;import java.io.IOException;import java.util.List;import javax.servlet.ServletException;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import javax.servlet.http.HttpSession;import com.imut.javabean.Book;import com.imut.javabean.BookDBAccess;import com.imut.javabean.User;import com.imut.javabean.UserDBAccess;public class ShowBookServlet extends HttpServlet public void doGet(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException doPost(request, response);public void doPost(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException request.setCharacterEncoding(UTF-8);response.setCharacterEncoding(UTF-8);String id=request.getParameter(bookId);int bookId=Integer.parseInt(id);BookDBAccess dbAccess=new BookDBAccess();Book book=dbAccess.findBookById(bookId);request.setAttribute(book,book);request.getRequestDispatcher(/bookShow.jsp).forward(request, response);检索package com.imut.servlet;import java.io.IOException;import java.util.List;import javax.servlet.ServletException;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import javax.servlet.http.HttpSession;import com.imut.javabean.BookDBAccess;import com.imut.javabean.User;import com.imut.javabean.UserDBAccess;public class CheckBookServlet extends HttpServlet public void doGet(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException doPost(request, response);public void doPost(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException request.setCharacterEncoding(UTF-8);response.setCharacterEncoding(UTF-8);String bookName=request.getParameter(bookName);String ISBN=request.getParameter(ISBN);String author=request.getParameter(author);String publishCom=request.getParameter(publishCom);request.setAttribute(bookName, bookName);request.setAttribute(ISBN, ISBN);request.setAttribute(author, author);request.setAttribute(publishCom, publishCom); BookDBAccess dbAccess=new BookDBAccess(); List list=dbAccess.findAllBookByMostCon(bookName, ISBN, author, publishCom); request.setAttribute(list, list); request.getRequestDispatcher(/bookList.jsp).forward(request, response);显示图书清单package com.imut.servlet;import java.io.IOException;import java.util.List;import javax.servlet.ServletException;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import javax.servlet.http.HttpSession;import com.imut.javabean.BookDBAccess;import com.imut.javabean.User;import com.imut.javabean.UserDBAccess;public class ListAllBookServlet extends HttpServlet public void doGet(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException doPost(request, response);public void doPost(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException request.setCharacterEncoding(UTF-8);response.setCharacterEncoding(UTF-8); BookDBAccess dbAccess=new BookDBAccess(); List list=dbAccess.findAllBook(); request.setAttribute(list, list); request.getRequestDispatcher(/bookList.jsp).forward(request, response);用户定义package com.imut.javabean;public class User private int userId;private String name;private String password;private String sex;private String feature;private String privence;private String author;private int userType;public User() public User(int userId,String name, String password, String sex, String feature,String privence, String author,int userType) this.userId = userId; = name;this.password = password;this.sex = sex;this.feature = feature;this.privence = privence;this.author = author;this.userType = userType;public int getUserId() return userId;public void setUserId(int userId) this.userId = userId;public String getName() return name;public void setName(String name) = name;public String getPassword() return password;public void setPassword(String password) this.password = password;public String getSex() return sex;public void setSex(String sex) this.sex = sex;public String getFeature() return feature;public void setFeature(String feature) this.feature = feature;public String getPrivence() return privence;public void setPrivence(String privence) this.privence = privence;public String getAuthor() return author;public void setAuthor(String author) this.author = author;public int getUserType() return userType;public void setUserType(int userType) this.userType = userType;用户数据库package com.imut.javabean;import java.sql.Connection;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.SQLException;import mmon.ConnectionFactory;import mmon.ResourceClose;public class UserDBAccess public User login(String name,String password) User user=null;Connection conn=null;PreparedStatement pstmt=null;ResultSet rs=null;tryconn=ConnectionFactory.getConnection();String sql=select * from usertbl1 where name=? and password=?; pstmt=conn.prepareStatement(sql);pstmt.setString(1, name);pstmt.setString(2, password);rs=pstmt.executeQuery();if(rs.next()user=new User();user.setUserId(rs.getInt(1);user.setName(rs.getString(2);user.setPassword(rs.getString(3);user.setSex(rs.getString(4);user.setFeature(rs.getString(5);user.setPrivence(rs.getString(6);user.setAuthor(rs.getString(7);user.setUserType(rs.getInt(8);catch (SQLException e) e.printStackTrace();finallyResourceClose.close(rs, pstmt, conn);return user;图书定义package com.imut.javabean;public class Book private int bookId;private String bookName;private String author;private String ISBN;private String publishCom;private float price;private String publishDate;private String remark;public Book() public Book(int bookId, String bookName, String isbn, String author,String publishCom, float price, String publishDate, String remark) this.bookId = bookId;this.bookName = bookName;ISBN = isbn;this.author = author;this.publishCom = publishCom;this.price = price;this.publishDate = publishDate;this.remark = remark;public int getBookId() return bookId;public void setBookId(int bookId) this.bookId = bookId;public String getBookName() return bookName;public void setBookName(String bookName) this.bookName = bookName;public String getISBN() return ISBN;public void setISBN(String isbn) ISBN = isbn;public String getAuthor() return author;public void setAuthor(String author) this.author = author;public String getPublishCom() return publishCom;public void setPublishCom(String publishCom) this.publishCom = publishCom;public float getPrice() return price;public void setPrice(float price) this.price = price;public String getPublishDate() return publishDate;public void setPublishDate(String publishDate) this.publishDate = publishDate;public String getRemark() return remark;public void setRemark(String remark) this.remark = remark;图书数据库package com.imut.javabean;import java.sql.Connection;import java.sql.Date;import java.sql.DriverManager;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;import java.util.ArrayList;import java.util.List;import mmon.ConnectionFactory;import mmon.ResourceClose;public class BookDBAccess public void addBook(Book book) Connection conn=null;PreparedStatement pstmt=null;ResultSet rs=null;tryconn=ConnectionFactory.getConnection();String sql=insert into book values(?,?,?,?,?,?,?,?); pstmt=conn.prepareStatement(sql);pstmt.setInt(1, book.getBookId();pstmt.setString(2, book.getBookName();pstmt.setString(3, book.getAuthor();pstmt.setString(4, book.getISBN();pstmt.setString(5, book.getPublishCom();pstmt.setFloat(6, book.getPrice();pstmt.setString(7, book.getPublishDate();pstmt.setString(8, book.getRemark();pstmt.executeUpdate();catch (SQLException e) e.printStackTrace();finallyResourceClose.close(rs, pstmt, conn);public void delBookById(int bookId)Connection conn=null;PreparedStatement pstmt=null;ResultSet rs=null;tryconn=ConnectionFactory.getConnection();String sql=delete from book where bookId=?; pstmt=conn.prepareStatement(sql);pstmt.setInt(1, bookId);pstmt.executeUpdate();catch (SQLException e) e.printStackTrace();finallyResourceClose.close(rs, pstmt, conn);public void updateBook(Book book) Connection conn=null;PreparedStatement pstmt=null;ResultSet rs=null;tryconn=ConnectionFactory.getConnection();String sql=update book set bookId=?,bookName=?,author=?,ISBN=?,+publishCom=?,price=?,publishDate=?,remark=? where bookId=?; pstmt=conn.prepareStatement(sql);pstmt.setInt(1, book.getBookId();pstmt.setString(2, book.getBookName();pstmt.setString(3, book.getAuthor();pstmt.setString(4, book.getISBN();pstmt.setString(5, book.getPublishCom();pstmt.setFloat(6, book.getPrice();pstmt.setString(7, book.getPublishDate();pstmt.setString(8, book.getRemark();pstmt.setInt(9, book.getBookId();pstmt.executeUpdate();catch (SQLException e) e.printStackTrace();finallyResourceClose.close(rs, pstmt, conn);public List findAllBook()Book book=null;ArrayList list=new ArrayList();Connection conn=null;PreparedStatement pstmt=null;ResultSet rs=null;tryconn=ConnectionFactory.getConnection();String sql=select * from book order by bookId; pstmt=conn.prepareStatement(sql);rs=pstmt.executeQuery();while(rs.next()book=new Book();book.setBookId(rs.getInt(1);book.setBookName(rs.getString(2);book.setAuthor(rs.getString(3);book.setISBN(rs.getString(4);book.setPublishCom(rs.getString(5);book.setPrice(rs.getFloat(6);book.setPublishD