JDBC-Delete

package jdbc0327;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;

public class Test04_Delete {

	public static void main(String[] args) {
		// sungjuk 테이블 행 삭제
        
		try {
			String url="jdbc:oracle:thin:@localhost:1521:xe";
			String user="system";
			String password="1234";
			String driver ="oracle.jdbc.driver.OracleDriver"; //ojdbc8.jar
			Class.forName(driver);
			Connection con=DriverManager.getConnection(url, user, password);
			System.out.println("오라클 DB연결 성공");
		
			StringBuilder sql= new StringBuilder();
			sql.append("delete from sungjuk where sno=133");
			
		
			PreparedStatement pstmt= con.prepareStatement(sql.toString());
			int cnt=pstmt.executeUpdate();
			if (cnt==0) {
				System.out.println("삭제 실패");
			}else {
				System.out.println("삭제 성공");
			}
			
			//자원 반납(순서주의)
			pstmt.close();
			con.close();
			
		} catch (Exception e) {
			System.out.println("오라클 DB연결 실패"+ e);
		}
	}

}