?? show.jsp
字號:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<%@ page contentType="text/html;charset=gb2312"%>
<%@page import="java.util.*,java.text.*"%>
<%
//新聞表
String uid = (String)session.getAttribute("ID");
com.util.DealString ds = new com.util.DealString();
String step = ds.toString(request.getParameter("step"));
String addtime = ds.toString(request.getParameter("addtime"));
String endtime = ds.toString(request.getParameter("endtime"));
String froms = "";
String title = ds.toString(request.getParameter("title"));
String url = ds.toString(request.getParameter("url"));
String content = ds.toString(request.getParameter("content"));
//回復表
String txt_rybh = ds.toString(request.getParameter("txt_rybh"));
String txt_rymc = ds.toGBK(request.getParameter("txt_rymc"));
//附件表
String strfile = ds.toGBK(request.getParameter("strfile"));
String strname = ds.toGBK(request.getParameter("strname"));
String strsize = ds.toString(request.getParameter("strsize"));
String upmonth = ds.toString(request.getParameter("upmonth"));
String cursize = "0" ;
//新聞編號
String sql = "" ;
com.db.CommonBean myBean = new com.db.CommonBean();
String id = ds.toString(request.getParameter("id")) ;
//標記為已讀
String backid1 = ds.toString(request.getParameter("backid")) ;
if(!backid1.equals(""))myBean.getDataBySql("update kjc_back set ifread='1' where id="+backid1);
//System.out.println("+++++++++++++++"+id+"-------");
//選擇文章信息
myBean.init("kjc_publish","addtime desc","");
myBean.setID( id ) ;
Hashtable hash = myBean.getOneData ( ) ;
addtime = ds.toString((String)hash.get("addtime"));
endtime = ds.toString((String)hash.get("endtime"));
froms = ds.toString((String)hash.get("froms"));
title = ds.toString((String)hash.get("title"));
url = ds.toString((String)hash.get("url"));
content = ds.toString((String)hash.get("content"));
//選擇回復信息
sql = "select a.backer,b.name from kjc_back a,kjc_people b where a.backer=b.id and a.objectid="+id+" order by a.backer" ;
Vector vect = myBean.getDataBySql(sql);
txt_rymc = "" ;
txt_rybh = "" ;
for(int i =0 ; i < vect.size ( ) ; i++ )
{
Hashtable h = (Hashtable) vect.get( i ) ;
if(!txt_rymc.equals(""))txt_rymc += "," ;
if(!txt_rybh.equals(""))txt_rybh += "," ;
txt_rymc += (String)h.get("name");
txt_rybh += (String)h.get("backer");
}
//選擇附件信息
sql = "select * from kjc_file where objectid="+id+" order by updatetime desc" ;
Vector vect1 = myBean.getDataBySql(sql);
String fujian = "" ;
for(int i =0 ; i < vect1.size ( ) ; i++ )
{
Hashtable h = (Hashtable) vect1.get( i ) ;
String size = (String)h.get("size") ;
String newname = (String)h.get("newname") ;
String oldname = (String)h.get("oldname") ;
fujian += "<a href=\"../UploadPath/"+newname+"\">"+oldname+"("+ds.toMKByte(Long.parseLong(size))+")"+"</a> ";
}
sql = "select * from kjc_back where objectid="+id+" and backer="+(String)session.getAttribute("ID");
Vector v = myBean.getDataBySql(sql);
String backid = "";
if(v.size()>0)backid = ds.toString((String)((Hashtable)v.get(0)).get("id"));
myBean.closeConn ( ) ;
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" href="../index.css" type="text/css">
<title>發表通知</title>
<style>
.inputnull {
border-top:0px ;border-bottom:0px;border-left:0 px;border-right:0px;
}
</style>
</head>
<body>
<table width="100%" height="20" border="0" cellpadding="0" cellspacing="0">
<tr>
<td> </td>
</tr>
</table>
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="40"> </td>
<td width="910"><table width="100%" height="20" border="0" cellpadding="0" cellspacing="0">
<tr>
<td height="20" class="title_s"> 您已登陸: <%=(String)session.getAttribute("NAME")%> </td>
</tr>
<tr>
<td height="5" bgcolor="#A3BED9"></td>
</tr>
<tr>
<td height="1" bgcolor="#0A1870"></td>
</tr>
</table></td>
<td width="50"> </td>
</tr>
</table>
<div align=center>
<TABLE width="90%" border=1 cellPadding=5 cellSpacing=0 bordercolor="ffffff" class="main1">
<TBODY>
<TR bgcolor="ffffff" align=center>
<TD align=center class="title_s" colspan=2>
<table width="100%">
<tr><td align=center><%=title%> </td><td align=right class="title_s" width=80><%if(v.size()!=0&&!backid1.equals("")){%><a href="newback.jsp?id=<%=id%>&backid=<%=backid%>&title=<%=title%>">回復</a><%}else{%> <%}%></td>
</tr></table>
</TD>
</TR>
<TR bgcolor="E7F2FF" align=left>
<TD width=150>發布日期</TD>
<TD><%=addtime%>
</TD>
</TR>
<TR bgcolor="E7F2FF" align=left>
<TD width=150>有效日期</TD>
<TD><%=endtime%></TD>
</TR>
<TR bgcolor="E7F2FF" align=left>
<TD width=150>發布人</TD>
<TD><%=(String)session.getAttribute("NAME")%></TD>
</TR>
<%if(uid.equals(froms)){%>
<TR bgcolor="E7F2FF" align=left>
<TD width=150>接受人</TD>
<TD><%=txt_rymc%></TD>
</TR><%}%>
</TR>
<TR bgcolor="E7F2FF" align=left>
<TD>鏈接地址</TD>
<TD><a href="<%=url%>" target=_blank><%=url%></a></TD>
</TR>
<TR bgcolor="E7F2FF" align=left>
<TD width=150 vAlign=top class=TBBG1><BR>
<TABLE cellSpacing=0 cellPadding=0 border=0>
<TBODY>
<TR>
<TD>
<TABLE cellSpacing=0 cellPadding=0 border=0>
<TBODY>
<TR>
<TD colSpan=2>內容(最大16K)<BR>
<BR></TD>
</TR>
</TBODY>
</TABLE>
<BR>
<P> </P></TD>
</TR>
</TBODY>
</TABLE>
<BR></TD>
<TD class=TBBG9 valign=top><%=content%> </TD>
</TR><TR bgColor="E7F2FF">
</TR align=left>
<TR bgcolor="E7F2FF" align=left>
<TD width=150>上傳附件</TD>
<TD><%=fujian%></TD>
</TR>
</TABLE>
</div>
</body>
</html>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -