📄 index2.jsp

📁 一个简短的留言簿
💻 JSP
字号:
<%@ page contentType="text/html;charset=GBK" %>
<%@ page language="java" import="java.sql.*"%>
<jsp:useBean id="conn" scope="page" class="db.ConnOracle"/>

<%!
ResultSet rs = null;
ResultSet rsTmp = null;
String sql = "";
int PageSize = 4;
int Page = 1;
int totalPage = 1;
String str = "";

public String ShowOnePage(ResultSet rs, int Page, int PageSize) {
	  str = "";
	  // 先将记录指针定位到相应的位置
	  try {
	  		rs.absolute( (Page-1) * PageSize + 1);
	  }catch(SQLException e) {
	  }
	        
	  for(int iPage=1; iPage<=PageSize; iPage++) {
	     str += RsToGbook(rs);
		 try {
		     if(!rs.next()) break;
		 }catch(Exception e) {
		     System.out.println("Locate Current Page Error!");
		 }
	  }
	  return str;
}
	
// 显示单行记录子模块
public String RsToGbook( ResultSet rs ) {
		String oneRecord = "";
		String email = "";
		String homepage = "";
		String name = "";
		String sex  = "";
		String subject = "";
		String memo = "";
		String gtime = "";
		try {
			email     = rs.getString("email");
			homepage  = rs.getString("homepage");
			name      = rs.getString("name");
			sex       = rs.getString("gender");
			subject   = rs.getString("title");
			memo      = rs.getString("content");
			memo      = memo.replaceAll("\n","<br>");
			gtime     = rs.getString("gtime");
		}catch(SQLException e) {
			e.printStackTrace();
		}

		if(!email.equals("")) {
			email = "<a href='mailto:" + email + "'>电子邮件信箱</a>";
		}
		
		if(homepage.equals("http://")  || homepage.equals("")) {
			homepage = "";
		}else {
			homepage = "<a href='" + homepage + "'>网址</a>";
		}

		oneRecord += "<table border='0' >";
		oneRecord += "<tr><td>"+name + "</td></tr>";
		oneRecord += "<tr><td>"+email + "</td></tr>";
		oneRecord += "<tr><td>"+homepage + "</td></tr>";
		oneRecord += "<tr><td>"+sex + "</td></tr>";
		oneRecord += "<tr><td>主题："+subject + "</td></tr>";
		oneRecord += "<tr><td>内容："+memo + "</td></tr>";
		oneRecord += "<tr><td>时间："+gtime + "</td></tr>";
		oneRecord += "<tr><td><hr color=red></td></tr></table>";

		return oneRecord;
}
%>

<%
   request.setCharacterEncoding("GBK");
   sql = "select * from gbook order by gtime desc";
   try {
       rs = conn.query( sql );
   }catch(Exception e) {
       out.println("访问数据库出错！");
   }


	rsTmp = conn.query("select count(*) as mycount from gbook");
	rsTmp.next();

	int totalrecord = rsTmp.getInt("mycount");
	if(totalrecord % PageSize ==0) totalPage = totalrecord / PageSize;  
	else  totalPage = (int) Math.floor( totalrecord / PageSize ) + 1;  

	if(totalPage == 0) totalPage = 1;
	rsTmp.close();

	try {
		if(request.getParameter("Page")==null || request.getParameter("Page").equals("")) 
		   Page = 1;
		else
		   Page = Integer.parseInt(request.getParameter("Page"));
	} catch(Exception e) {  
		   Page = 1;
	}

	if(Page < 1)  Page = 1;
	if(Page > totalPage) Page = totalPage;
%>


<html>

<body BGCOLOR="#FFFFFF">
<div align="center">

<%
	out.println((ShowOnePage(rs, Page, PageSize)));
%>
<form Action="index2.jsp" Method="GET">
<% 
   if(Page != 1) {
      out.println("<A HREF=index2.jsp?Page=1>第一页</A>
⌨️ 快捷键说明

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