📄 comment.jsp
字号:
<%@page contentType="text/html"%>
<%@page pageEncoding="UTF-8"%>
<!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=UTF-8" />
<title></title>
<style type="text/css">
<!--
.block {
font-family: "����";
font-size: 14px;
font-style: normal;
font-weight: normal;
color: #000000;
letter-spacing: normal;
text-align: left;
vertical-align: top;
word-spacing: normal;
display: run-in;
height: 200px;
width: auto;
border: thin solid #FFFFFF;
}
.block1 {
background-position: left top;
letter-spacing: normal;
text-align: left;
vertical-align: top;
word-spacing: normal;
white-space: pre;
display: none;
position: relative;
height: 100px;
width: 100px;
left: 100px;
top: 50px;
right: 600px;
bottom: 50px;
visibility: visible;
z-index: auto;
}
#Layer1 {
position: absolute;
left: 304px;
top: 21px;
width: 698px;
height: 194px;
z-index: 1;
}
#Layer2 {
position: absolute;
left: 304px;
top: 257px;
width: 712px;
height: 195px;
z-index: 2;
}
#Layer3 {
position: absolute;
left: 307px;
top: 492px;
width: 700px;
height: 195px;
z-index: 3;
}
-->
</style>
</head>
<body>
<%@page contentType="text/html"%>
<%@ page import="java.sql.*"%>
<%@ page import="com.iss.bean.dataPageBean"%>
<%@ page import="com.iss.dataBase.SQLParser"%>
<%@ page import="java.util.*"%>
<jsp:useBean id="datapagebean" class="com.iss.bean.dataPageBean"
scope="session" />
<%!public String codeToString(String str) {
String s = str;
try {
byte tempB[] = s.getBytes("gb2312");
s = new String(tempB);
return s;
} catch (Exception e) {
return s;
}
}%>
<%
Statement stmt = SQLParser.getInstance().getStmt();
String sql = "select * from comment order by commentTime asc ";
ResultSet rs = stmt.executeQuery(sql);
String pages = request.getParameter("dipage");
rs.last();
int countRecord = rs.getRow();
int countPageRecord = 3;
if (pages == null || (pages.trim()).length() == 0)
(datapagebean).setAll(countRecord, countPageRecord);
else {
try {
(datapagebean).setCurrentPage(Integer.parseInt(pages));
} catch (Exception e) {
out.println("����ȷ");
}
}
int currentRecord = (datapagebean.getCurrentPage() - 1)* (datapagebean).getsizePage();
if (currentRecord == 0)
((ResultSet) rs).beforeFirst();
else
((ResultSet) rs).absolute(currentRecord);
%>
<div id="Layer1">
<%
if (rs!=null&rs.next())
out.print(rs.getString("commentContent"));
%>
</div>
<div class="block">
<img src="images/touxiang.jpg" alt="" width="100" height="100" />
<br />
<br />
name :
<%
if (rs != null)
out.print(rs.getString("customerName"));
%>
<br />
time :
<%
if (rs != null)
out.print(rs.getString("commentTime"));
%>
<br />
</div>
<hr noshade align="right">
<div id="Layer2">
<%
int temp1=0;
if (rs!=null&rs.next())
{
temp1=1;
out.print(rs.getString("commentContent"));
}
%>
</div>
<div class="block">
<img src="images/touxiang.jpg" alt="" width="100" height="100" />
<br />
<br />
name:<%
if (temp1==1) {
out.print(rs.getString("customerName"));
System.out.println(rs.getString("customerName"));
}
%>
<br />
time:
<%
if (temp1==1){
out.print(rs.getString("commentTime"));
System.out.println(rs.getString("commentTime"));
}
%><br />
</div>
<div id="Layer3">
<%
int temp2=0;
if(rs!=null&rs.next())
{
temp2=1;
out.print(rs.getString("commentContent"));
}
%>
</div>
<hr noshade align="right">
<div class="block">
<img src="images/touxiang.jpg" alt="" width="100" height="100" />
<br />
<br />
name:<%
if (temp2==1)
out.print(rs.getString("customerName"));
%><br />
time:
<%
if (temp2==1)
out.print(rs.getString("commentTime"));
%>
<br />
</div>
<hr noshade align="right" />
<% out.print(codeToString("共 ")+(datapagebean).getCountRecord()+codeToString("条记录 ,共")+(datapagebean).getCountPage()+codeToString("页,当前第")+(datapagebean).getCurrentPage()+codeToString("页，每页")+(datapagebean).getsizePage()+codeToString("条记录"));
System.out.println("you "+datapagebean.getCountPage());
if((datapagebean).getCurrentPage()!=1)
{
out.print("<a href=comment.jsp?dipage=1>"+codeToString("首页")+"</a>,");
out.print("<a href=comment.jsp?dipage="+((datapagebean).getCurrentPage()-1)+">"+codeToString("上一页")+"</a>,");
}
if((datapagebean).getCountPage()==(datapagebean).getCurrentPage())
{
}
else
{
out.print("<a href=comment.jsp?dipage="+((datapagebean).getCurrentPage()+1)+">"+codeToString("下一页")+"</a>,");
out.print("<a href=comment.jsp?dipage="+((datapagebean).getCountPage())+">"+codeToString("末页")+"</a>,");
}
%>
<form action="uploadComment.jsp" method="get">
<div align="center">
<table border="1" cellpadding="3" width="740" id="table1"
style="border-collapse: collapse" bordercolor="#D1D7DE"
bgcolor="#F1F3F5">
<tr>
<td width="116" align="center">
<font size="2" color="#4E5B6D">name</font>
</td>
<td width="360">
<input type="text" name="customerName" size="23" maxlength="20"
style="border: 1px solid 'black';"/>
</td>
<td width="244">
</td>
</tr>
<tr>
<td width="116" align="center">
<font size="2" color="#4E5B6D">email</td>
<td width="360">
<input type="text" name="email" size="36" maxlength="50"
style="border: 1px solid 'black';" />
</td>
<td width="244">
</td>
</tr>
<tr>
<td width="116" align="center">
<font size="2" color="#4E5B6D">title</font>
</td>
<td width="360">
<input type="text" name="title" size="46" maxlength="50"
style="border: 1px solid 'black';" />
</td>
<td width="244">
</td>
</tr>
<tr>
<td width="720" align="center" colspan="3">
<textarea rows="11" name="content" cols="98"
style="border: 1px solid #E4E4E4;"></textarea>
</td>
</tr>
</table>
</div>
<center>
<input type='submit' value='提交' name='B1' /></center><br />
<center>
<input type='reset' value='重写' ��� name='B2' />
</center>
</form>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -