📄 editchoose.jsp
字号:
<%@ page errorPage="error.jsp" %>
<script language=javascript>
<!--
var startTime,endTime;
var d=new Date();
startTime=d.getTime();
//-->
</script>
<html>
<%
if (session.getAttribute("admin")==null || session.getAttribute("admin")==""){
response.sendRedirect("login.jsp");
} %>
<%@ page contentType="text/html;charset=gb2312" %>
<%@ page language="java" import="java.sql.*"%>
<jsp:useBean id="sqlbean" scope="page" class="news.sql_data"/>
<jsp:useBean id="pagi" scope="page" class="util.page" />
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>企业内部管理信息平台-管理</title>
<link rel="stylesheet" href="m_style.css" type="text/css">
<script language="JavaScript" type="text/JavaScript">
<!--
function MM_jumpMenu(targ,selObj,restore){ //v3.0
eval(targ+".location='"+selObj.options[selObj.selectedIndex].value+"'");
if (restore) selObj.selectedIndex=0;
}
//-->
</script>
</head>
<body>
<div align=center>
<table width="100%" border="0" align="center" cellpadding="2" cellspacing="1" class="tableBorder">
<TR >
<form method=post name=form action=adm_search.jsp>
<td align="center" class=shadow width="100%" colspan="8"><input name="keyword" type="text" onblur="if (value ==''){value='请输入要查询的关键字'}" onmouseover=this.focus() onfocus=this.select() onclick="if(this.value=='请输入要查询的关键字')this.value=''" size="10" class="inputbody" value=请输入要查询的关键字>
<select name="field" size="1" class="inputbody" id="select0">
<option value="all" selected>所有</option>
<option value="title">标题</option>
<option value="content">内容</option>
</select>
<select size="1" name="kt" class="inputbody">
<option value="all" selected>全部类别</option>
<%ResultSet RS_temp=null;
RS_temp = sqlbean.executeQuery("select * from class where parentid=0");
while(RS_temp.next()){%>
<option value="<%=RS_temp.getString("class")%>"><%=RS_temp.getString("class")%></option>
<%}
RS_temp.close();%>
</select>
<input name="Submit" type="Submit" value="搜索..." class="button"></td></form>
</TR>
<tr>
<td width="3%" height="22" class="forumrow">id</td>
<td align="center" class="forumrow">所属分类</td>
<td width="37%" align="center" class=forumrow>标题</td>
<td width="20%" align="center" nowrap class=forumrow>加入日期</td>
<td width="9%" align="center" nowrap class=forumrow>出处</td>
<td width="10%" align="center" nowrap class=forumrow>处理</td>
</tr>
<% String nowPage="";
String str_where="";//设置查询条件,默认值为空
String footer="";
String id="",cuclass="",parentclass="",author="",title="",d="";
nowPage=request.getParameter("pages"); //获取地址栏传过来的pages参数
if (nowPage==null||nowPage.equals("null"))
nowPage="0"; //将当前页的具体页号置为0
pagi.setPages(15); //设置分页的每页条数
ResultSet rs = pagi.setQuerysql("news",str_where,"editchoose.jsp",nowPage);
footer = pagi.PageFooter(); //读分页栏
try{
if (pagi.intPageCount>0)
{int i=0;
while (rs.next())
{i++;
if (i>((pagi.intPage-1)*pagi.intPageSize) &&(i<=pagi.intPage*pagi.intPageSize))
{
id=rs.getString("id")+"";
parentclass=rs.getString("parentclass")+"";
cuclass=rs.getString("class")+"";
d=rs.getString("d")+"";
title=rs.getString("title")+"";
author=rs.getString("author")+"";
%>
<tr><td height="22" class="forumrow"><%=id%></td>
<td height="22" class="forumrow"><%=parentclass%> <%=cuclass%></td>
<td height="22" class="forumrow"><a href=../show.jsp?id=<%=id%> target="_blank"><%=title%></a></td>
<td height="22" class="forumrow"><%=d%></td>
<td height="22" class="forumrow"><%=author%></td>
<td><a href="editupdate.jsp?delete=del&id=<%=id%>"
onclick="{if(confirm('此操作将删除当前记录！\n \n 删除后将不能恢复，您确定执行的操作吗?')){this.document.myform.submit();return true;}return false;}">删除</a>|<a href="edit.jsp?id=<%=id%>">修改</a></td></tr>
<%}//end if
} //end while
} //end if
rs.close();} catch(Exception e)
{out.println(e.getMessage());}
finally
{pagi.closeConn();}
out.print("</table>");
out.println("<table border=0 width='70%' cellspacing='0' cellpadding='0' align='center' bordercolorlight='#000000' bordercolordark='#FFFFFF'><tr><td colspan=4 align=center>"+footer+"</td></tr>");
%>
</table>
<tr>
<td colspan="2">
</div>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -