show.jsp

来自「用JSP实现的聊天室功能.满好的 初学者可以参考参考」· JSP 代码 · 共 24 行

<%@page contentType = "text/html;charset=GB2312"
                import = "java.sql.*"
%>
<%
 String change = (String)session.getValue("change");
 int i=0;
 response.setHeader("Refresh",change);  //设定更新时间
 Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
 Connection con = DriverManager.getConnection("jdbc:odbc:chat");
 Statement smt =  con.createStatement();
 String sql = "select * from chatroom order by 时间 desc";
 ResultSet rs = smt.executeQuery(sql);
 while(rs.next())
 {
  if(i==15)            //显示第15个信息时，停止循环
   break;
  out.println("<font color='"+rs.getString(3)+"'>");
  out.println(rs.getString(4).substring(5)+">");
  out.println(rs.getString(1)+"：");
  out.println(rs.getString(2)+"<br>");
  i++;
 }
 con.close();
%>