简单的图书管理系统练习（jsp页面MVC模式）

最新推荐文章于 2024-04-12 09:44:49 发布

鸣泓

最新推荐文章于 2024-04-12 09:44:49 发布

阅读量650

点赞数 1

分类专栏： JSP 文章标签： mvc java eclipse

本文链接：https://blog.csdn.net/weixin_47079747/article/details/122436483

版权

JSP 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

开始页面start.jsp

<%@ page language="java" contentType="text/html; charset=gb2312"
    pageEncoding="utf-8"%>
<!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=ISO-8859-1">
<title>欢迎来到图书管理系统</title>
</head>

<body background="image/a1.jpg">
<br><br><br> 
<center><h1>图书管理系统</h1></center>
<table width="600" align="center" border="0">
	<tr valign="bottom">
	<td><h2><a href="login.jsp">登录</a></h2></td>
	<td><h2><a href="inquire.jsp">查询</a></h2></td>
	<td><h2><a href="jieyue.jsp">借阅</a></h2></td>
	<td><h2><a href="logout.jsp">退出</a></h2></td>
	</tr>
</table>
</body>
</html>

登录login.jsp

<%@ page language="java" contentType="text/html; charset=gb2312"
    pageEncoding="utf-8"%>
<!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=ISO-8859-1">
<title>Insert title here</title>
</head>
<body background="image/a1.jpg">
<center>
<form action="register.jsp" method="post">
	<input type=submit value="注册" name="sub">
</form>

<form action="attention.jsp" method="post">
	<br>输入账号：<input type=text name="first"><br>
	<br>输入密码：<input type=password name="last"><br>
	<br><input type=submit value="登录" name="submit">
</form>
</center>
</body>
</html>

查询inquire.jsp

<%@ page language="java" contentType="text/html; charset=gb2312"
    pageEncoding="utf-8"%>
<%@ page 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=ISO-8859-1">
<title>查询图书</title>
</head>
<body background="image/a1.jpg">
<center><font size=6>
<br>图书查询系统<br><br></font>
<form action="" method=post>
<br>输入图书编号：<input type=text name="first">
<input type=submit value="查找" name="submit">
</form>
<%
	request.setCharacterEncoding("gb2312");
	String yhm=request.getParameter("first");

	Connection con;
	Statement sql; 
	ResultSet rs;
	try{  
		Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
	}
	catch(Exception e){
	out.println("忘记把JDBC-数据库驱动程序复制到JDK的扩展目录中");
	}
	try{ 
		String uri= "jdbc:sqlserver://127.0.0.1:1433;DatabaseName=BooksContent";
  		String user="sa";
  		String password="123";
  		con=DriverManager.getConnection(uri,user,password);

  		sql=con.createStatement();
  		
  		String c="select* from books where num='"+yhm+"'";
  		
  		rs=sql.executeQuery(c);

        out.print("<table border=2>");
        out.print("<tr>");
        out.print("<th width=100>"+"图书编号");
	    out.print("<th width=100>"+"图书名");
	    out.print("<th width=50>"+"类别");
	    out.print("<th width=50>"+"状态");
         
        out.print("</TR>");
        while(rs.next()){
        	out.print("<tr>");
            out.print("<td >"+rs.getString(1)+"</td>"); 
            out.print("<td >"+rs.getString(2)+"</td>");
            out.print("<td >"+rs.getString(2)+"</td>");
            out.print("<td >"+rs.getInt("status")+"</td>");
            out.print("</tr>") ; 
       } 
       out.print("</table>");
       con.close();	
	}
	catch(SQLException e)
	{ 
  		out.print(e);
	}
%>
<br><br>
<form action="start.jsp" method=post>
<input type=submit value="返回主页面" name="submit">
</form>
</center>
</body>
</html>

借阅jieyue.jsp

<%@ page language="java" contentType="text/html; charset=gb2312"
    pageEncoding="utf-8"%>
