1. SecurityConfig 클래스 config라는 패키지를 만들고 스프링시큐리티를 설정을 처리할 SecurityConfig 클래스 rememberMe(): 자동로그인 기능 formLogin: 로그인처리 authorizeRequests: 접권한 처리 PasswordEncoder passwordEncoder(): 비밀번호를 그대로 저장하지 않고 BCryptPasswordEncoder의 해시 함수를 이용하여 암호화처리 package com.example.moduleclient.config; import com.example.moduleclient.member.MemberService; import lombok.RequiredArgsConstructor; import lombok.extern.log4j.L..
outplayer package dao; import model.OutPlayer; import java.sql.*; import java.util.ArrayList; import java.util.List; public class OutPlayerDAO { //선수 퇴출 등록, 선수 퇴출 목록 private Connection connection; public OutPlayerDAO(Connection connection){ this.connection =connection; } //톼출 선수 등록 public void registerOutPlayer(int playerId, String reason, Timestamp createdAt ) throws SQLException{ String query ..
player 모델 @ToString @Getter public class Player { private int id; //PK @ManyToOne @JoinColumn(name="team_id") private Team team; //FK private String name; private String position; private Timestamp createdAt; @Builder public Player(int id, Team team, String name, String position, Timestamp createdAt) { this.id = id; this.team = team; this.name = name; this.position = position; this.createdAt = c..
stadium 3개 insert into stadium(name, created_at) values('잠실' , now()); insert into stadium(name, created_at) values('기아챔피언스필드' , now()); insert into stadium(name, created_at) values('서울종합운동장' , now()); team 3팀 insert into team(stadium_id, name,created_at) values(1, '한화이글스', now()); insert into team(stadium_id, name, created_at) values(2, '두산베어스', now()); insert into team(stadium_id, name, create..
미니프로젝트 1 - 야구 관리 프로그램.pdf - Google Drive 미니프로젝트 1 - 야구 관리 프로그램.pdf drive.google.com 야구장 테이블(3개) create table stadium ( id integer primary key auto_increment, name varchar(255), created_at timestamp ); 팀 테이블(3팀) create table team ( id integer primary key auto_increment, stadium_id integer, name varchar(255), created_at timestamp, foreign key (stadium_id) references stadium(id) ); 선수 테이블(9명) creat..
