📄 kind.jsp
字号:
<%@ page contentType="text/html; charset=GBK"%>
<%@ page import="java.sql.*,ntsky.admin.column.*"%>
<%@ include file="check.jsp" %>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>类管理</title>
<link rel="stylesheet" href="../../css/admin.css" type="text/css">
<script language="JavaScript" src="../../js/admin/column/kind.js"></script>
</head>
<body>
<%
Kind kid = new Kind();
ResultSet rs = kid.rs_columnt();
//获取总记录进行判断
int sum = kid.sum();
%>
<table width="578" border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="#FFFFFF">
<form method="post" action="insertkind.jsp" name="kind" onSubmit = "return check();">
<tr>
<td height="33" colspan="4" align="center" valign="middle">
<font color="#FF0000">类别添加</font> 选择栏目:
<%
if(sum>0){
%>
<select name="column">
<option value="0">请选择栏目</option>
<%
while(rs.next()){
%>
<option value="<%=rs.getString("classid")%>"><%=rs.getString("content")%></option>
<%
}
%>
</select>
添加类别:
<input type="text" size="20" name="kind">
<input type="submit" value="添加" >
</td>
<%
}
else{
out.print("请您先添加栏目");
}
%>
</tr>
</form>
</table>
<br>
<br>
<br>
<table width="578" border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="#FFFFFF">
<%
ResultSet rt = kid.rs_columnt();
%>
<%
//判断指针是否为空，如果为空说明还没有数据!
if(sum>0){
while(rt.next()){//循环将结果显示
%>
<tr align="center">
<td height="28" colspan="4"><font color="#FF0000">栏目名 ：</font><font color="#ffffff"><%=rt.getString("content")%></font></td>
</tr>
<%
//将循环的classid参数传递到javabean
int num = rt.getInt("classid");
kid.set_num(num);
//获取指针
ResultSet rk = kid.rs_kind();
//总数的获取
int summ = kid.sum();
%>
<tr align="center">
<td height="29"><font color="#FFFFFF">类ID</font></td>
<td height="29"><font color="#FFFFFF">类名</font></td>
<td height="29" colspan="2"><font color="#FFFFFF">编辑、删除</font></td>
</tr>
<%
//判断指针是否为空，如果为空说明还没有数据!
if(summ>0){
while(rk.next()){//循环将结果显示
%>
<tr align="center">
<td width="41%" height="24"> <%=rk.getInt("id")%></td>
<td width="40%" height="24"> <%=rk.getString("content")%></td>
<td width="10%" height="24"><a href="editkind.jsp?id=<%=rk.getString("id")%>"><img src="../../images/admin/edit.gif" alt="编辑栏目" height="18" border="0"></a></td>
<td width="9%" height="24"><a href="delkind.jsp?id=<%=rk.getString("id")%>"><img src="../../images/admin/del.gif" alt="删除栏目" width="16" height="16" border="0"></a></td>
</tr>
<%
}
}else{
%>
<tr align="center">
<td height="27" colspan="4" class="title">sorry!现在还没有类别，请您先添加类别</td>
</tr>
<%
}
%>
<%
}
}else{
%>
<tr align="center">
<td height="29" colspan="4" class="title">sorry!现在还没有栏目，请您先添加栏目</td>
</tr>
<%
}
%>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -