- 컨트롤러 : 서비스를 의존
MemberService 객체가 생성돼야 작업을 할 수 있으므로 하나의 컨트롤러가 여러 서비스를 의존할 수 있음. 이경우 각각의 객체를 생성해줘야 한다.- 서비스 : CRUD 작업 -> 레퍼지토리를 의존한다.
MemberRepository 객체가 생성돼야 작업을 할 수 있으므로- 레퍼지토리
Oracle을 쓰다가 고객사에서 MySQL의 요구가 들어오면 바꿔줘야함.
레퍼지토리를 수정할 경우 서비스 영역에서 레포지토리 영역을 의존하기 때문에 서비스의 코드 수정도 일부 이루어져야함.
package com.codingbox.core2.controller;
import java.util.List;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.PostMapping;
import com.codingbox.core2.dto.Member;
import com.codingbox.core2.dto.MemberForm;
import com.codingbox.core2.service.MemberService;
@Controller
public class MemberController {
// 'Controller가 Service에 의존한다.'라고 표현
// MemberService mService = new MemberService();
// Sercive는 여러 Controller에서 가져다 쓸 수 있기 때문에
// Spring Container에 등록을 해야한다.
// 스프링스럽게 작업하기 - 의존성 주입(DI), 무조건 이 방법으로 사용해야 한다.
// 다른 Bean이 할당되지 못하도록 private final로 잠그는 것
private final MemberService memberService;
// service에 오류가 생기면 서버 기동조차 안되게 파라미터로 넣어줌
// @Autowired를 통해 스프링이 알아서 제어하도록 함
@Autowired
public MemberController(MemberService memberService) {
this.memberService = memberService;
}
@GetMapping(value = "/members/new") // value 는 생략 가능
public String createForm() {
return "members/createMemberForm";
}
@PostMapping("/members/new")
public String create(MemberForm form) {
Member member = new Member();
member.setName(form.getName());
memberService.join(member);
// 회원가입 후 홈 화면으로 돌린다.
return "redirect:/"; // ("/")이거로 인해 HomeController로 갔다가 home.html로 간다.home.html로 간다.
}
// /members 방식으로 getMapping이 될 것
// list(Model model), return "members/memberList"
@GetMapping("/members") // value 는 생략 가능
public String list(Model model) {
List<Member> members = memberService.findMembers(); // members를 키 값으로 담아서 memberList로 보냄
model.addAttribute("members", members);
return "members/memberList";
}
}
package com.codingbox.core2.controller;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.GetMapping;
@Controller
public class HomeController {
// 웰컴파일 -> static/index.html
// localhost:9090
@GetMapping("/") // -> 여기가 index.html보다 우선순위가 됨.
public String home() {
return "home";
}
}
package com.codingbox.core2.dto;
import jakarta.persistence.Entity;
import jakarta.persistence.GeneratedValue;
import jakarta.persistence.GenerationType;
import jakarta.persistence.Id;
import jakarta.persistence.SequenceGenerator;
@Entity // @Entity : '이거는 JPA에서 관리하는 class야' 라고 알려줌
public class Member {
@Id
@GeneratedValue(strategy = GenerationType.SEQUENCE, generator = "mySeq")
@SequenceGenerator(name = "mySeq", sequenceName = "member_seq", allocationSize = 1)
private int id;
private String name;
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
}
package com.codingbox.core2.dto;
public class MemberForm {
private String name;
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
}
package com.codingbox.core2.repository;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.List;
import javax.sql.DataSource;
import org.springframework.stereotype.Repository;
import com.codingbox.core2.dto.Member;
//@Repository
public class JdbcMemberRepository implements MemberRepository{
private final DataSource dataSource;
public JdbcMemberRepository(DataSource dataSource) {
this.dataSource = dataSource;
}
@Override
public Member save(Member member) {
String sql = "INSERT INTO MEMBER VALUES(member_seq.nextval, ?)"; // 이런 방식은 이제 잘 안쓴다.
Connection conn = null;
PreparedStatement pstmt = null;
ResultSet rs = null;
try {
conn = dataSource.getConnection();
String generatedColumns[] = {"ID"};
pstmt = conn.prepareStatement(sql, generatedColumns);
pstmt.setString(1, member.getName());
pstmt.executeUpdate();
rs = pstmt.getGeneratedKeys();
if( rs.next() ) {
member.setId(rs.getInt(1));
}
}catch(Exception e) {
e.printStackTrace();
}
return member;
}
@Override
public List<Member> findAll() {
String sql = "SELECT * FROM MEMBER";
Connection conn = null;
PreparedStatement pstm = null;
ResultSet rs = null;
List<Member> members = new ArrayList<>();
try {
conn = dataSource.getConnection();
pstm = conn.prepareStatement(sql);
rs = pstm.executeQuery();
while(rs.next()) {
Member member = new Member();
member.setId(rs.getInt("id"));
member.setName(rs.getString("name"));
members.add(member);
}
}catch( Exception e ) {
e.printStackTrace();
}
return members;
}
}
package com.codingbox.core2.repository;
import java.util.List;
import org.springframework.stereotype.Repository;
import com.codingbox.core2.dto.Member;
import jakarta.persistence.EntityManager;
@Repository
public class JpaMemberRepository implements MemberRepository{
private final EntityManager em;
public JpaMemberRepository(EntityManager em) {
this.em = em;
}
@Override
public Member save(Member member) {
em.persist(member);
return member;
}
@Override
public List<Member> findAll() {
return em.createQuery("select m from Member m", Member.class).getResultList();
}
}
package com.codingbox.core2.repository;
import java.util.List;
import com.codingbox.core2.dto.Member;
public interface MemberRepository {
// 회원 저장
Member save(Member member);
// 전체 조회
List<Member> findAll();
}
package com.codingbox.core2.repository;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import org.springframework.stereotype.Repository;
import com.codingbox.core2.dto.Member;
//@Repository
public class MemoryMemberRepository implements MemberRepository{
// 메모리 사용 -> 아직 DB가 정해지지 않아서 임시로 메모리 사용
private static Map<Integer, Member> store = new HashMap<>();
private static int sequence = 0;
// 메모리 영역에 간단하게 저장하는 방법
@Override
public Member save(Member member) {
member.setId(++sequence);
store.put(member.getId(), member);
return member;
}
// store에 있는 values를 통째로 리턴해준다.
@Override
public List<Member> findAll() {
return new ArrayList<>(store.values());
}
}
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<h1>Hello Spring</h1>
<p>회원기능</p>
<p>
<a href="/members/new">회원가입</a>
<a href="/members">회원목록</a>
</p>
</body>
</html>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<form action="/members/new" method="post">
<label>이름</label>
<input type="text" id="name" name="name" placeholder="이름을 입력하세요"/>
<button type="submit">등록</button>
</form>
</body>
</html>
<!DOCTYPE html>
<html xmlns:th="http://www.thymeleaf.org">
<head>
<meta charset="UTF-8">
<title>Insert title here</title>
</head>
<body>
<table>
<thead>
<tr>
<th>no</th>
<th>이름</th>
</tr>
</thead>
<tbody>
<!-- members 키 값으로 넣어주는데 arrylist로 반복으로 넣어줌 -->
<tr th:each="member : ${members}">
<td th:text="${member.id}"></td>
<td th:text="${member.name}"></td>
</tr>
</tbody>
</table>
</body>
</html>
#port 세팅
server.port=9090
#한글설정
server.servlet.encoding.charset=UTF-8
server.servlet.encoding.enabled=true
server.servlet.encoding.force=true
#thymleaf cache
spring.thymeleaf.cache=false
#DBMS
spring.datasource.url=jdbc:oracle:thin:@localhost:1521:XE
spring.datasource.driver-class-name=oracle.jdbc.OracleDriver
spring.datasource.username=springweb
spring.datasource.password=springweb
#JPA
spring.jpa.show-sql=true
spring.jpa.hibernate.ddl-auto=none