Java tutorial
/* * To change this license header, choose License Headers in Project Properties. * To change this template file, choose Tools | Templates * and open the template in the editor. */ package Usuario.Reportes; import EstructurasAux.proveedor; import interfaces.Usuario; import java.awt.Desktop; import java.awt.Toolkit; import java.io.File; import java.io.FileOutputStream; import java.io.IOException; import java.rmi.RemoteException; import java.text.DateFormat; import java.text.SimpleDateFormat; import java.util.ArrayList; import java.util.logging.Level; import java.util.logging.Logger; import javax.swing.JFileChooser; import javax.swing.JOptionPane; import javax.swing.table.DefaultTableModel; import org.apache.poi.hssf.usermodel.HSSFWorkbook; import org.apache.poi.ss.usermodel.Cell; import org.apache.poi.ss.usermodel.Row; import org.apache.poi.ss.usermodel.Sheet; import org.apache.poi.ss.usermodel.Workbook; /** * * @author Sammy Guergachi <sguergachi at gmail.com> */ public class verProveedores extends javax.swing.JFrame { /** * Creates new form verProveedores */ public verProveedores() { initComponents(); setIcon(); this.setLocationRelativeTo(null); Usuario u = cliente.Cliente.conectarU(); try { ArrayList<proveedor> todosProveedores = u.todosProveedores(); ArrayList<Object> tabla = new ArrayList<>(); for (proveedor t : todosProveedores) { Object[] datos = new Object[8]; datos[0] = t.getNIT(); datos[1] = t.getNombre(); datos[2] = t.getDireccion(); datos[3] = t.getTelefono(); datos[4] = t.getTelefax(); datos[5] = t.getCelular(); datos[6] = t.getCorreo(); datos[7] = t.getContacto(); tabla.add(datos); } DefaultTableModel df = (DefaultTableModel) this.jTable1.getModel(); for (Object t : tabla) { df.addRow((Object[]) t); } } catch (RemoteException ex) { Logger.getLogger(verProveedores.class.getName()).log(Level.SEVERE, null, ex); } } /** * 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">//GEN-BEGIN:initComponents private void initComponents() { labelAdministrador = new javax.swing.JLabel(); jLabel1 = new javax.swing.JLabel(); jScrollPane1 = new javax.swing.JScrollPane(); jTable1 = new javax.swing.JTable(); jPanel1 = new javax.swing.JPanel(); btnProveedores = new javax.swing.JButton(); btnCerrar = new javax.swing.JButton(); jLabel3 = new javax.swing.JLabel(); jLabel2 = new javax.swing.JLabel(); setDefaultCloseOperation(javax.swing.WindowConstants.DO_NOTHING_ON_CLOSE); labelAdministrador.setFont(new java.awt.Font("Tahoma", 1, 24)); // NOI18N labelAdministrador.setText("Listado de Proveedores"); jLabel1.setText("Esta vista le permite generar un archivo .xls con el listado de proveedores"); jTable1.setModel(new javax.swing.table.DefaultTableModel(new Object[][] { }, new String[] { "NIT", "Nombre", "Direccin", "Telfono", "Telefax", "Celular", "Correo", "Contactol" }) { boolean[] canEdit = new boolean[] { false, true, true, true, true, true, true, true }; public boolean isCellEditable(int rowIndex, int columnIndex) { return canEdit[columnIndex]; } }); jScrollPane1.setViewportView(jTable1); btnProveedores.setIcon(new javax.swing.ImageIcon(getClass().getResource("/Imagenes/excel.png"))); // NOI18N btnProveedores.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { btnProveedoresActionPerformed(evt); } }); btnCerrar.setIcon(new javax.swing.ImageIcon(getClass().getResource("/Imagenes/NO.png"))); // NOI18N btnCerrar.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { btnCerrarActionPerformed(evt); } }); jLabel3.setHorizontalAlignment(javax.swing.SwingConstants.CENTER); jLabel3.setText("Cerrar"); jLabel2.setHorizontalAlignment(javax.swing.SwingConstants.CENTER); jLabel2.setText("Generar .xls"); javax.swing.GroupLayout jPanel1Layout = new javax.swing.GroupLayout(jPanel1); jPanel1.setLayout(jPanel1Layout); jPanel1Layout.setHorizontalGroup(jPanel1Layout .createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(jPanel1Layout.createSequentialGroup().addContainerGap().addGroup(jPanel1Layout .createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addComponent(btnProveedores, javax.swing.GroupLayout.PREFERRED_SIZE, 94, javax.swing.GroupLayout.PREFERRED_SIZE) .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addComponent(btnCerrar, javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.PREFERRED_SIZE, 94, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(jLabel3, javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.PREFERRED_SIZE, 90, javax.swing.GroupLayout.PREFERRED_SIZE)) .addComponent(jLabel2, javax.swing.GroupLayout.PREFERRED_SIZE, 96, javax.swing.GroupLayout.PREFERRED_SIZE)) .addContainerGap())); jPanel1Layout.setVerticalGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(jPanel1Layout.createSequentialGroup().addContainerGap() .addComponent(btnProveedores, javax.swing.GroupLayout.PREFERRED_SIZE, 93, javax.swing.GroupLayout.PREFERRED_SIZE) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED).addComponent(jLabel2) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addComponent(btnCerrar, javax.swing.GroupLayout.PREFERRED_SIZE, 92, javax.swing.GroupLayout.PREFERRED_SIZE) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED).addComponent(jLabel3) .addContainerGap())); javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane()); getContentPane().setLayout(layout); layout.setHorizontalGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(layout.createSequentialGroup().addContainerGap().addGroup(layout .createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(layout.createSequentialGroup() .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING) .addComponent(labelAdministrador, javax.swing.GroupLayout.Alignment.LEADING) .addComponent(jLabel1, javax.swing.GroupLayout.Alignment.LEADING)) .addGap(0, 342, Short.MAX_VALUE)) .addGroup(layout.createSequentialGroup().addComponent(jScrollPane1) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addComponent(jPanel1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))) .addContainerGap())); layout.setVerticalGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING).addGroup( javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup().addContainerGap().addGroup(layout .createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING) .addGroup(layout.createSequentialGroup().addGap(0, 0, Short.MAX_VALUE).addComponent(jPanel1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)) .addGroup(layout.createSequentialGroup().addComponent(labelAdministrador) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addComponent(jLabel1) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED).addComponent( jScrollPane1, javax.swing.GroupLayout.DEFAULT_SIZE, 395, Short.MAX_VALUE))) .addContainerGap())); pack(); }// </editor-fold>//GEN-END:initComponents private void btnCerrarActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_btnCerrarActionPerformed this.setVisible(false); }//GEN-LAST:event_btnCerrarActionPerformed private void btnProveedoresActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_btnProveedoresActionPerformed Usuario u = cliente.Cliente.conectarU(); try { File xls; JFileChooser chooser = new JFileChooser(); chooser.setFileSelectionMode(JFileChooser.DIRECTORIES_ONLY); chooser.showOpenDialog(this); String path = chooser.getSelectedFile().getPath(); xls = this.imprimirProveedores(path); if (JOptionPane.showConfirmDialog(null, "Desea abrir el archivo?", "", JOptionPane.YES_NO_OPTION) == JOptionPane.YES_OPTION) { Desktop.getDesktop().open(xls); } } catch (RemoteException ex) { Logger.getLogger(verProveedores.class.getName()).log(Level.SEVERE, null, ex); } catch (IOException ex) { Logger.getLogger(verProveedores.class.getName()).log(Level.SEVERE, null, ex); } }//GEN-LAST:event_btnProveedoresActionPerformed /** * @param args the command line arguments */ public static void main(String args[]) { /* Set the Nimbus look and feel */ //<editor-fold defaultstate="collapsed" desc=" Look and feel setting code (optional) "> /* If Nimbus (introduced in Java SE 6) is not available, stay with the default look and feel. * For details see http://download.oracle.com/javase/tutorial/uiswing/lookandfeel/plaf.html */ try { for (javax.swing.UIManager.LookAndFeelInfo info : javax.swing.UIManager.getInstalledLookAndFeels()) { if ("Nimbus".equals(info.getName())) { javax.swing.UIManager.setLookAndFeel(info.getClassName()); break; } } } catch (ClassNotFoundException | InstantiationException | IllegalAccessException | javax.swing.UnsupportedLookAndFeelException ex) { java.util.logging.Logger.getLogger(verProveedores.class.getName()).log(java.util.logging.Level.SEVERE, null, ex); } //</editor-fold> //</editor-fold> //</editor-fold> /* Create and display the form */ java.awt.EventQueue.invokeLater(new Runnable() { @Override public void run() { new verProveedores().setVisible(true); } }); } // Variables declaration - do not modify//GEN-BEGIN:variables private javax.swing.JButton btnCerrar; private javax.swing.JButton btnProveedores; private javax.swing.JLabel jLabel1; private javax.swing.JLabel jLabel2; private javax.swing.JLabel jLabel3; private javax.swing.JPanel jPanel1; private javax.swing.JScrollPane jScrollPane1; private javax.swing.JTable jTable1; private javax.swing.JLabel labelAdministrador; // End of variables declaration//GEN-END:variables private void setIcon() { setIconImage(Toolkit.getDefaultToolkit().getImage(getClass().getResource("iconB.png"))); } File imprimirProveedores(String ruta) { DateFormat dateFormat = new SimpleDateFormat("yyyy_MM_dd__HH_mm_ss"); java.util.Date date = new java.util.Date(); File xls = new File(ruta + "\\ListaProveedores" + dateFormat.format(date) + ".xls"); if (!xls.exists()) { try { xls.createNewFile(); } catch (IOException ex) { Logger.getLogger(Usuario.class.getName()).log(Level.SEVERE, null, ex); } } Workbook libro = new HSSFWorkbook(); FileOutputStream archivo; Sheet hoja; ArrayList<proveedor> todos; try { xls.createNewFile(); archivo = new FileOutputStream(xls); hoja = libro.createSheet("Lista_Proveedores"); Usuario u = cliente.Cliente.conectarU(); todos = u.todosProveedores(); int i = 0; for (int j = 0; j < 8; j++) { Row fila = hoja.createRow(i); Cell aux; if (i == 0) { aux = fila.createCell(j); aux.setCellValue("NIT"); j++; aux = fila.createCell(j); aux.setCellValue("Nombre"); j++; aux = fila.createCell(j); aux.setCellValue("Direccin"); j++; aux = fila.createCell(j); aux.setCellValue("Telfono"); j++; aux = fila.createCell(j); aux.setCellValue("Fax"); j++; aux = fila.createCell(j); aux.setCellValue("Celular"); j++; aux = fila.createCell(j); aux.setCellValue("Correo"); j++; aux = fila.createCell(j); aux.setCellValue("Contacto"); j++; i++; } } for (proveedor t : todos) { Row fila = hoja.createRow(i); Cell aux; for (int j = 0; j < 7; j++) { aux = fila.createCell(j); aux.setCellValue(t.getNIT()); hoja.autoSizeColumn(j); j++; aux = fila.createCell(j); aux.setCellValue(t.getNombre()); hoja.autoSizeColumn(j); j++; aux = fila.createCell(j); aux.setCellValue(t.getDireccion()); hoja.autoSizeColumn(j); j++; aux = fila.createCell(j); aux.setCellValue(t.getTelefono()); hoja.autoSizeColumn(j); j++; aux = fila.createCell(j); aux.setCellValue(t.getTelefax()); hoja.autoSizeColumn(j); j++; aux = fila.createCell(j); aux.setCellValue(t.getCelular()); hoja.autoSizeColumn(j); j++; aux = fila.createCell(j); aux.setCellValue(t.getCorreo()); hoja.autoSizeColumn(j); j++; aux = fila.createCell(j); aux.setCellValue(t.getContacto()); hoja.autoSizeColumn(j); j++; } i++; } libro.write(archivo); archivo.close(); } catch (IOException ex) { Logger.getLogger(Usuario.class.getName()).log(Level.SEVERE, null, ex); } return xls; } }