2024. 01.14. 19:47ㆍSpring
Spring Tool Suit를 설치하고 legacy maven 프로젝트를 실행시켜 보자.
기본 설정파일
root-context.xml
스캔 / bean 등록.. 등
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:context="http://www.springframework.org/schema/context"
xmlns:mybatis-spring="http://mybatis.org/schema/mybatis-spring"
xsi:schemaLocation="http://mybatis.org/schema/mybatis-spring http://mybatis.org/schema/mybatis-spring-1.2.xsd
http://www.springframework.org/schema/beans https://www.springframework.org/schema/beans/spring-beans.xsd
http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.3.xsd">
<!-- Root Context: defines shared resources visible to all other web components -->
<bean id="hikariConfig" class="com.zaxxer.hikari.HikariConfig">
<property name="driverClassName" value="oracle.jdbc.driver.OracleDriver" />
<property name="jdbcUrl" value="jdbc:oracle:thin:@192.168.1.100:1521:xe" />
<property name="username" value="c##itbank" />
<property name="password" value="it" />
</bean>
<bean id="dataSource" class="com.zaxxer.hikari.HikariDataSource">
<constructor-arg ref="hikariConfig" />
</bean>
<bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
<property name="dataSource" ref="dataSource"></property>
</bean>
<!-- classpath : src/main/java .java 형식의 자바 소스코드를 배치하는 위치
src/main/resources .java 가 아닌 기타 형식의 파일 (xml, properties 등)을 배치하는 위치
-->
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<property name="dataSource" ref="dataSource" />
<property name="mapperLocations">
<list>
<value>classpath:mybatis/test2-mapper.xml</value>
<value>classpath:mybatis/test3-mapper.xml</value>
</list>
</property>
</bean>
<bean id="sqlSessionTemplate" class="org.mybatis.spring.SqlSessionTemplate">
<constructor-arg ref="sqlSessionFactory" />
</bean>
<context:component-scan base-package="com.itbank.service" />
<context:component-scan base-package="com.itbank.repository" />
<!-- 지정한 패키지에서 인터페이스 형태의 DAO 를 스캔함
: 스캔후에는 xml 과 연결 가능
-->
<mybatis-spring:scan base-package="com.itbank.repository" />
</beans>
pom.xml
의존성 관리
<?xml version="1.0" encoding="UTF-8"?>
<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/maven-v4_0_0.xsd">
<modelVersion>4.0.0</modelVersion>
<groupId>com.itbank</groupId>
<artifactId>day01</artifactId>
<name>day01</name>
<packaging>war</packaging>
<version>1.0.0-BUILD-SNAPSHOT</version>
<properties>
<java-version>11</java-version>
<org.springframework-version>5.3.30</org.springframework-version>
<org.aspectj-version>1.6.10</org.aspectj-version>
<org.slf4j-version>1.6.6</org.slf4j-version>
</properties>
<dependencies>
<!-- Spring -->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-context</artifactId>
<version>${org.springframework-version}</version>
<exclusions>
<!-- Exclude Commons Logging in favor of SLF4j -->
<exclusion>
<groupId>commons-logging</groupId>
<artifactId>commons-logging</artifactId>
</exclusion>
</exclusions>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-webmvc</artifactId>
<version>${org.springframework-version}</version>
</dependency>
<!-- AspectJ -->
<dependency>
<groupId>org.aspectj</groupId>
<artifactId>aspectjrt</artifactId>
<version>${org.aspectj-version}</version>
</dependency>
<!-- Logging -->
<dependency>
<groupId>org.slf4j</groupId>
<artifactId>slf4j-api</artifactId>
<version>${org.slf4j-version}</version>
</dependency>
<dependency>
<groupId>org.slf4j</groupId>
<artifactId>jcl-over-slf4j</artifactId>
<version>${org.slf4j-version}</version>
<scope>runtime</scope>
</dependency>
<dependency>
<groupId>org.slf4j</groupId>
<artifactId>slf4j-log4j12</artifactId>
<version>${org.slf4j-version}</version>
<scope>runtime</scope>
</dependency>
<dependency>
<groupId>log4j</groupId>
<artifactId>log4j</artifactId>
<version>1.2.15</version>
<exclusions>
<exclusion>
<groupId>javax.mail</groupId>
<artifactId>mail</artifactId>
</exclusion>
<exclusion>
<groupId>javax.jms</groupId>
<artifactId>jms</artifactId>
</exclusion>
<exclusion>
<groupId>com.sun.jdmk</groupId>
<artifactId>jmxtools</artifactId>
</exclusion>
<exclusion>
<groupId>com.sun.jmx</groupId>
<artifactId>jmxri</artifactId>
</exclusion>
</exclusions>
<scope>runtime</scope>
</dependency>
<!-- @Inject -->
<dependency>
<groupId>javax.inject</groupId>
<artifactId>javax.inject</artifactId>
<version>1</version>
</dependency>
<!-- Servlet -->
<dependency>
<groupId>javax.servlet</groupId>
<artifactId>servlet-api</artifactId>
<version>2.5</version>
<scope>provided</scope>
</dependency>
<dependency>
<groupId>javax.servlet.jsp</groupId>
<artifactId>jsp-api</artifactId>
<version>2.1</version>
<scope>provided</scope>
</dependency>
<dependency>
<groupId>javax.servlet</groupId>
<artifactId>jstl</artifactId>
<version>1.2</version>
</dependency>
<!-- Test -->
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>4.7</version>
<scope>test</scope>
</dependency>
<!-- https://mvnrepository.com/artifact/xerces/xercesImpl -->
<dependency>
<groupId>xerces</groupId>
<artifactId>xercesImpl</artifactId>
<version>2.12.2</version>
</dependency>
<!-- https://mvnrepository.com/artifact/com.oracle.database.jdbc/ojdbc10 -->
<dependency>
<groupId>com.oracle.database.jdbc</groupId>
<artifactId>ojdbc10</artifactId>
<version>19.21.0.0</version>
</dependency>
<!-- https://mvnrepository.com/artifact/org.springframework/spring-jdbc -->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-jdbc</artifactId>
<version>5.3.30</version>
</dependency>
<!-- https://mvnrepository.com/artifact/com.zaxxer/HikariCP -->
<dependency>
<groupId>com.zaxxer</groupId>
<artifactId>HikariCP</artifactId>
<version>4.0.3</version>
</dependency>
<!-- https://mvnrepository.com/artifact/org.mybatis/mybatis -->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.5.15</version>
</dependency>
<!-- https://mvnrepository.com/artifact/org.mybatis/mybatis-spring -->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis-spring</artifactId>
<version>2.1.2</version>
</dependency>
</dependencies>
<build>
<plugins>
<plugin>
<artifactId>maven-eclipse-plugin</artifactId>
<version>2.9</version>
<configuration>
<additionalProjectnatures>
<projectnature>org.springframework.ide.eclipse.core.springnature</projectnature>
</additionalProjectnatures>
<additionalBuildcommands>
<buildcommand>org.springframework.ide.eclipse.core.springbuilder</buildcommand>
</additionalBuildcommands>
<downloadSources>true</downloadSources>
<downloadJavadocs>true</downloadJavadocs>
</configuration>
</plugin>
<plugin>
<groupId>org.apache.maven.plugins</groupId>
<artifactId>maven-compiler-plugin</artifactId>
<version>2.5.1</version>
<configuration>
<source>11</source>
<target>11</target>
<compilerArgument>-Xlint:all</compilerArgument>
<showWarnings>true</showWarnings>
<showDeprecation>true</showDeprecation>
</configuration>
</plugin>
<plugin>
<groupId>org.codehaus.mojo</groupId>
<artifactId>exec-maven-plugin</artifactId>
<version>1.2.1</version>
<configuration>
<mainClass>org.test.int1.Main</mainClass>
</configuration>
</plugin>
</plugins>
</build>
</project>
web.xml
<?xml version="1.0" encoding="UTF-8"?>
<web-app version="4.0" xmlns="http://java.sun.com/xml/ns/javaee"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://java.sun.com/xml/ns/javaee https://java.sun.com/xml/ns/javaee/web-app_4_0.xsd">
<!-- The definition of the Root Spring Container shared by all Servlets and Filters -->
<context-param>
<param-name>contextConfigLocation</param-name>
<param-value>/WEB-INF/spring/root-context.xml</param-value>
</context-param>
<!-- Creates the Spring Container shared by all Servlets and Filters -->
<listener>
<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
</listener>
<filter>
<filter-name>encodingFilter</filter-name>
<filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
<init-param>
<param-name>encoding</param-name>
<param-value>utf-8</param-value>
</init-param>
</filter>
<filter-mapping>
<filter-name>encodingFilter</filter-name>
<url-pattern>/*</url-pattern>
</filter-mapping>
<!-- Processes application requests -->
<servlet>
<servlet-name>appServlet</servlet-name>
<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
<init-param>
<param-name>contextConfigLocation</param-name>
<param-value>/WEB-INF/spring/appServlet/servlet-context.xml</param-value>
</init-param>
<load-on-startup>1</load-on-startup>
</servlet>
<servlet-mapping>
<servlet-name>appServlet</servlet-name>
<url-pattern>/</url-pattern>
</servlet-mapping>
</web-app>
HomeController
최상위 경로(/)로 GET요청을 받았을 때 처리하는 controller
@Autowired private TestService testService
-> com.itbank.service 에 TestService 클래스가 만들어져 있어야한다.
내가 만든 클래스를 스프링 빈으로 만드는 방법 : 1) 스캔 2) 어노테이션
MVC 패턴에서는 JSP를 향한 forward를 기본으로 사용하기 때문에
요청 주소와 JSP의 이름은 분리해서 생각해야한다 .
home() 함수의 반환형은 ModelAndView
: Attribute, redirect 등 그대로 넣을 수 있기 때문
import java.sql.Date;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.servlet.ModelAndView;
import com.itbank.service.TestService;
@Controller
public class HomeController {
@Autowired private TestService testService;
@GetMapping("/") // 만약 최상위 경로로 GET 요청을 받으면 home() 함수를 실행하고 viewName을 "home"으로 설정
public ModelAndView home() {
ModelAndView mav = new ModelAndView("home");
String version = testService.getDBVersion(); // getDBVersion() : 함수명은 마음대로 설정
Date sysdate = testService.getSysDate();
mav.addObject("version", version);
mav.addObject("sysdate", sysdate);
return mav;
}
}
home.jsp
최상위 경로를 실행하면 사용자에게 접속된 DB버전과 현재 시간이 출력된다.
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
<html>
<head>
<title>Home</title>
</head>
<body>
<h1>
Hello world!
</h1>
<h3>접속된 DB 버전 : ${version }</h3>
<h3>${sysdate }</h3>
<a href="member"><button>member</button></a>
</body>
</html>
MemberController
: Controller 어노테이션을 이용해서, 해당 클래스가 Controller 역할을 수행함을 명시해야 한다.
PathVariable
: 경로변수
요청 주소 상의 특정 경로의 값을 정수 및 문자열 형태로 전달받아서 파라미터와 유사하게 사용 가능
쿼리스트링을 안써도 된다.
GetMapping
: 일반적으로, 데이터 처리 없이 페이지를 실행할때
PostMapping
: form 등의 submit 을 통한 데이터 처리가 일어난 상황일때
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.servlet.ModelAndView;
import com.itbank.service.MemberService;
import java.util.HashMap;
import java.util.List;
import com.itbank.member.MemberDTO;
@Controller
public class MemberController {
@Autowired private MemberService ms;
@GetMapping("/member")
public ModelAndView memberList() {
ModelAndView mav = new ModelAndView("member-list");
List<MemberDTO> list = ms.getMemberList();
mav.addObject("list", list);
return mav;
}
@PostMapping("/member")
public ModelAndView memberSearchList(@RequestParam HashMap<String, String> paramMap) {
// DTO 에 정의 되어 있지 않은 값을 여러개 받을 때는
// HashMap 을 사용할 수 있다 !!
// 단, HashMap은 파라미터 처리외에도 다양한 기능들이 있기 때문에
// 어노테이션 RequestParam 으로 파라미터 처리를 하라는 명시를 해주자
ModelAndView mav = new ModelAndView("member-list");
List<MemberDTO> list = ms.getMemberSearchList(paramMap);
mav.addObject("list", list);
return mav;
}
// a 태그를 이용한 이동에는 @GetMapping 으로 처리
@GetMapping("/member/add")
public ModelAndView memberAdd() {
ModelAndView mav = new ModelAndView("member-add");
return mav;
}
@PostMapping("/member/add")
public ModelAndView memberAdd(MemberDTO dto) {
// form 의 input name과 dto의 필드이름이 일치하다면
// 자동으로 파라미터가 입력된다
ModelAndView mav = new ModelAndView("redirect:/member");
int row = ms.add(dto);
System.out.println(row != 0 ? "추가 성공" : "추가 실패");
return mav;
}
@GetMapping("/member/delete/{idx}")
public ModelAndView delete(@PathVariable("idx")int idx) {
ModelAndView mav = new ModelAndView("alert");
int row = ms.delete(idx);
String message = row != 0 ? "삭제 성공" : "삭제 실패";
String url = "/member";
mav.addObject("message", message);
mav.addObject("url", url);
return mav;
}
}
MemberService
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import java.util.HashMap;
import java.util.List;
import com.itbank.member.MemberDTO;
import com.itbank.repository.MemberDAO;
@Service
public class MemberService {
@Autowired private MemberDAO dao;
public List<MemberDTO> getMemberList() {
List<MemberDTO> list = dao.selectList();
list.forEach(dto -> dto.setUserpw("******"));
return list;
}
public List<MemberDTO> getMemberSearchList(HashMap<String, String> paramMap) {
// mybatis 함수는 인자를 하나만 전달하거나, 아예 전달하지 않는다
// (= 인자를 2개이상 전달하지 않음. 즉, 파라미터는 묶어서 전달해야함)
List<MemberDTO> list = dao.selectSearchList(paramMap);
list.forEach(dto -> dto.setUserpw("******"));
return list;
}
public int add(MemberDTO dto) {
int row = dao.insert(dto);
return row;
}
public int delete(int idx) {
int row = dao.delete(idx);
return row;
}
}
MemberDTO
필드와 getter, setter 생성
IDX | NOT NULL | NUMBER |
USERID | NOT NULL | VARCHAR2(100) |
USERPW | NOT NULL | VARCHAR2(100) |
USERNAME | NOT NULL | VARCHAR2(100) |
NOT NULL | VARCHAR2(500) |
MemberDAO
: spring 에서는 일반적으로 DAO 를 interface로 생성한다.
인터페이스는 어노테이션이 필요없지만, 가독성때문에 쓰기도 한다.
import java.util.HashMap;
import java.util.List;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;
import com.itbank.member.MemberDTO;
@Repository
public interface MemberDAO {
@Select("select * from member order by idx")
List<MemberDTO> selectList();
// pstmt 에는 ?에 대응하는 표현식이 2개 있다
// ${} 안에는 따옴표를 넣지 않음
// #{} 안에는 자료형에 따라서 따옴표를 적절히 넣어줌
@Select("select * from member where ${searchType} like '%' || #{searchKeyword} || '%' order by idx")
List<MemberDTO> selectSearchList(HashMap<String, String> paramMap);
@Insert("insert into member (userid, userpw, username, email)"
+ " values ( #{userid}, #{userpw} , #{username}, #{email} )")
int insert(MemberDTO dto);
@Delete("delete from member where idx = #{idx}")
int delete(int idx);
}
코드 해석 및 용어정리
context 파일
: 스프링빈을 만들때 사용하기 위한 설정파일
Dispather servlet
직접적으로 응답과 요청에 연관있는 애들 작성 (= 인터셉트 같은 애들)
root context 는 직접적으로 관련은 없는데 다 쓰는 것
servlet-context
<resources mapping="/resources/**" location="/resources/" />
-> 요청이 들어오면 이 경로에서 처리해라 (css나 이미지 폴더 등은 여기에 넣어두기)
[ 사용자 요청 처리 과정 ]
과정 1 | 과정 2 | 과정 3 | 과정 4 |
Controller | JDBC Template | DB | DAO |
사용자의 요청을 받는다 | Spring 과 DB 를 연결 | DB service 참조 | DAO 참조 |
[ DB 와 연결해서 결과를 처리하는 방법 ]
1) JdbcTemplate 2) SqlSessionTemplate 3) mapper auto injection
= myBatis-spring
Spring은 처음 프로젝트 생성 시 설정 파일 관리만 잘 해놓는다면, jsp로만 할때 보다 더욱 수월해질 것 같다.
하지만 매번 설정 파일 관리하는게 여간 귀찮은 일이 아니다.
그래서 여기서 한 단계 더 업그레이드(?)된 spring boot를 나중에 배워 볼 생각이다.