JAVA
JDBC Util
yn98
2024. 7. 31. 08:56
package model;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
public class JDBCUtil {
private static final String driverName="oracle.jdbc.driver.OracleDriver";
private static final String url="jdbc:oracle:thin:@localhost:1521:xe";
private static final String userName="YENA"; // 내 아이디
private static final String password="1234"; // 내 비밀번호
public static Connection connect() {
Connection conn=null;
// 1 드라이버 로드
try {
Class.forName(driverName);
} catch (ClassNotFoundException e) {
System.out.println("드라이버 로드 실패");
}
// 2 conn 연결 확보
try {
conn=DriverManager.getConnection(url, userName, password);
} catch (SQLException e) {
System.out.println("conn 연결 실패");
}
return conn;
}
public static void disconnect(Connection conn,PreparedStatement pstmt) {
// 4 연결 해제
try {
pstmt.close();
conn.close();
} catch (SQLException e) {
System.out.println("연결 해제 실패");
}
}
}