📄 test1.jsp

📁 多功能学生宿舍管理系统分布式体系结构
💻 JSP
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*,java.lang.*" errorPage="" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>test1</title>
</head>
<%@page import="myweb.bean.Visitor,myweb.DBContent.DBContent" %>
<body>
<p>
  <jsp:useBean id="db" class="myweb.DBContent.DBContent"/>
  <jsp:useBean id="v" class="myweb.bean.Visitor" scope="session">
  </jsp:useBean>
  <jsp:setProperty name="v" property="*" />
  <%
	int rowcount=0;
	int introw;
	int row;
	String strrow=request.getParameter("row");
	if(strrow==null)
	{
		introw=1;
	}
	else
	{
		
		introw=Integer.parseInt(strrow);
		if(introw<1)
			introw=1;
	}
	String sql="select * from visitor where visittime='"+v.getVisittime()+"'";
	ResultSet rs=db.select(sql);
	if(rs.next()){
	rs.last();
	rowcount=rs.getRow();
	if(introw>rowcount)
		introw=rowcount;
	if(rowcount>0)
	{
		rs.absolute(introw);
	}
	
%>
</p>
<table width="100%" border="1" cellpadding="0" cellspacing="0">
  <tr>
    <td><%=rs.getString("buildingid") %></td>
    <td><%=rs.getString("houseid") %></td>
    <td><%=rs.getString("visitedn") %></td>
    <td><%=rs.getString("visitorn") %></td>
    <td><%=rs.getString("relation") %></td>
    <td><%=rs.getString("zjmc") %></td>
    <td><%=rs.getString("zjhm") %></td>
    <td><%=rs.getString("visittime") %></td>
    <td><%=rs.getString("inturn") %></td>
  </tr>
</table>
<%} %>
<p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 今天来访记录共有<%=rowcount %>; 条，这是第<%=introw %>条记录。<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<a href="test1.jsp?row=1"> 第一条记录 </a><%if(introw<rowcount) {%><a href="test1.jsp?row=<%=introw+1 %>">下一条记录</a> <%} %><%if(introw>1) {%><a href="test1.jsp?row=<%=introw-1 %>">上一条记录</a> <%} %><a href="test1.jsp?row=<%=rowcount %>">最后一条记录</a></p>
<p> </p>
</body>
</html>
⌨️ 快捷键说明

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