SpringMVC05
1.new ->other ->
next...finish!
spring.application.name=SpringMVC05
# Tomcat Server Port \uc124\uc815
server.port=8089
# Context Path \uc124\uc815
server.servlet.context-path=/boot
# View Resolver 설정
spring.mvc.view.prefix=/WEB-INF/views/
spring.mvc.view.suffix=.jsp
# MySQL DataBase 설정
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
spring.datasource.url=jdbc:mysql://localhost:3306/com
spring.datasource.username=com
spring.datasource.password=com01
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
@SpringBootApplication
public class SpringMvc05Application {
// Spring Boot를 실행하는 클래스
public static void main(String[] args) {
SpringApplication.run(SpringMvc05Application.class, args);
}
}
pom.xml
src안에 main안에 webapp생성
webapp안에 WEB-INF생성
WEB-INF안에 views생성
views안에 jsp생성
Spring Boot는 mapper의 역할을 3-Tier Architecture 가 대신한다.
대충 아래와 같은식
<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<h1>BoardList Page</h1>
</body>
</html>
import java.util.List;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.GetMapping;
import com.lgdx.entity.Board;
import com.lgdx.service.BoardService;
@Controller
public class BoardController {
@Autowired
private BoardService service;
@GetMapping("/boardList.do")
public String boadList() {
List<Board> list = service.boardList();
System.out.println(list.toString());
return "boardList";
}
}
import lombok.Data;
@Data
public class Board {
private int idx;
private String title;
private String contents;
private String writer;
private int count;
private String indate;
}
import java.util.List;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import com.lgdx.entity.Board;
import com.lgdx.mapper.BoardMapper;
@Service
public class BoardService {
@Autowired
private BoardMapper mapper;
public List<Board> boardList() {
return mapper.boardList();
}
}
import java.util.List;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import com.lgdx.entity.Board;
@Mapper
public interface BoardMapper {
@Select("SELECT * FROM BOARD")
List<Board> boardList();
}
CREATE TABLE BOARD(
IDX INT NOT NULL AUTO_INCREMENT,
TITLE VARCHAR(100) NOT NULL,
CONTENTS VARCHAR(1000) NOT NULL,
WRITER VARCHAR(100) NOT NULL,
COUNT INT DEFAULT 0,
INDATE DATETIME DEFAULT NOW(),
PRIMARY KEY(IDX)
);