[JSP][동빈나] JSP 게시판 만들기 강좌 9강 - 게시판 데이터베이스 구축하기 (JSP Advanced Development Tutorial #9)

[JSP][동빈나] JSP 게시판 만들기 강좌 9강 - 게시판 데이터베이스 구축하기 (JSP Advanced Development Tutorial #9)

use bbs;
 
create table bbs(
    bbsID int,
    bbsTitle varchar(50),
    userID varchar(20),
    bbsDate DATETIME,
    bbsContent varchar(2048),
    bbsAvailable int, -- 0인경우에는 삭제가된것, 0이아닌경우에는 삭제가 되지않은것
    PRIMARY KEY (bbsID)
);

package bbs;
 
public class Bbs {
    private int bbsID;
    private String bbsTitle;
    private String userID;
    private String bbsDate;
    private String bbsContent;
    private int bbsAvailable;
    
    public int getBbsID() {
        return bbsID;
    }
    public void setBbsID(int bbsID) {
        this.bbsID = bbsID;
    }
    public String getBbsTitle() {
        return bbsTitle;
    }
    public void setBbsTitle(String bbsTitle) {
        this.bbsTitle = bbsTitle;
    }
    public String getUserID() {
        return userID;
    }
    public void setUserID(String userID) {
        this.userID = userID;
    }
    public String getBbsDate() {
        return bbsDate;
    }
    public void setBbsDate(String bbsDate) {
        this.bbsDate = bbsDate;
    }
    public String getBbsContent() {
        return bbsContent;
    }
    public void setBbsContent(String bbsContent) {
        this.bbsContent = bbsContent;
    }
    public int getBbsAvailable() {
        return bbsAvailable;
    }
    public void setBbsAvailable(int bbsAvailable) {
        this.bbsAvailable = bbsAvailable;
    }
 
}