📄 main.jsp
字号:
<%@page contentType="text/html"%><%@page pageEncoding="GB2312"%><%@page import = "java.sql.*" %><html> <head><title>留言板首页</title></head> <body> <font color="red" size="5"> <b><i><center>JSP留言板</i></b> </font> <hr> <% Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection con = DriverManager.getConnection("jdbc:odbc:msg");
Statement smt =con.createStatement (ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
int num=0,lastno,lastpage,nowpage,prepage,nextpage,nostart,noend;
String sql = "select * from message"; //取出message中的所有数据
ResultSet rs = smt.executeQuery(sql);
rs.last(); //将指针移到最后一条
lastno = rs.getRow(); //取出总数据数目
lastpage = (int)Math.ceil((double)lastno/5); //计算最后一页的编号
if(request.getParameter("page") != null) //取得传来的页码
try{
nowpage = Integer.parseInt(request.getParameter("page"));
}catch(Exception e){
nowpage = Integer.parseInt(request.getParameter("p"));
}
else
nowpage = lastpage;
prepage = nowpage -1; //上一页
nextpage = nowpage +1; //下一页
if(nowpage == 1) //判断是否为第一页
prepage =1; if(nowpage == lastpage) //判断是否为最后一页
nextpage = lastpage;
nostart = nowpage * 5 -4; //计算开始编号
noend = nowpage * 5; //计算结束编号
sql = "select * from message where msgid between "+nostart+" and "+noend;
rs = smt.executeQuery(sql);
out.println("<table>");
while(rs.next()){
out.println("<tr><td bgcolor='pink'>留言人</td><td>"+
rs.getString("msgname")+"</td><td rowspan='3'><img src='pic//icon"+num+".jpg'></td></tr>");
out.println("<tr><td bgcolor='pink'>讯息</td><td>"+rs.getString("msgcontent")+"</td></tr>");
out.println("<tr><td bgcolor='pink'>时间</td><td>"+rs.getString("msgdate")+"</td></tr>");
out.println("<tr><td colspan=2><hr></td></tr>") ;
num++;
if(num==5)
num=0;
}
out.println("</table><br>");
con.close();
%>
<form action="main.jsp?p=<%=nowpage%>" method="post">
<a href="msg.htm"><img src="pic//msg.jpg" border="0"></a>
<a href='main.jsp?page=1'><img src=pic//first.jpg border=0></a>
<a href='main.jsp?page=<%=prepage%>'><img src=pic//previous.jpg border=0 ></a>
<a href='main.jsp?page=<%=nextpage%>'><img src=pic//next.jpg border=0 ></a> <a href='main.jsp?page=<%=lastpage%>'><img src=pic//last.jpg border=0></a>
目前页数<b><%=nowpage%></font> /<font color=red><%=lastpage%></b></font> <br>
输入显示的页码：<input type="text" size="3" name="page"> <input type="submit" value="显示留言"> </form> </body></html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -