📄 mainnews.jsp~28~

📁 源码新闻发布系统

💻 JSP~28~

字号:

<%@ page contentType="text/html; charset=GBK" %>
<%@ page import="java.sql.*" %>
<%@ page import="java.util.*"%>
<jsp:useBean id="sqlcb" class="newsreleasesystem.SQLBean" scope="session" />
<%!Connection conn=null; %>
<%!ArrayList allink=new ArrayList();%>
<%!ArrayList atitle=new ArrayList(); %>
<html>
<head>
<title>
mainnews
</title>
</head>
<body bgcolor="#ffffff">
<ul>
<%
try {
  if(sqlcb.getCon()!=null){
  conn=sqlcb.getCon();
  String strSql="select * from SecondLevelTitle";
  Statement stmt=conn.createStatement();
  ResultSet rs=stmt.executeQuery(strSql);
  while(rs.next()){
    allink.add(rs.getString(2));
    atitle.add(rs.getString(3));
}
}
}
catch (Exception ex) {
  System.out.println(ex.getMessage());
}
%>
<%
for(int i=0;i<allink.size();i++)
{
  %>
  <li><a href="<%=(String)atitle.get(i)%>" target="_blank"><%=(String)allink.get(i)%></a>
</li>

<%
}
%>
</ul>
</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -