⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 search.jsp~4~

📁 这是一个图书馆管理系统的jsp代码
💻 JSP~4~
字号:
🔍 
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<!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>search</title>
</head>

<body>
<form name="form1" method="post" action="">
  <table width="80%" border="0" align="center" cellpadding="4" cellspacing="1" id="table">
    <tr>
      <td width="33%" align="center"><img src="F:\example\图书馆\login/479226731.jpg" width="128" height="128" alt=""></td>
      <td><input name="statbook" type="submit" id="statbook" value="statbook"></td>
    </tr>
    <tr>
      <td width="33%" align="center"><img src="F:\example\图书馆\login/479227809.jpg" width="128" height="128" alt=""></td>
      <td><input name="statinbook" type="submit" id="statinbook" value="statinbook"></td>
    </tr>
    <tr>
      <td width="33%" align="center"><img src="F:\example\图书馆\login/479226731.jpg" width="128" height="128" alt=""></td>
      <td><input name="statoutbook" type="submit" id="statoutbook" value="statoutbook"></td>
    </tr>
    <tr>
      <td width="33%" align="center"><img src="F:\example\图书馆\login/479227809.jpg" width="128" height="128" alt=""></td>
      <td><input type="submit" name="statprize" value="statprize"></td>
    </tr>
    <tr>
      <td width="33%" align="center"><img src="F:\example\图书馆\login/479226731.jpg" width="128" height="128" alt=""></td>
      <td><input name="aveprize" type="submit" id="aveprize" value="aveprize"></td>
    </tr>
  </table>
</form>
<jsp:useBean id="Library" scope="session" class="login.Library">
</jsp:useBean>
<center>
<%
int statbooknumber=0,statinbooknumber=0,statoutbooknumber=0,statprizenumber=0,aveprizenumber=0,temp1=0,temp2=0,temp3=0,temp4=0;


try{
  Connection conn=Library.getConn();
  Statement stmt=conn.createStatement();
  ResultSet rs = stmt.executeQuery("select * from book");
  while(rs.next()){
    temp1=Integer.parseInt(rs.getString("innumber"));
    temp2=Integer.parseInt(rs.getString("outnumber"));
    temp3=Integer.parseInt(rs.getString("prize"));
    statinbooknumber=statinbooknumber+temp1;
    statoutbooknumber=statoutbooknumber+temp2;
    temp4=temp3*(temp1+temp2);
    statprizenumber=statprizenumber+temp4;
  }
  statbooknumber=statinbooknumber+statoutbooknumber;
  aveprizenumber=statprizenumber/statbooknumber;
  if(request.getParameter("statbook")!=null){
    out.println("<p>statbook = " + statbooknumber +"&nbsp; </p>");}
    else if(request.getParameter("statinbook")!=null){
      out.println("<p>statinbook = " + statinbooknumber +"&nbsp; </p>");}
      else if(request.getParameter("statoutbook")!=null){
        out.println("<p>statoutbook = " + statoutbooknumber +"&nbsp; </p>");}
        else if(request.getParameter("statprize")!=null){
          out.println("<p>statprize = " + statprizenumber +"&nbsp; </p>");}
          else if(request.getParameter("aveprize")!=null){
            out.println("<p>aveprize = " + aveprizenumber +"&nbsp; </p>");}
          }catch (Exception ex){
          response.sendRedirect("fail.jsp");
ex.printStackTrace();}
%>
</center>
</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -