12.16.(금) Spring Framework(30): 자료실 기능(4)

자료실 목록

짜놓은 틀에다가 제대로 된 데이터를 표시해보자.

우선 data_tbl로부터 데이터를 select해오자.

Service, ServiceImpl, DAO, Mapper.xml을 구성한다.

Service

package com.poby.myapp.service;

import java.util.List;

import com.poby.myapp.vo.DataVO;

public interface DataService {
	// 자료 올리기
	public int dataPostOk(DataVO vo);
	
	// 자료실 목록
	public List<DataVO> dataList();
}

쿼리문 생성

<select id="dataList" resultType="com.poby.myapp.vo.DataVO">
	SELECT postno, subject, username, hitcount, to_char(regdate, 'mm-dd hh:mi') regdate, filename1, filename2 
	FROM data_tbl ORDER BY postno desc
</select>

뷰페이지

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
<!-- attribute : list -->
<style>
	.dataDiv{
		overflow:auto;
	}
	.dataDiv>li{
		float:left;
		width:10%;
		height:40px;
		line-height:40px;
		border-bottom:1px solid #ddd;
	}
	.dataDiv>li:nth-child(6n+2) {
		width:50%
	}
</style>
<title>자료실 목록</title>
<div class="container">
	<h1>자료실 목록</h1>
	<div>
		<a href="/myapp/data/dataPost">자료 올리기</a>
	</div>
	<ul class="dataDiv">
		<li>번호</li>
		<li>제목</li>
		<li>작성자</li>
		<li>조회수</li>
		<li>첨부</li>
		<li>등록일</li>
		
		<c:forEach var="vo" items="${ list }">
			<li>${ vo.postno }</li>
			<li><a href="/myapp/data/dataView?postno=${ vo.postno }">${ vo.subject }</a></li>
			<li>${ vo.username }</li>
			<li>${ vo.hitcount }</li>
			<li>
				<a href="/myapp/upload/${ vo.filename1 }" download><img src="/myapp/img/disk.png" title="${ vo.filename1 }"></a>
				<c:if test="${ vo.filename2!=null && vo.filename2!='' }">
					<a href="/myapp/upload/${ vo.filename2 }" download><img src="/myapp/img/disk.png" title="${ vo.filename2 }"></a>
				</c:if>
			</li>
			<li>${ vo.regdate }</li>
		</c:forEach>
	</ul>
</div>