图书管理系统

★漂浮ing☆

于 2020-05-05 15:59:06 发布

阅读量769

点赞数

分类专栏： Java Web

本文链接：https://blog.csdn.net/qq_43956340/article/details/105933656

版权

Java Web 专栏收录该内容

5 篇文章 0 订阅

订阅专栏

web作业，，来记录一下,，代码量没有多少，挺好写的。

增加了一个下架图书功能，，当flag为1时，，显示在当前页面中，flag为0时，，，不显示，，点击下架图书时显示。

bookInfo.java

package beans;

import java.sql.*;
public class bookInfo {
	private String driverStr="com.mysql.jdbc.Driver";
	private String connStr="jdbc:mysql://localhost:3306/book?characterEncoding=gb2312";//数据库名
    private String dbusername="root";
    private String dbpassword="sa";//密码和数据库一致 
    private Connection conn=null;
    private Statement stmt=null;
public bookInfo()
{
	try{
		Class.forName(driverStr);
		conn=DriverManager.getConnection(connStr,dbusername, dbpassword);
		stmt=conn.createStatement();
	}
	catch(Exception ex){System.out.println("无法同数据库建立连接！");}
}
public int executeUpdate(String s)
{
    int result=0;
    try{result=stmt.executeUpdate(s);}
    catch(Exception ex){System.out.println("执行更新错误！");}
    return result;
}
public ResultSet executeQuery(String s)
{
	ResultSet rs=null;
	try{rs=stmt.executeQuery(s);}
	catch(Exception ex){System.out.println("执行查询错误！");}
	return rs;
}
public void close()
{
	try{
		stmt.close();
		conn.close();
	}
	catch(Exception e){}
}
 
}

index.jsp

<%@ page language="java" contentType="text/html; charset=gb2312"
    pageEncoding="UTF-8" import="java.sql.*"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>图书管理界面</title>
</head>
<body background="1.jpg" width=100% height=100%>
   
   <div align="center">
   <tr>
	<td><a href=add.jsp>增加图书信息</a></td>&nbsp&nbsp&nbsp
	<td><a href="trash.jsp">查看下架图书</a></td>
	</tr>
	<table border="1" >
	<tr><td align="center">书名<td align="center">作者<td align="center">价格<td align="center">管理
	<jsp:useBean id="db" class="beans.bookInfo" scope="page"/><!-- 导入自己的类（Javabean） -->
	
	<%
	String s="select * from book_info";
	ResultSet rs=db.executeQuery(s);
	while(rs.next())
	{
	int flag=rs.getInt(5);
	if(flag==1)
	{
	int id=rs.getInt(1);
	out.println("<tr><td>"+rs.getString(2)+"</td><td>"+rs.getString(3)+"</td><td>"+rs.getString(4)+"</td><td><a href='del.jsp?id="+id+"'>删除</a>&nbsp;<a href='edit.jsp?id="+id+"'>修改</a>&nbsp;<a href='xiajiacaozuo.jsp?id="+id+"'>下架</a></td></tr>");
	}
	}
	rs.close();
	db.close();
	%>
	</table>
	</div>
</body>
</html>

add.jsp

<%@ page language="java" contentType="text/html; charset=gb2312"
    pageEncoding="UTF-8" import="java.sql.*"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>增加图书</title>
</head>
<body>
  <form action="add.jsp" method="post">
<table >
<CAPTION>添加图书信息</CAPTION>
  <tr>
    <th width="30%">书名：</th>
    <td width="70%"><input name="bookname" type="text"></td>
  </tr>
  <tr>
    <th>作者：</th>
    <td><input name="author" type="text"></td>
  </tr>
  <tr>
    <th>价格：</th>
    <td><input name="price" type="text">元</td>
  </tr>
  <tr>
    <th colspan="2">
    <input type="submit" name="submit" value="添加">
    <input type="reset" value="重置">
    </th>
  </tr>
</table>
</form>
<jsp:useBean id="db" class="beans.bookInfo" scope="page"/>
<%
request.setCharacterEncoding("gb2312");
String submit=request.getParameter("submit");
if(submit!=null&&!submit.equals(""))
{
	String  bookname=request.getParameter("bookname");
	String  author=request.getParameter("author");
	String  price=request.getParameter("price");
	String sql="insert into book_info(bookname,author,price) values('"+bookname+"','"+author+"',"+price+")";
	int i=db.executeUpdate(sql);
	if(i!=-1)
	{
	out.println("<script language='javaScript'> alert('添加成功,点击确定跳转到主页!');</script>");
	response.setHeader("refresh","1;url=index.jsp");
	}
	else{
	out.println("<script language='javaScript'> alert('添加失败，点击确定返回添加页面！');</script>");
	response.setHeader("refresh","1;url=add.jsp");
	}
	db.close();
}
%>
</body>
</html>

del.jsp

<%@ page language="java" contentType="text/html; charset=gb2312"
    pageEncoding="UTF-8" import="java.sql.*" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>删除图书</title>
</head>
<body>
  <jsp:useBean id="db" class="beans.bookInfo" scope="page"/>
	<%
	request.setCharacterEncoding("gb2312");
	String id=request.getParameter("id");
	String sql="delete from book_info where id="+id;
	int i=db.executeUpdate(sql);
	if(i==1)
		{out.println("<script language='javaScript'> alert('删除成功，点击确定后自动跳到主页！');</script>");
		response.setHeader("refresh","1;url=index.jsp");
		}
		else{
		out.println("<script language='javaScript'> alert('删除失败，点击确定后自动跳到主页！');</script>");
		response.setHeader("refresh","1;url=del.jsp");
		}
     db.close();
	%>
</body>
</html>

edit.jsp

<%@ page language="java" contentType="text/html; charset=gb2312"
    pageEncoding="UTF-8" import="java.sql.*"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>修改图书</title>
</head>
<body background="2.jpg">
  <jsp:useBean id="db" class="beans.bookInfo" scope="page"/>
  <%
  request.setCharacterEncoding("gb2312");
  String id=request.getParameter("id");
  ResultSet rs=db.executeQuery("select * from book_info where id="+id);
  rs.next();
   %>
   <form action="update.jsp" method="post">
   <div align="center">
     <table border="1" width="50%"  >
	  <CAPTION>修改图书信息</CAPTION>
	  <tr>
	        <th width="30%">书名：</th>
               <td width="70%">
               <input name="bookname" type="text" value="<%=rs.getString(2)%>"></td>
           </tr>
	  <tr>
	    <th>作者：</th>
	    <td><input name="author" type="text" value="<%=rs.getString(3)%>"></td>
	  </tr>
	  <tr>
	    <th>价格：</th>
	    <td><input name="price" type="text" value="<%=rs.getString(4)%>">元</td>
	  </tr>
	  <tr>
	    <th colspan="2">
	    <input type="hidden" name="id" value="<%=id%>">
	    <input type="submit" value="修改">
	    <input type="reset" value="重置">
	    </th>
	  </tr>
	</table>
	</div>
</form>
<%
  db.close();
 %>
</body>
</html>

update.jsp

<%@ page language="java" contentType="text/html; charset=gb2312" import="java.sql.*" errorPage="error.jsp"%>
<html>
  <head>
    <title>图书修改完成</title>
 </head>
  <body>
   <jsp:useBean id="db" class="beans.bookInfo" scope="page"/>
  <%
  request.setCharacterEncoding("gb2312");
  String bookname=request.getParameter("bookname");
  String author=request.getParameter("author");  
  String price=request.getParameter("price");  
  String id=request.getParameter("id"); 
  String sql="update book_info set bookname='"+bookname+"',author='"+author+"',price="+price+" where id="+id; 
  int i=db.executeUpdate(sql);
	if(i==1)
	{out.println("<script language='javaScript'> alert('修改成功，点击确定后自动跳到主页。');</script>");
	response.setHeader("refresh","1;url=index.jsp");
	return;
	}
  db.close();
   %>
  </body>
</html>

xiajiacaozuo.jsp

<%@ page language="java" contentType="text/html; charset=gb2312"
    pageEncoding="UTF-8" import="java.sql.*" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>下架图书</title>
</head>
<body>
  <jsp:useBean id="db" class="beans.bookInfo" scope="page"/>
	<%
	request.setCharacterEncoding("gb2312");
	String id=request.getParameter("id");
	String sql="update book_info set flag=0 where id="+id;
	int i=db.executeUpdate(sql);
	if(i==1)
		{out.println("<script language='javaScript'> alert('下架成功，点击确定后自动跳到主页！');</script>");
		response.setHeader("refresh","1;url=index.jsp");
		}
		else{
		out.println("<script language='javaScript'> alert('下架失败，点击确定后自动跳到主页！');</script>");
		response.setHeader("refresh","1;url=recycle.jsp");
		}
     db.close();
	%>
</body>
</html>

trash.jsp

<%@ page language="java" contentType="text/html; charset=gb2312"
    pageEncoding="UTF-8" import="java.sql.*"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>图书管理界面</title>
</head>
<body style = "background-image:url(1.jpg)">
   
   <div align="center">
	<table border="1" >
	<tr>下架的图书</tr>
	<tr><td>书名<td>作者<td>价格<td>管理
	<jsp:useBean id="db" class="beans.bookInfo" scope="page"/><!-- 导入自己的类（Javabean） -->
	
	<%
	String s="select * from book_info";
	ResultSet rs=db.executeQuery(s);
	while(rs.next())
	{
	int flag=rs.getInt(5);
	if(flag==0)
	{
	int id=rs.getInt(1);
	out.println("<tr><td>"+rs.getString(2)+"</td><td>"+rs.getString(3)+"</td><td>"+rs.getString(4)+"<td><a href='shangjiacaozuo.jsp?id="+id+"'>上架</a></td></tr>");
	}
	}
	rs.close();
	db.close();
	%>
	</table>
	</div>
</body>
</html>

shangjiacaozuo.jsp

<%@ page language="java" contentType="text/html; charset=gb2312"
    pageEncoding="UTF-8" import="java.sql.*" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>下架图书</title>
</head>
<body>
  <jsp:useBean id="db" class="beans.bookInfo" scope="page"/>
	<%
	request.setCharacterEncoding("gb2312");
	String id=request.getParameter("id");
	String sql="update book_info set flag=1 where id="+id;
	int i=db.executeUpdate(sql);
	if(i==1)
		{out.println("<script language='javaScript'> alert('上架成功，点击确定后自动跳到主页！');</script>");
		response.setHeader("refresh","1;url=index.jsp");
		}
		else{
		out.println("<script language='javaScript'> alert('上架失败，点击确定后自动跳到主页！');</script>");
		response.setHeader("refresh","1;url=recycle.jsp");
		}
     db.close();
	%>
</body>
</html>