javaWeb模糊查询&评论

<%
      Class.forName("oracle.jdbc.driver.OracleDriver");
      String url="jdbc:oracle:thin:@localhost:1521:orcl";
      Connection con=DriverManager.getConnection(url, "scott","tiger");
      String sql="select * from topic279 order by tid";
      PreparedStatement ps=con.prepareStatement(sql);
      ResultSet rs=ps.executeQuery();
      while(rs.next()){
      
      %>
       < a href=' >'><b><%=rs.getString(2) %> </b></ a>
        <%
      } 
        %>
        < a href="index.jsp"><b>全部</b></ a>
      </ul>
      <ul class="classlist">
      <%
      //接收tid
      String tid=request.getParameter("tid");
      //新闻编号、标题、发表时间
      sql="select nid,ntitle,naddtime from news279";
      if(tid!=null){//点击了主题 传了值
       sql+=" where tid="+tid;
      }
      ps=con.prepareStatement(sql);
      rs=ps.executeQuery();
      while(rs.next()){
      %>
        <li>< a href='/q4/news/read.jsp?nid=<%=rs.getInt(1)%>'><%=rs.getString(2)%></ a><span> <%=rs.getString(3)%></span></li>
        <%
      }
        //关闭连接
        if(con!=null&&!con.isClosed()){
         con.close();
        }
        if(ps!=null){
         ps.close();
        }
        if(rs!=null){
         rs.close();
        }       
        %>

效果图

 

<!-- jsp指令:包含 -->
 <%@include file="../foota.jsp"%>
 <%@include file="../footb.jsp" %>

<div id="footer">
  <p class="">
   24小时客户服务热线：010-68988888 &#160;&#160;&#160;&#160; < a href=" ">常见问题解答</ a>
   &#160;&#160;&#160;&#160; 新闻热线：010-627488888 <br />
   文明办网文明上网举报电话：010-627488888 &#160;&#160;&#160;&#160; 举报邮箱： < a href="#">jubao@jb-aptech.com.cn</ a>
  </p >
  <p class="copyright">
   Copyright &copy; 1999-2009 News China gov, All Right Reserver <br />
   新闻中国 版权所有
  </p >
 </div>

效果图