DB 설계 & 데이터 모델링

DB 설계

LE 데이터베이스 > User 테이블

CREATE DATABASE LE;
USE LE;
CREATE TABLE LE (
userID varchar(20) PRIMARY KEY,
userPassword varchar(64),
userEmail varchar(50),
userEmailHash varchar(64),
userEmailChecked boolean,
);
DESC USER;

 

LE 데이터베이스 > EVALUATION 테이블

CREATE TABLE EVALUATION (
evaluationID int PRIMARY KEY AUTO_INCREMENT,
userID varchar(20),
lectureName varchar(50),
professorName varchar(20),
lectureYear int,
semesterDivide varchar(20),
lectureDivide varchar(10),
evaluationTitle varchar(50),
evaluationContent varchar(2048),
totalScore varchar(5),
creditScore varchar(5),
comfortableScore varchar(5),
lectureScore varchar(5),
likeCount int
);
DESC EVALUATION;

 

LE 데이터베이스 > LIKEY 테이블

CREATE TABLE LIKEY (
userID varchar(20),
evaluationID int,
userIP varchar(50)
);
DESC LIKEY;

 

DB 연동

Java Resource 폴더 > util 패키지 생성 > DatabaseUtil 클래스 생성

#DatabaseUtil.java 파일

package util;

import java.sql.Connection;
import java.sql.DriverManager;

public class DatabaseUtil {
	
	public static Connection getConnection() {
		try {
			String dbURL = "jdbc:mysql://localhost:3306/LE";
			String dbID = "root";
			String dbPassword = "Abcd123@";
			Class.forName("com.mysql.cj.jdbc.Driver");
			return DriverManager.getConnection(dbURL, dbID, dbPassword);
		} catch (Exception e) {
			e.printStackTrace();
		}
		return null;
	}

}