newpreleft.jsp~12~

来自「源码新闻发布系统」· JSP~12~ 代码 · 共 44 行

JSP~12~
44
字号
<%@ page contentType="text/html; charset=GBK" %>
<%@ page import="java.sql.*" %>
<%@ page import="java.util.*" %>
<jsp:useBean id="sqlb" class="newsreleasesystem.SQLBean" scope="session" />
<%!Connection con=null; %>
<%!ArrayList path=new ArrayList(); %>
<html>
<head>
<title>
newpreleft
</title>
</head>
<body bgcolor="#ff00ff">
<%@ include file="newsleft.html" %>
<h3 align="center">
新闻分类
</h3>
<div align="center">
<%
try {
  if(sqlb.getCon()!=null){
    con=sqlb.getCon();
    String strSql="select * from FirstLevelTitle";
    Statement stmt=con.createStatement();
    ResultSet rs=stmt.executeQuery(strSql);
    while(rs.next()){
      path.add(rs.getString(5));
    }
    for(int i=0;i<path.size();i++){%>
    <p><a href="<%=(String)path.get(i) %>" target="newspremainframe"><%=rs.getString(2) %></a></p>
    <%}
    rs.close();
    stmt.close();
    con.close();
  }
}
catch (Exception ex) {
  System.out.println(ex.getMessage());
}
%>
</div>
</body>
</html>

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?