[Spring+JSP] 이클립스 스프링+JSP 초기 프로젝트 세팅 & 간단 DB 조회 구현

류넹·2025년 8월 20일

Project

목록 보기

14/14

# 개발환경

항목	내용
Language	Java 11
IDE	Eclipse 2023-12
Spring MVC (레거시)	5.3.36 (설정파일 : web.xml, dispatcher-servlet.xml)
Tomcat	9.0.105
DataBase	MySQL 8.0.33 (MyBatis 3.5.15)
Build Tool	Maven (설정파일 : pom.xml)
View template engine	JSP

디렉토리 구조

📌 프로젝트 세팅

0. 프로젝트 생성

아래 링크의 4번까지 참고해서 Dynamic Web Project 생성
https://velog.io/@ryuneng2/Spring-Eclipse-스프링-프로젝트-생성-및-초기-개발환경-구축-Feat.-Maven-Tomcat-설정-Dynamic-Web-Project

1. pom.xml

필요한 의존성 추가

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd">
  <modelVersion>4.0.0</modelVersion>
  <groupId>jqueryapp</groupId>
  <artifactId>jqueryapp</artifactId>
  <version>0.0.1-SNAPSHOT</version>
  <packaging>war</packaging>
  <build>
    <plugins>
      <plugin>
        <artifactId>maven-compiler-plugin</artifactId>
        <version>3.8.1</version>
        <configuration>
          <release>17</release>
        </configuration>
      </plugin>
      <plugin>
        <artifactId>maven-war-plugin</artifactId>
        <version>3.2.3</version>
      </plugin>
    </plugins>
  </build>
  
  <!-- Java version properties -->
  <properties>
    <java.version>11</java.version>
    <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
  </properties>

  <dependencies>
    <!-- Spring -->
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-web</artifactId>
      <version>5.3.36</version>
	</dependency>
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-webmvc</artifactId>
      <version>5.3.36</version>
    </dependency>
    <dependency>
	    <groupId>org.springframework</groupId>
	    <artifactId>spring-context</artifactId>
	    <version>5.3.36</version>
	</dependency>
	<dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-core</artifactId>
      <version>5.3.36</version>
	</dependency>
	<dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-beans</artifactId>
      <version>5.3.36</version>
	</dependency>

    <!-- MyBatis -->
    <dependency>
      <groupId>org.mybatis</groupId>
      <artifactId>mybatis</artifactId>
      <version>3.5.15</version>
    </dependency>
    <dependency>
      <groupId>org.mybatis</groupId>
      <artifactId>mybatis-spring</artifactId>
      <version>2.0.7</version>
    </dependency>
    <dependency>
      <groupId>org.apache.commons</groupId>
      <artifactId>commons-dbcp2</artifactId>
      <version>2.10.0</version>
	</dependency>

    <!-- MySQL JDBC Driver -->
    <dependency>
      <groupId>mysql</groupId>
      <artifactId>mysql-connector-java</artifactId>
      <version>8.0.33</version>
    </dependency>
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-jdbc</artifactId>
      <version>5.3.36</version>
	</dependency>

    <!-- Servlet API (provided by Tomcat) -->
    <dependency>
      <groupId>javax.servlet</groupId>
      <artifactId>javax.servlet-api</artifactId>
      <version>4.0.1</version>
      <scope>provided</scope>
    </dependency>
    
    <!-- JSON 직렬화를 위한 Jackson -->
	<dependency>
	  <groupId>com.fasterxml.jackson.core</groupId>
	  <artifactId>jackson-databind</artifactId>
	  <version>2.15.3</version>
	</dependency>
    <!-- Jackson 날짜 타입 java.time 처리 -->
	<dependency>
	  <groupId>com.fasterxml.jackson.datatype</groupId>
	  <artifactId>jackson-datatype-jsr310</artifactId>
	  <version>2.15.0</version>
	</dependency>
	
	<!-- lombok -->
	<dependency>
	  <groupId>org.projectlombok</groupId>
	  <artifactId>lombok</artifactId>
	  <version>1.18.30</version>
	  <scope>provided</scope>
	</dependency>
    
    <!-- SLF4J API 로깅 -->
	<dependency>
	  <groupId>org.slf4j</groupId>
	  <artifactId>slf4j-api</artifactId>
	  <version>1.7.36</version>
	</dependency>
	<!-- Logback 구현체 -->
	<dependency>
	  <groupId>ch.qos.logback</groupId>
	  <artifactId>logback-classic</artifactId>
	  <version>1.2.12</version>
	</dependency>
	
	<!-- JSTL 태그 라이브러리 -->
	<dependency>
      <groupId>javax.servlet</groupId>
      <artifactId>jstl</artifactId>
      <version>1.2</version>
	</dependency>
  </dependencies>
</project>

2. web.xml

경로 : src/main/webapp/WEB-INF/web.xml

<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://xmlns.jcp.org/xml/ns/javaee" xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_4_0.xsd" id="WebApp_ID" version="4.0">
  <display-name>jqueryapp</display-name>
  
  <!-- Dispatcher Servlet 설정 -->
  <servlet>
    <servlet-name>dispatcher</servlet-name>
    <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
    <init-param>
      <param-name>contextConfigLocation</param-name>
      <param-value>/WEB-INF/spring/dispatcher-servlet.xml</param-value>
    </init-param>
    <load-on-startup>1</load-on-startup>
  </servlet>

  <servlet-mapping>
    <servlet-name>dispatcher</servlet-name>
    <url-pattern>/</url-pattern>
  </servlet-mapping>
  
  <welcome-file-list>
    <welcome-file>index.html</welcome-file>
    <welcome-file>index.jsp</welcome-file>
    <welcome-file>index.htm</welcome-file>
    <welcome-file>default.html</welcome-file>
    <welcome-file>default.jsp</welcome-file>
    <welcome-file>default.htm</welcome-file>
  </welcome-file-list>
</web-app>

3. dispatcher-servlet.xml

경로 : src/main/WEB-INF/spring/dispatcher-servlet.xml

* DB 생성하는 방법 참고)
https://velog.io/@ryuneng2/MySQL-사용자-생성-및-비밀번호-설정

DB 연결 부분에는 자신의 DB 정보에 맞게 입력
Component Scan과 MapperScannerConfigurer의 base-package는 자신이 설정할 최상위 경로에 맞게 설정

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
       xmlns:context="http://www.springframework.org/schema/context"
       xmlns:mvc="http://www.springframework.org/schema/mvc"
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       xsi:schemaLocation="
           http://www.springframework.org/schema/beans 
           http://www.springframework.org/schema/beans/spring-beans.xsd
           http://www.springframework.org/schema/context 
           http://www.springframework.org/schema/context/spring-context.xsd
           http://www.springframework.org/schema/mvc 
           http://www.springframework.org/schema/mvc/spring-mvc.xsd">

  <!-- Component Scan -->
  <context:component-scan base-package="com.jqueryapp" />

  <!-- MVC 설정 -->
  <mvc:annotation-driven />
  <mvc:default-servlet-handler />

  <!-- DB 연결 -->
  <bean id="dataSource" class="org.apache.commons.dbcp2.BasicDataSource">
    <property name="driverClassName" value="com.mysql.cj.jdbc.Driver" />
    <property name="url" value="jdbc:mysql://localhost:3306/[DB명]" />
    <property name="username" value="[유저명]" />
    <property name="password" value="[비밀번호]" />
  </bean>

  <!-- MyBatis 설정 -->
  <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
    <property name="dataSource" ref="dataSource" />
    <property name="mapperLocations" value="classpath:/mybatis/mapper/*.xml" />
  </bean>

  <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
    <property name="basePackage" value="com.jqueryapp.mapper" />
  </bean>
  
  <!-- JSP ViewResolver 설정 -->
  <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
    <property name="prefix" value="/WEB-INF/views/" />
    <property name="suffix" value=".jsp" />
  </bean>
