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 (
	 id		varchar2(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 {
			Class.forName("oracle.jdbc.driver.OracleDriver");

			String url = "jdbc:oracle:thin:@localhost:1521:xe";
			String user = "hr";
			String password = "hr";
			conn = DriverManager.getConnection(url, user, password);

			String sql = "insert into t_test(id, name) values(?,?)";
			pstmt = conn.prepareStatement(sql);

			System.out.println("아이디를 입력하세요");
			String id = sc.nextLine();
			System.out.println("이름을 입력하세요");
			String name = sc.nextLine();

			pstmt.setString(1, id);
			pstmt.setString(2, name);

			int cnt = pstmt.executeUpdate();
			System.out.println(cnt + "열 삽입 성공");

		} catch (Exception e) {
			System.out.println("연결실패");
			e.printStackTrace();

		} finally {
			sc.close();
			try {
				conn.close();
				pstmt.close();
			} catch (Exception e2) {
				e2.printStackTrace();
			}

		}

	}

}