[Java]JDBC DELETE하기

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class Jdbc_delete {

	private static Connection conn;
	private static Statement stmt;
	private static PreparedStatement pstmt;
	private static ResultSet rs;

	// 자원반납용
	private static void disConnect() {
		if(rs != null) {
			try {
				rs.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
		if(stmt != null)
			try {
				stmt.close();
			} catch (Exception e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}

		if(conn != null) {
			try {
				conn.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
		if(pstmt != null) {
			try {
				pstmt.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}

	}


	public static void main(String[] args) {

		String query_delete = "DELETE FROM 테이블명";// 테이블값 전체 지움

		try {
			conn = DButil.getconnection();
			stmt = conn.createStatement();

			stmt.executeUpdate(query_delete);// 쿼리 실행
			conn.commit();// commit

		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally {
			disConnect();// 자원반납
		}

	}


}

자바로 테이블 전체 DELETE하는 코드입니다. 필요한 부분은 변수에 WHERE절을 추가하여 작성하시면 됩니다.

더 좋은 생각 있으시면 댓글 남겨주시면 감사하겠습니다~!