java简单图书馆管理系统.doc
java简单图书馆管理系统.doc
- 配套讲稿：
如PPT文件的首页显示word图标，表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制：
部分文档作品中含有的国旗、国徽等图片，仅作为作品整体效果示例展示，禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词：
- java 简单 图书馆 管理 系统
- 资源描述：
-
内蒙古工业大学信息工程学院 设计一个通用的基于浏览器/服务器的简单图书馆管理系统，实现用户的注册和登陆，以及图书的查询与借阅。 1、 实验要求 1) 利用JavaBean进行数据传递 2) 用户的基本信息采用数据库存放 3) 使用Sevlet进行数据验证 八、程序清单 Admin类 //管理员 package library.info; public class Admin { private String username; private String userkey; public Admin(){ username=null; userkey=null; } public Admin(String username,String userkey){ this.username=username; this.userkey=userkey; } public void setUsername(String username) { this.username = username; } public String getUsername() { return username; } public void setUserkey(String userkey) { this.userkey = userkey; } public String getUserkey() { return userkey; } public boolean equals(Object a){ if(a==null)return false; if(!(a instanceof Admin))return false; Admin temp=(Admin)a; if((username.equals(temp.username))&&(userkey.equals(temp.userkey)))return true; else return false; } } Book类 //图书 package library.info; public class Book { private String number; private String name; private String author; private String chubanshe; private String jiage; private String shuliang; public Book(){ number=null; name=null; author=null; chubanshe=null; jiage=null; shuliang=null; } public Book(String number,String name,String author,String chubanshe,String jiage,String shuliang){ this.number=number; this.name=name; this.author=author; this.chubanshe=chubanshe; this.jiage=jiage; this.shuliang=shuliang; } public void setNumber(String number) { this.number = number; } public String getNumber() { return number; } public void setName(String name) { this.name = name; } public String getName() { return name; } public void setAuthor(String author) { this.author = author; } public String getAuthor() { return author; } public void setChubanshe(String chubanshe) { this.chubanshe = chubanshe; } public String getChubanshe() { return chubanshe; } public void setJiage(String jiage) { this.jiage = jiage; } public String getJiage() { return jiage; } public void setShuliang(String shuliang) { this.shuliang = shuliang; } public String getShuliang() { return shuliang; } } userlogin.jsp //登陆界面 <%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <title>登陆</title> <meta http-equiv="pragma" content="no-cache"> <meta http-equiv="cache-control" content="no-cache"> <meta http-equiv="expires" content="0"> <meta http-equiv="keywords" content="keyword1,keyword2,keyword3"> <meta http-equiv="description" content="This is my page"> <!-- <link rel="stylesheet" type="text/css" href="styles.css"> --> </head> <body> <form name="form" method="post" action="userlogin"> <table width="354" border="0" align="center"> <tr> <td colspan="2" align="center" >登录管理界面</td> </tr> <tr> <td width="93" >管理员账号</td> <td width="251"><input type="text" name="username"></td> </tr> <tr> <td width="93">管理员密码</td> <td width="251"><input type="password" name="userkey"></td> </tr> <tr> <td colspan="2"> <input name="submit" type="submit" value="登录" /> <input type="reset" value="重置" name="reset"></td> </tr> </table> </form> </body> </html> UserLogin //servlet用户登录的处理 package library.database; import java.io.IOException; import javax.servlet.RequestDispatcher; import javax.servlet.ServletException; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import library.info.*; public class UserLogin extends HttpServlet { /** * */ private static final long serialVersionUID = 1L; public void destroy() { super.destroy(); // Just puts "destroy" string in log // Put your code here } public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { doPost(request,response); } public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { String url = "error.jsp"; response.setContentType("text/html"); response.setCharacterEncoding("UTF-8"); request.setCharacterEncoding("UTF-8"); Admin user = new Admin(); user.setUsername(request.getParameter("username").trim()); user.setUserkey(request.getParameter("userkey").trim()); if(user.getUsername().equals("")||user.getUserkey().equals("")){ request.setAttribute("message", "用户名或密码不能为空，请重新输入！"); } else if(AdminDatabase.CheckLogin(user)==3){ url="index.jsp"; request.setAttribute("username", user.getUsername()); } else if(AdminDatabase.CheckLogin(user)==2){ request.setAttribute("message", "密码有误，请检查！"); } else if(AdminDatabase.CheckLogin(user)==1){ request.setAttribute("message", "用户名不存在，请重新输入！"); } RequestDispatcher rd=request.getRequestDispatcher(url); rd.forward(request, response); return; } public void init() throws ServletException { // Put your code here } } AdminDatabase //处理登陆的数据库信息 package library.database; import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException; import java.sql.ResultSet; import java.sql.Statement; import library.info.*; public class AdminDatabase { public static Connection getconnect(){ String DBDRIVER="com.microsoft.sqlserver.jdbc.SQLServerDriver"; String DBURL="jdbc:sqlserver://localhost:1433;databaseName=libraryinfo"; Connection con = null; try{ Class.forName(DBDRIVER); con = DriverManager.getConnection(DBURL,"sa","zty"); }catch(ClassNotFoundException e){ System.err.println(e.getMessage()); System.exit(1); }catch(SQLException e){ System.err.println(e.getMessage()); } return con; } public static int CheckLogin(Admin user){ Admin temp = new Admin(); Connection con=null; Statement stmt=null; ResultSet rs=null; boolean flag=false; int lab=1; try{ con=AdminDatabase.getconnect(); stmt=con.createStatement(); rs=stmt.executeQuery("select * from admininfo where username ='"+user.getUsername().trim()+"'"); while(rs.next()){ flag = true; temp.setUsername(rs.getString("username").trim()); temp.setUserkey(rs.getString("userkey").trim()); if(user.equals(temp)){ lab=3; flag=false; break; } } if(flag)lab=2; }catch(SQLException e){ System.err.println(e.getMessage()); }if(rs!=null){ try{ rs.close(); }catch(SQLException e){} } Finally(con,stmt); return lab; } public static void Finally(Connection con,Statement stmt){ if(stmt!=null){ try{ stmt.close(); }catch(SQLException e){} } if(con!=null){ try{ con.close(); }catch(SQLException e){} } } } error.jsp //处理错误信息 <%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%> <% String path = request.getContextPath(); String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/"; %> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <base href="<%=basePath%>"> <title>错误</title> <meta http-equiv="pragma" content="no-cache"> <meta http-equiv="cache-control" content="no-cache"> <meta http-equiv="expires" content="0"> <meta http-equiv="keywords" content="keyword1,keyword2,keyword3"> <meta http-equiv="description" content="This is my page"> <!-- <link rel="stylesheet" type="text/css" href="styles.css"> --> </head> <body> <%=request.getAttribute("message") %> <br> <p><a href="userlogin.jsp">重新登录</a></p> </body> </html> success.jsp //处理正确信息 <%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%> <% String path = request.getContextPath(); String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/"; %> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <base href="<%=basePath%>"> <title>成功</title> <meta http-equiv="pragma" content="no-cache"> <meta http-equiv="cache-control" content="no-cache"> <meta http-equiv="expires" content="0"> <meta http-equiv="keywords" content="keyword1,keyword2,keyword3"> <meta http-equiv="description" content="This is my page"> <!-- <link rel="stylesheet" type="text/css" href="styles.css"> --> </head> <body> <%=request.getAttribute("message") %> <br> <p><a href="index.jsp">返回主页</a></p> </body> </html> index.jsp //主页面 <%@ page language="java" import="java.util.*,library.database.*,library.info.*" pageEncoding="UTF-8"%> <% String path = request.getContextPath(); String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/"; %> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <base href="<%=basePath%>"> <title>欢迎登陆</title> <meta http-equiv="pragma" content="no-cache"> <meta http-equiv="cache-control" content="no-cache"> <meta http-equiv="expires" content="0"> <meta http-equiv="keywords" content="keyword1,keyword2,keyword3"> <meta http-equiv="description" content="This is my page"> <!-- <link rel="stylesheet" type="text/css" href="styles.css"> --> </head> <body> 欢迎你：<%=request.getAttribute("username")%>，使用图书管理系统 <br> <table width="706" border="0" align="center" height="75"> <tr> <td colspan="6" align="center" ><strong>图书管理系统</strong></td> </tr> <tr> <td colspan="6" align="center" > </td> </tr> <tr> <td align="right" width="500"> <form name="form" method="post" action="querybook"> 书号查询： <input type="text" name="number"> <input type="submit" value="查询" ></form></td> <td align="right" width="103"> <form name="form" method="post" action="bookinput.jsp"> <input type="submit" value="添加" ></form></td> <td align="right" width="103"> <form name="form" method="post" action="userlogin.jsp"> <input type="submit" value="注销" ></form></td> </tr> </table> <% ArrayList<Book> bookinfo = BookDatabase.showAllInfo(); if(bookinfo!=null&&bookinfo.size()>0){ %> <table width="706" border="1" align="center"> <tr> <td colspan="6" align="center" >图书列表</td> </tr> </table> <table width="706" border="1" align="center"> <tr> <td width="180" colspan="1" align="center" >书号</td> <td width="180" colspan="1" align="center" >书名</td> <td width="131" colspan="1" align="center" >作者</td> <td width="122" colspan="1" align="center" >出版社</td> <td width="85" colspan="1" align="center" >价格</td> <td width="65" colspan="1" align="center" >数量</td> <td width="83" colspan="1" align="center" >操作</td> </tr> <% for(int i=0;i<bookinfo.size();i++){ Book book=(Book)bookinfo.get(i); %> <tr > <td><%=book.getNumber() %></td> <td><%=book.getName()%></td> <td><%=book.getAuthor() %></td> <td><%=book.getChubanshe() %></td> <td><%=book.getJiage() %></td> <td><%=book.getShuliang() %></td> <td align="right"> <form name="form" method='post' action='deletebook'> <input type="hidden" name="number" value=<%=book.getNumber()%>> <input type="submit" name="action" value="删除" ></form></td> </tr> <%} %> </table> <%} %> <table align="center"> <tr> <td colspan="2" align="center">Copyright © zty 2012.6.11</td> </tr> </table> </body> </html> BookDatabase类 //处理数据库的图书信息 package library.database; import java.util.ArrayList; import java.sql.Connection; import java.sql.SQLException; import java.sql.ResultSet; import java.sql.PreparedStatement; import library.info.*; public class BookDatabase { private static Connection con; private static PreparedStatement stmt; private static ResultSet rs; public static ArrayList<Book> showAllInfo(){ ArrayList<Book> bookinfo = new ArrayList<Book>(); try{ con=AdminDatabase.getconnect(); stmt=con.prepareStatement("select * from bookinfo "); rs=stmt.executeQuery(); while(rs.next()){ Book book = new Book(); book.setNumber(rs.getString("number")); book.setName(rs.getString("name")); book.setAuthor(rs.getString("author")); book.setChubanshe(rs.getString("chubanshe")); book.setJiage(rs.getString("jiage")); book.setShuliang(rs.getString("shuliang")); bookinfo.add(book); } }catch(SQLException e){ bookinfo=null; }if(rs!=null){ try{ rs.close(); }catch(SQLException e){} } AdminDatabase.Finally(con,stmt); return bookinfo; } public static boolean addInfo(Book book){ boolean flag=false; try{ con=AdminDatabase.getconnect(); stmt=con.prepareStatement("insert into bookinfo "+"values(?,?,?,?,?,?)"); stmt.setString(1,book.getNumber()); stmt.setString(2,book.getName()); stmt.setString(3,book.getAuthor()); stmt.setString(4,book.getChubanshe()); stmt.setString(5,book.getJiage()); stmt.setString(6,book.getShuliang()); if(stmt.executeUpdate()==1)flag=true; }catch(SQLException e){ System.out.println(e.getMessage()); } AdminDatabase.Finally(con,stmt); return flag; } public static Book QueryInfo(String number){ Book book = new Book(); ResultSet rs=null; try{ con=AdminDatabase.getconnect(); stmt=con.prepareStatement("select * from bookinfo where number= '"+number+"'"); rs=stmt.executeQuery(); while(rs.next()){ book.setNumber(rs.getString("number")); book.setName(rs.getString("name")); book.setAuthor(rs.getString("author")); book.setChubanshe(rs.getString("chubanshe")); book.setJiage(rs.getString("jiage")); book.setShuliang(rs.getString("shuliang")); } }catch(SQLException e){ book=null; }if(rs!=null){ try{ rs.close(); }catch(SQLException e){} } AdminDatabase.Finally(con,stmt); return book; } public static boolean deleteInfo(String number){ boolean flag=false; try{ con=AdminDatabase.getconnect(); stmt=con.prepareStatement("delete from bookinfo where number='"+number+"'"); if(stmt.executeUpdate()==1)flag=true; }catch(SQLException e){ System.out.println(e.getMessage()); } AdminDatabase.Finally(con,stmt); return flag; } }展开阅读全文
咨信网温馨提示：1、咨信平台为文档C2C交易模式，即用户上传的文档直接被用户下载，收益归上传人（含作者）所有；本站仅是提供信息存储空间和展示预览，仅对用户上传内容的表现方式做保护处理，对上载内容不做任何修改或编辑。所展示的作品文档包括内容和图片全部来源于网络用户和作者上传投稿，我们不确定上传用户享有完全著作权，根据《信息网络传播权保护条例》，如果侵犯了您的版权、权益或隐私，请联系我们，核实后会尽快下架及时删除，并可随时和客服了解处理情况，尊重保护知识产权我们共同努力。
2、文档的总页数、文档格式和文档大小以系统显示为准(内容中显示的页数不一定正确)，网站客服只以系统显示的页数、文件格式、文档大小作为仲裁依据，个别因单元格分列造成显示页码不一将协商解决，平台无法对文档的真实性、完整性、权威性、准确性、专业性及其观点立场做任何保证或承诺，下载前须认真查看，确认无误后再购买，务必慎重购买；若有违法违纪将进行移交司法处理，若涉侵权平台将进行基本处罚并下架。
3、本站所有内容均由用户上传，付费前请自行鉴别，如您付费，意味着您已接受本站规则且自行承担风险，本站不进行额外附加服务，虚拟产品一经售出概不退款（未进行购买下载可退充值款），文档一经付费（服务费）、不意味着购买了该文档的版权，仅供个人/单位学习、研究之用，不得用于商业用途，未经授权，严禁复制、发行、汇编、翻译或者网络传播等，侵权必究。
4、如你看到网页展示的文档有www.zixin.com.cn水印，是因预览和防盗链等技术需要对页面进行转换压缩成图而已，我们并不对上传的文档进行任何编辑或修改，文档下载后都不会有水印标识（原文档上传前个别存留的除外），下载后原文更清晰；试题试卷类文档，如果标题没有明确说明有答案则都视为没有答案，请知晓；PPT和DOC文档可被视为“模板”，允许上传人保留章节、目录结构的情况下删减部份的内容；PDF文档不管是原文档转换或图片扫描而得，本站不作要求视为允许，下载前可先查看【教您几个在下载文档中可以更好的避免被坑】。
5、本文档所展示的图片、画像、字体、音乐的版权可能需版权方额外授权，请谨慎使用；网站提供的党政主题相关内容(国旗、国徽、党徽－－等)目的在于配合国家政策宣传，仅限个人学习分享使用，禁止用于任何广告和商用目的。
6、文档遇到问题，请及时联系平台进行协调解决，联系【微信客服】、【QQ客服】，若有其他问题请点击或扫码反馈【服务填表】；文档侵犯商业秘密、侵犯著作权、侵犯人身权等，请点击“【版权申诉】”，意见反馈和侵权处理邮箱：1219186828@qq.com；也可以拔打客服电话：0574-28810668；投诉电话：18658249818。
实名认证
平台协调中心【客服】
自信AI助手
微信客服
客服QQ
发送邮件
意见反馈
链接地址：https://www.zixin.com.cn/doc/3635971.html