📄 board.jsp
字号:
<!--board.jsp-->
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<%@ page import="java.util.*"%>
<%!
public String codeString(String s){
String str=s;
try{
byte b[]=str.getBytes("ISO-8859-1");
str=new String (b);
return str;
}catch(Exception e){return str;}
}
%>
<html>
<head>
<title>Board</title>
</head>
<body bgcolor=#C0C0C0>
<center><h1>公共留言列表</h1>
<%
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String title;
String time;
String fromid;
Connection con=DriverManager.getConnection("jdbc:odbc:board","","");
Statement sql=con.createStatement();
String condition="SELECT * FROM board ";
ResultSet rs=sql.executeQuery(condition);
int rowcount=0;
%>
<center>
<table width="800" >
<tr>
<td ><table border="1" width="800" height="30">
<td width="400" valign="middle" align="center">时间</td>
<td width="100" valign="middle" align="center">作者</td>
<td width="300" valign="middle" align="center">标题</td>
</table></td>
</tr>
<%
while(rs.next()){
rowcount++;
time=rs.getString("time");
fromid=rs.getString("fromid");
title=rs.getString("title");
%>
<tr>
<td><table border="1" width="800" height="30">
<td width="400" valign="middle" align="center"><%=time%></td>
<td width="100" valign="middle" align="center"><%=fromid%></td>
<td width="300" valign="middle" align="center"><a href="showboard.jsp?rowcount=<%=rowcount%>"><%=title%></a></td>
</td>
</table></td>
</tr>
<%
}
%>
</table>
<a href="addboard.jsp">我也留言</a>
</center>
<%
con.close();
}catch(SQLException e){
out.print("SQL error!"+e);
}catch(ClassNotFoundException e){
out.print("CNF error!");
}
%>
</center>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -