Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- package VISUAL;
- import java.io.*;
- import java.sql.*;
- import org.w3c.dom.*;
- import org.w3c.dom.ls.*;
- import javax.xml.parsers.*;
- import com.itextpdf.tool.xml.*;
- import com.itextpdf.text.DocumentException;
- import com.itextpdf.text.pdf.*;
- import com.itextpdf.text.PageSize;
- import java.nio.charset.StandardCharsets;
- import javax.swing.JOptionPane;
- import DAL.ConectaBd;
- import java.util.List;
- import java.util.ArrayList;
- import java.util.Date;
- import java.awt.Desktop;
- import java.text.SimpleDateFormat;
- /**
- *
- * @author silas.paixao
- */
- public class frmRelatorios extends javax.swing.JInternalFrame {
- /**
- * Creates new form frmRelatorios
- */
- Connection conecta;
- PreparedStatement pst;
- ResultSet rs;
- public frmRelatorios() throws ClassNotFoundException{
- initComponents();
- setLocation(350, 100);
- conecta = ConectaBd.conectabd();
- }
- /**
- * This method is called from within the constructor to initialize the form.
- * WARNING: Do NOT modify this code. The content of this method is always
- * regenerated by the Form Editor.
- */
- @SuppressWarnings("unchecked")
- // <editor-fold defaultstate="collapsed" desc="Generated Code">
- private void initComponents() {
- jLabel1 = new javax.swing.JLabel();
- jButton1 = new javax.swing.JButton();
- jComboBox1 = new javax.swing.JComboBox();
- jComboBox2 = new javax.swing.JComboBox();
- jComboBox3 = new javax.swing.JComboBox();
- jLabel1.setFont(new java.awt.Font("Tahoma", 1, 36)); // NOI18N
- jLabel1.setText("Relatórios");
- jButton1.setIcon(new javax.swing.ImageIcon(getClass().getResource("/img/printer.png"))); // NOI18N
- jButton1.setText("Gerar");
- jButton1.addActionListener(new java.awt.event.ActionListener() {
- public void actionPerformed(java.awt.event.ActionEvent evt) {
- jButton1ActionPerformed(evt);
- }
- });
- jComboBox1.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "Selecione a Loja ...", "CLUBE BAR BOTECO ", "CLUBE BAR MOLHADO ", "CLUBE BAR SINUCA", "CLUBE CAFETERIA ", "CLUBE HOT DOG ", "CLUBE KIT CHURRASQUEIRAS ", "CLUBE PETISCO PISCINA ", "CLUBE RESTAURANTE ", "CLUBE RESTAURANTE 2 ", "CLUBE SAPÊ", "PARQUE BAR FLORESTA ", "PARQUE BAR DA PRAIA ", "PARQUE BAR MOLHADO ", "PARQUE CAFETERIA ", "PARQUE CASA DA MAMA ESPÇO EVENTOS", "PARQUE CASA DA ROÇA", "PARQUE CHOPERIA", "PARQUE CHURRASCARIA EXPRESS 2", "PARQUE EMPANADO", "PARQUE ESPETINHO NA BRASA", "PARQUE ESPETINHO GRILL", "PARQUE GALETERIA TENDA", "PARQUE LANCHONETE TENDA", "PARQUE LOJA DE CONVENIENCIA", "PARQUE MUNDO NESTLE", "PARQUE NESTLE ENTRADA", "PARQUE NESTLE KIDS", "PARQUE POINT SAÚDE", "PARQUE RESTAURANTE INFANTIL", " " }));
- jComboBox2.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "Selecione Status", "Em Funcinamento", "Em Manutenção", "Estoque CPD" }));
- jComboBox3.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "Selecione Modelo", "VX510", "VX520", "VX670", "SMARTPHONE" }));
- javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
- getContentPane().setLayout(layout);
- layout.setHorizontalGroup(
- layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
- .addGroup(layout.createSequentialGroup()
- .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
- .addGroup(layout.createSequentialGroup()
- .addContainerGap()
- .addComponent(jLabel1, javax.swing.GroupLayout.PREFERRED_SIZE, 209, javax.swing.GroupLayout.PREFERRED_SIZE))
- .addGroup(layout.createSequentialGroup()
- .addGap(28, 28, 28)
- .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
- .addComponent(jComboBox1, 0, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
- .addComponent(jComboBox2, 0, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
- .addComponent(jComboBox3, 0, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
- .addGap(30, 30, 30)
- .addComponent(jButton1, javax.swing.GroupLayout.PREFERRED_SIZE, 87, javax.swing.GroupLayout.PREFERRED_SIZE)))
- .addGap(19, 19, Short.MAX_VALUE))
- );
- layout.setVerticalGroup(
- layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
- .addGroup(layout.createSequentialGroup()
- .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
- .addGroup(layout.createSequentialGroup()
- .addGap(134, 134, 134)
- .addComponent(jButton1, javax.swing.GroupLayout.PREFERRED_SIZE, 85, javax.swing.GroupLayout.PREFERRED_SIZE))
- .addGroup(javax.swing.GroupLayout.Alignment.LEADING, layout.createSequentialGroup()
- .addContainerGap()
- .addComponent(jLabel1, javax.swing.GroupLayout.PREFERRED_SIZE, 54, javax.swing.GroupLayout.PREFERRED_SIZE)
- .addGap(70, 70, 70)
- .addComponent(jComboBox1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
- .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
- .addComponent(jComboBox2, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
- .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
- .addComponent(jComboBox3, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)))
- .addContainerGap(63, Short.MAX_VALUE))
- );
- pack();
- }// </editor-fold>
- private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {
- /* PESQUISANDO BANCO DE DADOS */
- List<String> listaLojas = new ArrayList();
- List<String> listaStatus = new ArrayList();
- List<String> listaModelos = new ArrayList();
- int numeroDeLinhas = 0;
- String sql = "SELECT * FROM pos WHERE loja LIKE ? and status LIKE ? and modelo LIKE ?;";
- /*
- Pesquisar coluna LIKE "%" aceita qualquer valor
- Então, se não for selecionada uma opção em uma das combobox, pesquisa com "%"
- */
- String loja = new Integer(jComboBox1.getSelectedIndex()).equals(0) ? "%" : jComboBox1.getSelectedItem().toString();
- String status = new Integer(jComboBox2.getSelectedIndex()).equals(0) ? "%" : jComboBox2.getSelectedItem().toString();
- String modelo = new Integer(jComboBox3.getSelectedIndex()).equals(0) ? "%" : jComboBox3.getSelectedItem().toString();
- /*
- Isso ai em cima é operador ternário, é tipo um if/else inline
- Tá checando, em cada combobox, se a opção selecionada é a primeira (0), ou seja, nenhum valor definido
- Ai, se não selecionaram nada, puxa registros com qualquer valor nessa coluna, usando o LIKE "%"
- */
- try {
- pst = conecta.prepareStatement(sql);
- pst.setString(1, loja);
- pst.setString(2, status);
- pst.setString(3, modelo);
- rs = pst.executeQuery();
- // Puxando a lista dos valores que retornaram da consulta ao bd:
- while(rs.next())
- {
- listaLojas.add(rs.getString("loja"));
- listaStatus.add(rs.getString("status"));
- listaModelos.add(rs.getString("modelo"));
- numeroDeLinhas++;
- }
- } catch (SQLException error) {
- JOptionPane.showMessageDialog(null, "1 " + error);
- }
- /* PEGANDO DATA E HORA PARA INCLUIR NO RELATORIO */
- SimpleDateFormat dataForma = new SimpleDateFormat("dd/MM/yyy - HH:mm");
- String data = dataForma.format(new Date()) + "h";
- /* CRIANDO DOCUMENTO XHTML VIA DOM */
- try
- {
- Document xhtml = DocumentBuilderFactory.newInstance().newDocumentBuilder().newDocument();
- Element root = xhtml.createElement("html");
- root.appendChild(xhtml.createElement("body"));
- Element table = xhtml.createElement("table");
- table.setAttribute("style", "border-collapse: collapse; margin-top: 1cm;");
- Element titulo = xhtml.createElement("tr");
- Element tituloLoja = xhtml.createElement("td");
- Element tituloStatus = xhtml.createElement("td");
- Element tituloModelo = xhtml.createElement("td");
- tituloLoja.appendChild(xhtml.createTextNode("LOJA"));
- tituloStatus.appendChild(xhtml.createTextNode("STATUS"));
- tituloModelo.appendChild(xhtml.createTextNode("MODELO"));
- titulo.appendChild(tituloLoja);
- titulo.appendChild(tituloStatus);
- titulo.appendChild(tituloModelo);
- titulo.setAttribute("style", "font-size: 1cm; padding-bottom: .5mm; text-align: center");
- table.appendChild(titulo);
- for(int i = 0; i < numeroDeLinhas; i++)
- {
- Element tr = xhtml.createElement("tr");
- for(int j = 0; j < 3; j++)
- {
- Element td = xhtml.createElement("td");
- td.setAttribute("style", "padding-top: .2cm; padding-bottom: .2cm; width: 7cm; text-align: center; border-bottom: .2mm #000 solid;");
- String texto;
- if(j == 0)
- texto = listaLojas.get(i);
- else if(j == 1)
- texto = listaStatus.get(i);
- else
- texto = listaModelos.get(i);
- td.appendChild(xhtml.createTextNode(texto));
- tr.appendChild(td);
- }
- table.appendChild(tr);
- }
- root.getFirstChild().appendChild(xhtml.createTextNode(data));
- root.getFirstChild().appendChild(table);
- xhtml.appendChild(root);
- /* TRANSFORMANDO DOCUMENTO EM STRING */
- DOMImplementationLS domLS = (DOMImplementationLS) xhtml.getImplementation();
- LSSerializer serializer = domLS.createLSSerializer();
- String xhtmlString = serializer.writeToString(xhtml);
- InputStream stream = new ByteArrayInputStream(xhtmlString.getBytes(StandardCharsets.UTF_8));
- /* CONVERTENDO PARA PDF VIA ITEXT */
- File pdf = new File("relatorio.pdf");
- pdf.createNewFile();
- com.itextpdf.text.Document doc = new com.itextpdf.text.Document(PageSize.A4);
- FileOutputStream sPdf = new FileOutputStream(pdf);
- PdfWriter writer = PdfWriter.getInstance(doc, sPdf);
- doc.open();
- XMLWorkerHelper.getInstance().parseXHtml(writer, doc, stream);
- doc.close();
- sPdf.close();
- /* ABRINDO A ARQUIVO */
- Desktop.getDesktop().open(pdf);
- }
- catch(DocumentException|FileNotFoundException e)
- {
- JOptionPane.showMessageDialog(null, "2 " + e.getClass().toString());
- }
- catch(IOException e)
- {
- JOptionPane.showMessageDialog(null, "3 " + e.toString());
- }
- catch(Exception e){
- JOptionPane.showMessageDialog(null, "4 " + e.toString());
- }
- }
- // Variables declaration - do not modify
- private javax.swing.JButton jButton1;
- private javax.swing.JComboBox jComboBox1;
- private javax.swing.JComboBox jComboBox2;
- private javax.swing.JComboBox jComboBox3;
- private javax.swing.JLabel jLabel1;
- // End of variables declaration
- }
Advertisement
Add Comment
Please, Sign In to add comment