<jsp:useBean id="digitBean" class="bean.JieBean" scope="request"></jsp:useBean>
<!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=ISO-8859-1">
<title>借阅</title>
</head>
<body background="image/a1.jpg">
<center>
<form action="jieServlet" method="get">
	<h2>请输入图书编号：<input type=text name="num" value=<%=digitBean.getNum() %> size=6></h2><br>
	<h2>请输入借阅命令：<input type=text name="status" value=<%=digitBean.getStatus() %> size=6></h2><br>
	<input type="submit" value="提交" name="sub">
</form>
</center>
</body>
</html>

退出logout.jsp

<%@ page language="java" contentType="text/html; charset=gb2312"
    pageEncoding="utf-8"%>
<!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=ISO-8859-1">
<title>退出登录</title>
</head>
<body background="image/a1.jpg">
<center>
<br><br><font size=5>是否保存登录信息</font>
<br><br>
<form action="start.jsp" method=post>
<input type=submit value="保存登录信息" name="submit1">
</form><br><br>
<form action="delete.jsp" method=post>
<input type=submit value="注销"  name="submit2">
</form>
</center>
</body>
</html>

判断是否能登录attention.jsp

<%@ page language="java" contentType="text/html; charset=gb2312"
    pageEncoding="utf-8"%>
<%@ page import="java.sql.*" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>判断是否能登录</title>
</head>
<body background="image/a1.jpg">
<%	request.setCharacterEncoding("gb2312");
    String yhm=request.getParameter("first");
    String mm=request.getParameter("last");
    String str=request.getParameter("submit");
    Connection con;
    Statement sql; 
    ResultSet rs;
    try{  Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
    }
    catch(Exception e){
       out.println("忘记把JDBC-数据库驱动程序复制到JDK的扩展目录中");
    }
    try { String uri= "jdbc:sqlserver://127.0.0.1:1433;DatabaseName=BooksContent";
          String user="sa";
          String password="123";
          con=DriverManager.getConnection(uri,user,password);
        
          sql=con.createStatement();
          
          String c="select * from people where ID='"+yhm+"'and password='"+mm+"'";
          rs=sql.executeQuery(c);

          if(rs.next())
           
              response.sendRedirect("start.jsp");
             
        
          else
           {
             
              out.print("请注册后再登录"); 
            }   
         
                     
          
          con.close();
    }
    catch(SQLException e){ 
          out.print(e);
    }
%> 

<form action="register.jsp" method="post" >
  
   <br><input type=submit value="注册" name="submit">
</form>
</body>
</html>

注册register.jsp

<%@ page language="java" contentType="text/html; charset=gb2312"
    pageEncoding="utf-8"%>
<%@ page 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=ISO-8859-1">
<title>欢迎来到注册界面</title>
</head>
<body background="image/a1.jpg">
<center>
<form action="" method="post" >
  
  <BR>输入昵称:<input type=text name="n"  ><BR>
  <BR>输入账号:<input type=text name="ID">
  <BR>输入密码:<input type=text name="m" ><BR>
     
  <BR><input type=submit value="注册" name="z">
 
</form>
<form action="login.jsp" method="post" >
<input type=submit value="返回登录" name="return">
</form>
</center>
<%
	request.setCharacterEncoding("gb2312");
	String xm=request.getParameter("ID");
	String pass=request.getParameter("m");
	String str=request.getParameter("z");
	Connection con;
	Statement sql; 
	ResultSet rs;
	try{  Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
	}
	catch(Exception e){
	out.println("忘记把JDBC-数据库驱动程序复制到JDK的扩展目录中");
	}
	try { 
		String url= "jdbc:sqlserver://127.0.0.1:1433;DatabaseName=BooksContent";
  		String user="sa";
  		String password="123";
  		con=DriverManager.getConnection(url,user,password);

  		sql=con.createStatement();
  
  		String c="insert into people values"+"("+"'"+xm+"',"+"'"+pass+"'"+")";
  		sql.executeUpdate(c);
  
  		con.close();
	}
	catch(SQLException e){ 
  		out.print(e);
}
%>
</body>
</html>

删除个人信息delete.jsp

<%@ page language="java" contentType="text/html; charset=gb2312"
    pageEncoding="utf-8"%>
