본문 바로가기
2023.11.21-2024.05.31

240131 게시판만들기(댓글 수정 삭제/ 아이피 정렬)

sukgi094 2024. 2. 1. 11:24

ip.jsp, ip.java 서블릿 만들기

 

ip.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>관리자 페이지 - 댓글관리</title>
<link href="../css/admin.css?ver=0.19" rel="stylesheet"/>
<link href="../css/member.css" rel="stylesheet"/>
<script type="text/javascript" src="../js/menu.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/jquery/3.7.1/jquery.min.js" integrity="sha512-v2CJ7UaYy4JwqLDIrZUI/4hqeoQieOmAZNXBeQyjo21dadnwR+8ZaIJVT8EE2iyI61OV8e6M8PP2/4hpQINQ/g==" crossorigin="anonymous" referrerpolicy="no-referrer"></script>
<link rel="stylesheet" href="//cdn.jsdelivr.net/npm/xeicon@2.3.3/xeicon.min.css">
</head>
<body>
	<div class="wrap">
		<!-- menu -->
		<%@ include file="adminmenu.jsp" %>
		<div class="main">
			<article>
				<h2>댓글관리</h2>
				<div class="nav-lists">
					<ul class="nav-lists-group">
						<li class="nav-lists-item" onclick="url('./comments?del=1')"><i class="xi-close-circle-o"></i> 보임</li>					
						<li class="nav-lists-item" onclick="url('./comments?del=0')"><i class="xi-close-circle-o"></i> 숨김</li>					
					</ul>
					<div class="search">
						<input type="text" id="search">
						<button id="searchBtn">검색</button>
					</div>
				</div>
				<table>
					<thead>
						<tr>
							<th>번호</th>
							<th>제목</th>
							<th>글쓴이</th>
							<th>날짜</th>
							<th>IP</th>
							<th>방문자</th>
							<th>삭제</th>
						</tr>
					</thead>
					<tbody>
						<c:forEach items="${list }" var="row">
							<tr class="row${row.del }">
								<td class="d1">${row.cno }</td>
								<td class="title"><a href="../detail?no=${row.board_no }">${row.comment }</a></td>
								<td class="d2">${row.mname }</td>
								<td class="d1">${row.cdate }</td>
								<td class="d1">${row.ip }</td>
								<td class="d1">${row.clike }</td>
								<td class="d1">
									<input type="hidden" class="del" value="${row.del }">
									<c:if test="${row.del eq 1}"><i class="xi-eye changeDel"></i></c:if>
									<c:if test="${row.del eq 0}"><i class="xi-eye-off-o changeDel"></i></c:if>
								</td>
							</tr>
						</c:forEach>
					</tbody>
				</table>
			</article>
		</div>
	</div>
</body>
</html>

 

 

ip.java 서블릿

package com.sukgi.admin;

import java.io.IOException;
import java.util.List;
import java.util.Map;

import javax.servlet.RequestDispatcher;
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.AdminDAO;


@WebServlet("/admin/adminip")
public class AdminIp extends HttpServlet {
	private static final long serialVersionUID = 1L;
       
   
    public AdminIp() {
        super();
        
    }

	
	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		AdminDAO dao = new AdminDAO();
		List<Map<String, Object>> list=dao.ipList();

		request.setAttribute("list", list);
		RequestDispatcher rd = request.getRequestDispatcher("/admin/adminip.jsp");
		rd.forward(request, response);
		
	}

	
	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		
		
	}

}

 

 

AdminDAO.java >ipList 만들기

 

	public List<Map<String, Object>> ipList() {
		 List<Map<String, Object>> list =  new ArrayList<Map<String, Object>>();
		Connection con = db.getConnection();
		PreparedStatement pstmt = null;
		ResultSet rs = null;
		String sql = "SELECT ino, iip, idate, iurl, idata FROM iplog ORDER BY ino DESC";
		
		try {
			pstmt = con.prepareStatement(sql);
			rs = pstmt.executeQuery();
			
			while (rs.next()) {
				Map<String, Object> e = new HashMap<String, Object>();
				e.put("ino", rs.getInt("ino"));
				e.put("iip", rs.getString("iip"));
				e.put("idate", rs.getString("idate"));
				e.put("iurl", rs.getString("iurl"));
				e.put("idata", rs.getString("idata"));
				
			list.add(e);
			}
		} catch (SQLException e) {
			
			e.printStackTrace();
		}
		
		return null;
	}

 

 

adminip.jsp 수정

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>관리자 페이지 - IP관리</title>
<link href="../css/admin.css?ver=0.19" rel="stylesheet"/>
<link href="../css/member.css" rel="stylesheet"/>
<script type="text/javascript" src="../js/menu.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/jquery/3.7.1/jquery.min.js" integrity="sha512-v2CJ7UaYy4JwqLDIrZUI/4hqeoQieOmAZNXBeQyjo21dadnwR+8ZaIJVT8EE2iyI61OV8e6M8PP2/4hpQINQ/g==" crossorigin="anonymous" referrerpolicy="no-referrer"></script>
<link rel="stylesheet" href="//cdn.jsdelivr.net/npm/xeicon@2.3.3/xeicon.min.css">
</head>
<body>
	<div class="wrap">
		<!-- menu -->
		<%@ include file="adminmenu.jsp" %>
		<div class="main">
			<article>
				<h2>IP관리</h2>
				0.중복없이 ip리스트 뽑기는? 디스틴스
				1.최다 접속 ip 5개 출력(sql)
				2.그래프 그리기(구글차트) ip당 접속 건수 10개
				<div class="nav-lists">
					<ul class="nav-lists-group">
						<li class="nav-lists-item" onclick="url('./comments?del=1')"><i class="xi-close-circle-o"></i> 보임</li>					
						<li class="nav-lists-item" onclick="url('./comments?del=0')"><i class="xi-close-circle-o"></i> 숨김</li>					
					</ul>
					<div class="search">
						<input type="text" id="search">
						<button id="searchBtn">검색</button>
					</div>
				</div>
				<table>
					<thead>
						<tr>
							<th>번호</th>
							<th>IP</th>
							<th>날짜</th>							
							<th>URL</th>
							<th>기타</th>
						</tr>
					</thead>
					<tbody>
						<c:forEach items="${list }" var="row">
							<tr class="row">
								<td class="d1">${row.ino }</td>
								<td class="d1">${row.iip }</td>
								<td class="d2">${row.idate }</td>
								<td class="d1">${row.iurl }</td>
								<td class="title">${row.idata }</td>
							</tr>
						</c:forEach>
					</tbody>
				</table>
			</article>
		</div>
	</div>
</body>
</html>

 

 

0.중복없이 ip리스트 뽑기는?

>DISTINCT

>SELECT DISTINCT iip FROM iplog 


1.최다 접속 ip 5개 출력(sql)

> SELECT iip, COUNT(iip) AS COUNT FROM iplog GROUP BY iip ORDER BY COUNT DESC LIMIT 5;


2.그래프 그리기(구글차트) ip당 접속 건수 10개

저작자표시

'2023.11.21-2024.05.31' 카테고리의 다른 글

240204 ajax 복습하기  (0) 2024.02.04
240201 리눅스  (0) 2024.02.01
240130 게시판만들기(관리자페이지-검색넣기)  (0) 2024.01.30
240126 게시판만들기(관리자 페이지)  (0) 2024.01.26
240125 게시판만들기(댓글 수정)  (0) 2024.01.25

'2023.11.21-2024.05.31' Related Articles

티스토리툴바