10/05 oracle jdbc 기초

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

public class JDBC01 {

	public static void main(String[] args) {
		try {
			//oracle jdbc드라이버 로드
			Class.forName("oracle.jdbc.driver.OracleDriver");// jdbc driver load
			//Connection
			Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:myoracle","ora_user","hong");// 연결
			System.out.println("연결완료");
			
			//Statement객체 생성
			Statement stmt=conn.createStatement();
			
			//insert
			//stmt.executeUpdate("insert into student2 values('K202001','왕건','국문학과')");
			//update
			//stmt.executeUpdate("update student2 set name='홍길돈' where id='E202001'");
			//delete
			stmt.executeUpdate("delete from student2 where id='K202001'");
			
			ResultSet rs=stmt.executeQuery("select * from student2");
			while(rs.next()) {
				System.out.println(rs.getString("id"));
				System.out.println(rs.getString("name"));
				System.out.println(rs.getString("dept"));
			}
			rs.close();
			stmt.close();
			conn.close();
			
		}catch(Exception e) {
			e.printStackTrace();
		}

	}

}