📄 addsecond.jsp

📁 新闻发布系统
💻 JSP
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@include file="getadminsession.jsp"%>
<%
request.setCharacterEncoding("GB2312");
%>
<jsp:useBean id="second" scope="page" class="dsp.database.Operation"/>
<%
String sql = "SELECT * FROM web_class WHERE flag=0 ORDER BY id ASC";
ResultSet rs = second.query(sql);
int total = second.totalRecord(rs);
String fs[] = new String[1];
if(total == 0){
	out.println("<script language=javascript> alert('在没有建立一级栏目之前，不能建立二级栏目！'); location.href='addfirst.jsp';</script>");
}
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">
<script language="JavaScript" type="text/JavaScript">
<!--
function MM_findObj(n, d) { //v4.01
  var p,i,x;  if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {
    d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}
  if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n];
  for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document);
  if(!x && d.getElementById) x=d.getElementById(n); return x;
}

function MM_validateForm() { //v4.0
  var i,p,q,nm,test,num,min,max,errors='',args=MM_validateForm.arguments;
  for (i=0; i<(args.length-2); i+=3) { test=args[i+2]; val=MM_findObj(args[i]);
    if (val) { nm=val.name; if ((val=val.value)!="") {
      if (test.indexOf('isEmail')!=-1) { p=val.indexOf('@');
        if (p<1 || p==(val.length-1)) errors+='- '+nm+' must contain an e-mail address.\n';
      } else if (test!='R') { num = parseFloat(val);
        if (isNaN(val)) errors+='- '+nm+' must contain a number.\n';
        if (test.indexOf('inRange') != -1) { p=test.indexOf(':');
          min=test.substring(8,p); max=test.substring(p+1);
          if (num<min || max<num) errors+='- '+nm+' must contain a number between '+min+' and '+max+'.\n';
    } } } else if (test.charAt(0) == 'R') errors += '【'+nm+'】不能为空！\n'; }
  } if (errors) alert(errors);
  document.MM_returnValue = (errors == '');
}
//-->
</script>
<script language="JavaScript">
function DelClass_check(id,c)
{
	var ok;
	ok=confirm("您是确定要删除【"+c+"】吗？");
	if(ok)
	{
		self.location.href="delsecond.jsp?id="+id;
	}
}
</script>
</head>

<body>
<table width="95%" border="1" cellspacing="0" cellpadding="3" align="center" bordercolorlight="#ECEEE4" bordercolordark="#CCCABC">
  <tr> 
    <td colspan="9" align="center" height="30" background="images/tablebg.gif"><b>添 
      加 二 级 栏 目</b></td>
  </tr>
  <tr> 
    <td height="25" colspan="3">
	<form action="processaddsecond.jsp" method="post" name="form1" onSubmit="MM_validateForm('firstname','','R');return document.MM_returnValue">
        <div align="center">栏目名称： 
          <input name="secondname" type="text" id="secondname" size="20" maxlength="80">
          &nbsp; 所属一级栏目：
          <select name="firstname" id="firstname">
		  <%
		    int i = 0;
		    do{
		  %>
            <option value="<%=rs.getInt("id")%>"><%=rs.getString("classname")%></option>
	     <%
		   fs[i++] = rs.getString("classname");
		 }while(rs.next());
		 %>
          </select>
          <input type="submit" name="Submit" value="添加">
        </div>
      </form></td>
  </tr>
  <tr> 
    <td height="25" colspan="3"><div align="center"><font color="#FF0000">注意</font>：【删除】操作将删除该栏目下的所有文章！</div></td>
  </tr>
  <%
  i = 0;
  while(i < total){
  	//second.closestmt();
  	sql = "SELECT * FROM web_class WHERE flag=(SELECT id FROM web_class WHERE classname='"+ fs[i] +"') ORDER BY id ASC";
	rs = second.query(sql);
  %>
  <tr>
    <td height="25" colspan="3"><div align="left"><strong><font color="#FF0000"><%=fs[i++]%></font></strong> </div></td>
  </tr>
  <tr> 
    <td width="20%" height="25"><div align="center">ID</div></td>
    <td width="53%"><div align="center">栏目名称</div></td>
    <td width="27%"><div align="center">操作</div></td>
  </tr>
  <%
  int id = 0;
  String c = "";
  while(rs.next()){
  id = rs.getInt("id");
  c = rs.getString("classname");
  %>
  <tr> 
    <td height="25"><div align="center"><%=id%></div></td>
    <td height="25"><div align="center"><%=c%></div></td>
    <td height="25"><div align="center"><a href="modsecond.jsp?id=<%=id%>">修 改</a> | <a onclick="javascript:DelClass_check(<%=id%>,'<%=c%>');" class="A">删 除</a></div></td>
  </tr>
  <%
   }
  }
  %>
</table>
 <%@include file="copyright.jsp"%> 
</body>
</html>
<%
second.closestmt();
second.closeconn();
%>
⌨️ 快捷键说明

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