240106 >240109복습 게시판 만들기(Detail)
2024. 1. 9. 20:48ㆍ2023.11.21-2024.05.31
BoardDAO06에 작성글보기(톺아보기) 추가하기
//작성글 보기(톺아보기)
public Map<String, Object> detail06(String no) {
Map<String, Object> detail06 = new HashMap<String, Object>();
Connection conn = dbCon06.getConn();
PreparedStatement pstmt = null;
ResultSet rs = null;
String sql = "SELECT * FROM board WHERE board_no=?";
// countUp(no);
try {
pstmt = conn.prepareStatement(sql);
pstmt.setString(1, no);
rs = pstmt.executeQuery();
if (rs.next()) {
detail06.put("board_no", rs.getInt(1));
detail06.put("board_title", rs.getString(2));
detail06.put("board_write", rs.getString(3));
detail06.put("board_content", rs.getString(4));
detail06.put("board_date", rs.getString(5));
detail06.put("board_count", rs.getInt(6));
}
} catch (SQLException e) {
e.printStackTrace();
} finally {
close(rs, pstmt, conn);
}
return detail06;
}
서블릿> Detail06.java 만들기
package com.sukgi.web;
import java.io.IOException;
import java.util.Map;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import com.sukgi.dao.BoardDAO06;
@WebServlet("/detail")
public class Detail06 extends HttpServlet {
private static final long serialVersionUID = 1L;
public Detail06() {
super();
}
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
//response.getWriter().append("Served at: ").append(request.getContextPath());
//데이터베이스에게 물어보고
String no = request.getParameter("no");
//DAO에게 일 시키기기
BoardDAO06 dao06 = new BoardDAO06();
Map<String, Object> detail = dao06.detail06(no);
}
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
doGet(request, response);
}
}
webapp> detail06.jsp 추가하기
<%@page import="com.sukgi.dao.BoardDAO06"%>
<%@page import="java.util.Map"%>
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>톺아보기</title>
</head>
<body>
<%-- <%@ include file="./menu.jsp" %> --%>
<h1>톺아보기</h1>
<%
BoardDAO06 dao06 = new BoardDAO06();
String no = request.getParameter("no");
Map<String, Object> details = dao06.detail06(no);
%>
<img onclick="update(<%=details.get("board_no")%>)" alt="수정"
src="./img/update.png" title="버튼을 누르면 글을 수정합니다.">
<img onclick="del(<%=details.get("board_no")%>)" alt="삭제"
src="./img/delete1.png" title="버튼을 누르면 삭제합니다">
<br> 제목 : <%=details.get("board_title")%>
<br> 글쓴이 :<%=details.get("board_write")%>
<br> 날짜 : <%=details.get("board_date")%>
<br> 번호 : <%=details.get("board_no")%>
<br> 조회 : <%=details.get("board_count")%>
<hr>
<%=details.get("board_content")%><br>
<button onclick="location.href='./index.jsp'">돌아가기</button>
<button onclick="what()">눌러보세요</button>
<script type="text/javascript">
function update(){
var check = confirm("수정하시겠습니까?");
if(check){
alert("글을 수정합니다.")
location.href="./update?no=<%=details.get("board_no")%>";
}
}
function del(no){
if(confirm("정말 삭제할거야?")){
location.href="./delete?no="+no;
}
}
</script>
</body>
</html>'2023.11.21-2024.05.31' 카테고리의 다른 글
| 쿼리2 (0) | 2024.01.15 |
|---|---|
| 쿼리1 (0) | 2024.01.15 |
| 240106 복습 게시판 만들기(INDEX) (1) | 2024.01.06 |
| 240104 웹 만들기 ; write.html (1) | 2024.01.04 |
| 240104 웹 만들기 ; position.html (1) | 2024.01.04 |