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 ui; import java.text.DateFormat; import java.text.ParseException; import java.text.SimpleDateFormat; import java.util.Calendar; import java.util.Date; import java.util.Iterator; import java.util.logging.Level; import java.util.logging.Logger; import javax.swing.JFileChooser; import javax.swing.filechooser.FileFilter; import javax.swing.filechooser.FileNameExtensionFilter; import javax.swing.table.DefaultTableModel; import org.apache.poi.hssf.usermodel.HSSFDateUtil; import org.apache.poi.ss.usermodel.Sheet; import org.apache.poi.ss.usermodel.Row; import org.apache.poi.ss.usermodel.Cell; import org.apache.poi.ss.usermodel.DateUtil; import org.apache.poi.ss.usermodel.Workbook; import tools.WorksheetFactory; /** * * @author Administrador */ public class MainWindow extends javax.swing.JFrame { private static final FileFilter FILTER = new FileNameExtensionFilter("Archivo de MS Excel", "xls", "xlsx"); public Workbook workbook; /** * Creates new form MainWindow */ public MainWindow() { initComponents(); jFileChooser1.setFileFilter(FILTER); int returnVal = jFileChooser1.showOpenDialog(this); jLabel2.setVisible(false); jLabel3.setVisible(false); jLabel4.setVisible(false); jLabel5.setVisible(false); jLabel6.setVisible(false); jLabel7.setVisible(false); if (returnVal == JFileChooser.APPROVE_OPTION) { workbook = WorksheetFactory.importExcel(jFileChooser1.getSelectedFile().getAbsolutePath()); } else { System.out.println("Cancelado"); System.exit(0); } Sheet sheet = workbook.getSheetAt(0); Iterator iter = sheet.rowIterator(); Row row; Cell c; while (iter.hasNext()) { row = (Row) iter.next(); if (row.getRowNum() >= 4 && !row.getCell(1).getStringCellValue().isEmpty()) { c = row.getCell(1); jComboBox1.addItem(c.getStringCellValue()); } } Calendar mon = Calendar.getInstance(), sun = Calendar.getInstance(); mon.set(Calendar.DAY_OF_WEEK, Calendar.MONDAY); sun.set(Calendar.DAY_OF_WEEK, Calendar.FRIDAY); DateFormat df = new SimpleDateFormat("dd/MM/yyyy"); while (!(sun.get(Calendar.MONTH) == Calendar.DECEMBER && sun.get(Calendar.WEEK_OF_MONTH) > 2)) { jComboBox2.addItem(df.format(mon.getTime()) + "-" + df.format(sun.getTime())); mon.add(Calendar.DAY_OF_YEAR, 7); sun.add(Calendar.DAY_OF_YEAR, 7); } } /** * 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() { jFileChooser1 = new javax.swing.JFileChooser(); jTabbedPane1 = new javax.swing.JTabbedPane(); jPanel1 = new javax.swing.JPanel(); jComboBox1 = new javax.swing.JComboBox<>(); jLabel1 = new javax.swing.JLabel(); jLabel2 = new javax.swing.JLabel(); jLabel3 = new javax.swing.JLabel(); jLabel4 = new javax.swing.JLabel(); jLabel5 = new javax.swing.JLabel(); jLabel6 = new javax.swing.JLabel(); jLabel7 = new javax.swing.JLabel(); jButton1 = new javax.swing.JButton(); jPanel2 = new javax.swing.JPanel(); jComboBox2 = new javax.swing.JComboBox<>(); jLabel8 = new javax.swing.JLabel(); jButton2 = new javax.swing.JButton(); jScrollPane1 = new javax.swing.JScrollPane(); jTable1 = new javax.swing.JTable(); jFileChooser1.setApproveButtonText("Abrir"); jFileChooser1.setDialogTitle("Seleccionar Archivo a Abrir"); jFileChooser1.setToolTipText(""); jFileChooser1.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jFileChooser1ActionPerformed(evt); } }); setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE); jComboBox1.setModel(new javax.swing.DefaultComboBoxModel<>(new String[] { "-Seleccionar Colegio-" })); jLabel1.setText("Colegio:"); jLabel2.setText("El colegio"); jLabel3.setText("<colegio>"); jLabel4.setText("tiene su prxima clase el da"); jLabel5.setText("<fecha>"); jLabel6.setText("El tema de la clase es:"); jLabel7.setText("<tema>"); jButton1.setText("Buscar"); jButton1.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jButton1ActionPerformed(evt); } }); javax.swing.GroupLayout jPanel1Layout = new javax.swing.GroupLayout(jPanel1); jPanel1.setLayout(jPanel1Layout); jPanel1Layout.setHorizontalGroup(jPanel1Layout .createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(jPanel1Layout.createSequentialGroup().addGroup(jPanel1Layout .createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(jPanel1Layout.createSequentialGroup().addContainerGap().addComponent(jLabel1) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED) .addComponent(jComboBox1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addComponent(jButton1)) .addGroup(jPanel1Layout.createSequentialGroup().addGap(29, 29, 29) .addGroup(jPanel1Layout .createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(jPanel1Layout.createSequentialGroup().addGap(10, 10, 10) .addComponent(jLabel6) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addComponent(jLabel7)) .addGroup(jPanel1Layout.createSequentialGroup().addComponent(jLabel2) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addComponent(jLabel3) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addComponent(jLabel4) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addComponent(jLabel5))))) .addContainerGap(195, Short.MAX_VALUE))); jPanel1Layout.setVerticalGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(jPanel1Layout.createSequentialGroup().addGap(26, 26, 26).addGroup(jPanel1Layout .createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(jComboBox1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(jLabel1).addComponent(jButton1)).addGap(18, 18, 18) .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(jLabel2).addComponent(jLabel3).addComponent(jLabel4) .addComponent(jLabel5)) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(jLabel6).addComponent(jLabel7)) .addContainerGap(250, Short.MAX_VALUE))); jTabbedPane1.addTab("Buscar por Colegio", jPanel1); jComboBox2.setModel(new javax.swing.DefaultComboBoxModel<>(new String[] { "-Seleccionar Semana-" })); jComboBox2.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jComboBox2ActionPerformed(evt); } }); jLabel8.setText("Semana:"); jButton2.setText("Buscar"); jButton2.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jButton2ActionPerformed(evt); } }); jTable1.setModel(new javax.swing.table.DefaultTableModel(new Object[][] { }, new String[] { "Colegio", "Fecha Clase", "Tema Clase" }) { boolean[] canEdit = new boolean[] { false, false, false }; public boolean isCellEditable(int rowIndex, int columnIndex) { return canEdit[columnIndex]; } }); jScrollPane1.setViewportView(jTable1); if (jTable1.getColumnModel().getColumnCount() > 0) { jTable1.getColumnModel().getColumn(0).setResizable(false); jTable1.getColumnModel().getColumn(1).setResizable(false); jTable1.getColumnModel().getColumn(2).setResizable(false); } javax.swing.GroupLayout jPanel2Layout = new javax.swing.GroupLayout(jPanel2); jPanel2.setLayout(jPanel2Layout); jPanel2Layout .setHorizontalGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(jPanel2Layout.createSequentialGroup().addGap(8, 8, 8).addComponent(jLabel8) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED) .addComponent(jComboBox2, javax.swing.GroupLayout.PREFERRED_SIZE, 181, javax.swing.GroupLayout.PREFERRED_SIZE) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED) .addComponent(jButton2).addContainerGap(200, Short.MAX_VALUE)) .addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 0, Short.MAX_VALUE)); jPanel2Layout.setVerticalGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup(jPanel2Layout.createSequentialGroup().addGap(21, 21, 21).addGroup(jPanel2Layout .createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE) .addComponent(jComboBox2, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addComponent(jLabel8).addComponent(jButton2)).addGap(18, 18, 18) .addComponent(jScrollPane1, javax.swing.GroupLayout.DEFAULT_SIZE, 289, Short.MAX_VALUE))); jTabbedPane1.addTab("Buscar por Semana", jPanel2); javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane()); getContentPane().setLayout(layout); layout.setHorizontalGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addComponent(jTabbedPane1, javax.swing.GroupLayout.DEFAULT_SIZE, 517, Short.MAX_VALUE)); layout.setVerticalGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addComponent(jTabbedPane1, javax.swing.GroupLayout.DEFAULT_SIZE, 379, Short.MAX_VALUE)); pack(); }// </editor-fold>//GEN-END:initComponents private void jFileChooser1ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jFileChooser1ActionPerformed }//GEN-LAST:event_jFileChooser1ActionPerformed private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton1ActionPerformed if (jComboBox1.getSelectedIndex() == 0) { return; } jLabel4.setText("tiene su prxima clase el da"); jLabel5.setVisible(false); jLabel6.setVisible(false); jLabel7.setVisible(false); Calendar today = Calendar.getInstance(); Sheet sheet = workbook.getSheetAt(0); Row colegio = sheet.getRow(3 + jComboBox1.getSelectedIndex()); int i = 2; Cell c = colegio.getCell(i); DateFormat df = new SimpleDateFormat("dd-MM-yyyy"); Calendar clase = Calendar.getInstance(); while (HSSFDateUtil.isCellDateFormatted(c)) { clase.setTime(c.getDateCellValue()); if (clase.after(today)) { jLabel3.setText(jComboBox1.getSelectedItem().toString()); jLabel5.setText(df.format(clase.getTime())); jLabel7.setText(sheet.getRow(3).getCell(i).getStringCellValue()); jLabel2.setVisible(true); jLabel3.setVisible(true); jLabel4.setVisible(true); jLabel5.setVisible(true); jLabel6.setVisible(true); jLabel7.setVisible(true); return; } else { i++; c = colegio.getCell(i); } } jLabel3.setText(jComboBox1.getSelectedItem().toString()); jLabel4.setText("no tiene ms clases."); jLabel2.setVisible(true); jLabel3.setVisible(true); jLabel4.setVisible(true); }//GEN-LAST:event_jButton1ActionPerformed private void jComboBox2ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jComboBox2ActionPerformed }//GEN-LAST:event_jComboBox2ActionPerformed private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton2ActionPerformed DefaultTableModel m = (DefaultTableModel) jTable1.getModel(); m.setRowCount(0); if (jComboBox2.getSelectedIndex() == 0) { return; } String dates = jComboBox2.getSelectedItem().toString(); String[] split = dates.split("-"); DateFormat df = new SimpleDateFormat("dd/MM/yyyy"); try { Calendar first = Calendar.getInstance(); first.setTime(df.parse(split[0])); Calendar last = Calendar.getInstance(); last.setTime(df.parse(split[1])); String[] clas; for (int i = 1; i < jComboBox1.getItemCount() - 1; i++) { clas = getClass(first.getTime(), last.getTime(), 3 + i); m.addRow(new String[] { jComboBox1.getItemAt(i), clas[0], clas[1] }); } } catch (ParseException ex) { Logger.getLogger(MainWindow.class.getName()).log(Level.SEVERE, null, ex); } }//GEN-LAST:event_jButton2ActionPerformed public String[] getClass(Date weekStart, Date weekEnd, int colegioIndex) { String[] date = new String[] { "-", "-" }; Sheet sheet = workbook.getSheetAt(0); Row colegio = sheet.getRow(colegioIndex); int i = 2; Cell c = colegio.getCell(i); DateFormat df = new SimpleDateFormat("dd-MM-yyyy"); Date clase; while (c != null && HSSFDateUtil.isCellDateFormatted(c)) { clase = c.getDateCellValue(); if (clase.after(weekStart) && clase.before(weekEnd)) { date[0] = df.format(clase); date[1] = sheet.getRow(3).getCell(i).getStringCellValue(); break; } else { i++; c = colegio.getCell(i); } } return date; } /** * @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 ex) { java.util.logging.Logger.getLogger(MainWindow.class.getName()).log(java.util.logging.Level.SEVERE, null, ex); } catch (InstantiationException ex) { java.util.logging.Logger.getLogger(MainWindow.class.getName()).log(java.util.logging.Level.SEVERE, null, ex); } catch (IllegalAccessException ex) { java.util.logging.Logger.getLogger(MainWindow.class.getName()).log(java.util.logging.Level.SEVERE, null, ex); } catch (javax.swing.UnsupportedLookAndFeelException ex) { java.util.logging.Logger.getLogger(MainWindow.class.getName()).log(java.util.logging.Level.SEVERE, null, ex); } //</editor-fold> /* Create and display the form */ java.awt.EventQueue.invokeLater(new Runnable() { public void run() { new MainWindow().setVisible(true); } }); } // Variables declaration - do not modify//GEN-BEGIN:variables private javax.swing.JButton jButton1; private javax.swing.JButton jButton2; private javax.swing.JComboBox<String> jComboBox1; private javax.swing.JComboBox<String> jComboBox2; private javax.swing.JFileChooser jFileChooser1; private javax.swing.JLabel jLabel1; private javax.swing.JLabel jLabel2; private javax.swing.JLabel jLabel3; private javax.swing.JLabel jLabel4; private javax.swing.JLabel jLabel5; private javax.swing.JLabel jLabel6; private javax.swing.JLabel jLabel7; private javax.swing.JLabel jLabel8; private javax.swing.JPanel jPanel1; private javax.swing.JPanel jPanel2; private javax.swing.JScrollPane jScrollPane1; private javax.swing.JTabbedPane jTabbedPane1; private javax.swing.JTable jTable1; // End of variables declaration//GEN-END:variables }