[JAVA] delete values

기존 테이블에서 아무개의 값을 지워보자

 

package DBconn;

import java.sql.*;

public class StudentUpdateEx {

	public static void main(String[] args) {
		Connection conn = null;
		Statement stmt = null;
		ResultSet rs = null;
		
		try {
			//1.드라이버 로드 oracle.jdbc.driver.OracleDriver
			Class.forName("oracle.jdbc.driver.OracleDriver");
			//2. DB접속
			conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl", "scott", "tiger");
			
			//명시가 안되어 있는 경우 순서대로 들어감
			String sql = "delete from student where name = '아무개'";
			
			stmt = conn.createStatement();
			stmt.executeUpdate(sql);
			
		} catch (Exception e) {
			System.out.println("오류");
		}
	}
}

 

 

모두삭제

package DBconn;

import java.sql.*;

public class StudentUpdateEx {

	public static void main(String[] args) {
		Connection conn = null;
		Statement stmt = null;
		ResultSet rs = null;
		
		try {
			//1.드라이버 로드 oracle.jdbc.driver.OracleDriver
			Class.forName("oracle.jdbc.driver.OracleDriver");
			//2. DB접속
			conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl", "scott", "tiger");
			
			//명시가 안되어 있는 경우 순서대로 들어감
			String sql = "delete from student";
			
			stmt = conn.createStatement();
			stmt.executeUpdate(sql);
			
		} catch (Exception e) {
			System.out.println("오류");
		}
	}
}