85 lines
3.6 KiB
Plaintext
85 lines
3.6 KiB
Plaintext
<%@ page language="java" contentType="text/html; charset=utf-8" pageEncoding="utf-8"%>
|
||
<%@ include file="/field_manager/include/manager_head.jsp"%>
|
||
<%
|
||
|
||
String nowPage = r_call(request.getParameter("nowPage")); //현재페이지
|
||
String c_no = r_call(request.getParameter("c_no")); //현재페이지
|
||
String clickSql="update tbl_board set c_click=c_click+1 where c_no="+c_no;
|
||
stmt.executeQuery(clickSql);
|
||
%>
|
||
<center>
|
||
<%
|
||
String sql1="select c_title,c_id,c_name,c_click,c_content,c_files,to_char(c_date,'YYYY-MM-DD') as c_date,c_now,c_a_title,c_a_name,to_char(c_a_date,'YYYY-MM-DD') as c_a_date,c_a_content,c_a_files from tbl_board where c_no="+c_no;
|
||
ResultSet rst = stmt.executeQuery(sql1);
|
||
if(rst.next()) {
|
||
String c_content=rst.getString("c_content");
|
||
String c_files = rst.getString("c_files");
|
||
String[] c_filesArray=null;
|
||
if(c_files==null || c_files.equals("")){}
|
||
else{
|
||
c_filesArray = c_files.split("[|]");
|
||
|
||
}
|
||
c_content = c_content.replaceAll("\r\n","<br>");
|
||
c_content = c_content.replaceAll("-","-");
|
||
|
||
|
||
%>
|
||
<table width="100%" cellSpacing="0" cellPadding="0" border="0" bgcolor="#F1F1F1">
|
||
<tr>
|
||
<td width="20" rowspan="20"></td>
|
||
<td colspan="3" width="" height="10" align="center"></td>
|
||
<td width="20" rowspan="8"></td>
|
||
</tr>
|
||
<tr>
|
||
<td height="30" colspan="3" align="center" bgcolor="#959E06" style="color:#fff; font-size:13pt"><%=rst.getString("c_title")%></td>
|
||
</tr>
|
||
<tr>
|
||
<td height="30" style="padding:5px; border-bottom:1px solid #CECECE">Wirter : <%=rst.getString("c_name")%> </td>
|
||
<td width="33%" align="center" style="padding:5px; border-bottom:1px solid #CECECE">Date : <%=rst.getString("c_date")%></td>
|
||
<td width="33%" align="right" style="padding:5px; border-bottom:1px solid #CECECE">Clicks : <%=rst.getInt("c_click")%></td>
|
||
</tr>
|
||
<tr>
|
||
<td height="100" colspan="3" style="padding:20px 5px" valign=top><%=c_content%></td>
|
||
</tr>
|
||
|
||
<tr>
|
||
<td height="30" colspan=3 style="padding:5px; border-top:1px solid #CECECE; border-bottom:1px solid #CECECE">file :
|
||
<%if(c_files==null || c_files.equals("")){
|
||
}else{%>
|
||
<%for(int i=0 ; i<c_filesArray.length;i++){ %>
|
||
<%if(i>0){%>
|
||
|
||
<%}%>
|
||
<a href="file_down.jsp?fileName=<%=c_filesArray[i]%>"><%=c_filesArray[i]%></a><br />
|
||
|
||
<%}%>
|
||
|
||
<%} %>
|
||
</td>
|
||
|
||
</tr>
|
||
|
||
<tr>
|
||
<td colspan="3" height="10"></td>
|
||
</tr>
|
||
|
||
|
||
</table>
|
||
<table width="100%">
|
||
<tr>
|
||
<td height="35" align="center" colspan="5" style="padding-bottom:10px;padding-top:10px">
|
||
|
||
<a href="edit.jsp?c_no=<%=c_no%><%=call_par%>" style="width: 98px; line-height: 30px; text-align: center;display: inline-block; background: #5e7cc4; border: 1px solid #555; border-radius: 5px; color: #ffffff;">Edit</a>
|
||
<a href="#none" onclick="if(confirm('Are you sure you want to delete?')){location.href='delete.jsp?c_no=<%=c_no%><%=call_par%>'}" style="width: 98px; line-height: 30px; text-align: center;display: inline-block; background: #F7E2DF; border: 1px solid #555; border-radius: 5px; color: #000000;">Delete</a>
|
||
|
||
<a href="list.jsp?1=1<%=call_par%>" style="width: 98px; line-height: 30px; text-align: center;display: inline-block; background: #ededed; border: 1px solid #555; border-radius: 5px; color: #000000;">List</a>
|
||
</td>
|
||
|
||
</tr>
|
||
</table>
|
||
<% }
|
||
rst.close();
|
||
%>
|
||
<%@ include file="/field_manager/include/manager_bottom.jsp"%>
|
||
|