본문 바로가기

Java

[Java] Statement 인터페이스를 이용한 Table delete

728x90
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Scanner;

public class JDBC5 {
    public static void main(String[] args) {
        String url = "jdbc:mysql://127.0.0.1/aiclass?useSSL=false";
        String id = "root";
        String pw = "1234";

        String userid;
        Scanner sc = new Scanner(System.in);
        System.out.println("********* 회원수정 **********");
        System.out.print("삭제할 아이디를 입력하세요 : ");
        userid = sc.next();
        String sql = "delete from tb_member where mem_userid = '" + userid + "'";

        try {
            Class.forName("com.mysql.cj.jdbc.Driver");
            Connection conn = DriverManager.getConnection(url, id, pw);
            Statement stmt = conn.createStatement();
            int result = stmt.executeUpdate(sql);
            if (result >= 1) System.out.println("회원삭제 성공했습니다.");
            else System.out.println("회원삭제 실패했습니다.");
        } catch (ClassNotFoundException | SQLException e) {
            e.printStackTrace();
        }

    }
}

728x90