[Oracle]update

delete 와 차이가 없어 샘플 코드 하나만 남기겟습니다.

public static void main(String[] args) throws SQLException, ClassNotFoundException {
	Scanner sc= new Scanner(System.in);
	System.out.println("아이디를 입력해주세요 :");
	String MEMBER_ID =sc.next();
	System.out.println("비밀번호를 입력해주세요 :");
	String MEMBER_PW =sc.next();
	System.out.println("변경하실 비밀번호를 입력해주세요");
	String change_pw=sc.next();
	Class.forName("oracle.jdbc.OracleDriver");
		
	sc.close();
	Connection con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe", "kh", "kh");
			
	String sql ="update member set Member_pw=? where MEMBER_ID=? and MEMBER_PW=?";
	PreparedStatement ps = con.prepareStatement(sql);
	
	
	ps.setString(1, change_pw);
	ps.setString(2, MEMBER_ID);
	ps.setString(3, MEMBER_PW);
		
	int count =ps.executeUpdate();
	con.close();
		
	if(count>0) {
		System.out.println("비밀번호가 변경되었습니다");
	}else {
		System.out.println("비밀번호 변경에 실패하였습니다.");
	}
		
}