column.jsp
来自「NTsky新闻发布v1.0(提供JavaBean)」· JSP 代码 · 共 73 行
JSP
73 行
<%@ page contentType="text/html; charset=GBK"%>
<%@ page import="ntsky.admin.column.*,java.sql.*"%>
<%@ include file="check.jsp"%>
<html>
<head>
<title>类别管理</title>
<link rel="stylesheet" href="../../css/admin.css" type="text/css">
<script language="JavaScript" src="../../js/admin/column/column.js"></script>
</head>
<body>
<br>
<table width="595" height="2%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="26" align="center">系 统 总 栏 管 理 </td>
</tr>
</table>
<%
//从javabean中获取指针
Column clm = new Column();
ResultSet rs = clm.rs_columnt();
//获取记录进行判断
int sum = clm.sum();
%>
<table width="595" border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="#FFFFFF">
<tr valign="middle" bgcolor="#799ae1">
<td width="220" height="29" align="center"><font color="#FFFFFF">栏目ID</font></td>
<td width="221" align="center"><font color="#FFFFFF">栏目名称</font></td>
<td colspan="2" align="center"><font color="#FFFFFF">编辑、删除</font></td>
</tr>
<%
//判断指针是否为空，如果为空说明还没有数据!
if(sum>0){
while(rs.next()){//循环将结果显示
%>
<tr>
<td height="30" align="center"> <%=rs.getString("classid")%></td>
<td align="center"> <%=rs.getString("content")%></a></td>
<td width="60" align="center"><a href="editcolumn.jsp?classid=<%=rs.getString("classid")%>"><img src="../../images/admin/edit.gif" alt="编辑栏目" height="18" border="0"></a></td>
<td width="60" align="center"><a href="delcolumn.jsp?classid=<%=rs.getString("classid")%>" onclick="return(charge('<%=rs.getString("content")%>'))"><img src="../../images/admin/del.gif" alt="删除栏目" width="16" height="16" border="0"></a></td>
</tr>
<%
}
}else{
%>
<tr align="center">
<td height="35" colspan="4" align="center" class="title">Sorry! 还没有任何记录？ 请先添加!</td>
</tr>
<%
}
%>
<%
clm.close();
%>
</table>
<p> </p>
<table width="595" height="7%" border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="#ffffff">
<form action="insertcolumn.jsp" method=post name="column" onSubmit = "return check();">
<tr>
<td width="899" height="32" align="center"> 添加栏目 ID：<input type="text" name="classid" size="4"> 栏目名称：
<input name="content" type="text" size="20">
<input type="submit" name="Submit" value="提交"></td>
</tr>
</form>
</table>
<p> </p>
</body>
</html>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?