📄 borrowinfo.jsp

📁 vb+java实现的图书管理系统

💻 JSP

字号:

<%@ page language="java" import="java.util.*,com.bean.util.*" pageEncoding="UTF-8"%>
<%
String readerId=session.getAttribute("user").toString();
DbConn conn=new DbConn();
String sql="select b.BookName,b.author,a.borrowtime,a.endtime,a.reborrowflag,a.borrowId from BorrowInfo a,BookInfo b,readerInfo r where r.readerId='"+readerId+"' and r.readerId=a.readerId and b.bookId=a.bookId and a.rebacktime is null";
String[][] bookinfo=conn.getData(sql);
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>My JSP 'borrowInfo.jsp' starting page</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>
  <div style="padding-left:30px;padding-top:10px;">
    <table style="BORDER: #d6d6d6 1px solid;">
    	<tr><th style="width:100px">题名</th><th style="width:100px">作者/编著</th><th style="width:100px">借出日期</th><th style="width:100px">应还日期</th><th style="width:40px">续借</th></tr>
    <%
    if(bookinfo!=null){
	    for(int i=0;i<bookinfo.length;i++){ 
	    	
	    	if(bookinfo[i][4].equals("Y")){
	    	%>
	    		<tr><td><%=bookinfo[i][0] %></td><td><%=bookinfo[i][1] %></td><td><%=bookinfo[i][2].substring(0,10) %></td><td><%=bookinfo[i][3].substring(0,10) %></td><td>不可续借</td></tr>
	    	<%
	    	}else{%>
	    		<tr><td><%=bookinfo[i][0] %></td><td><%=bookinfo[i][1] %></td><td><%=bookinfo[i][2].substring(0,10) %></td><td><%=bookinfo[i][3].substring(0,10) %></td><td><a href="Reborrow?borrowId=<%=bookinfo[i][5]%>">续借</a></td></tr>
	    <%	}
	    }
	}
	%>
    </table>
    </div>
  </body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -