jdbc3 JDBC Oracle DB연동 및 해제 클래스 만들기 / 사용하기 //오라클 DB 연동되는 클래스와 메소드 package kr.ac.jnu.util; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.SQLException; public class ConnectionFactory { public Connection getConnection(){ Connection conn = null; try { Class.forName("oracle.jdbc.driver.OracleDriver"); String url = "jdbc:oracle:thin:@localhost:1521:xe"; String user = "hr"; String .. 2015. 11. 25. JDBC Oracle 연동하기 [PreparedStatement] package kr.ac.kr.jnu.jdbc; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.util.Scanner; /* CREATE TABLE t_test ( idvarchar2(20) primary key, name varchar2(40) not null ); */ public class InsertMain03 { public static void main(String[] args) { Scanner sc = new Scanner(System.in); Connection conn = null; PreparedStatement pstmt = null; try.. 2015. 11. 25. JDBC Oracle 연동하기 [Statement] package kr.ac.kr.jnu.jdbc; import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException; import java.sql.Statement; /* CREATE TABLE t_test ( idvarchar2(20) primary key, name varchar2(40) not null ); */ public class InsertMain01 { public static void main(String[] args) { Connection conn = null; Statement stmt = null; // 1단계 : 드라이버 로딩 ... try { Class.forName("oracle.jdbc.. 2015. 11. 25. 이전 1 다음