scroll_bulletin.jsp

论坛元程序

<%@page contentType="text/html; charset=gb2312" language="java" import="java.sql.*,java.io.*,java.lang.*"  %>
<jsp:useBean id="yy" scope="page" class="yy.jdbc"/>
<%
  String title="";
  String content="";
  String time="";
  String id="";
  String array[]=new String[10];
  int i=0;
  String sql="select * from Bulletin order by bulletin_id desc";
  ResultSet rs=yy.executeQuery(sql);
  out.println("<marquee onmouseout=this.start() onmouseover=this.stop() scrollamount='4'  scrolldelay='100' direction= 'left' width='800' height='50' align='middle'>");
  while(rs.next())
  {
    id=rs.getString("bulletin_id");
    title=rs.getString("bulletin_title");
    content=rs.getString("bulletin_content");
    time=rs.getString("bulletin_time");
    time=time.substring(0,10);
    array[i]=title+":&nbsp;&nbsp;"+content+"&nbsp;&nbsp;("+time+")"; 
    out.print("<a href=bulletin_display.jsp?bulletin_id="+id+">"+array[i]+"</a>&nbsp;&nbsp;&nbsp;&nbsp;");
  }
  out.println("</marquee>");
  %>