📄 showmessage.jsp
字号:
<%
/**
* Title: 使用JSP创建留言板
* Description: 教学示范
* Copyright: Copyright (c) 2003
* Company: 北京师范大学计算机系
* @author 孙一林
* @version 1.0
*/
%>
<%@ page contentType="text/html; charset=GBK" %>
<html>
<%@ page language="java" import="java.sql.*"%>
<head>
<title>留言板</title>
</head>
<body bgcolor="#FFFFFF" text="#000000">
<%
int pageNumber = 0;
try
{
pageNumber = Integer.parseInt(request.getParameter("pageNumber"));
}
catch(Exception ex)
{
System.out.println("进入首页");
}
Connection connection = null; //定义与数据库进行连接的Connection对象
ResultSet rs = null; //定义数据库查询的结果集
Statement statement = null; //定义查询数据库的Statement对象
int recordCount = 0;
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); //指定与数据库连接使用JDBC-ODBC桥驱动程序
String url = "jdbc:odbc:MessageBoard"; //指定数据源名
connection = DriverManager.getConnection(url); //与数据源建立连接
statement = connection.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY); //创建Statement接口实例
String sql = "select * from MessageBoard order by ID Desc"; //创建取出MessageBoard表中所有数据的SQL语句
rs = statement.executeQuery(sql); //将数据存入结果集中
while(rs.next()) //获取记录的条数
{
recordCount++;
}
if (pageNumber==0) //显示留言板的记录
{
rs.beforeFirst();
}
else
{
rs.absolute(pageNumber*5);
}
int tmp_Record = 0;
out.println("<h2 align=center>欢迎使用留言板</h2>");
out.println("<table border=0>");
while(rs.next()&&tmp_Record<5)
{
tmp_Record++;
out.println("<tr>");
out.println("<td>标题：" + rs.getString("MessageTitle") + "</td>");
out.println("<td align=right>发表日期：" + rs.getString("MessageDate") + "</td>");
out.println("</tr>");
String content = rs.getString("MessageContent"); //将留言内容中的回车符转换为HTML语言中的“<BR>”字符
String content2 = "";
while(content.indexOf('\n')!=-1)
{
int a=content.indexOf('\n');
String s1=content.substring(0,a);
content2=content2.concat(s1);
content2=content2.concat("<br>");
int b=a+1;
content=content.substring(b);
}
content2=content2.concat(content);
content=content2;
out.println("<tr><td colspan=2 width=700>" + content + "</td></tr>");
out.println("<tr><td> </td>");
out.println("<td align=right>发言人：" + rs.getString("MessageUser") + "</td></tr>");
out.println("<tr> </tr>");
}
out.println("</table>");
out.println("<p align=right>"); //设置页面跳转链接
out.println("<a href='ShowMessage.jsp?pageNumber=0'>首页</a>");
if(pageNumber!=0)
{
out.println("<a href='ShowMessage.jsp?pageNumber="+(pageNumber-1)+"'>上一页</a>");
}
if((pageNumber+1)*5<rs.getRow())
{
out.println("<a href='ShowMessage.jsp?pageNumber="+(pageNumber+1)+"'>下一页</a>");
}
out.println("<a href='ShowMessage.jsp?pageNumber="+((recordCount-1)/5)+"'>尾页</a>");
out.println("</p>");
}
catch(SQLException ex){ //捕捉异常
System.out.println("\nERROR:----- SQLException -----\n");
while (ex != null) {
System.out.println("Message: " + ex.getMessage());
System.out.println("SQLState: " + ex.getSQLState());
System.out.println("ErrorCode: " + ex.getErrorCode());
ex = ex.getNextException();
}
}
catch(Exception ex ) {
ex.printStackTrace();
}
finally {
try {
if(statement != null)
{
statement.close(); //关闭Statement接口实例
}
if(connection != null)
{
connection.close(); //关闭Connection接口实例
}
}
catch (SQLException ex) {
System.out.println("\nERROR:----- SQLException -----\n");
System.out.println("Message: " + ex.getMessage());
System.out.println("SQLState: " + ex.getSQLState());
System.out.println("ErrorCode: " + ex.getErrorCode());
}
}
%>
<p align="center"><a href="AddMessage.htm">发表留言</a></p>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -