import java.io.IOException;
import java.sql.Clob;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
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 displayclob extends HttpServlet {
public void doGet(HttpServletRequest request, HttpServletResponse response) throws IOException,ServletException{
Clob clobFile = null;
Connection con = null;
Statement stmt = null;
ResultSet rs = null;
Integer id = 1;
String query = "select Body from article where id = " + id;
ServletOutputStream out = response.getOutputStream();
response.setContentType("text/html");
out.println("Display Clob Example");
try {
Class.forName("com.mysql.jdbc.Driver");
con =DriverManager.getConnection ("jdbc:mysql://192.168.10.13:3306/ankdb","root","root");
stmt = con.createStatement();
rs = stmt.executeQuery(query);
if (rs.next()) {
clobFile = rs.getClob(1);
} else {
out.println("There are no any File on id=" + id + "
");
return;
}
long length = clobFile.length();
String fileData = clobFile.getSubString(1, (int) length);
out.println("Successfully Display The Record: