?? 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 + -