Be fully awake if you want to dream

package step1;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;

public class TestJdbc1 {
    public static void main(String[] args) {
        String driver = "oracle.jdbc.driver.OracleDriver";        // 1
        String url = "jdbc:oracle:thin:@127.0.0.1:1521:xe";        // 2
        String user = "pm";
        String pass = "oracle";
        try {
            // 1.
            Class.forName(driver);
            System.out.println("1. driver loading");
            // 2.
            Connection con = DriverManager.getConnection(url, user, pass);
            System.out.println("2. Connection");
            Statement stmt = con.createStatement();
            System.out.println("3. Statement");
            String sql = "insert into member(id, password, name, address) " +
            "values('lee', 'bbb', '이영표', '종로')";
            int result = stmt.executeUpdate(sql);
            // int result 리턴값은 영향을 준 row 의 수
            System.out.println("4. Query 실행--> " + result);
            stmt.close();
            con.close();
            System.out.println("5. Close...");
        } catch (ClassNotFoundException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }

    }
}