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

public class OracleDBTest {
	public static void main(String[] args) {
		
		final String DB_URL = "jdbc:oracle:thin:@127.0.0.1:1521:XE";
		final String DB_USER = "system";
		final String DB_PASSWORD = "xxxx";
		Connection conn = null;
		Statement stmt = null;
		String sql = null;
		
		try {
			
			Class.forName("oracle.jdbc.driver.OracleDriver");
			System.out.println("드라이버 로딩 성공");
			
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		}
		
		try {
			
			conn = DriverManager.getConnection(DB_URL, DB_USER, DB_PASSWORD);
			System.out.println("접속 성공");
			
		} catch (SQLException e) {
			e.printStackTrace();
		}
		
		try {
			
			stmt = conn.createStatement();
			sql = "INSERT INTO MOVIE(moviename, movieactor, mcount) values('홍길동', '임꺽정' , 30)";
			stmt.executeUpdate(sql);
			System.out.println("추가 성공");
			
		} catch (SQLException e) {
			e.printStackTrace();
		}
		
		try {
			sql = "UPDATE MOVIE SET moviename = 'hhhh' WHERE mcount = 30";
			stmt.executeUpdate(sql);
			System.out.println("업데이트 성공");
		} catch (SQLException e) {
			e.printStackTrace();
		}
		
		try {
			sql = "DELETE FROM MOVIE WHERE mcount = 30;";
			stmt.executeUpdate(sql);
			System.out.println("업데이트 성공");
		} catch (SQLException e) {
			e.printStackTrace();
		}

		try {
			rs = stmt.executeQuery("select * from movie");
			while ( rs.next() )
			{
				System.out.println(rs.getString("moviename"));
			}
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		
	}
}