[spring] 댓글 0. 테이블 생성, STS 기본 생성

 

1. DB에 테이블 생성

mysql -uspringuser -pmysql

use springtest

create table comment(
cno int not null auto_increment,
bno int not null,
writer varchar(100) not null,
content text,
reg_date datetime default now(),
mod_date datetime default now(),
primary key(cno)
);

---

sql에 추가

 

---

 

2. comment 라이브러리 추가 = pom.xml에 추가

1. jackson-databind 2.13.0
2. jackson-format 2.13.0

jackson-databind 2.13.0

<!-- https://mvnrepository.com/artifact/com.fasterxml.jackson.core/jackson-databind --> <dependency> <groupId>com.fasterxml.jackson.core</groupId> <artifactId>jackson-databind</artifactId> <version>2.13.0</version> </dependency>

jackson-format 2.13.0

<!-- https://mvnrepository.com/artifact/com.fasterxml.jackson.dataformat/jackson-dataformat-xml --> <dependency> <groupId>com.fasterxml.jackson.dataformat</groupId> <artifactId>jackson-dataformat-xml</artifactId> <version>2.13.0</version> </dependency>

 

---

 

 

3. domain에 CommentVO 생성 ( class파일 )

package com.myweb.www.domain;

import lombok.AllArgsConstructor;
import lombok.Getter;
import lombok.NoArgsConstructor;
import lombok.Setter;
import lombok.ToString;

@AllArgsConstructor
@NoArgsConstructor
@ToString
@Setter
@Getter
public class CommentVO {

	private int cno;
	private int bno;
	private String writer;
	private String content;
	private String reg_date;
	private String mod_date;
	
	public CommentVO() {}
	
	
	public CommentVO(int cno, int bno, String writer, String content, String reg_date, String mod_date) {
		this.cno = cno;
		this.bno = bno;
		this.writer = writer;
		this.content = content;
		this.reg_date = reg_date;
		this.mod_date = mod_date;
	}
 }

 

---

 

4.  controller에 CommentController생성 ( class파일 )

CommetnController

package com.myweb.www.controller;

import javax.inject.Inject;

import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;

import com.myweb.www.service.CommentService;

import lombok.extern.slf4j.Slf4j;

@Slf4j
@RequestMapping("/comment/*")
@Controller
public class CommentController {

	private static final Logger log = LoggerFactory.getLogger(CommentController.class);
	
	@Inject
	private CommentService csv;
	
}

---

5.  CommentController에서 연결해서 Service ( interface파일 ), ServiceImpl ( class파일 )생성

CommentService

CommetServiceImpl

package com.myweb.www.service;

import javax.inject.Inject;

import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.stereotype.Service;

import com.myweb.www.controller.CommentController;
import com.myweb.www.repository.CommentDAO;

import lombok.extern.slf4j.Slf4j;

@Slf4j
@Service
public class CommentServiceImpl implements CommentService{
	
	private static final Logger log = LoggerFactory.getLogger(CommentServiceImpl.class);
	@Inject
	private CommentDAO cdao; 
}

---

6.  ServiceImpl에 연결해서 DAO ( interface파일 )생성

CommetDAO

 

6. CommentMapper ( xml파일 )생성

CommentMapper

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper
  PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
  "https://mybatis.org/dtd/mybatis-3-mapper.dtd">
  <mapper namespace="com.myweb.www.repository.CommentDAO">
  
  
  </mapper>

 

---