<%@ page 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=ISO-8859-1">
<title>注销账号信息</title>
</head>
<body background="image/a1.jpg">
<center>
<form action="" method=post>
<h2>确认账户信息：<input type=text name="zh"></h2><br><br>
<h2>确认密码信息：<input type=text name="mm"></h2><br><br>
<h2><input type=submit value="确认注销" name="queren"></h2>
</form>
</center>
<%
	request.setCharacterEncoding("gb2312");
    String a=request.getParameter("zh");
	String b=request.getParameter("mm");
	
	Connection con;
	Statement sql; 
	ResultSet rs;
	try{  Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
	}
	catch(Exception e){
 	out.println("忘记把JDBC-数据库驱动程序复制到JDK的扩展目录中");
	}
	try { String uri= "jdbc:sqlserver://127.0.0.1:1433;DatabaseName=BooksContent";
    	String user="sa";
    	String password="123";
    	con=DriverManager.getConnection(uri,user,password);
  
    	sql=con.createStatement();
    
   		int n=Integer.parseInt(b);
    	String deleteSQL="delete from people where ID="+"'"+a+"'";
   		sql.executeUpdate(deleteSQL);
  		
    	con.close();
    	out.print("注销成功");
	}


	catch(Exception e){ 
 
	}
%>
<center>
<br><br>
<form action="start.jsp" method=post>
<input type=submit value="返回主页面" name="submit">
</form>
</center> 
</body>
</html>

JieServlet.java

package handle;

import java.io.IOException;

import javax.servlet.ServletConfig;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import java.sql.*;
import bean.JieBean;
/**
 * Servlet implementation class JieServlet
 */
@WebServlet("/JieServlet")
public class JieServlet extends HttpServlet {
	private static final long serialVersionUID = 1L;
       
    /**
     * @see HttpServlet#HttpServlet()
     */
    public JieServlet() {
        super();
        // TODO Auto-generated constructor stub
    }

	/**
	 * @see Servlet#init(ServletConfig)
	 */
	public void init(ServletConfig config) throws ServletException {
		super.init(config);
		// TODO Auto-generated method stub
	}

	/**
	 * @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
	 */
	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		// TODO Auto-generated method stub
		response.getWriter().append("Served at: ").append(request.getContextPath());
		
		JieBean digitBean=null;
		digitBean=new JieBean();		//创建bean对象
		request.setAttribute("digitBean", digitBean);
		String s1=request.getParameter("num");
        String s2=request.getParameter("status");
        if(s1==null||s2==null)
            return;
        if(s1.length()==0||s2.length()==0)
            return;
        //double num=Double.parseDouble(s1);
        //double status=Double.parseDouble(s2);	//从bean中获取输入的值		
        
        //链接数据库
        request.setCharacterEncoding("gb2312");
    	String n=request.getParameter("num");
    	String s=request.getParameter("status");
    	Connection con;
    	Statement sql; 
    	//ResultSet rs;
    	
	    try{  Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
	    }
	    catch(Exception e){
	       //out.println("忘记把JDBC-数据库驱动程序复制到JDK的扩展目录中");
	    	System.out.println("忘记把JDBC-数据库驱动程序复制到JDK的扩展目录中");
	    }
	    try { 
	    	String uri= "jdbc:sqlserver://127.0.0.1:1433;DatabaseName=BooksContent";
	        String user="sa";
	        String password="123";
	        con=DriverManager.getConnection(uri,user,password);
	        
	        sql=con.createStatement();
	          
	        String c="update books set status='"+s+"' where num='"+n+"'";
	        sql.executeUpdate(c);

	        // if(sc.length()==0||sc==null)
	         // sql.executeUpdate("delete from student where name is null");
	        
	        con.close();
	    }
	    catch(SQLException e){ 
	          //out.print(e);
	    	System.out.print(e);
	    }
	}

	/**
	 * @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
	 */
	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		// TODO Auto-generated method stub
		doGet(request, response);
	}

}

JieBean.java

package bean;

public class JieBean {
	public JieBean() {
    }

    double num,status;
    public double getNum() {
        return num;
    }

    public void setNum(double num) {
        this.num = num;
    }

    public double getStatus() {
        return status;
    }

    public void setStatus(double status) {
        this.status = status;
    }

}