JX405기_비트/Java
Day05-3 Connection을 이용한 db연결 만들기
_하루살이_
2023. 1. 16. 16:23

dbConn 패키지에 ConnectionMaker 인터페이스 생성
package dbConn;
import java.sql.Connection;
// Connection 자바가 제공하는 데이터베이스와 연결하는 통신을 객체화한 것
// 컴퓨터와 데이터베이스의 연결 담당 메소드 모음
public interface ConnectionMaker {
public Connection makeConnection();
}

MySqlConnectionMaker 자식 클래스 생성
package dbConn;
import java.sql.Connection;
public class MySqlConnectioMaker implements ConnectionMaker{
private final String ADDRESS = "192.168.0.1";
private final String USERNAME = "admin";
private final String PASSWORD = "1111";
@Override
public Connection makeConnection() {
System.out.println("MySQL 데이터베이스 연결 시도");
System.out.println("연결 주소 : " + ADDRESS);
System.out.println("아이디 : " + USERNAME);
System.out.println("비밀번호 : " + PASSWORD);
System.out.println("연결 성공");
return null;
}
}
package day0113;
import dbConn.ConnectionMaker;
import dbConn.MySqlConnectioMaker;
import java.sql.Connection;
public class Ex02Controller {
public static void main(String[] args) {
ConnectionMaker maker = new MySqlConnectioMaker();
Connection connection = maker.makeConnection();
}
}
OracleConnectionMaker 자식 클래스 생성

package dbConn;
import java.sql.Connection;
public class OracleConnectionMaker implements ConnectionMaker{
private final String ADDRESS = "192.168.0.2";
private final String USERNAME = "ADMIN";
private final String PASSWORD = "1234";
@Override
public Connection makeConnection() {
System.out.println("오라클 데이터 베이스 연결 시도");
System.out.println("오라클 주소: " + ADDRESS);
System.out.println("오라클 아이디: " + USERNAME);
System.out.println("오라클 비밀번호: " + PASSWORD);
System.out.println("연결 성공");
return null;
}
}
package day0113;
import dbConn.ConnectionMaker;
import dbConn.MySqlConnectioMaker;
import java.sql.Connection;
public class Ex02Controller {
public static void main(String[] args) {
ConnectionMaker maker = new OracleConnectionMaker();
Connection connection = maker.makeConnection();
}
}