reader

FOR HTML HOMEPAGE
------------------------------------------------------------
<html>
<head>
<title>Untitled Document</title>

</head>

<body>
    <form action="reader" method="get">

       <a href="reader">test</a>

    </form>


</body>
</html>


----------------------------------------------------------------
FOR SERVLET TO RETRIEVE THE PDF AND TO DISPLAY IT
-----------------------------------------------------------------

import java.io.IOException;
import java.io.OutputStream;
import java.io.PrintWriter;
import java.sql.Blob;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import javax.servlet.ServletException;
import javax.servlet.ServletOutputStream;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

/**
 *
 * @author ISSPL
 */
public class reader extends HttpServlet {
    @Override
    protected void doGet(HttpServletRequest request, HttpServletResponse response)throws IOException, ServletException {
        response.setContentType("text/html;charset=UTF-8");
        PrintWriter out= response.getWriter();
        byte[] fileBytes = null;
        Blob file = null;


        if(request.getParameter("button1")!= null){
           try{
               Connection con= createConn();
           String sql = "SELECT pdf FROM book WHERE bookname = ?";
            PreparedStatement statement = con.prepareStatement(sql);
            statement.setString(1, "cv");
           ResultSet rs = statement.executeQuery();
            if (rs.next()) {
                file = rs.getBlob("pdf");
                fileBytes= file.getBytes(1, (int)file.length());

            }else{
                out.println("File Not Found");
            }
            response.setContentType("application/pdf");
            response.setHeader("Content-Disposition", "inline");
            response.setContentLength((int) file.length());
            OutputStream os= response.getOutputStream();
            os.write(fileBytes);
            os.flush();
           }catch(Exception ee){
               ee.printStackTrace();
           }
        }
        }

    private Connection createConn() {
        try{
            Class.forName("com.mysql.jdbc.Driver");
            Connection  con = DriverManager.getConnection("jdbc:mysql://localhost:3306/project", "root", "swasthya");
            return con;
        }catch(Exception ee){
            ee.printStackTrace();
            return null;
        }
    }


}


-------------------------------------------------------------
WEB.XML
-------------------------------------------------------------

<?xml version="1.0" encoding="UTF-8"?>
<web-app version="3.1" xmlns="http://xmlns.jcp.org/xml/ns/javaee" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_3_1.xsd">
    <servlet>
        <servlet-name>reader</servlet-name>
        <servlet-class>reader</servlet-class>
    </servlet>
    <servlet-mapping>
        <servlet-name>reader</servlet-name>
        <url-pattern>/reader</url-pattern>
    </servlet-mapping>
    <session-config>
        <session-timeout>
            30
        </session-timeout>
    </session-config>
</web-app>