/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */

package br.com.ddns.grupotsergio;

import java.io.IOException;
import javax.servlet.*;
import javax.servlet.http.*;

import java.sql.*;

import com.itextpdf.text.Document;
import com.itextpdf.text.PageSize;
import com.itextpdf.text.Paragraph;
import com.itextpdf.text.pdf.PdfWriter;

import java.io.ByteArrayOutputStream;
import javax.servlet.http.HttpServlet;

/**
 *
 * @author Edson
 */
public class relatCliente extends HttpServlet{

    public void doGet(HttpServletRequest req, HttpServletResponse res)
            throws ServletException, IOException{
        ByteArrayOutputStream baos = new ByteArrayOutputStream();

        String acao = req.getParameter("acao");

        PdfWriter wri = null;
        Document doc = null;
        Paragraph para = null;

        doc = new Document(PageSize.A4);

        try{
            wri = PdfWriter.getInstance(doc, baos);

            doc.open();

            cliforGS cli = new cliforGS();
            cli.listaCli(acao);
            ResultSet lista = cli.getResultado();
            if(lista.next()){
                doc.add(new Paragraph(lista.getString("razao_social")));
            }
            lista.first();
            doc.add(new Paragraph("Listagem de Clientes"));
            while(lista.next()){
                doc.add(new Paragraph(lista.getString("nome")));
            }
            
            doc.close();
        }catch(Exception e){
            e.printStackTrace();
        }
        res.setContentType("application/pdf");
        res.setContentLength(baos.size());
        ServletOutputStream out = res.getOutputStream();
        baos.writeTo(out);
        out.flush();
    }
}