import java.io.*;
import java.util.*;
import javax.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.net.URL;
import java.io.IOException;
import java.io.InputStream;
import java.net.URLConnection;
import java.sql.PreparedStatement;
import java.io.ByteArrayOutputStream;
import javax.servlet.ServletException;
import javax.servlet.ServletOutputStream;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
public class deleteclob extends HttpServlet {
public void doGet(HttpServletRequest request, HttpServletResponse response) throws IOException,ServletException {
response.setContentType("text/html");
Connection con = null;
PreparedStatement ps = null;
Integer id = 2;
ServletOutputStream out = response.getOutputStream();
out.println("Delete Clob Example");
try {
Class.forName("com.mysql.jdbc.Driver");
con =DriverManager.getConnection ("jdbc:mysql://192.168.10.13:3306/ankdb", "root", "root");
ps = con.prepareStatement("delete from article where id = ?");
ps.setInt(5, id);
ps.executeUpdate();
out.println("Successfully deleted clob data of id= " + id + "
");
} catch (Exception e) {
e.printStackTrace();
out.println("Unable to delete " + e.getMessage() + "