📄 liuyanstore.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*,java.io.*,java.util.*" errorPage="" %>
<html><body>
<meta http-equiv="Refresh" content="8";name="" />
<%
//int ID=Integer.parseInt(request.getParameter("ID"));
//int ID;
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:test","sa","sa");
String sql="select * from leavewords";
//out.print(sql);
Statement st=con.createStatement();
ResultSet rs=st.executeQuery(sql);
String publisher="";
String content="";
String publishdate="";
while(rs.next())
{%>
<table width="780" border="0" align="center" bgcolor="#99CCCC"><!--设置用以表格显示.-->
<%out.print("<tr>");%>
<%=rs.getString(2)%>
<%out.print("发表留言：");%>
<%=rs.getString(3)%>
<%out.print("发表时间：");%>
<%=rs.getString(4)%>
<% out.print("</tr><br>");%>
<%}
con.close();
String newcontent=content.replaceAll("\n","<br>") ;
%>
<h1><%=publisher%></h1>
<p align="left"><%= newcontent.replaceAll(" "," ")%></p>
<p><%=publishdate%></p>
</body></html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -