show.jsp

来自「基于JAVA语言」· JSP 代码 · 共 28 行

<meta http-equiv="Content-Type" content="text/html; charset=gb2312"><style type="text/css">
<!--
body {
	background-image: url(1679803.jpg);
}
-->
</style><%@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 shijian desc";
ResultSet rs=smt.executeQuery(sql);
while(rs.next())
{
if(i==15)
break;
out.println("<font color='"+rs.getString("yanse")+"'>");
out.println(rs.getString("shijian").substring(5)+">");
out.println(rs.getString("nicheng")+" ");
out.println(rs.getString("xinxi")+"<br>");
i++;
}
con.close();
%>