bbs/view.jsp > JSP

• 목록

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>

<%@ include file="/include/header.jsp" %>

<%

String code = request.getParameter("code"); //데이타베이스 게시판 테이블명

String uid = request.getParameter("uid");

//검색 관련

String field = request.getParameter("field");

String search = request.getParameter("search");

//게시판 타이틀

String bbs_title = "";

if(code.equals("notice")){

bbs_title = "공지게시판";

}else if(code.equals("free")){

bbs_title = "자유게시판";

}else if(code.equals("gallery")){

bbs_title = "갤러리게시판";

}else if(code.equals("qna")){

bbs_title = "QnA게시판";

}

%>

<%

//조회수 +1

String sql_count="update "+code+" set ref = ref + 1 where uid="+uid;

Connection conn_count=DriverManager.getConnection(url, user, password);

Statement stmt_count=conn_count.createStatement();

stmt_count.executeUpdate(sql_count);

stmt_count.close();

conn_count.close();

//view(상세보기)

String sql="select * from "+code+" where uid="+uid;

Connection conn=DriverManager.getConnection(url, user, password);

Statement stmt=conn.createStatement();

ResultSet rs=stmt.executeQuery(sql);

//전역변수

String id = "";

String name = "";

String gongji = "";

String subject = "";

String comment = "";

String signdate = "";

String ref = "";

String file1 = "";

if(rs.next()){

id = rs.getString("id");

name = rs.getString("name");

gongji = rs.getString("gongji");

subject = rs.getString("subject");

comment = rs.getString("comment");

signdate = rs.getString("signdate");

ref = rs.getString("ref");

file1 = rs.getString("file1");

}

rs.close();

stmt.close();

conn.close();

if(gongji.equals("3")){ //비밀글

if((session_level != null && session_level.equals("10")) || (session_id != null && session_id.equals(id))){

//관리자 or 작성자

}else{

%>

<script>

alert("읽을 권한이 없습니다.");

history.back();

</script>

<%

}

}

%>

<table width=100% height=50 border=0>

<tr>

<td align=center style="color:#777;font-size:14px;font-weight:bold;">[<%=bbs_title %>]_상세보기</td>

</tr>

</table>

<center>

<table width="700" border="0" cellpadding="0" cellspacing="0">

<tr height=26>

<td colspan=3 height=20 width=100% align=right>●글쓴이:<%=name%> ●작성일:<%=signdate%> ●조회:<%=ref%></td>

</tr>

<tr><td colspan=3 height=1 width=100% bgcolor=#d1dee2></td></tr>

<tr height=26 bgcolor="#eee" align="center">

<td colspan=3><%=subject%></td>

</tr>

<tr><td colspan=3 height=1 width=100% bgcolor=#d1dee2></td></tr>

<%

//commnet 개행처리

pageContext.setAttribute("cmt", comment);

pageContext.setAttribute("LF", "\n");

%>

<tr>

<td colspan=3 width=100% style="padding:5px 0px 7px 0px">${fn:replace(cmt, LF, '<br>')}</td>

</tr>

<tr><td colspan=3 height=1 width=100% bgcolor=#d1dee2></td></tr>

<%if(!file1.equals("")){ //첨부파일 존재 %>

<tr height=26>

<td colspan=3>● 첨부 : <a href="/upload/<%=file1 %>" download><%=file1 %></a></td>

</tr>

<tr><td colspan=3 height=1 width=100% bgcolor=#d1dee2></td></tr>

<%} %>

</table>

<br>

<table width="700" border="0" cellpadding="0" cellspacing="0">

<tr>

<td><a href="list.jsp?code=<%=code%>&field=<%=field%>&search=<%=search%>">[목록]</a></td>

<td align=right>

<a href="modify.jsp?code=<%=code%>&uid=<%=uid%>&field=<%=field%>&search=<%=search%>">[수정]</a>

<a href="delete.jsp?code=<%=code%>&uid=<%=uid%>">[삭제]</a>

</td>

</tr>

</table>

<br>

</center>

<%@ include file="/include/footer.jsp" %>