[SPRING] 로그인 및 회원 관리(등록, 수정, 삭제) 기능 예시

※ 로그인 및 회원 관리(등록, 수정, 삭제) 기능

 

[사용 테이블]

CREATE TABLE bt_login_session (
  session_id character varying(255) NOT NULL,
  user_id character varying(20) NOT NULL,
  user_ip character varying(20),
  user_agent character varying(255),
  create_date timestamp without time zone,
  expired_date timestamp without time zone
);

 

CREATE TABLE bt_sys_user_mgt (
  user_id character varying(20) NOT NULL,
  user_pwd character varying(256),
  user_name character varying(20),
  email_adr character varying(50),
  login_yn character(1),
  dept_nm character varying(50),
  tel_no character varying(50),
  last_login_dt character varying(20),
  user_pwd_modify_dt character varying(20),
  allow_ip_addr1 character varying(20),
  allow_ip_addr2 character varying(20),
  login_fail_cnt numeric DEFAULT 0,
  CONSTRAINT bt_sys_user_mgt_pkey PRIMARY KEY (user_id)
);

 

실행 예시

 

 

프로젝트 압축 파일(Spring Project)

member.zip

0.65MB