📄 viewleave.jsp
字号:
<html>
<head>
<title>查看留言</title>
</head>
<body>
<h2>留言</h2>
<hr>
<%@ page import="java.sql.*"%>
<%
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:example","devon","book");
String str="select * from messages";
Statement sm=con.createStatement();
ResultSet rs=sm.executeQuery(str);
String name,date,email,topic,words;
int ID;
while(rs.next())
{
ID=rs.getInt("ID");
name=rs.getString("name");
email=rs.getString("email");
topic=rs.getString("subject");
words=rs.getString("message");
date=rs.getString("date");
out.print("<table>");
out.print("<tr><td align=\"rigth\"><b>主题</b></td><td colspan=\"3\"><b>");
out.print(topic);
out.print("</b></td></tr>");
out.print("<tr><td align=\"right\"><b> 姓名</b></td><td colspan=\"3\"><b>");
out.print(name);
out.print("</b></td></tr>");
out.print("<tr><td align=\"right\"><b> Email</b></td><td colspan=\"3\"><b>");
out.print(email);
out.print("</b></td></tr>");
out.print("<tr><td align=\"right\"><b> 留言</b></td><td colspan=\"3\"><b>");
out.print(words);
out.print("</b></td></tr>");
out.print("<tr><td align=\"right\"><b>日期</b></td><td colspan=\"3\"><b>");
out.print(date);
out.print("<td><form name=\"deleteform\" action=\"delete.jsp\" method=\"POST\">");
out.print("<td><input type=\"hidden\" name=\"delete\" value="+ID+"></td>");
out.print("<td align=\"right\"><input type=\"submit\" name=\"action\" value=\"删除\">");
out.print("</td></tr></form></table>");
out.print("</hr>");
}
sm.close();
con.close();
}
catch(Exception e)
{
out.print(e.getMessage());
}
%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -