<%@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();
%>