</beans>

* xml 파일 오류 발생 시 참고

https://velog.io/@ryuneng2/Eclipse-이클립스-XML-파일에서-Downloading-external-resources-is-disabled-오류-해결하는-방법

4. SQL

DB 테이블 생성, 더미 데이터 삽입

use jqueryapp;

CREATE TABLE board (
	id BIGINT AUTO_INCREMENT PRIMARY KEY,
    title VARCHAR(255) NOT NULL,
    content VARCHAR(1000) NOT NULL
);

INSERT INTO board
	(title, content)
VALUES
	('제목1', '내용1입니다.');

INSERT INTO board
	(title, content)
VALUES
	('제목2', '내용2입니다.');

✔️ Java 코드 작성

1. Controller

return 값 : jsp 파일 경로 및 이름

package com.jqueryapp.controller;

import java.util.List;

import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.GetMapping;

import com.jqueryapp.service.BoardService;
import com.jqueryapp.vo.Board;

import lombok.RequiredArgsConstructor;

@Controller
@RequiredArgsConstructor
public class BoardController {

	private final BoardService boardService;
	
	@GetMapping
	public String test(Model model) {
		
		String test = boardService.test();
		model.addAttribute("test", test);
		
		return "index";
	}
	
	@GetMapping("/list")
	public String list(Model model) {
		
		List<Board> boards = boardService.getBoards();
		model.addAttribute("boards", boards);
		
		return "board/list";
	}
}

2. Service

package com.jqueryapp.service;

import java.util.List;

import org.springframework.stereotype.Service;

import com.jqueryapp.mapper.BoardMapper;
import com.jqueryapp.vo.Board;

import lombok.RequiredArgsConstructor;

@Service
@RequiredArgsConstructor
public class BoardService {

	private final BoardMapper boardMapper;
	
	public String test() {
		
		return "DI Success";
	}
	
	public List<Board> getBoards() {
		
		return boardMapper.getBoards();
	}
}

3. Mapper

package com.jqueryapp.mapper;

import java.util.List;

import org.apache.ibatis.annotations.Mapper;

import com.jqueryapp.vo.Board;

@Mapper
public interface BoardMapper {

	List<Board> getBoards();
}

4. Mapper.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper   PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.jqueryapp.mapper.BoardMapper">

	<select id="getBoards" resultType="com.jqueryapp.vo.Board">
		select
			id, title, content
		from
			board
	</select>
</mapper>

5. vo

package com.jqueryapp.vo;

import lombok.Getter;

@Getter
public class Board {

	private int id;
	private String title;
	private String content;
}

✔️ JSP 코드 작성

1. index.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>메인 페이지</title>
</head>
<body>
<div>
	<h4>${test }</h4>
	<div>메인 테스트</div>
	<a href="/list">board로 이동</a>
</div>
</body>
</html>

2. common/tags.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<%-- JSTL 태그 라이브러리 --%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%@ taglib prefix="fmt" uri="http://java.sun.com/jsp/jstl/fmt" %>
<%@ taglib prefix="fn" uri="http://java.sun.com/jsp/jstl/functions" %>
<%-- Spring 태그 라이브러리 --%>
<%@ taglib prefix="spring" uri="http://www.springframework.org/tags" %>
<%@ taglib prefix="form" uri="http://www.springframework.org/tags/form" %>

3. board/list.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<%@ include file="../common/tags.jsp" %>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>리스트 페이지</title>
</head>
<body>
<div>
	<h4>Board 리스트</h4>
	<table>
		<thead>
			<tr>
				<th>번호</th>
				<th>제목</th>
				<th>내용</th>
			</tr>
		</thead>
		<tbody>
		<c:forEach var="board" items="${boards }">
			<tr>
				<td>${board.id }</td>
				<td>${board.title }</td>
				<td>${board.content }</td>
			</tr>
		</c:forEach>
		</tbody>
	</table>
	<a href="/">메인으로 이동</a>
</div>
</body>
</html>