04.데이터 삭제하기

데이터 삭제하기

package ex1;

import java.beans.Statement;
import java.net.URL;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Date;
//
public class Program4 {
	public static void main(String[] args) throws  SQLException, ClassNotFoundException{
  

	int id = 3; //id가 3인 것이 삭제댐


    String url ="jdbc:oracle:thin:@localhost:1521/orcl";   
	String sql = "DELETE NOTICE WHERE ID=?";
	
	
	
			
	Class.forName("oracle.jdbc.driver.OracleDriver"); 
	Connection con = DriverManager.getConnection(url,"eunji","1234"); 
//	sql.Statement st =con.createStatement();
	//st.execute query,update를 실행 할때 넘겼는데 
	PreparedStatement st=con.prepareStatement(sql); //prepare 미리 준비해서 실행하라 statement자체가 쿼리문을 가지고 있다
	
	st.setInt(1, id);
//prepare쓸때는 sql을 쓰면 안된다
	int result = st.executeUpdate();
	System.out.println(result);
	

	
	st.close();
	con.close();
	}
}