DBMS : 자바와 오라클 연동

JDBC (JAVA DATABASE CONNECTOR)

JSP

JDBC

CONNECTION

STATEMENT

RESULT SET

JDBC DRIVER

Libraries ->복잡하고 어려운 과정들을 쉽게 처리하기 위한 도구(module)

(jar,짜르)

oracle11이면 ojdbc6.jar  ==> oracle10이면 ojdbc14.jar(실무)

package net.gondor;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

public class Oracle {

public static void main(String[] args) {

try {

Class.forName("oracle.jdbc.driver.OracleDriver");

} catch (ClassNotFoundException e1) {

// TODO Auto-generated catch block

e1.printStackTrace();

}

Connection conn = null;

PreparedStatement stmt = null;

ResultSet rs = null;

try

{

String query = "SELECT EMPLOYEE_ID, FIRST_NAME || ' ' || LAST_NAME AS NAME, PHONE_NUMBER, HIRE_DATE FROM EMPLOYEES";

conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:XE", "HR", "hr");

stmt = conn.prepareStatement(query);

rs = stmt.executeQuery();

while (rs.next()) {

System.out.println(rs.getString("EMPLOYEE_ID"));

System.out.println(rs.getString("NAME"));

System.out.println(rs.getString("PHONE_NUMBER"));

System.out.println(rs.getString("HIRE_DATE"));

}

}catch(

SQLException se)

{

se.printStackTrace();

}finally

{

if (rs != null) {

try {

rs.close();

} catch (SQLException e) {

}

}

if (stmt != null) {

try {

stmt.close();

} catch (SQLException e) {

}

}

if (conn != null) {

try {

conn.close();

} catch (SQLException e) {

}

}

}

}

}

[출처] JDBC 코드 (HuCloud) |작성자 장민창 강사