알고보면코딩천재

select는 get인데 login만 예외로 post이다 1.font/enc 설정 2.file import해서 세팅환경 다운받기 blog 폴더에 생성 3. Boards 생성 4. interface BoardsDao 만들기 --- 5. BoardsContrller ---@Controller 6. UsersController ---@Controller @ResponseBody 데이터 찾게끔 해준다 session 회원가입과 로그인 joinForm.jsp 회원가입 form태그는 / x-www-머시기 UsersController package site.metacoding.red.web; import org.springframework.stereotype.Controller; import org.springfram..

1. BoardUser 만들기 -boards.xml INNER JOIN 쿼리문 작성 -> select 값 고르지 말고 일단 다 적어준다 SELECT b.id, b.title, b.content, b.usersId, b.createdAt, u.username, u.password, u.email FROM boards b INNER JOIN users u ON b.usersId = u.id WHERE b.id = #{id} DELETE FROM boards WHERE id =#{id} UPDATE boards SET title = #{title}, content = #{content} WHERE id = #{id} INSERT INTO boards(id, title, content, usersId, crea..

데이터베이스 타입 젤 큰거 오라클에서 4기가 저장할 수 있음 CLOB (겁나 큰 문자열 저장시에 사용) drop table users; drop SEQUENCE users_seq; drop table boards; drop SEQUENCE boards_seq; drop table comments; create table users( id number primary key, username varchar2(20) UNIQUE, password varchar2(20), email varchar2(50), createdAt TIMESTAMP ); CREATE SEQUENCE users_seq INCREMENT BY 1 START WITH 1; create table boards( id number primar..

회사마다의 규칙-컨벤션 도메인이름/액션의이름/ insert만들기 package site.metacoding.red.web.dto.request.users; import lombok.Getter; import lombok.Setter; @Setter @Getter public class JoinDto { private String username; private String password; private String email; // 받을 것만 적기 } package site.metacoding.red.web; import java.util.List; import org.springframework.http.HttpStatus; import org.springframework.http.ResponseEn..

아래 코드 복사해서 데이터 넣기 create table users( id number primary key, username varchar2(20), password varchar2(20), email varchar2(50), createdAt TIMESTAMP ); CREATE SEQUENCE users_seq INCREMENT BY 1 START WITH 1; insert into users(id, username, password, email, createdAt) values(users_seq.nextval, 'ssar', '1234', 'ssar@nate.com', sysdate); insert into users(id, username, password, email, createdAt) valu..

DB연결 설정파일 위에는 @Configuration

모델에 데이터를 담아서 뿌리기 index.jsp까지 세팅후 1. Board클래스 만들기 package site.metacoding.yellow.damain; import lombok.AllArgsConstructor; import lombok.Getter; import lombok.NoArgsConstructor; import lombok.Setter; @NoArgsConstructor @AllArgsConstructor @Setter @Getter public class Board { private Integer id; private String title; private String content; } 2. BoardController만들기 package site.metacoding.yellow.we..