LeeBG/blog

JSP 블로그 프로젝트

환경

• Windows
• jdk version 1.8
• Tomcat9.0
• sts tool
• Database : mySQL 8.0
• Postman
• lombok.jar
• gson (json파싱)
• Encoding : UTF-8
• github

MySQL 데이터 베이스 생성 및 사용자 생성

create user 'bloguser'@'%' identified by 'bitc5600';
GRANT ALL PRIVILEGES ON *.* TO 'bloguser'@'%';
create database blog;

• bloguser 사용자로 접속
• use blog; 데이터 베이스 선택

MySQL 데이터 베이스 테이블 생성

use blog;

CREATE TABLE user(
    id int primary key auto_increment,
    username varchar(100) not null unique,
    password varchar(100) not null,
    email varchar(100) not null,
    address varchar(100),
    userRole varchar(20),
    createDate timestamp
) engine=InnoDB default charset=utf8;

CREATE TABLE board(
    id int primary key auto_increment,
    userId int,
    title varchar(100) not null,
    content longtext,
    readCount int default 0,
    createDate timestamp,
    foreign key (userId) references user (id)
) engine=InnoDB default charset=utf8;

CREATE TABLE reply(
    id int primary key auto_increment,
    userId int,
    boardId int,
    content varchar(300) not null,
    createDate timestamp,
    foreign key (userId) references user (id) on delete set null,
    foreign key (boardId) references board (id) on delete cascade
) engine=InnoDB default charset=utf8;