📄 admindata.jsp

📁 新闻发布系统

💻 JSP

字号:

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@include file="getusersession.jsp"%>
<%
request.setCharacterEncoding("GB2312");
%>
<jsp:useBean id="adminnews" scope="page" class="dsp.database.Operation"/>
<%
String sql = "SELECT * FROM web_class WHERE flag=0 ORDER BY id ASC";
ResultSet rs = adminnews.query(sql);
int total = adminnews.totalRecord(rs);
String fs[] = new String[1];
if(total > 0)
	fs = new String[total];
%>
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="inc/admin.css" rel="stylesheet" type="text/css">
</head>
<%
int i = 0;
do{
	fs[i++] = rs.getString("classname");
}while(rs.next());
%>
<body>
<table width="95%" border="1" cellspacing="0" cellpadding="3" align="center" bordercolorlight="#ECEEE4" bordercolordark="#CCCABC">
    <tr> 
      
    <td colspan="7" align="center" height="30" background="images/tablebg.gif"><b>管 
      理 资 源</b></td>
    </tr>
	 <%
  		i = 0;
  		while(i < total){
  		sql = "SELECT * FROM web_class WHERE flag=(SELECT id FROM web_class WHERE classname='"+ fs[i] +"') ORDER BY id ASC";
		rs = adminnews.query(sql);
  %>
    <tr> 
    <td height="25"><font color="#FF0000">● </font><%=fs[i++]%></td>
    </tr>
    <tr> 
      
    <td height="25" colspan="2" bgcolor="#FFFFFF">
<%
  		int id = 0;
  		String c = "";
  		while(rs.next()){
  		id = rs.getInt("id");
  		c = rs.getString("classname");
      %>
      【<a href="data.jsp?id=<%=id%>&name=<%=c%>"><%=c%></a>】&nbsp; 
      <%}%>
	  </td>
    </tr>
	 <%
  }
  %>
</table>
 <%@include file="copyright.jsp"%> 
</body>
</html>
<%
adminnews.closestmt();
adminnews.closeconn();
%>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -