brow.jsp

来自「该源码为JSP的开发案例集锦」· JSP 代码 · 共 45 行

JSP
45
字号
<%@ page import="java.sql.*"%>
<%@ page contentType="text/html;charset=gb2312"%>
<html>
<head>
	<title>查看留言</title>
</head>
<%
    Class.forName("org.gjt.mm.mysql.Driver");
    String dbUrl = "jdbc:mysql://localhost/csnews";
 	String dbUser = "root";
 	String dbPassword = "";
    Connection	conn = DriverManager.getConnection(dbUrl,dbUser,dbPassword); 
    Statement    stm=conn.createStatement();

   String query="select * from message";
   ResultSet rs=stm.executeQuery(query);
   while(rs.next()){
   		String name=rs.getString("name");
   		String title=rs.getString("title");
   		String content=rs.getString("content");
   		String time=rs.getString("time");
%>
<body bgcolor="#FFCCCC">
	
<table width="323" border="0" cellspacing="0" align="center">
  <tr> 
    		<td width="303" bgcolor="#FFFFFF" > 
      			<div align="center">留言版</div></td>
  		</tr>
  		<tr> 
    		<td bgcolor="#00FFFF">主题:  <%=title%></td>
  		</tr>
  		<tr> 
    		<td bgcolor="#FFFFCC">发表时间:  <%=time%></td>
  		<tr> 
  		<tr> 
    		<td bgcolor="#00FFFF">姓名:  <%=name%></td>
 		</tr>
  		<tr> 
    		<td bgcolor="#FFFFCC">内容:  <%=content%></td>
  		<tr> 
	</table>
 <% }   %>
</body>
</html>

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?