?? show.jsp
字號:
<script language=javascript>
<!--
var startTime,endTime;
var d=new Date();
startTime=d.getTime();
//-->
</script>
<html>
<%@ page contentType="text/html;charset=gb2312" %>
<%@ page language="java" import="java.sql.*"%>
<%@ page language="java" import="java.util.*"%>
<jsp:useBean id="sqlbean" scope="page" class="news.sql_data"/>
<jsp:useBean id="strFormat" scope="page" class="news.strFormat"/>
<head>
<title>企業內部管理信息平臺∷瀏覽</title>
<META http-equiv=Content-Type content="text/html; charset=gb2312">
<link rel="stylesheet" href="newstyle.css" type="text/css">
<style type="text/css">
<!--
.style2 {
color: #000066;
font-weight: bold;
font-family: Arial, Helvetica, sans-serif;
}
-->
</style>
</head>
<body leftMargin=0 topMargin=0 marginheight="0" marginwidth="0">
<div align=center>
<jsp:include page="header.jsp"/>
<BR style="OVERFLOW: hidden; LINE-HEIGHT: 3px">
<TABLE width="780" border=0 align=center cellPadding=0 cellSpacing=0>
<TR>
<TD width="23%" vAlign=top>
<TABLE width="100%" cellSpacing=0 cellPadding=0 align=center border=0>
</table>
<table width="98%" border="0" align="center" cellpadding="3" cellspacing="0">
<tr>
<td align="center" vAlign=top style="LINE-HEIGHT: 130%; font-size: 9pt;"><span class="style2">-=本類瀏覽排行=-</span></td>
</tr>
<tr>
<td vAlign=top style="LINE-HEIGHT: 130%; font-size: 9pt;">
<%String keyword=null;
if (!(request.getParameter("keyword")==null))
keyword=new String(request.getParameter("keyword").getBytes("ISO8859_1"),"GBK");
//聲明變量，并取得所提交參數值和進行編碼轉換
String newsid=request.getParameter("id");
int idd = Integer.parseInt(newsid);
sqlbean.executeUpdate("update news set hit=hit+1 where id="+idd+"");
String sql = "Select * FROM news where id="+idd+"";
ResultSet RS_detail = sqlbean.executeQuery(sql);
RS_detail.next();
//String sortid=new String(request.getParameter("sortid").getBytes("ISO8859_1"),"GBK");
String sortid=RS_detail.getString("class");
sql = "Select id,title,hit FROM news where class='"+sortid+"' order by hit desc";
ResultSet RS = sqlbean.executeQuery(sql);
int i=0;
while (RS.next()&&(i<10)){%>
<img src=images/ico1.gif> <A href='show.jsp?id=<%=RS.getString("id")%>'>
<%
String title=RS.getString("title");
if (title.length()>11){
title=title.substring(0,10);
out.println(title+"...");}else{
out.println(title);}%></a> <FONT color=#999999><%=RS.getString("hit")%></font><BR>
<%i++;}
RS.close();%></td>
</tr>
</table>
<TABLE width="100%" cellSpacing=0 cellPadding=0 align=center border=0>
</table>
<table width="98%" border="0" align="center" cellpadding="3" cellspacing="0">
<tr>
<td align="center" vAlign=top style="LINE-HEIGHT: 130%; font-size: 9pt;"><span class="style2">-=總瀏覽排行=-</span></td>
</tr>
<tr>
<td vAlign=top style="LINE-HEIGHT: 130%; font-size: 9pt;">
<% sql = "Select top 10 id,title,hit FROM news order by hit desc";
RS = sqlbean.executeQuery(sql);
while (RS.next()){%>
<img src=images/ico1.gif> <A href='show.jsp?id=<%=RS.getString("id")%>'>
<%
String title=RS.getString("title");
if (title.length()>11){
title=title.substring(0,10);
out.println(title+"...");}else{
out.println(title);}%></a> <FONT color=#999999><%=RS.getString("hit")%></font><BR>
<%}
RS.close();%></td>
</tr>
</table> </TD>
<TD width="1"><img src="" width=1 height=1></TD>
<TD width="87%" vAlign=top>
<TABLE width="100%" cellSpacing=0 cellPadding=0 align=center border=0>
<TR>
<Th align="left">標題：<%
if (keyword==null)
out.println(RS_detail.getString("title"));
else
out.println(RS_detail.getString("title").replaceAll(keyword,"<font color=red><b>"+keyword+"</b></font>"));
%></Th>
</TR></TABLE>
<TABLE width="100%" border=0 align=center cellPadding=2 cellSpacing=1>
<TR>
<TD width="50%" height=22 colspan="2">所屬類別： <%=RS_detail.getString("parentclass")%> <%=RS_detail.getString("class")%></TD>
</TR>
<TR height=22>
<TD width="50%" colspan="2">出處： <%=RS_detail.getString("author")%></TD>
</TR>
<TR height=22>
<TD width="25%" >添加時間： <%=RS_detail.getString("d")%></TD>
<TD width="25%" >瀏覽次數<%=RS_detail.getString("hit")%></TD>
</TR>
</TABLE>
<BR style="OVERFLOW: hidden; LINE-HEIGHT: 3px">
<TABLE width="100%" border=0 align=center cellPadding=0 cellSpacing=1>
<TR>
<Th align="left"> ::<FONT color=#00a5ce>文字內容</FONT>::</Th>
</TR>
<TR>
<TD ><TABLE width="100%" cellSpacing=1 cellPadding=5 align=center border=0>
<TR>
<TD style="LINE-HEIGHT: 150%"><%String news2= new String(RS_detail.getString("news").getBytes("ISO8859_1"),"GBK");
news2=strFormat.toHtml(news2);
if (!(keyword==null))
news2=news2.replaceAll(keyword,"<font color=red><b>"+keyword+"</b></font>");
out.println(news2);%></TD>
</TR>
</TABLE></TD>
</TR>
<TR>
<Th align="left"> ::<FONT color=#ff0066>附加文件</FONT>::</Th>
</TR> <%String file=request.getRequestURL().toString();
int xPoint = file.lastIndexOf("/");
file=file.substring(0,xPoint+1);//得到當前虛擬目錄的地址
if (RS_detail.getString("file1").equals("")){}
else{
%>
<TR>
<TD style="LINE-HEIGHT: 150%"> <img src="images/download.gif" border=0> <script language="javascript">function DownDvasp(htmlurl){var newwin=window.open(htmlurl,'','toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbars=no,resizable=no');return false;}</script>
<a href="<%=file%><%=RS_detail.getString("file1")%>" onclick="return DownDvasp(this.href);">下載地址</a></TD>
</TR><%}
if (RS_detail.getString("file2").equals("")){}
else{
%>
<TR>
<TD style="LINE-HEIGHT: 150%"> <img src="images/download.gif" border=0> <script language="javascript">function DownDvasp(htmlurl){var newwin=window.open(htmlurl,'','toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbars=no,resizable=no');return false;}</script>
<a href="<%=file%><%=RS_detail.getString("file2")%>" onclick="return DownDvasp(this.href);">下載地址</a></TD>
</TR><%}
if (RS_detail.getString("file3").equals("")){}
else{
%>
<TR>
<TD style="LINE-HEIGHT: 150%"> <img src="images/download.gif" border=0> <script language="javascript">function DownDvasp(htmlurl){var newwin=window.open(htmlurl,'','toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbars=no,resizable=no');return false;}</script>
<a href="<%=file%><%=RS_detail.getString("file3")%>" onclick="return DownDvasp(this.href);">下載地址</a></TD>
</TR><%}
RS_detail.close();%>
</TABLE>
</TD>
</TR></TABLE><div align="center"><jsp:include page="bottom.jsp"/></div>
</div>
</body>
</html>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -