利用Servlet和JSP设计并实现简单的图书管理系统.docx
- 文档编号:6026198
- 上传时间:2023-01-03
- 格式:DOCX
- 页数:28
- 大小:317.38KB
利用Servlet和JSP设计并实现简单的图书管理系统.docx
《利用Servlet和JSP设计并实现简单的图书管理系统.docx》由会员分享,可在线阅读,更多相关《利用Servlet和JSP设计并实现简单的图书管理系统.docx(28页珍藏版)》请在冰豆网上搜索。
利用Servlet和JSP设计并实现简单的图书管理系统
实验六利用Servlet和JSP设计并实现简单的图书管理系统
1、实验目的
1)掌握对JDBC基本操作步骤的简单封装
2)掌握Servlet和JSP结合使用
3)掌握MVC设计模式
4)掌握监听器、过滤器的使用
2、实验设备与环境
硬件:
安装有WindowsXP系统的微机一台。
软件:
JDK1.6、MyEclipse6.0以上、Oracle或者SQLServer2000(2005、2008)和Tomcat6。
3、实验内容
设计一个通用的基于浏览器/服务器的简单的图书管理系统。
系统包括用户登录、图书基本信息维护(图书的增删改查)等简单功能。
4、实验要求
1)用户、图书的基本信息采用数据库存放
2)使用Servlet作为业务流程控制器
3)使用session、JavaBean进行数据传递
5、实验要求
1)实验前充分预习实验指导书内容及相关理论知识内容;实验时提交本次实验的预习报告。
2)实验中严格遵守实验室规范和制度,调试程序出现的问题并给出解决方法。
认真完成实验内容并做好实验纪录
3)实验后必须按照要求独立完成实验报告
4)打印的源程序清单和测试结果附在实验报告的后面。
源程序必须有注释以及必要的测试数据和运行结果数据
6、实验程序
<1>登录界面
packagecom.imut.servlet;
importjava.io.IOException;
importjavax.servlet.ServletException;
importjavax.servlet.http.HttpServlet;
importjavax.servlet.http.HttpServletRequest;
importjavax.servlet.http.HttpServletResponse;
importjavax.servlet.http.HttpSession;
importcom.imut.javabean.User;
importcom.imut.javabean.UserDBAccess;
publicclassLoginServletextendsHttpServlet{
publicvoiddoGet(HttpServletRequestrequest,HttpServletResponseresponse)
throwsServletException,IOException{
doPost(request,response);
}
publicvoiddoPost(HttpServletRequestrequest,HttpServletResponseresponse)
throwsServletException,IOException{
HttpSessionsession=request.getSession();
request.setCharacterEncoding("UTF-8");
response.setCharacterEncoding("UTF-8");
Stringname=request.getParameter("name");
Stringpasswd=request.getParameter("password");
UserDBAccessdbAccess=newUserDBAccess();
Useruser=dbAccess.login(name,passwd);
if(user!
=null){
session.setAttribute("user",user);
response.sendRedirect("http:
//localhost:
8081/book/index.jsp");
}else{
session.setAttribute("message","登录信息有误,请重新登录");
response.sendRedirect("http:
//localhost:
8081/book/login.jsp");
}
}
}
<2>添加
packagecom.imut.servlet;
importjava.io.IOException;
importjava.util.Date;
importjava.util.List;
importjavax.servlet.ServletException;
importjavax.servlet.http.HttpServlet;
importjavax.servlet.http.HttpServletRequest;
importjavax.servlet.http.HttpServletResponse;
importjavax.servlet.http.HttpSession;
importcom.imut.javabean.Book;
importcom.imut.javabean.BookDBAccess;
importcom.imut.javabean.User;
importcom.imut.javabean.UserDBAccess;
publicclassAddBookServletextendsHttpServlet{
publicvoiddoGet(HttpServletRequestrequest,HttpServletResponseresponse)
throwsServletException,IOException{
doPost(request,response);
}
publicvoiddoPost(HttpServletRequestrequest,HttpServletResponseresponse)
throwsServletException,IOException{
HttpSessionsession=request.getSession();
request.setCharacterEncoding("UTF-8");
response.setCharacterEncoding("UTF-8");
StringbookName=request.getParameter("bookName");
StringISBN=request.getParameter("ISBN");
Stringauthor=request.getParameter("author");
StringpublishCom=request.getParameter("publishCom");
StringstrPrice=request.getParameter("price");
StringpublishDate=request.getParameter("publishDate");
Stringremark=request.getParameter("remark");
floatprice=Float.parseFloat(strPrice);
BookDBAccessdbAccess=newBookDBAccess();
Bookbook=newBook(dbAccess.getBookId(),bookName,ISBN,author,
publishCom,price,publishDate,remark);
dbAccess.addBook(book);
session.setAttribute("message","图书信息添加成功!
");
request.getRequestDispatcher("/listAllBookServlet").forward(request,response);
}
}
<3>删除
packagecom.imut.servlet;
importjava.io.IOException;
importjava.util.List;
importjavax.servlet.ServletException;
importjavax.servlet.http.HttpServlet;
importjavax.servlet.http.HttpServletRequest;
importjavax.servlet.http.HttpServletResponse;
importjavax.servlet.http.HttpSession;
importcom.imut.javabean.Book;
importcom.imut.javabean.BookDBAccess;
importcom.imut.javabean.User;
importcom.imut.javabean.UserDBAccess;
publicclassDeleteBookServletextendsHttpServlet{
publicvoiddoGet(HttpServletRequestrequest,HttpServletResponseresponse)
throwsServletException,IOException{
doPost(request,response);
}
publicvoiddoPost(HttpServletRequestrequest,HttpServletResponseresponse)
throwsServletException,IOException{
HttpSessionsession=request.getSession();
request.setCharacterEncoding("UTF-8");
response.setCharacterEncoding("UTF-8");
Stringid=request.getParameter("bookId");
intbookId=Integer.parseInt(id);
BookDBAccessdbAccess=newBookDBAccess();
dbAccess.delBookById(bookId);
session.setAttribute("message","删除图书信息成功!
");
request.getRequestDispatcher("/listAllBookServlet").forward(request,response);
}
}
<4>更新
packagecom.imut.servlet;
importjava.io.IOException;
importjava.util.List;
importjavax.servlet.ServletException;
importjavax.servlet.http.HttpServlet;
importjavax.servlet.http.HttpServletRequest;
importjavax.servlet.http.HttpServletResponse;
importjavax.servlet.http.HttpSession;
importcom.imut.javabean.Book;
importcom.imut.javabean.BookDBAccess;
importcom.imut.javabean.User;
importcom.imut.javabean.UserDBAccess;
publicclassUpdateBookServletextendsHttpServlet{
publicvoiddoGet(HttpServletRequestrequest,HttpServletResponseresponse)
throwsServletException,IOException{
doPost(request,response);
}
publicvoiddoPost(HttpServletRequestrequest,HttpServletResponseresponse)
throwsServletException,IOException{
HttpSessionsession=request.getSession();
request.setCharacterEncoding("UTF-8");
response.setCharacterEncoding("UTF-8");
Stringid=request.getParameter("bookId");
StringbookName=request.getParameter("bookName");
StringISBN=request.getParameter("ISBN");
Stringauthor=request.getParameter("author");
StringpublishCom=request.getParameter("publishCom");
StringstrPrice=request.getParameter("price");
StringpublishDate=request.getParameter("publishDate");
Stringremark=request.getParameter("remark");
intbookId=Integer.parseInt(id);
floatprice=Float.parseFloat(strPrice);
BookDBAccessdbAccess=newBookDBAccess();
Bookbook=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);
}
}
<5>书籍管理界面
packagecom.imut.servlet;
importjava.io.IOException;
importjava.util.List;
importjavax.servlet.ServletException;
importjavax.servlet.http.HttpServlet;
importjavax.servlet.http.HttpServletRequest;
importjavax.servlet.http.HttpServletResponse;
importjavax.servlet.http.HttpSession;
importcom.imut.javabean.Book;
importcom.imut.javabean.BookDBAccess;
importcom.imut.javabean.User;
importcom.imut.javabean.UserDBAccess;
publicclassShowBookServletextendsHttpServlet{
publicvoiddoGet(HttpServletRequestrequest,HttpServletResponseresponse)
throwsServletException,IOException{
doPost(request,response);
}
publicvoiddoPost(HttpServletRequestrequest,HttpServletResponseresponse)
throwsServletException,IOException{
request.setCharacterEncoding("UTF-8");
response.setCharacterEncoding("UTF-8");
Stringid=request.getParameter("bookId");
intbookId=Integer.parseInt(id);
BookDBAccessdbAccess=newBookDBAccess();
Bookbook=dbAccess.findBookById(bookId);
request.setAttribute("book",book);
request.getRequestDispatcher("/bookShow.jsp").forward(request,response);
}
}
<6>检索
packagecom.imut.servlet;
importjava.io.IOException;
importjava.util.List;
importjavax.servlet.ServletException;
importjavax.servlet.http.HttpServlet;
importjavax.servlet.http.HttpServletRequest;
importjavax.servlet.http.HttpServletResponse;
importjavax.servlet.http.HttpSession;
importcom.imut.javabean.BookDBAccess;
importcom.imut.javabean.User;
importcom.imut.javabean.UserDBAccess;
publicclassCheckBookServletextendsHttpServlet{
publicvoiddoGet(HttpServletRequestrequest,HttpServletResponseresponse)
throwsServletException,IOException{
doPost(request,response);
}
publicvoiddoPost(HttpServletRequestrequest,HttpServletResponseresponse)
throwsServletException,IOException{
request.setCharacterEncoding("UTF-8");
response.setCharacterEncoding("UTF-8");
StringbookName=request.getParameter("bookName");
StringISBN=request.getParameter("ISBN");
Stringauthor=request.getParameter("author");
StringpublishCom=request.getParameter("publishCom");
request.setAttribute("bookName",bookName);
request.setAttribute("ISBN",ISBN);
request.setAttribute("author",author);
request.setAttribute("publishCom",publishCom);
BookDBAccessdbAccess=newBookDBAccess();
Listlist=dbAccess.findAllBookByMostCon(bookName,ISBN,author,publishCom);
request.setAttribute("list",list);
request.getRequestDispatcher("/bookList.jsp").forward(request,response);
}
}
<7>显示图书清单
packagecom.imut.servlet;
importjava.io.IOException;
importjava.util.List;
importjavax.servlet.ServletException;
importjavax.servlet.http.HttpServlet;
importjavax.servlet.http.HttpServletRequest;
importjavax.servlet.http.HttpServletResponse;
importjavax.servlet.http.HttpSession;
importcom.imut.javabean.BookDBAccess;
importcom.imut.javabean.User;
importcom.imut.javabean.UserDBAccess;
publicclassListAllBookServletextendsHttpServlet{
publicvoiddoGet(HttpServletRequestrequest,HttpServletResponseresponse)
throwsServletException,IOException{
doPost(request,response);
}
publicvoiddoPost(HttpServletRequestrequest,HttpServletResponseresponse)
throwsServletException,IOException{
request.setCharacterEnc
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- 利用 Servlet JSP 设计 实现 简单 图书 管理 系统