javaWeb图书管理系统

1、实验报告模板实 验 报 告课程名称 高级Java程序设计 实验项目 基于MVC模式的Web 综合应用 实验仪器 _ 个人计算机 _系 别_计算机学院 _专 业_计算机科学与技术_班级/学号_计科1204 学生姓名 _ 实验日期 _ 2014/5/21/_成 绩 _指导教师 _ _目 录第一章 需求分析第二章 总体设计2.1本系统的主要功能2.2 Java源文件及其功能2.3 项目构建思路第三章 模块功能介绍第四章 功能测试及运行效果参考文献工作总结第一章：需求分析任务1 开发图书馆管理信息系统项目需求：1. 基于MVC模式开发该Java Web项目；2. 本系统有两类用户角色，普通用户和管理员

2、用户；3. 普通用户：浏览图书信息，分类浏览，能够分别根据书名、作者、出版社为关键字查询图书；登陆后还可借阅图书；4. 管理员用户管理系统各项信息，包括：信息的添加、修改和删除。5. 建立的图书类包含如下信息：编号、书名、作者、出版社、出版日期。项目设计n 选择开发模型MVC第二章：总体设计2.1本系统的主要功能：1、基于MVC模式开发该Java Web项目；2、本系统有两类用户角色，普通用户和管理员用户；3、普通用户：浏览图书信息，分类浏览，能够分别根据书名、作者、出版社为关键字查询图书；登陆后还可借阅图书；4、管理员用户管理系统各项信息，包括：信息的添加、修改和删除。5、建立的图书类包含如

3、下信息：编号、书名、作者、出版社、出版日期。2.2 Java源文件及其功能(功能在下一章讲述)：Index.jsp 欢迎进入图书馆里系统！ 普通用户 管理员用户 管理员密码 Manager.jsp 添加图书 编号书名作者出版社出版日期管理 % request.setCharacterEncoding(utf-8); ArrayList list=(ArrayList)request.getAttribute(list); for(bookinfo bi:list) String id=bi.getId();% a href=/servlets/edit.do?id=修改 a href=/ser

4、vlets/delete.do?id=删除 Reader.jsp 现有图书信息 点击查询 编号书名作者出版社出版日期借阅 % request.setCharacterEncoding(utf-8); ArrayList list=(ArrayList)request.getAttribute(list); for(bookinfo bi:list) String id=bi.getId(); % input type=hidden name=id value= Success.jsp 操作成功 浏览图书信息Finalcheck.jsp 编号书名作者出版社出版日期 Successreader.j

5、sp 操作成功 浏览图书信息Failure.jsp 操作失败点击返回Edit.jsp input type=hidden name=id value= 修改信息 书名input type=text value= name=name 作者input type=text value= name=author 出版社input type=text value= name=press 出版日期input type=text value= name=date Check.jsp input type=hidden name=id value= 修改信息 书名input type=text value=

6、name=name 作者input type=text value= name=author 出版社input type=text value= name=press 出版日期input type=text value= name=date Add.jsp 图书信息 编号 书名 作者 出版社 出版日期 Common.jsfunction check() if(form1.id.value=) alert (no id!); form1.id.focus(); return false; if(.value=) alert(no name!); .focu

7、s(); return false; if(form1.author.value=) alert(no author!); form1.author.focus(); return false; if(form1.press.value=) alert(no press!); form1.press.focus(); return false; if(form1.date.value=) alert(no date!) form1.date.focus(); return false; Bookinfo.javapackage bean;import java.lang.Exception;i

8、mport java.lang.String;import java.lang.System;import java.sql.*;import java.sql.Connection;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;import java.util.*;import java.util.ArrayList;public class bookinfo private String id; private String name; private String auth

9、or; private String press; private String date; public void setName(String name) = name; public String getName() return name; public void setAuthor(String author) this.author = author; public String getAuthor() return author; public void setDate(String date) this.date = date; public String

10、getDate() return date; public void setPress(String press) this.press = press; public String getPress() return press; public void setId(String id) this.id = id; public String getId() return id; public static ArrayList getbooklist() ArrayList list=new ArrayList(); String sql=select * from mvc_book; be

