JAVA/Spring
[ Spring / JAVA ] 스프링 게시판 만들기 (1)
menus
2024. 1. 28. 15:36
728x90
안녕하세요 (●ˇ∀ˇ●)
이번 글에서는 spring을 이용해 간단한 게시판을 만들겠습니다.
spring 환경 설정이 필요하신 분들은 지난 글을 참고해주시면 감사하겠습니다.
[Spring/JAVA] 이클립스에서 Spring 환경 설정하기
안녕하세요 ! (●'◡'●) 오늘은 Spring을 배우기 위해 이클립스에서 작업 환경을 세팅해보도록 하겠습니다 . 제 작업 환경은 다음과 같습니다. jdk 11 tomcat 9.0 eclipse 2021-3 이클립스 2021-3버전을 깔아
preparingforme-n-us.tistory.com
작업환경은 다음과 같습니다.
jdk 11
tomcat 9.0
eclipse 2021-3
oracle
다음과 같은 기능이 포함한 게시판을 만드려고합니다.
- 로그인 / 회원가입
- 게시물 목록 / 디테일 / 등록 / 수정 / 삭제
- 댓글 등록
우선 spring 프로젝트를 생성해줍니다.
src/main/java에 controller, model.dao, model.dto, service를 만들어줍니다.
src/main/resources에 mapper 폴더를 만들어줍니다. mapper에는 Mapper.xml 을 만들어서 sql문을 작성할 것입니다.
src/main/webapp/views 에는 board와 member 폴더를 만들어줍니다. 이후에 jsp로 페이지를 작업할 공간입니다.
spring, mybatis, oracle 등을 쓰기 위해서 pom.xml에 dependency를 추가하는 작업을 거쳐야합니다.
다음은 제가 작성해둔 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.spring</groupId>
<artifactId>board</artifactId>
<name>Board</name>
<packaging>war</packaging>
<version>1.0.0-BUILD-SNAPSHOT</version>
<properties>
<java-version>1.6</java-version>
<org.springframework-version>3.1.1.RELEASE</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>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-aop</artifactId>
<version>${org.springframework-version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-tx</artifactId>
<version>${org.springframework-version}</version>
</dependency>
<!-- AOP Library -->
<!-- https://mvnrepository.com/artifact... -->
<dependency>
<groupId>org.aspectj</groupId>
<artifactId>aspectjweaver</artifactId>
<version>1.8.1</version>
</dependency>
<!-- mybatis를 쓰기위해서 -->
<!-- https://mvnrepository.com/artifact/org.mybatis/mybatis -->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>3.5.8</version>
</dependency>
<!-- mybatis를 spring에서 읽기위해서 -->
<!-- https://mvnrepository.com/artifact/org.mybatis/mybatis-spring -->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis-spring</artifactId>
<version>3.0.0</version>
</dependency>
<!-- https://mvnrepository.com/artifact/org.springframework/spring-jdbc -->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-jdbc</artifactId>
<version>5.3.26</version>
</dependency>
<!-- https://mvnrepository.com/artifact/commons-dbcp/commons-dbcp -->
<dependency>
<groupId>commons-dbcp</groupId>
<artifactId>commons-dbcp</artifactId>
<version>1.4</version>
</dependency>
<!-- 자신이 사용하고 있는 오라클 버전 -->
<!-- https://mvnrepository.com/artifact/com.oracle.database.jdbc/ojdbc6 -->
<dependency>
<groupId>com.oracle.database.jdbc</groupId>
<artifactId>ojdbc6</artifactId>
<version>11.2.0.4</version>
</dependency>
<!-- json 을 사용하기 위한 용도 -->
<!-- https://mvnrepository.com/artifact/com.fasterxml.jackson.core/jackson-databind -->
<dependency>
<groupId>com.fasterxml.jackson.core</groupId>
<artifactId>jackson-databind</artifactId>
<version>2.9.0</version>
</dependency>
<!-- https://mvnrepository.com/artifact/org.codehaus.jackson/jackson-mapper-asl -->
<dependency>
<groupId>org.codehaus.jackson</groupId>
<artifactId>jackson-mapper-asl</artifactId>
<version>1.9.13</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>
</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>1.6</source>
<target>1.6</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>
이제 src/main/webapp/WEB-INF/spring 의 root-contex.xml에서 oracle과 연결해주도록 하겠습니다.
<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
<property name="driverClassName" value="oracle.jdbc.driver.OracleDriver" />
<property name="url" value="jdbc:oracle:thin:@localhost:1521:orcl" />
<property name="username" value="hr" />
<property name="password" value="본인의 비밀번호" />
</bean>
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<property name="dataSource" ref="dataSource" />
<property name="configLocation" value="classpath:mybatis-config.xml" />
<property name="mapperLocations" value="classpath:mapper/*Mapper.xml" />
</bean>
<bean id="sqlSession" class="org.mybatis.spring.SqlSessionTemplate">
<constructor-arg name="sqlSessionFactory" ref="sqlSessionFactory" />
</bean>
이렇게 bean을 설정해주셨으면 mybatis-config.xml을 만들어줄건데
src/main/resources에 만들어준 뒤 다음과 같이 작성해줍니다.
<?xml version="1.0" encoding="UTF-8"?>
<!-- MyBatis 환경설정 -->
<!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
<!-- DB는 보통 snake_case인데 그걸 CamelCase로 바꿔준다 -->
<settings>
<setting name="mapUnderscoreToCamelCase" value="true" />
</settings>
<!-- 객체의 위치 -->
<typeAliases>
<package name="com.spring.board.model.dto" />
</typeAliases>
</configuration>
DAO와 DTO를 만들어주기 전에 Oracle에서 테이블을 만들어주도록 하겠습니다.
만들어야 할 테이블은 다음과 같습니다.
- 회원 테이블 ( 아이디, 비밀번호, 이름 )
- 게시글 테이블 ( 글 번호, 작성자 아이디, 작성자 이름, 글 제목, 글 내용, 작성 일자 )
- 댓글 테이블 ( 댓글 번호, 댓글 내용, 댓글 작성자, 해당 게시글 번호 )
위에 정리된 내용에 따라 다음과 같이 SQL문을 작성했습니다.
CREATE TABLE BOARD_MEMBER (
ID VARCHAR2(20) NOT NULL,
PW VARCHAR2(20) NOT NULL,
NAME VARCHAR2(20) NOT NULL
);
CREATE TABLE SPRING_BOARD (
NUM NUMBER(20, 0) NOT NULL,
ID VARCHAR2(20) NOT NULL,
NAME VARCHAR2(20) NOT NULL,
TITLE VARCHAR2(20) NOT NULL,
CONTENT VARCHAR2(100) NOT NULL,
CURRENT_DATE DATE
);
CREATE TABLE SPRING_REPLY (
REPLY_NUM VARCHAR2(20) NOT NULL,
REPLY_CONTENT VARCHAR2(100) NOT NULL,
REPLY_WRITER VARCHAR2(50),
BOARD_NUM NUMBER(20,0)
CONSTRAINT PK_REPLY_NUM PRIMARY KEY(REPLY_NUM)
);
이제 DAO를 작성하고 DAO와 연결되는 Mapper.xml에서 SQL쿼리문을 작성해준 다음 DTO까지 만들도록 하겠습니다.
코드를 작성하기 전에 !!
사용자가 요청하게 될 것들을 정리해두고 DAO와 DTO에 대해서도 간단히 짚고 넘어가도록 하겠습니다.
사용자 요청 사항
- 로그인, 회원가입
- 관리자 모드 - 회원 조회 ( 목록 조회 & 세부사항 ), 회원 삭제
- 글 작성, 삭제, 수정, 조회 ( 목록 조회 & 세부사항 )
- 댓글 작성
DAO란?
DAO(Data Access Object) 는 데이터베이스에 접근하는 역할을 하는 객체입니다.
비즈니스 로직을 분리해서 도메인 로직으로부터 데이터베이스와 관련된 매커니즘을 숨길 수 있습니다.
DTO란?
DTO(Data Transfer Object) 는 데이터를 전달해주는 객체입니다.
getter와 setter를 가지며 다른 비즈니스 로직은 가지고있지 않습니다.
DAO는 인터페이스 MemberDao와 MemberDaoImpl의 형태로 나눠서 작업하도록 하겠습니다.
MemberDao.java
package com.spring.board.model.dao;
import java.util.List;
import com.spring.board.model.dto.MemberDto;
public interface MemberDao {
void signup(MemberDto memberDto);
int delete(String id);
MemberDto login(String id, String pw);
MemberDto getMember(String id);
List<MemberDto> getAllMembers();
}
DaoImpl에서 SqlSession을 사용해줬는데 SqlSession의 메소드는 select, insert, update, delete, selectOne, selectList, selectMap이 있습니다.
MemberDao에서 signup과 같은 경우는 회원 가입 = 회원 생성 이므로 insert를 사용해주면 되겠습니다.
namespace라는 것도 설정해줘야하는데 이는 Mapper.xml의 namespace와 동일하게 맞춰주면 됩니다.
MemberDaoImpl.java
package com.spring.board.model.dao;
import java.util.List;
import org.apache.ibatis.session.SqlSession;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Repository;
import com.spring.board.model.dto.MemberDto;
@Repository
public class MemberDaoImpl implements MemberDao {
@Autowired
private SqlSession sqlSession;
private final static String NAMESPACE="memberMapper.";
@Override
public void signup(MemberDto memberDto) {
sqlSession.insert(NAMESPACE + "signup", memberDto);
}
@Override
public int delete(String id) {
return sqlSession.delete(NAMESPACE + "delete", id);
}
@Override
public MemberDto login(String id, String pw) {
MemberDto memberDto = new MemberDto();
memberDto.setId(id);
memberDto.setPw(pw);
return sqlSession.selectOne(NAMESPACE+"login", memberDto);
}
@Override
public MemberDto getMember(String id) {
return sqlSession.selectOne(NAMESPACE+"getMember", id);
}
@Override
public List<MemberDto> getAllMembers() {
return sqlSession.selectList(NAMESPACE+"getAllMembers");
}
}
BoardDao.java
package com.spring.board.model.dao;
import java.util.List;
import com.spring.board.model.dto.BoardDto;
public interface BoardDao {
BoardDto detail(int num);
List<BoardDto> findAll();
List<BoardDto> findSearch(String name);
int delete(int num);
int update(BoardDto boardDto);
BoardDto modify(int num);
int write(BoardDto boardDto);
}
BoardDaoImpl.java
package com.spring.board.model.dao;
import java.util.List;
import org.apache.ibatis.session.SqlSession;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Repository;
import com.spring.board.model.dto.BoardDto;
@Repository
public class BoardDaoImpl implements BoardDao{
@Autowired
private SqlSession sqlSession;
private final static String NAMESPACE="boardMapper.";
@Override
public int write(BoardDto boardDto) {
return sqlSession.insert(NAMESPACE + "write", boardDto);
}
@Override
public List<BoardDto> findAll() {
// TODO Auto-generated method stub
return sqlSession.selectList(NAMESPACE+"findAll");
}
@Override
public List<BoardDto> findSearch(String name) {
// TODO Auto-generated method stub
return sqlSession.selectList(NAMESPACE + "findSearch", name);
}
@Override
public int delete(int num) {
// TODO Auto-generated method stub
return sqlSession.delete(NAMESPACE + "delete", num);
}
@Override
public int update(BoardDto boardDto) {
// TODO Auto-generated method stub
return sqlSession.update(NAMESPACE + "update", boardDto);
}
@Override
public BoardDto modify(int num) {
// TODO Auto-generated method stub
return sqlSession.selectOne(NAMESPACE + "modify", num);
}
@Override
public BoardDto detail(int num) {
return sqlSession.selectOne(NAMESPACE+"detail", num);
}
}
ReplyDao.java
package com.spring.board.model.dao;
import java.util.List;
import com.spring.board.model.dto.ReplyDto;
public interface ReplyDao {
int write(ReplyDto replyDto);
List<ReplyDto> findSearch(int boardNum);
}
ReplyDaoImpl.java
package com.spring.board.model.dao;
import java.util.List;
import org.apache.ibatis.session.SqlSession;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Repository;
import com.spring.board.model.dto.ReplyDto;
@Repository
public class ReplyDaoImpl implements ReplyDao {
@Autowired
private SqlSession sqlSession;
private final static String NAMESPACE="replyMapper.";
@Override
public int write(ReplyDto replyDto) {
return sqlSession.insert(NAMESPACE + "write", replyDto);
}
@Override
public List<ReplyDto> findSearch(int boardNum) {
// TODO Auto-generated method stub
return sqlSession.selectList(NAMESPACE + "findSearch", boardNum);
}
}
DAO가 작성되었으니 Mapper.xml에서 SQL문을 작성해보겠습니다.
src/main/resources/mapper 에서 작업해주세요 !
DaoImpl에서 작성한 namepace에 유의해주시면서 오타가 발생하지 않도록 작업해주세요 !
MemberMapper.xml
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTO Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="memberMapper">
<insert id="signup" parameterType="com.spring.board.model.dto.MemberDto">
INSERT INTO BOARD_MEMBER(ID, PW, NAME)
VALUES (#{id}, #{pw}, #{name})
</insert>
<select id="login" parameterType="com.spring.board.model.dto.MemberDto" resultType="com.spring.board.model.dto.MemberDto">
SELECT ID, PW, NAME FROM BOARD_MEMBER
WHERE ID = #{id} AND PW = #{pw}
</select>
<delete id="delete" parameterType="string">
DELETE FROM BOARD_MEMBER
WHERE ID = #{id}
</delete>
<select id="getMember" parameterType="string" resultType="com.spring.board.model.dto.MemberDto">
SELECT * FROM BOARD_MEMBER WHERE id = #{id}
</select>
<select id="getAllMembers" parameterType="string" resultType="com.spring.board.model.dto.MemberDto">
SELECT * FROM BOARD_MEMBER
</select>
</mapper>
BoardMapper.xml
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTO Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="boardMapper">
<insert id="write" parameterType="com.spring.board.model.dto.BoardDto">
INSERT INTO SPRING_BOARD (NUM, ID, NAME, TITLE, CONTENT, CURRENT_DATE)
VALUES (#{num, jdbcType=INTEGER}, #{id, jdbcType=VARCHAR}, #{name, jdbcType=VARCHAR}, #{title, jdbcType=VARCHAR}, #{content, jdbcType=VARCHAR}, TO_TIMESTAMP(#{currentDate, jdbcType=TIMESTAMP}, 'YYYY-MM-DD HH24:MI:SS.FF'))
</insert>
<select id="findAll"
resultType="com.spring.board.model.dto.BoardDto">
SELECT NUM, ID, NAME, TITLE, CONTENT, CURRENT_DATE
FROM
SPRING_BOARD
</select>
<update id="update" parameterType="BoardDto">
UPDATE SPRING_BOARD
SET TITLE = #{title} , CONTENT = #{content}
WHERE NUM = #{num}
</update>
<select id="modify" parameterType="BoardDto" resultType="BoardDto">
SELECT ID, NAME, TITLE, CONTENT, CURRENT_DATE
FROM SPRING_BOARD
WHERE NUM = #{num}
</select>
<delete id="delete" parameterType="int">
DELETE FROM SPRING_BOARD
WHERE NUM = #{num}
</delete>
<select id="findSearch" parameterType="string" resultType="BoardDto">
SELECT NUM, ID, NAME, TITLE, CONTENT, CURRENT_DATE
FROM SPRING_BOARD
WHERE NAME = #{name}
</select>
<select id="detail" parameterType="int"
resultType="com.spring.board.model.dto.BoardDto">
SELECT NUM, ID, NAME, TITLE, CONTENT, CURRENT_DATE
FROM
SPRING_BOARD
WHERE NUM= #{num}
</select>
</mapper>
ReplyMapper.xml
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTO Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="replyMapper">
<insert id="write" parameterType="com.spring.board.model.dto.ReplyDto">
INSERT INTO SPRING_REPLY (REPLY_NUM, REPLY_CONTENT, REPLY_WRITER, BOARD_NUM)
VALUES (#{replyNum, jdbcType=VARCHAR}, #{replyContent, jdbcType=VARCHAR}, #{replyWriter, jdbcType=VARCHAR}, #{boardNum, jdbcType=INTEGER})
</insert>
<select id="findSearch" parameterType="int" resultType="com.spring.board.model.dto.ReplyDto">
SELECT REPLY_NUM, REPLY_CONTENT, REPLY_WRITER, BOARD_NUM
FROM SPRING_REPLY
WHERE BOARD_NUM= #{boardNum}
</select>
</mapper>
자, 이제 dto를 작성해볼까요?
MemberDto.java
package com.spring.board.model.dto;
public class MemberDto {
private String id;
private String pw;
private String name;
public String getId() {
return id;
}
public void setId(String id) {
this.id = id;
}
public String getPw() {
return pw;
}
public void setPw(String pw) {
this.pw = pw;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
}
BoardDto.java
package com.spring.board.model.dao;
import java.util.List;
import com.spring.board.model.dto.BoardDto;
public interface BoardDao {
BoardDto detail(int num);
List<BoardDto> findAll();
List<BoardDto> findSearch(String name);
int delete(int num);
int update(BoardDto boardDto);
BoardDto modify(int num);
int write(BoardDto boardDto);
}
ReplyDto.java
package com.spring.board.model.dto;
public class ReplyDto {
private String replyNum;
private String replyContent;
private String replyWriter;
private int boardNum;
public String getReplyNum() {
return replyNum;
}
public void setReplyNum(String replyNum) {
this.replyNum = replyNum;
}
public String getReplyContent() {
return replyContent;
}
public void setReplyContent(String replyContent) {
this.replyContent = replyContent;
}
public String getReplyWriter() {
return replyWriter;
}
public void setReplyWriter(String replyWriter) {
this.replyWriter = replyWriter;
}
public int getBoardNum() {
return boardNum;
}
public void setBoardNum(int boardNum) {
this.boardNum = boardNum;
}
}
이번 글에서는 여기까지하고 다음 글에 이어서 Controller로 요청을 받고 DAO를 통해 데이터에 접근하는 코드를 작업하도록 하겠습니다 !
감사합니다.
