javaWeb圖書管理系統(tǒng)

1、實(shí)驗(yàn)報(bào)告模板實(shí) 驗(yàn) 報(bào) 告課程名稱 高級(jí)Java程序設(shè)計(jì) 實(shí)驗(yàn)項(xiàng)目 基于MVC模式的Web 綜合應(yīng)用 實(shí)驗(yàn)儀器 _ 個(gè)人計(jì)算機(jī) _系 別_計(jì)算機(jī)學(xué)院 _專 業(yè)_計(jì)算機(jī)科學(xué)與技術(shù)_班級(jí)/學(xué)號(hào)_計(jì)科1204 學(xué)生姓名 _ 實(shí)驗(yàn)日期 _ 2014/5/21/_成 績 _指導(dǎo)教師 _ _目 錄第一章 需求分析第二章 總體設(shè)計(jì)2.1本系統(tǒng)的主要功能2.2 Java源文件及其功能2.3 項(xiàng)目構(gòu)建思路第三章 模塊功能介紹第四章 功能測試及運(yùn)行效果參考文獻(xiàn)工作總結(jié)第一章：需求分析任務(wù)1 開發(fā)圖書館管理信息系統(tǒng)項(xiàng)目需求：1. 基于MVC模式開發(fā)該Java Web項(xiàng)目；2. 本系統(tǒng)有兩類用戶角色，普通用戶和管理員

2、用戶；3. 普通用戶：瀏覽圖書信息，分類瀏覽，能夠分別根據(jù)書名、作者、出版社為關(guān)鍵字查詢圖書；登陸后還可借閱圖書；4. 管理員用戶管理系統(tǒng)各項(xiàng)信息，包括：信息的添加、修改和刪除。5. 建立的圖書類包含如下信息：編號(hào)、書名、作者、出版社、出版日期。項(xiàng)目設(shè)計(jì)n 選擇開發(fā)模型MVC第二章：總體設(shè)計(jì)2.1本系統(tǒng)的主要功能：1、基于MVC模式開發(fā)該Java Web項(xiàng)目；2、本系統(tǒng)有兩類用戶角色，普通用戶和管理員用戶；3、普通用戶：瀏覽圖書信息，分類瀏覽，能夠分別根據(jù)書名、作者、出版社為關(guān)鍵字查詢圖書；登陸后還可借閱圖書；4、管理員用戶管理系統(tǒng)各項(xiàng)信息，包括：信息的添加、修改和刪除。5、建立的圖書類包含如

3、下信息：編號(hào)、書名、作者、出版社、出版日期。2.2 Java源文件及其功能(功能在下一章講述)：Index.jsp 歡迎進(jìn)入圖書館里系統(tǒng)！ 普通用戶 管理員用戶 管理員密碼 Manager.jsp 添加圖書 編號(hào)書名作者出版社出版日期管理 % 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 現(xiàn)有圖書信息 點(diǎn)擊查詢 編號(hào)書名作者出版社出版日期借閱 % 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 編號(hào)書名作者出版社出版日期 Successreader.j

5、sp 操作成功 瀏覽圖書信息Failure.jsp 操作失敗點(diǎn)擊返回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 圖書信息 編號(hào) 書名 作者 出版社 出版日期 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=xyh; private Connection conn=null; private Statement stmt=null; public dbbean() try Class.forName(driverStr); conn=DriverManager.getConnection(connStr,name,pa

18、ssword); 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 rs=null

19、; 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.HttpServlet;i

20、mport 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(HttpServl

21、etRequest 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.getServletP

22、ath(); 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.getbo

23、oklist(); 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,respons

24、e); 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.getParameter

25、(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).forward(requ

26、est,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); elserequest.get

27、RequestDispatcher(/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,response); el