11、an.dbbean jdbc=new bean.dbbean(); ResultSet rs=jdbc.executeQuery(sql); try while(rs.next() bookinfo bi=new bookinfo(); bi.setId(rs.getString(id); bi.setName(rs.getString(name); bi.setAuthor(rs.getString(author); bi.setPress(rs.getString(press); bi.setDate(rs.getString(date); list.add(bi); rs.close()

12、; catch(SQLException e) e.printStackTrace(); jdbc.close(); return list; public static bookinfo getbookbyid(String id) String sql=select * from mvc_book where id=+id; dbbean jdbc=new dbbean(); ResultSet rs=jdbc.executeQuery(sql); bookinfo bi = new bookinfo(); try if(rs.next() bi.setDate(rs.getString(

13、date); bi.setPress(rs.getString(press); bi.setAuthor(rs.getString(author); bi.setName(rs.getString(name); bi.setId(rs.getString(id); rs.close(); catch(SQLException e) System.out.println(no find); jdbc.close(); return bi; public static int updatebook(String id,String name,String author,String press,S

14、tring date) int result=0; String sql=update mvc_book set name=+name+,author=+author+,press=+press+,date=+date+ where id=+id; dbbean jdbc=new dbbean(); result=jdbc.executeUpdate(sql); return result; public static int deletebook(String id) int result=0; String sql=delete from mvc_book where id=+id; db

15、bean jdbc=new dbbean(); result=jdbc.executeUpdate(sql); return result; public static int addbook(String id,String name,String author,String press,String date) int result=0; String sql=insert into mvc_book(id,name,author,press,date) values(id,+name+,+author+,+press+,+date+); dbbean jdbc=new dbbean();

16、 result=jdbc.executeUpdate(sql); return result; Dbbean.javapackage bean;import java.lang.Exception;import java.lang.String;import java.lang.System;import java.sql.*;import java.sql.Connection;import java.sql.ResultSet;import java.sql.Statement;public class dbbean private String driverStr=com.mysql.j

17、dbc.Driver; private String connStr=jdbc:mysql:/localhost:3306/book?characterEncoding=utf-8; private String name=root; private String password=xyh201268; private Connection conn=null; private Statement stmt=null; public dbbean() try Class.forName(driverStr); conn=DriverManager.getConnection(connStr,n

18、ame,password); stmt=conn.createStatement(); catch(Exception ex) System.out.println(no connect); public int executeUpdate(String s) int result=0; try result=stmt.executeUpdate(s); catch(Exception ex) System.out.println(update wrong!); return result; public ResultSet executeQuery(String s) ResultSet r

19、s=null; try rs=stmt.executeQuery(s); catch(Exception ex) System.out.println(check wrong!); return rs; public void close() trystmt.close();conn.close(); catch(Exception ex) System.out.println(close!); Servlet.javapackage servlets;import javax.servlet.ServletException;import javax.servlet.http.HttpSer

20、vlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import java.io.IOException;import java.io.PrintWriter;import java.util.ArrayList;import bean.*;/* * Created by Administrator on 14-5-31. */public class Servlet extends HttpServlet protected void doGet(Htt

21、pServletRequest request, HttpServletResponse response) throws ServletException, IOException doPost(request, response); protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException request.setCharacterEncoding(utf-8); String action=request.getSe

22、rvletPath(); if(action.equals(/servlets/depend.do) String value=request.getParameter(password); if(value.equals(123) ArrayList list= bean.bookinfo.getbooklist(); request.setAttribute(list, list); request.getRequestDispatcher(/manager.jsp).forward(request,response); else ArrayList list= bean.bookinfo

23、.getbooklist(); request.setAttribute(list, list); request.getRequestDispatcher(/reader.jsp).forward(request,response); else if (action.equals(/servlets/list.do) ArrayList list= bean.bookinfo.getbooklist(); request.setAttribute(list, list); request.getRequestDispatcher(/manager.jsp).forward(request,r

24、esponse); else if(action.equals(/servlets/edit.do) String id =request.getParameter(id); bean.bookinfo bi= bean.bookinfo.getbookbyid(id); request.setAttribute(bi,bi); request.getRequestDispatcher(/edit.jsp).forward(request,response); else if(action.equals(/servlets/update.do) String id=request.getPar

25、ameter(id); String name=request.getParameter(name); String author=request.getParameter(author); String press=request.getParameter(press); String date=request.getParameter(date); int r= bean.bookinfo.updatebook(id, name, author, press, date); if (r=1) request.getRequestDispatcher(/success.jsp).forwar

26、d(request,response); elserequest.getRequestDispatcher(/failure.jsp).forward(request,response); else if (action.equals(/servlets/delete.do) String id=request.getParameter(id); int r= bean.bookinfo.deletebook(id); if (r=1) request.getRequestDispatcher(/success.jsp).forward(request,response); elsereque

27、st.getRequestDispatcher(/failure.jsp).forward(request,response); else if (action.equals(/servlets/add.do) String id=request.getParameter(id); String name=request.getParameter(name); String author=request.getParameter(author); String press=request.getParameter(press); String date=request.getParameter(date); int r= bean.bookinfo.addbook(id, name, author, press, date); if (r=1) request.getRequestDispatcher(/success.jsp).forward(request,respons