Delete

Main

public class mainClass {

	public static void main(String[] args) {
		DBConnection.initConnection();
		
		DeleteTest dt = new DeleteTest();
		
		String id = "1";
		
		boolean b = dt.Delete(id);
		
		if (b == true) {
			System.out.println("성공적으로 삭제되었습니다");
		}
	}
}

 

DeleteTest

public class DeleteTest {

	public boolean Delete(String id) {
		
		String sql = " DELETE FROM USERTEST WHERE ID = '" + id + "' ";
		System.out.println("sql : " + sql);
		
		Connection conn = DBConnection.getConnection();
		Statement stmt = null;
		
		int count = 0;
		try {
			stmt = conn.createStatement();	//현재 상태를 가져옴
			
			count = stmt.executeUpdate(sql);	//쿼리문이 sql로 들어가고 결과가 count로 나옴
			
		} catch (SQLException e) {
			e.printStackTrace();
		} finally {
			DBClose.close(stmt, conn, null);
		}
		return count > 0 ? true: false;	//삼항연산자로 크면 true;
	}
}