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 seguimientoprogramatico; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import javax.swing.JComboBox; import javax.swing.JFrame; import javax.swing.JOptionPane; import javax.swing.JTextArea; import com.itextpdf.text.Document; import com.itextpdf.text.DocumentException; import com.itextpdf.text.Image; import com.itextpdf.text.Paragraph; import com.itextpdf.text.pdf.PdfWriter; import java.awt.Rectangle; import java.awt.image.BufferedImage; import java.io.File; import java.io.FileNotFoundException; import java.io.FileOutputStream; import java.io.IOException; import java.util.logging.Level; import java.util.logging.Logger; import javax.imageio.ImageIO; public final class GUI extends javax.swing.JFrame { JComboBox ListaGrupos = new JComboBox(); public GUI() { initComponents(); iniciarLista(); } /** * 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() { jScrollPane2 = new javax.swing.JScrollPane(); jPanel1 = new javax.swing.JPanel(); Materia = new javax.swing.JLabel(); Catedratico = new javax.swing.JLabel(); Carrera = new javax.swing.JLabel(); Grupo = new javax.swing.JLabel(); LunesInicio = new javax.swing.JLabel(); LunesFin = new javax.swing.JLabel(); MartesInicio = new javax.swing.JLabel(); MartesFin = new javax.swing.JLabel(); MiercolesInicio = new javax.swing.JLabel(); MiercolesFIn = new javax.swing.JLabel(); JuevesInicio = new javax.swing.JLabel(); JuevesFin = new javax.swing.JLabel(); ViernesInicio = new javax.swing.JLabel(); ViernesFin = new javax.swing.JLabel(); Tema1 = new javax.swing.JLabel(); Tema2 = new javax.swing.JLabel(); Tema3 = new javax.swing.JLabel(); Tema4 = new javax.swing.JLabel(); Tema5 = new javax.swing.JLabel(); Tema6 = new javax.swing.JLabel(); Tema7 = new javax.swing.JLabel(); Tema8 = new javax.swing.JLabel(); Tema9 = new javax.swing.JLabel(); Tema10 = new javax.swing.JLabel(); HoraProg1 = new javax.swing.JLabel(); HoraProg2 = new javax.swing.JLabel(); HoraProg3 = new javax.swing.JLabel(); HoraProg4 = new javax.swing.JLabel(); HoraProg5 = new javax.swing.JLabel(); HoraProg6 = new javax.swing.JLabel(); HoraProg7 = new javax.swing.JLabel(); HoraProg8 = new javax.swing.JLabel(); HoraProg9 = new javax.swing.JLabel(); HoraProg10 = new javax.swing.JLabel(); InicioProg1 = new javax.swing.JLabel(); InicioProg2 = new javax.swing.JLabel(); InicioProg3 = new javax.swing.JLabel(); InicioProg4 = new javax.swing.JLabel(); InicioProg5 = new javax.swing.JLabel(); InicioProg6 = new javax.swing.JLabel(); InicioProg7 = new javax.swing.JLabel(); InicioProg8 = new javax.swing.JLabel(); InicioProg9 = new javax.swing.JLabel(); InicioProg10 = new javax.swing.JLabel(); FinProg1 = new javax.swing.JLabel(); FinProg2 = new javax.swing.JLabel(); FinProg3 = new javax.swing.JLabel(); FinProg4 = new javax.swing.JLabel(); FinProg5 = new javax.swing.JLabel(); FinProg6 = new javax.swing.JLabel(); FinProg7 = new javax.swing.JLabel(); FinProg8 = new javax.swing.JLabel(); FinProg9 = new javax.swing.JLabel(); FinProg10 = new javax.swing.JLabel(); AvanceProg1 = new javax.swing.JLabel(); AvanceProg2 = new javax.swing.JLabel(); AvanceProg3 = new javax.swing.JLabel(); AvanceProg4 = new javax.swing.JLabel(); AvanceProg5 = new javax.swing.JLabel(); AvanceProg6 = new javax.swing.JLabel(); AvanceProg7 = new javax.swing.JLabel(); AvanceProg8 = new javax.swing.JLabel(); AvanceProg9 = new javax.swing.JLabel(); AvanceProg10 = new javax.swing.JLabel(); HoraReal1 = new javax.swing.JTextField(); HoraReal2 = new javax.swing.JTextField(); HoraReal3 = new javax.swing.JTextField(); HoraReal4 = new javax.swing.JTextField(); HoraReal5 = new javax.swing.JTextField(); HoraReal6 = new javax.swing.JTextField(); HoraReal7 = new javax.swing.JTextField(); HoraReal8 = new javax.swing.JTextField(); HoraReal9 = new javax.swing.JTextField(); HoraReal10 = new javax.swing.JTextField(); InicioReal1 = new javax.swing.JTextField(); InicioReal2 = new javax.swing.JTextField(); InicioReal3 = new javax.swing.JTextField(); InicioReal4 = new javax.swing.JTextField(); InicioReal5 = new javax.swing.JTextField(); InicioReal6 = new javax.swing.JTextField(); InicioReal7 = new javax.swing.JTextField(); InicioReal8 = new javax.swing.JTextField(); InicioReal9 = new javax.swing.JTextField(); InicioReal10 = new javax.swing.JTextField(); FinReal1 = new javax.swing.JTextField(); FinReal2 = new javax.swing.JTextField(); FinReal3 = new javax.swing.JTextField(); FinReal4 = new javax.swing.JTextField(); FinReal5 = new javax.swing.JTextField(); FinReal6 = new javax.swing.JTextField(); FinReal7 = new javax.swing.JTextField(); FinReal8 = new javax.swing.JTextField(); FinReal9 = new javax.swing.JTextField(); FinReal10 = new javax.swing.JTextField(); AvanceReal1 = new javax.swing.JTextField(); AvanceReal2 = new javax.swing.JTextField(); AvanceReal3 = new javax.swing.JTextField(); AvanceReal4 = new javax.swing.JTextField(); AvanceReal5 = new javax.swing.JTextField(); AvanceReal6 = new javax.swing.JTextField(); AvanceReal7 = new javax.swing.JTextField(); AvanceReal8 = new javax.swing.JTextField(); AvanceReal9 = new javax.swing.JTextField(); AvanceReal10 = new javax.swing.JTextField(); Practica1 = new javax.swing.JLabel(); Practica2 = new javax.swing.JLabel(); Practica3 = new javax.swing.JLabel(); Practica4 = new javax.swing.JLabel(); Unidad1 = new javax.swing.JLabel(); Unidad2 = new javax.swing.JLabel(); Unidad3 = new javax.swing.JLabel(); Unidad4 = new javax.swing.JLabel(); FechaProgramada1 = new javax.swing.JLabel(); FechaProgramada2 = new javax.swing.JLabel(); FechaProgramada3 = new javax.swing.JLabel(); FechaProgramada4 = new javax.swing.JLabel(); FechaRealizada1 = new javax.swing.JTextField(); FechaRealizada2 = new javax.swing.JTextField(); FechaRealizada3 = new javax.swing.JTextField(); FechaRealizada4 = new javax.swing.JTextField(); NombreEmpresa = new javax.swing.JTextField(); UnidadTematica = new javax.swing.JTextField(); FechaProgramadaVisita = new javax.swing.JTextField(); FechaRealizadaVisita = new javax.swing.JTextField(); EVUnidad1 = new javax.swing.JTextField(); EVUnidad2 = new javax.swing.JTextField(); EVUnidad3 = new javax.swing.JTextField(); EVUnidad4 = new javax.swing.JTextField(); EVUnidad5 = new javax.swing.JTextField(); EVUnidad6 = new javax.swing.JTextField(); EVUnidad7 = new javax.swing.JTextField(); EVUnidad8 = new javax.swing.JTextField(); EVUnidad9 = new javax.swing.JTextField(); EVUnidad10 = new javax.swing.JTextField(); EVUnidad11 = new javax.swing.JTextField(); EVUnidad12 = new javax.swing.JTextField(); EVUnidad13 = new javax.swing.JTextField(); EVUnidad14 = new javax.swing.JTextField(); EVUnidad15 = new javax.swing.JTextField(); EVUnidad16 = new javax.swing.JTextField(); TP1 = new javax.swing.JTextField(); TP2 = new javax.swing.JTextField(); TP3 = new javax.swing.JTextField(); TP4 = new javax.swing.JTextField(); TP5 = new javax.swing.JTextField(); TP6 = new javax.swing.JTextField(); TP7 = new javax.swing.JTextField(); TP8 = new javax.swing.JTextField(); TP9 = new javax.swing.JTextField(); TP10 = new javax.swing.JTextField(); TP11 = new javax.swing.JTextField(); TP12 = new javax.swing.JTextField(); TP13 = new javax.swing.JTextField(); TP14 = new javax.swing.JTextField(); TP15 = new javax.swing.JTextField(); TP16 = new javax.swing.JTextField(); TR1 = new javax.swing.JTextField(); TR2 = new javax.swing.JTextField(); TR3 = new javax.swing.JTextField(); TR4 = new javax.swing.JTextField(); TR5 = new javax.swing.JTextField(); TR6 = new javax.swing.JTextField(); TR7 = new javax.swing.JTextField(); TR8 = new javax.swing.JTextField(); TR9 = new javax.swing.JTextField(); TR10 = new javax.swing.JTextField(); TR11 = new javax.swing.JTextField(); TR12 = new javax.swing.JTextField(); TR13 = new javax.swing.JTextField(); TR14 = new javax.swing.JTextField(); TR15 = new javax.swing.JTextField(); TR16 = new javax.swing.JTextField(); EP1 = new javax.swing.JTextField(); EP2 = new javax.swing.JTextField(); EP3 = new javax.swing.JTextField(); EP4 = new javax.swing.JTextField(); EP5 = new javax.swing.JTextField(); EP6 = new javax.swing.JTextField(); EP7 = new javax.swing.JTextField(); EP8 = new javax.swing.JTextField(); EP9 = new javax.swing.JTextField(); EP10 = new javax.swing.JTextField(); EP11 = new javax.swing.JTextField(); EP12 = new javax.swing.JTextField(); EP13 = new javax.swing.JTextField(); EP14 = new javax.swing.JTextField(); EP15 = new javax.swing.JTextField(); EP16 = new javax.swing.JTextField(); ER1 = new javax.swing.JTextField(); ER2 = new javax.swing.JTextField(); ER3 = new javax.swing.JTextField(); ER4 = new javax.swing.JTextField(); ER5 = new javax.swing.JTextField(); ER6 = new javax.swing.JTextField(); ER7 = new javax.swing.JTextField(); ER8 = new javax.swing.JTextField(); ER9 = new javax.swing.JTextField(); ER10 = new javax.swing.JTextField(); ER11 = new javax.swing.JTextField(); ER12 = new javax.swing.JTextField(); ER13 = new javax.swing.JTextField(); ER14 = new javax.swing.JTextField(); ER15 = new javax.swing.JTextField(); ER16 = new javax.swing.JTextField(); FS = new javax.swing.JTextField(); TotalEstudiantes = new javax.swing.JTextField(); UnidadesEvaluadasALaFecha = new javax.swing.JTextField(); Aprobados = new javax.swing.JTextField(); Reprobados = new javax.swing.JTextField(); NoAsisten = new javax.swing.JTextField(); Fondo = new javax.swing.JLabel(); jPanel2 = new javax.swing.JPanel(); Abrir = new javax.swing.JButton(); Guardar = new javax.swing.JButton(); PDF = new javax.swing.JButton(); setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE); setMinimumSize(new java.awt.Dimension(800, 600)); setSize(new java.awt.Dimension(800, 600)); jPanel1.setLayout(new org.netbeans.lib.awtextra.AbsoluteLayout()); jPanel1.add(Materia, new org.netbeans.lib.awtextra.AbsoluteConstraints(170, 160, 400, 20)); jPanel1.add(Catedratico, new org.netbeans.lib.awtextra.AbsoluteConstraints(170, 180, 400, 50)); jPanel1.add(Carrera, new org.netbeans.lib.awtextra.AbsoluteConstraints(170, 230, 400, -1)); jPanel1.add(Grupo, new org.netbeans.lib.awtextra.AbsoluteConstraints(420, 250, 150, 20)); jPanel1.add(LunesInicio, new org.netbeans.lib.awtextra.AbsoluteConstraints(570, 230, 160, -1)); jPanel1.add(LunesFin, new org.netbeans.lib.awtextra.AbsoluteConstraints(570, 250, 150, -1)); jPanel1.add(MartesInicio, new org.netbeans.lib.awtextra.AbsoluteConstraints(740, 230, 160, -1)); jPanel1.add(MartesFin, new org.netbeans.lib.awtextra.AbsoluteConstraints(740, 250, 160, -1)); jPanel1.add(MiercolesInicio, new org.netbeans.lib.awtextra.AbsoluteConstraints(910, 230, 120, -1)); jPanel1.add(MiercolesFIn, new org.netbeans.lib.awtextra.AbsoluteConstraints(910, 250, 120, -1)); jPanel1.add(JuevesInicio, new org.netbeans.lib.awtextra.AbsoluteConstraints(1040, 230, 110, -1)); jPanel1.add(JuevesFin, new org.netbeans.lib.awtextra.AbsoluteConstraints(1040, 250, 110, -1)); jPanel1.add(ViernesInicio, new org.netbeans.lib.awtextra.AbsoluteConstraints(1160, 230, 100, -1)); jPanel1.add(ViernesFin, new org.netbeans.lib.awtextra.AbsoluteConstraints(1160, 250, 100, -1)); jPanel1.add(Tema1, new org.netbeans.lib.awtextra.AbsoluteConstraints(100, 380, 320, 20)); jPanel1.add(Tema2, new org.netbeans.lib.awtextra.AbsoluteConstraints(100, 402, 320, 20)); jPanel1.add(Tema3, new org.netbeans.lib.awtextra.AbsoluteConstraints(100, 424, 320, 20)); jPanel1.add(Tema4, new org.netbeans.lib.awtextra.AbsoluteConstraints(100, 447, 320, 20)); jPanel1.add(Tema5, new org.netbeans.lib.awtextra.AbsoluteConstraints(100, 469, 320, 20)); jPanel1.add(Tema6, new org.netbeans.lib.awtextra.AbsoluteConstraints(100, 494, 320, 20)); jPanel1.add(Tema7, new org.netbeans.lib.awtextra.AbsoluteConstraints(100, 515, 320, 20)); jPanel1.add(Tema8, new org.netbeans.lib.awtextra.AbsoluteConstraints(100, 538, 320, 20)); jPanel1.add(Tema9, new org.netbeans.lib.awtextra.AbsoluteConstraints(100, 560, 320, 20)); jPanel1.add(Tema10, new org.netbeans.lib.awtextra.AbsoluteConstraints(100, 583, 320, 20)); jPanel1.add(HoraProg1, new org.netbeans.lib.awtextra.AbsoluteConstraints(430, 380, -1, 20)); jPanel1.add(HoraProg2, new org.netbeans.lib.awtextra.AbsoluteConstraints(430, 402, -1, 20)); jPanel1.add(HoraProg3, new org.netbeans.lib.awtextra.AbsoluteConstraints(430, 424, -1, 20)); jPanel1.add(HoraProg4, new org.netbeans.lib.awtextra.AbsoluteConstraints(430, 447, -1, 20)); jPanel1.add(HoraProg5, new org.netbeans.lib.awtextra.AbsoluteConstraints(430, 469, -1, 20)); jPanel1.add(HoraProg6, new org.netbeans.lib.awtextra.AbsoluteConstraints(430, 492, -1, 20)); jPanel1.add(HoraProg7, new org.netbeans.lib.awtextra.AbsoluteConstraints(430, 515, -1, 20)); jPanel1.add(HoraProg8, new org.netbeans.lib.awtextra.AbsoluteConstraints(430, 538, -1, 20)); jPanel1.add(HoraProg9, new org.netbeans.lib.awtextra.AbsoluteConstraints(430, 560, -1, 20)); jPanel1.add(HoraProg10, new org.netbeans.lib.awtextra.AbsoluteConstraints(430, 583, -1, 20)); jPanel1.add(InicioProg1, new org.netbeans.lib.awtextra.AbsoluteConstraints(490, 380, -1, 20)); jPanel1.add(InicioProg2, new org.netbeans.lib.awtextra.AbsoluteConstraints(490, 402, -1, 20)); jPanel1.add(InicioProg3, new org.netbeans.lib.awtextra.AbsoluteConstraints(490, 424, -1, 20)); jPanel1.add(InicioProg4, new org.netbeans.lib.awtextra.AbsoluteConstraints(490, 447, -1, 20)); jPanel1.add(InicioProg5, new org.netbeans.lib.awtextra.AbsoluteConstraints(490, 469, -1, 20)); jPanel1.add(InicioProg6, new org.netbeans.lib.awtextra.AbsoluteConstraints(490, 492, -1, 20)); jPanel1.add(InicioProg7, new org.netbeans.lib.awtextra.AbsoluteConstraints(490, 515, -1, 20)); jPanel1.add(InicioProg8, new org.netbeans.lib.awtextra.AbsoluteConstraints(490, 538, -1, 20)); jPanel1.add(InicioProg9, new org.netbeans.lib.awtextra.AbsoluteConstraints(490, 560, -1, 20)); jPanel1.add(InicioProg10, new org.netbeans.lib.awtextra.AbsoluteConstraints(490, 583, -1, 20)); jPanel1.add(FinProg1, new org.netbeans.lib.awtextra.AbsoluteConstraints(549, 380, 50, 20)); jPanel1.add(FinProg2, new org.netbeans.lib.awtextra.AbsoluteConstraints(549, 402, 50, 20)); jPanel1.add(FinProg3, new org.netbeans.lib.awtextra.AbsoluteConstraints(549, 424, 50, 20)); jPanel1.add(FinProg4, new org.netbeans.lib.awtextra.AbsoluteConstraints(549, 447, 50, 20)); jPanel1.add(FinProg5, new org.netbeans.lib.awtextra.AbsoluteConstraints(549, 470, 50, 20)); jPanel1.add(FinProg6, new org.netbeans.lib.awtextra.AbsoluteConstraints(549, 492, 50, 20)); jPanel1.add(FinProg7, new org.netbeans.lib.awtextra.AbsoluteConstraints(549, 515, 50, 20)); jPanel1.add(FinProg8, new org.netbeans.lib.awtextra.AbsoluteConstraints(549, 538, 50, 20)); jPanel1.add(FinProg9, new org.netbeans.lib.awtextra.AbsoluteConstraints(549, 560, 50, 20)); jPanel1.add(FinProg10, new org.netbeans.lib.awtextra.AbsoluteConstraints(549, 583, 50, 20)); jPanel1.add(AvanceProg1, new org.netbeans.lib.awtextra.AbsoluteConstraints(630, 380, -1, 20)); jPanel1.add(AvanceProg2, new org.netbeans.lib.awtextra.AbsoluteConstraints(630, 402, -1, 20)); jPanel1.add(AvanceProg3, new org.netbeans.lib.awtextra.AbsoluteConstraints(630, 424, -1, 20)); jPanel1.add(AvanceProg4, new org.netbeans.lib.awtextra.AbsoluteConstraints(630, 447, -1, 20)); jPanel1.add(AvanceProg5, new org.netbeans.lib.awtextra.AbsoluteConstraints(630, 469, -1, 20)); jPanel1.add(AvanceProg6, new org.netbeans.lib.awtextra.AbsoluteConstraints(630, 492, -1, 20)); jPanel1.add(AvanceProg7, new org.netbeans.lib.awtextra.AbsoluteConstraints(630, 515, -1, 20)); jPanel1.add(AvanceProg8, new org.netbeans.lib.awtextra.AbsoluteConstraints(630, 538, -1, 20)); jPanel1.add(AvanceProg9, new org.netbeans.lib.awtextra.AbsoluteConstraints(630, 560, -1, 20)); jPanel1.add(AvanceProg10, new org.netbeans.lib.awtextra.AbsoluteConstraints(630, 583, -1, 20)); HoraReal1.setBorder(null); HoraReal1.setMinimumSize(new java.awt.Dimension(6, 21)); HoraReal1.setOpaque(false); HoraReal1.setPreferredSize(new java.awt.Dimension(61, 21)); HoraReal1.setBorder(javax.swing.BorderFactory.createEmptyBorder()); HoraReal1.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { HoraReal1ActionPerformed(evt); } }); jPanel1.add(HoraReal1, new org.netbeans.lib.awtextra.AbsoluteConstraints(690, 380, 70, 20)); HoraReal2.setBorder(null); HoraReal2.setMinimumSize(new java.awt.Dimension(6, 21)); HoraReal2.setOpaque(false); HoraReal2.setBorder(javax.swing.BorderFactory.createEmptyBorder()); HoraReal2.setPreferredSize(new java.awt.Dimension(61, 21)); HoraReal2.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { HoraReal2ActionPerformed(evt); } }); jPanel1.add(HoraReal2, new org.netbeans.lib.awtextra.AbsoluteConstraints(690, 402, 70, 20)); HoraReal3.setBorder(null); HoraReal3.setMinimumSize(new java.awt.Dimension(6, 21)); HoraReal3.setOpaque(false); HoraReal3.setPreferredSize(new java.awt.Dimension(61, 21)); HoraReal3.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { HoraReal3ActionPerformed(evt); } }); jPanel1.add(HoraReal3, new org.netbeans.lib.awtextra.AbsoluteConstraints(690, 424, 70, 20)); HoraReal4.setBorder(null); HoraReal4.setMinimumSize(new java.awt.Dimension(6, 21)); HoraReal4.setOpaque(false); HoraReal4.setPreferredSize(new java.awt.Dimension(61, 21)); HoraReal4.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { HoraReal4ActionPerformed(evt); } }); jPanel1.add(HoraReal4, new org.netbeans.lib.awtextra.AbsoluteConstraints(690, 447, 70, 20)); HoraReal5.setBorder(null); HoraReal5.setMinimumSize(new java.awt.Dimension(6, 21)); HoraReal5.setOpaque(false); HoraReal5.setPreferredSize(new java.awt.Dimension(61, 21)); HoraReal5.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { HoraReal5ActionPerformed(evt); } }); jPanel1.add(HoraReal5, new org.netbeans.lib.awtextra.AbsoluteConstraints(690, 469, 70, 20)); HoraReal6.setBorder(null); HoraReal6.setMinimumSize(new java.awt.Dimension(6, 21)); HoraReal6.setOpaque(false); HoraReal6.setPreferredSize(new java.awt.Dimension(61, 21)); HoraReal6.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { HoraReal6ActionPerformed(evt); } }); jPanel1.add(HoraReal6, new org.netbeans.lib.awtextra.AbsoluteConstraints(690, 492, 70, 20)); HoraReal7.setBorder(null); HoraReal7.setMinimumSize(new java.awt.Dimension(6, 21)); HoraReal7.setOpaque(false); HoraReal7.setPreferredSize(new java.awt.Dimension(61, 21)); HoraReal7.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { HoraReal7ActionPerformed(evt); } }); jPanel1.add(HoraReal7, new org.netbeans.lib.awtextra.AbsoluteConstraints(690, 515, 70, 20)); HoraReal8.setBorder(null); HoraReal8.setMinimumSize(new java.awt.Dimension(6, 21)); HoraReal8.setOpaque(false); HoraReal8.setPreferredSize(new java.awt.Dimension(61, 21)); HoraReal8.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { HoraReal8ActionPerformed(evt); } }); jPanel1.add(HoraReal8, new org.netbeans.lib.awtextra.AbsoluteConstraints(690, 538, 70, 20)); HoraReal9.setBorder(null); HoraReal9.setMinimumSize(new java.awt.Dimension(6, 21)); HoraReal9.setOpaque(false); HoraReal9.setPreferredSize(new java.awt.Dimension(61, 21)); HoraReal9.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { HoraReal9ActionPerformed(evt); } }); jPanel1.add(HoraReal9, new org.netbeans.lib.awtextra.AbsoluteConstraints(690, 560, 70, 20)); HoraReal10.setBorder(null); HoraReal10.setMinimumSize(new java.awt.Dimension(6, 21)); HoraReal10.setOpaque(false); HoraReal10.setPreferredSize(new java.awt.Dimension(61, 21)); HoraReal10.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { HoraReal10ActionPerformed(evt); } }); jPanel1.add(HoraReal10, new org.netbeans.lib.awtextra.AbsoluteConstraints(690, 582, 70, 20)); InicioReal1.setBorder(null); jPanel1.add(InicioReal1, new org.netbeans.lib.awtextra.AbsoluteConstraints(770, 380, 50, 20)); InicioReal2.setBorder(null); jPanel1.add(InicioReal2, new org.netbeans.lib.awtextra.AbsoluteConstraints(770, 402, 50, 20)); InicioReal3.setBorder(null); jPanel1.add(InicioReal3, new org.netbeans.lib.awtextra.AbsoluteConstraints(770, 424, 50, 20)); InicioReal4.setBorder(null); jPanel1.add(InicioReal4, new org.netbeans.lib.awtextra.AbsoluteConstraints(770, 447, 50, 20)); InicioReal5.setBorder(null); jPanel1.add(InicioReal5, new org.netbeans.lib.awtextra.AbsoluteConstraints(770, 469, 50, 20)); InicioReal6.setBorder(null); jPanel1.add(InicioReal6, new org.netbeans.lib.awtextra.AbsoluteConstraints(770, 492, 50, 20)); InicioReal7.setBorder(null); jPanel1.add(InicioReal7, new org.netbeans.lib.awtextra.AbsoluteConstraints(770, 515, 50, 20)); InicioReal8.setBorder(null); jPanel1.add(InicioReal8, new org.netbeans.lib.awtextra.AbsoluteConstraints(770, 538, 50, 20)); InicioReal9.setBorder(null); jPanel1.add(InicioReal9, new org.netbeans.lib.awtextra.AbsoluteConstraints(770, 560, 50, 20)); InicioReal10.setBorder(null); jPanel1.add(InicioReal10, new org.netbeans.lib.awtextra.AbsoluteConstraints(770, 583, 50, 20)); FinReal1.setBorder(null); FinReal1.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { FinReal1ActionPerformed(evt); } }); jPanel1.add(FinReal1, new org.netbeans.lib.awtextra.AbsoluteConstraints(830, 380, 50, 20)); FinReal2.setBorder(null); FinReal2.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { FinReal2ActionPerformed(evt); } }); jPanel1.add(FinReal2, new org.netbeans.lib.awtextra.AbsoluteConstraints(830, 402, 50, 20)); FinReal3.setBorder(null); FinReal3.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { FinReal3ActionPerformed(evt); } }); jPanel1.add(FinReal3, new org.netbeans.lib.awtextra.AbsoluteConstraints(830, 424, 50, 20)); FinReal4.setBorder(null); FinReal4.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { FinReal4ActionPerformed(evt); } }); jPanel1.add(FinReal4, new org.netbeans.lib.awtextra.AbsoluteConstraints(830, 447, 50, 20)); FinReal5.setBorder(null); FinReal5.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { FinReal5ActionPerformed(evt); } }); jPanel1.add(FinReal5, new org.netbeans.lib.awtextra.AbsoluteConstraints(830, 469, 50, 20)); FinReal6.setBorder(null); FinReal6.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { FinReal6ActionPerformed(evt); } }); jPanel1.add(FinReal6, new org.netbeans.lib.awtextra.AbsoluteConstraints(830, 492, 50, 20)); FinReal7.setBorder(null); FinReal7.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { FinReal7ActionPerformed(evt); } }); jPanel1.add(FinReal7, new org.netbeans.lib.awtextra.AbsoluteConstraints(830, 515, 50, 20)); FinReal8.setBorder(null); FinReal8.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { FinReal8ActionPerformed(evt); } }); jPanel1.add(FinReal8, new org.netbeans.lib.awtextra.AbsoluteConstraints(830, 538, 50, 20)); FinReal9.setBorder(null); FinReal9.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { FinReal9ActionPerformed(evt); } }); jPanel1.add(FinReal9, new org.netbeans.lib.awtextra.AbsoluteConstraints(830, 560, 50, 20)); FinReal10.setBorder(null); FinReal10.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { FinReal10ActionPerformed(evt); } }); jPanel1.add(FinReal10, new org.netbeans.lib.awtextra.AbsoluteConstraints(830, 583, 50, 20)); AvanceReal1.setBorder(null); AvanceReal1.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { AvanceReal1ActionPerformed(evt); } }); jPanel1.add(AvanceReal1, new org.netbeans.lib.awtextra.AbsoluteConstraints(900, 380, 100, 20)); AvanceReal2.setBorder(null); AvanceReal2.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { AvanceReal2ActionPerformed(evt); } }); jPanel1.add(AvanceReal2, new org.netbeans.lib.awtextra.AbsoluteConstraints(900, 402, 100, 20)); AvanceReal3.setBorder(null); AvanceReal3.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { AvanceReal3ActionPerformed(evt); } }); jPanel1.add(AvanceReal3, new org.netbeans.lib.awtextra.AbsoluteConstraints(900, 424, 100, 20)); AvanceReal4.setBorder(null); AvanceReal4.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { AvanceReal4ActionPerformed(evt); } }); jPanel1.add(AvanceReal4, new org.netbeans.lib.awtextra.AbsoluteConstraints(900, 447, 100, 20)); AvanceReal5.setBorder(null); AvanceReal5.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { AvanceReal5ActionPerformed(evt); } }); jPanel1.add(AvanceReal5, new org.netbeans.lib.awtextra.AbsoluteConstraints(900, 469, 100, 20)); AvanceReal6.setBorder(null); AvanceReal6.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { AvanceReal6ActionPerformed(evt); } }); jPanel1.add(AvanceReal6, new org.netbeans.lib.awtextra.AbsoluteConstraints(900, 492, 100, 20)); AvanceReal7.setBorder(null); AvanceReal7.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { AvanceReal7ActionPerformed(evt); } }); jPanel1.add(AvanceReal7, new org.netbeans.lib.awtextra.AbsoluteConstraints(900, 515, 100, 20)); AvanceReal8.setBorder(null); AvanceReal8.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { AvanceReal8ActionPerformed(evt); } }); jPanel1.add(AvanceReal8, new org.netbeans.lib.awtextra.AbsoluteConstraints(900, 538, 100, 20)); AvanceReal9.setBorder(null); AvanceReal9.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { AvanceReal9ActionPerformed(evt); } }); jPanel1.add(AvanceReal9, new org.netbeans.lib.awtextra.AbsoluteConstraints(900, 560, 100, 20)); AvanceReal10.setBorder(null); AvanceReal10.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { AvanceReal10ActionPerformed(evt); } }); jPanel1.add(AvanceReal10, new org.netbeans.lib.awtextra.AbsoluteConstraints(900, 583, 100, 20)); jPanel1.add(Practica1, new org.netbeans.lib.awtextra.AbsoluteConstraints(90, 700, 720, 20)); jPanel1.add(Practica2, new org.netbeans.lib.awtextra.AbsoluteConstraints(90, 722, 720, 20)); jPanel1.add(Practica3, new org.netbeans.lib.awtextra.AbsoluteConstraints(90, 745, 720, 20)); jPanel1.add(Practica4, new org.netbeans.lib.awtextra.AbsoluteConstraints(90, 767, 720, 20)); jPanel1.add(Unidad1, new org.netbeans.lib.awtextra.AbsoluteConstraints(820, 700, 60, 20)); jPanel1.add(Unidad2, new org.netbeans.lib.awtextra.AbsoluteConstraints(820, 722, 60, 20)); jPanel1.add(Unidad3, new org.netbeans.lib.awtextra.AbsoluteConstraints(820, 745, 60, 20)); jPanel1.add(Unidad4, new org.netbeans.lib.awtextra.AbsoluteConstraints(820, 767, 60, 20)); jPanel1.add(FechaProgramada1, new org.netbeans.lib.awtextra.AbsoluteConstraints(900, 700, 170, 20)); jPanel1.add(FechaProgramada2, new org.netbeans.lib.awtextra.AbsoluteConstraints(900, 722, 170, 20)); jPanel1.add(FechaProgramada3, new org.netbeans.lib.awtextra.AbsoluteConstraints(900, 745, 170, 20)); jPanel1.add(FechaProgramada4, new org.netbeans.lib.awtextra.AbsoluteConstraints(900, 767, 170, 20)); FechaRealizada1.setBorder(null); jPanel1.add(FechaRealizada1, new org.netbeans.lib.awtextra.AbsoluteConstraints(1090, 700, 150, 20)); FechaRealizada2.setBorder(null); jPanel1.add(FechaRealizada2, new org.netbeans.lib.awtextra.AbsoluteConstraints(1090, 722, 150, 20)); FechaRealizada3.setBorder(null); jPanel1.add(FechaRealizada3, new org.netbeans.lib.awtextra.AbsoluteConstraints(1090, 744, 150, 20)); FechaRealizada4.setBorder(null); jPanel1.add(FechaRealizada4, new org.netbeans.lib.awtextra.AbsoluteConstraints(1090, 767, 150, 20)); NombreEmpresa.setBorder(null); jPanel1.add(NombreEmpresa, new org.netbeans.lib.awtextra.AbsoluteConstraints(90, 882, 320, 20)); UnidadTematica.setBorder(null); jPanel1.add(UnidadTematica, new org.netbeans.lib.awtextra.AbsoluteConstraints(420, 882, 280, 20)); FechaProgramadaVisita.setBorder(null); jPanel1.add(FechaProgramadaVisita, new org.netbeans.lib.awtextra.AbsoluteConstraints(710, 882, 140, 20)); FechaRealizadaVisita.setBorder(null); jPanel1.add(FechaRealizadaVisita, new org.netbeans.lib.awtextra.AbsoluteConstraints(860, 882, 150, 20)); EVUnidad1.setBorder(null); jPanel1.add(EVUnidad1, new org.netbeans.lib.awtextra.AbsoluteConstraints(122, 1054, 50, 20)); EVUnidad2.setBorder(null); jPanel1.add(EVUnidad2, new org.netbeans.lib.awtextra.AbsoluteConstraints(177, 1054, 50, 20)); EVUnidad3.setBorder(null); jPanel1.add(EVUnidad3, new org.netbeans.lib.awtextra.AbsoluteConstraints(233, 1054, 50, 20)); EVUnidad4.setBorder(null); jPanel1.add(EVUnidad4, new org.netbeans.lib.awtextra.AbsoluteConstraints(289, 1054, 50, 20)); EVUnidad5.setBorder(null); jPanel1.add(EVUnidad5, new org.netbeans.lib.awtextra.AbsoluteConstraints(345, 1054, 50, 20)); EVUnidad6.setBorder(null); jPanel1.add(EVUnidad6, new org.netbeans.lib.awtextra.AbsoluteConstraints(401, 1054, 50, 20)); EVUnidad7.setBorder(null); jPanel1.add(EVUnidad7, new org.netbeans.lib.awtextra.AbsoluteConstraints(457, 1054, 50, 20)); EVUnidad8.setBorder(null); jPanel1.add(EVUnidad8, new org.netbeans.lib.awtextra.AbsoluteConstraints(513, 1054, 50, 20)); EVUnidad9.setBorder(null); jPanel1.add(EVUnidad9, new org.netbeans.lib.awtextra.AbsoluteConstraints(569, 1054, 50, 20)); EVUnidad10.setBorder(null); jPanel1.add(EVUnidad10, new org.netbeans.lib.awtextra.AbsoluteConstraints(625, 1054, 50, 20)); EVUnidad11.setBorder(null); jPanel1.add(EVUnidad11, new org.netbeans.lib.awtextra.AbsoluteConstraints(681, 1054, 50, 20)); EVUnidad12.setBorder(null); jPanel1.add(EVUnidad12, new org.netbeans.lib.awtextra.AbsoluteConstraints(737, 1054, 50, 20)); EVUnidad13.setBorder(null); jPanel1.add(EVUnidad13, new org.netbeans.lib.awtextra.AbsoluteConstraints(792, 1054, 50, 20)); EVUnidad14.setBorder(null); jPanel1.add(EVUnidad14, new org.netbeans.lib.awtextra.AbsoluteConstraints(847, 1054, 50, 20)); EVUnidad15.setBorder(null); jPanel1.add(EVUnidad15, new org.netbeans.lib.awtextra.AbsoluteConstraints(903, 1054, 50, 20)); EVUnidad16.setBorder(null); jPanel1.add(EVUnidad16, new org.netbeans.lib.awtextra.AbsoluteConstraints(960, 1054, 50, 20)); TP1.setBorder(null); jPanel1.add(TP1, new org.netbeans.lib.awtextra.AbsoluteConstraints(122, 1076, 50, 20)); TP2.setBorder(null); jPanel1.add(TP2, new org.netbeans.lib.awtextra.AbsoluteConstraints(177, 1076, 50, 20)); TP3.setBorder(null); jPanel1.add(TP3, new org.netbeans.lib.awtextra.AbsoluteConstraints(233, 1076, 50, 20)); TP4.setBorder(null); jPanel1.add(TP4, new org.netbeans.lib.awtextra.AbsoluteConstraints(289, 1076, 50, 20)); TP5.setBorder(null); jPanel1.add(TP5, new org.netbeans.lib.awtextra.AbsoluteConstraints(345, 1076, 50, 20)); TP6.setBorder(null); jPanel1.add(TP6, new org.netbeans.lib.awtextra.AbsoluteConstraints(401, 1076, 50, 20)); TP7.setBorder(null); jPanel1.add(TP7, new org.netbeans.lib.awtextra.AbsoluteConstraints(457, 1076, 50, 20)); TP8.setBorder(null); jPanel1.add(TP8, new org.netbeans.lib.awtextra.AbsoluteConstraints(513, 1076, 50, 20)); TP9.setBorder(null); jPanel1.add(TP9, new org.netbeans.lib.awtextra.AbsoluteConstraints(569, 1076, 50, 20)); TP10.setBorder(null); jPanel1.add(TP10, new org.netbeans.lib.awtextra.AbsoluteConstraints(625, 1076, 50, 20)); TP11.setBorder(null); jPanel1.add(TP11, new org.netbeans.lib.awtextra.AbsoluteConstraints(681, 1076, 50, 20)); TP12.setBorder(null); jPanel1.add(TP12, new org.netbeans.lib.awtextra.AbsoluteConstraints(737, 1076, 50, 20)); TP13.setBorder(null); jPanel1.add(TP13, new org.netbeans.lib.awtextra.AbsoluteConstraints(792, 1076, 50, 20)); TP14.setBorder(null); jPanel1.add(TP14, new org.netbeans.lib.awtextra.AbsoluteConstraints(847, 1076, 50, 20)); TP15.setBorder(null); jPanel1.add(TP15, new org.netbeans.lib.awtextra.AbsoluteConstraints(903, 1076, 50, 20)); TP16.setBorder(null); jPanel1.add(TP16, new org.netbeans.lib.awtextra.AbsoluteConstraints(960, 1076, 50, 20)); TR1.setBorder(null); jPanel1.add(TR1, new org.netbeans.lib.awtextra.AbsoluteConstraints(121, 1099, 50, 20)); TR2.setBorder(null); jPanel1.add(TR2, new org.netbeans.lib.awtextra.AbsoluteConstraints(177, 1099, 50, 20)); TR3.setBorder(null); jPanel1.add(TR3, new org.netbeans.lib.awtextra.AbsoluteConstraints(233, 1099, 50, 20)); TR4.setBorder(null); jPanel1.add(TR4, new org.netbeans.lib.awtextra.AbsoluteConstraints(289, 1099, 50, 20)); TR5.setBorder(null); jPanel1.add(TR5, new org.netbeans.lib.awtextra.AbsoluteConstraints(345, 1099, 50, 20)); TR6.setBorder(null); jPanel1.add(TR6, new org.netbeans.lib.awtextra.AbsoluteConstraints(401, 1099, 50, 20)); TR7.setBorder(null); jPanel1.add(TR7, new org.netbeans.lib.awtextra.AbsoluteConstraints(457, 1099, 50, 20)); TR8.setBorder(null); jPanel1.add(TR8, new org.netbeans.lib.awtextra.AbsoluteConstraints(513, 1099, 50, 20)); TR9.setBorder(null); jPanel1.add(TR9, new org.netbeans.lib.awtextra.AbsoluteConstraints(569, 1099, 50, 20)); TR10.setBorder(null); jPanel1.add(TR10, new org.netbeans.lib.awtextra.AbsoluteConstraints(625, 1099, 50, 20)); TR11.setBorder(null); jPanel1.add(TR11, new org.netbeans.lib.awtextra.AbsoluteConstraints(681, 1099, 50, 20)); TR12.setBorder(null); jPanel1.add(TR12, new org.netbeans.lib.awtextra.AbsoluteConstraints(737, 1099, 50, 20)); TR13.setBorder(null); jPanel1.add(TR13, new org.netbeans.lib.awtextra.AbsoluteConstraints(792, 1099, 50, 20)); TR14.setBorder(null); jPanel1.add(TR14, new org.netbeans.lib.awtextra.AbsoluteConstraints(847, 1099, 50, 20)); TR15.setBorder(null); jPanel1.add(TR15, new org.netbeans.lib.awtextra.AbsoluteConstraints(903, 1099, 50, 20)); TR16.setBorder(null); jPanel1.add(TR16, new org.netbeans.lib.awtextra.AbsoluteConstraints(960, 1099, 50, 20)); EP1.setBorder(null); jPanel1.add(EP1, new org.netbeans.lib.awtextra.AbsoluteConstraints(121, 1121, 50, 20)); EP2.setBorder(null); jPanel1.add(EP2, new org.netbeans.lib.awtextra.AbsoluteConstraints(177, 1121, 50, 20)); EP3.setBorder(null); jPanel1.add(EP3, new org.netbeans.lib.awtextra.AbsoluteConstraints(233, 1121, 50, 20)); EP4.setBorder(null); jPanel1.add(EP4, new org.netbeans.lib.awtextra.AbsoluteConstraints(289, 1121, 50, 20)); EP5.setBorder(null); jPanel1.add(EP5, new org.netbeans.lib.awtextra.AbsoluteConstraints(345, 1121, 50, 20)); EP6.setBorder(null); jPanel1.add(EP6, new org.netbeans.lib.awtextra.AbsoluteConstraints(401, 1121, 50, 20)); EP7.setBorder(null); jPanel1.add(EP7, new org.netbeans.lib.awtextra.AbsoluteConstraints(457, 1121, 50, 20)); EP8.setBorder(null); jPanel1.add(EP8, new org.netbeans.lib.awtextra.AbsoluteConstraints(513, 1121, 50, 20)); EP9.setBorder(null); jPanel1.add(EP9, new org.netbeans.lib.awtextra.AbsoluteConstraints(569, 1121, 50, 20)); EP10.setBorder(null); jPanel1.add(EP10, new org.netbeans.lib.awtextra.AbsoluteConstraints(625, 1121, 50, 20)); EP11.setBorder(null); jPanel1.add(EP11, new org.netbeans.lib.awtextra.AbsoluteConstraints(681, 1121, 50, 20)); EP12.setBorder(null); jPanel1.add(EP12, new org.netbeans.lib.awtextra.AbsoluteConstraints(737, 1121, 50, 20)); EP13.setBorder(null); jPanel1.add(EP13, new org.netbeans.lib.awtextra.AbsoluteConstraints(792, 1121, 50, 20)); EP14.setBorder(null); jPanel1.add(EP14, new org.netbeans.lib.awtextra.AbsoluteConstraints(847, 1121, 50, 20)); EP15.setBorder(null); jPanel1.add(EP15, new org.netbeans.lib.awtextra.AbsoluteConstraints(903, 1121, 50, 20)); EP16.setBorder(null); jPanel1.add(EP16, new org.netbeans.lib.awtextra.AbsoluteConstraints(960, 1121, 50, 20)); ER1.setBorder(null); jPanel1.add(ER1, new org.netbeans.lib.awtextra.AbsoluteConstraints(121, 1143, 50, 20)); ER2.setBorder(null); jPanel1.add(ER2, new org.netbeans.lib.awtextra.AbsoluteConstraints(177, 1143, 50, 20)); ER3.setBorder(null); jPanel1.add(ER3, new org.netbeans.lib.awtextra.AbsoluteConstraints(233, 1143, 50, 20)); ER4.setBorder(null); jPanel1.add(ER4, new org.netbeans.lib.awtextra.AbsoluteConstraints(289, 1143, 50, 20)); ER5.setBorder(null); jPanel1.add(ER5, new org.netbeans.lib.awtextra.AbsoluteConstraints(345, 1143, 50, 20)); ER6.setBorder(null); jPanel1.add(ER6, new org.netbeans.lib.awtextra.AbsoluteConstraints(401, 1143, 50, 20)); ER7.setBorder(null); jPanel1.add(ER7, new org.netbeans.lib.awtextra.AbsoluteConstraints(457, 1143, 50, 20)); ER8.setBorder(null); jPanel1.add(ER8, new org.netbeans.lib.awtextra.AbsoluteConstraints(513, 1143, 50, 20)); ER9.setBorder(null); jPanel1.add(ER9, new org.netbeans.lib.awtextra.AbsoluteConstraints(569, 1143, 50, 20)); ER10.setBorder(null); jPanel1.add(ER10, new org.netbeans.lib.awtextra.AbsoluteConstraints(625, 1143, 50, 20)); ER11.setBorder(null); jPanel1.add(ER11, new org.netbeans.lib.awtextra.AbsoluteConstraints(681, 1143, 50, 20)); ER12.setBorder(null); jPanel1.add(ER12, new org.netbeans.lib.awtextra.AbsoluteConstraints(737, 1143, 50, 20)); ER13.setBorder(null); jPanel1.add(ER13, new org.netbeans.lib.awtextra.AbsoluteConstraints(792, 1143, 50, 20)); ER14.setBorder(null); jPanel1.add(ER14, new org.netbeans.lib.awtextra.AbsoluteConstraints(847, 1143, 50, 20)); ER15.setBorder(null); jPanel1.add(ER15, new org.netbeans.lib.awtextra.AbsoluteConstraints(903, 1143, 50, 20)); ER16.setBorder(null); jPanel1.add(ER16, new org.netbeans.lib.awtextra.AbsoluteConstraints(960, 1143, 50, 20)); FS.setBorder(null); FS.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { FSActionPerformed(evt); } }); jPanel1.add(FS, new org.netbeans.lib.awtextra.AbsoluteConstraints(123, 1166, 270, 20)); TotalEstudiantes.setBackground(new java.awt.Color(217, 217, 217)); TotalEstudiantes.setBorder(null); jPanel1.add(TotalEstudiantes, new org.netbeans.lib.awtextra.AbsoluteConstraints(420, 1300, 90, -1)); UnidadesEvaluadasALaFecha.setBackground(new java.awt.Color(217, 217, 217)); UnidadesEvaluadasALaFecha.setBorder(null); jPanel1.add(UnidadesEvaluadasALaFecha, new org.netbeans.lib.awtextra.AbsoluteConstraints(420, 1325, 90, -1)); Aprobados.setBackground(new java.awt.Color(217, 217, 217)); Aprobados.setBorder(null); Aprobados.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { AprobadosActionPerformed(evt); } }); jPanel1.add(Aprobados, new org.netbeans.lib.awtextra.AbsoluteConstraints(420, 1350, 90, -1)); Reprobados.setBackground(new java.awt.Color(217, 217, 217)); Reprobados.setBorder(null); jPanel1.add(Reprobados, new org.netbeans.lib.awtextra.AbsoluteConstraints(420, 1375, 90, -1)); NoAsisten.setBackground(new java.awt.Color(217, 217, 217)); NoAsisten.setBorder(null); jPanel1.add(NoAsisten, new org.netbeans.lib.awtextra.AbsoluteConstraints(420, 1400, 90, -1)); Fondo.setIcon(new javax.swing.ImageIcon( "C:\\Users\\Slayvic\\Documents\\NetBeansProjects\\SeguimientoProgramatico\\src\\seguimientoprogramatico\\Seguimiento.png")); // NOI18N Fondo.setText("jLabel1"); Fondo.setAutoscrolls(true); jPanel1.add(Fondo, new org.netbeans.lib.awtextra.AbsoluteConstraints(0, 0, 1340, -1)); jScrollPane2.setViewportView(jPanel1); getContentPane().add(jScrollPane2, java.awt.BorderLayout.CENTER); Abrir.setText("ABRIR"); Abrir.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { AbrirActionPerformed(evt); } }); jPanel2.add(Abrir); Guardar.setText("GUARDAR"); Guardar.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { GuardarActionPerformed(evt); } }); jPanel2.add(Guardar); PDF.setText(" PDF "); PDF.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { PDFActionPerformed(evt); } }); jPanel2.add(PDF); getContentPane().add(jPanel2, java.awt.BorderLayout.PAGE_START); pack(); }// </editor-fold>//GEN-END:initComponents private void HoraReal1ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_HoraReal1ActionPerformed // TODO add your handling code here: }//GEN-LAST:event_HoraReal1ActionPerformed private void HoraReal2ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_HoraReal2ActionPerformed // TODO add your handling code here: }//GEN-LAST:event_HoraReal2ActionPerformed private void HoraReal3ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_HoraReal3ActionPerformed // TODO add your handling code here: }//GEN-LAST:event_HoraReal3ActionPerformed private void HoraReal4ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_HoraReal4ActionPerformed // TODO add your handling code here: }//GEN-LAST:event_HoraReal4ActionPerformed private void HoraReal5ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_HoraReal5ActionPerformed // TODO add your handling code here: }//GEN-LAST:event_HoraReal5ActionPerformed private void HoraReal10ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_HoraReal10ActionPerformed // TODO add your handling code here: }//GEN-LAST:event_HoraReal10ActionPerformed private void HoraReal9ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_HoraReal9ActionPerformed // TODO add your handling code here: }//GEN-LAST:event_HoraReal9ActionPerformed private void HoraReal8ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_HoraReal8ActionPerformed // TODO add your handling code here: }//GEN-LAST:event_HoraReal8ActionPerformed private void HoraReal7ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_HoraReal7ActionPerformed // TODO add your handling code here: }//GEN-LAST:event_HoraReal7ActionPerformed private void HoraReal6ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_HoraReal6ActionPerformed // TODO add your handling code here: }//GEN-LAST:event_HoraReal6ActionPerformed private void FinReal1ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_FinReal1ActionPerformed // TODO add your handling code here: }//GEN-LAST:event_FinReal1ActionPerformed private void FinReal2ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_FinReal2ActionPerformed // TODO add your handling code here: }//GEN-LAST:event_FinReal2ActionPerformed private void FinReal3ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_FinReal3ActionPerformed // TODO add your handling code here: }//GEN-LAST:event_FinReal3ActionPerformed private void FinReal4ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_FinReal4ActionPerformed // TODO add your handling code here: }//GEN-LAST:event_FinReal4ActionPerformed private void FinReal5ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_FinReal5ActionPerformed // TODO add your handling code here: }//GEN-LAST:event_FinReal5ActionPerformed private void FinReal6ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_FinReal6ActionPerformed // TODO add your handling code here: }//GEN-LAST:event_FinReal6ActionPerformed private void FinReal7ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_FinReal7ActionPerformed // TODO add your handling code here: }//GEN-LAST:event_FinReal7ActionPerformed private void FinReal8ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_FinReal8ActionPerformed // TODO add your handling code here: }//GEN-LAST:event_FinReal8ActionPerformed private void FinReal9ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_FinReal9ActionPerformed // TODO add your handling code here: }//GEN-LAST:event_FinReal9ActionPerformed private void FinReal10ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_FinReal10ActionPerformed // TODO add your handling code here: }//GEN-LAST:event_FinReal10ActionPerformed private void AvanceReal1ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_AvanceReal1ActionPerformed // TODO add your handling code here: }//GEN-LAST:event_AvanceReal1ActionPerformed private void AvanceReal2ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_AvanceReal2ActionPerformed // TODO add your handling code here: }//GEN-LAST:event_AvanceReal2ActionPerformed private void AvanceReal3ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_AvanceReal3ActionPerformed // TODO add your handling code here: }//GEN-LAST:event_AvanceReal3ActionPerformed private void AvanceReal4ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_AvanceReal4ActionPerformed // TODO add your handling code here: }//GEN-LAST:event_AvanceReal4ActionPerformed private void AvanceReal5ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_AvanceReal5ActionPerformed // TODO add your handling code here: }//GEN-LAST:event_AvanceReal5ActionPerformed private void AvanceReal6ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_AvanceReal6ActionPerformed // TODO add your handling code here: }//GEN-LAST:event_AvanceReal6ActionPerformed private void AvanceReal7ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_AvanceReal7ActionPerformed // TODO add your handling code here: }//GEN-LAST:event_AvanceReal7ActionPerformed private void AvanceReal8ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_AvanceReal8ActionPerformed // TODO add your handling code here: }//GEN-LAST:event_AvanceReal8ActionPerformed private void AvanceReal9ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_AvanceReal9ActionPerformed // TODO add your handling code here: }//GEN-LAST:event_AvanceReal9ActionPerformed private void AvanceReal10ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_AvanceReal10ActionPerformed // TODO add your handling code here: }//GEN-LAST:event_AvanceReal10ActionPerformed private void AprobadosActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_AprobadosActionPerformed // TODO add your handling code here: }//GEN-LAST:event_AprobadosActionPerformed private void iniciarLista() { try { Class.forName("com.mysql.jdbc.Driver"); Connection cnx = DriverManager.getConnection("jdbc:mysql://localhost:3306/segumientoprogramatico2", "root", "sql123"); String query = "SELECT grupo FROM segumientoprogramatico2.Materia"; Statement st = cnx.createStatement(); ResultSet rs = st.executeQuery(query); while (rs.next()) { ListaGrupos.addItem(rs.getString(1)); } jPanel2.add(ListaGrupos); cnx.close(); } catch (SQLException ex) { System.out.println(ex.getMessage()); } catch (ClassNotFoundException ex) { System.out.println(ex.getMessage()); } } private void GuardarActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_GuardarActionPerformed String seleccion = ListaGrupos.getSelectedItem().toString(); try { Class.forName("com.mysql.jdbc.Driver"); Connection cnx = DriverManager.getConnection("jdbc:mysql://localhost:3306/segumientoprogramatico2", "root", "sql123"); String query = "SELECT count(Grupo) FROM segumientoprogramatico2.Temas where Grupo = \"" + seleccion + "\" and NumeroTema = 1"; Statement st = cnx.createStatement(); ResultSet rs = st.executeQuery(query); rs.next(); if (rs.getString(1).equals("1")) { query = "update segumientoprogramatico2.Temas set Tema = \"" + Tema1.getText() + "\"," + "HoraProg = \"" + HoraProg1.getText() + "\"," + "InicioProg = \"" + InicioProg1.getText() + "\"," + "FinProg = \"" + FinProg1.getText() + "\"," + "AvanceProg = \"" + AvanceProg1.getText() + "\"," + "HoraReal = \"" + HoraReal1.getText() + "\"," + "InicioReal = \"" + InicioReal1.getText() + "\"," + "FinReal = \"" + FinReal1.getText() + "\"," + "AvanceReal = \"" + AvanceReal1.getText() + "\" where Grupo = \"" + seleccion + "\" and NumeroTema = 1"; System.out.println(query); st = cnx.createStatement(); st.executeUpdate(query); } query = "SELECT count(Grupo) FROM segumientoprogramatico2.Temas where Grupo = \"" + seleccion + "\" and NumeroTema = 2"; st = cnx.createStatement(); rs = st.executeQuery(query); rs.next(); if (rs.getString(1).equals("1")) { query = "update segumientoprogramatico2.Temas set Tema = \"" + Tema2.getText() + "\"," + "HoraProg = \"" + HoraProg2.getText() + "\"," + "InicioProg = \"" + InicioProg2.getText() + "\"," + "FinProg = \"" + FinProg2.getText() + "\"," + "AvanceProg = \"" + AvanceProg2.getText() + "\"," + "HoraReal = \"" + HoraReal2.getText() + "\"," + "InicioReal = \"" + InicioReal2.getText() + "\"," + "FinReal = \"" + FinReal2.getText() + "\"," + "AvanceReal = \"" + AvanceReal2.getText() + "\" where Grupo = \"" + seleccion + "\" and NumeroTema = 2"; System.out.println(query); st = cnx.createStatement(); st.executeUpdate(query); } query = "SELECT count(Grupo) FROM segumientoprogramatico2.Temas where Grupo = \"" + seleccion + "\" and NumeroTema = 3"; st = cnx.createStatement(); rs = st.executeQuery(query); rs.next(); if (rs.getString(1).equals("1")) { query = "update segumientoprogramatico2.Temas set Tema = \"" + Tema3.getText() + "\"," + "HoraProg = \"" + HoraProg3.getText() + "\"," + "InicioProg = \"" + InicioProg3.getText() + "\"," + "FinProg = \"" + FinProg3.getText() + "\"," + "AvanceProg = \"" + AvanceProg3.getText() + "\"," + "HoraReal = \"" + HoraReal3.getText() + "\"," + "InicioReal = \"" + InicioReal3.getText() + "\"," + "FinReal = \"" + FinReal3.getText() + "\"," + "AvanceReal = \"" + AvanceReal3.getText() + "\" where Grupo = \"" + seleccion + "\" and NumeroTema = 3"; System.out.println(query); st = cnx.createStatement(); st.executeUpdate(query); } query = "SELECT count(Grupo) FROM segumientoprogramatico2.Temas where Grupo = \"" + seleccion + "\" and NumeroTema = 4"; st = cnx.createStatement(); rs = st.executeQuery(query); rs.next(); if (rs.getString(1).equals("1")) { query = "update segumientoprogramatico2.Temas set Tema = \"" + Tema4.getText() + "\"," + "HoraProg = \"" + HoraProg4.getText() + "\"," + "InicioProg = \"" + InicioProg4.getText() + "\"," + "FinProg = \"" + FinProg4.getText() + "\"," + "AvanceProg = \"" + AvanceProg4.getText() + "\"," + "HoraReal = \"" + HoraReal4.getText() + "\"," + "InicioReal = \"" + InicioReal4.getText() + "\"," + "FinReal = \"" + FinReal4.getText() + "\"," + "AvanceReal = \"" + AvanceReal4.getText() + "\" where Grupo = \"" + seleccion + "\" and NumeroTema = 4"; System.out.println(query); st = cnx.createStatement(); st.executeUpdate(query); } query = "SELECT count(Grupo) FROM segumientoprogramatico2.Temas where Grupo = \"" + seleccion + "\" and NumeroTema = 5"; st = cnx.createStatement(); rs = st.executeQuery(query); rs.next(); if (rs.getString(1).equals("1")) { query = "update segumientoprogramatico2.Temas set Tema = \"" + Tema5.getText() + "\"," + "HoraProg = \"" + HoraProg5.getText() + "\"," + "InicioProg = \"" + InicioProg5.getText() + "\"," + "FinProg = \"" + FinProg5.getText() + "\"," + "AvanceProg = \"" + AvanceProg5.getText() + "\"," + "HoraReal = \"" + HoraReal5.getText() + "\"," + "InicioReal = \"" + InicioReal5.getText() + "\"," + "FinReal = \"" + FinReal5.getText() + "\"," + "AvanceReal = \"" + AvanceReal5.getText() + "\" where Grupo = \"" + seleccion + "\" and NumeroTema = 5"; System.out.println(query); st = cnx.createStatement(); st.executeUpdate(query); } query = "SELECT count(Grupo) FROM segumientoprogramatico2.Temas where Grupo = \"" + seleccion + "\" and NumeroTema = 6"; st = cnx.createStatement(); rs = st.executeQuery(query); rs.next(); if (rs.getString(1).equals("1")) { query = "update segumientoprogramatico2.Temas set Tema = \"" + Tema6.getText() + "\"," + "HoraProg = \"" + HoraProg6.getText() + "\"," + "InicioProg = \"" + InicioProg6.getText() + "\"," + "FinProg = \"" + FinProg6.getText() + "\"," + "AvanceProg = \"" + AvanceProg6.getText() + "\"," + "HoraReal = \"" + HoraReal6.getText() + "\"," + "InicioReal = \"" + InicioReal6.getText() + "\"," + "FinReal = \"" + FinReal6.getText() + "\"," + "AvanceReal = \"" + AvanceReal6.getText() + "\" where Grupo = \"" + seleccion + "\" and NumeroTema = 6"; System.out.println(query); st = cnx.createStatement(); st.executeUpdate(query); } query = "SELECT count(Grupo) FROM segumientoprogramatico2.Temas where Grupo = \"" + seleccion + "\" and NumeroTema = 7"; st = cnx.createStatement(); rs = st.executeQuery(query); rs.next(); if (rs.getString(1).equals("1")) { query = "update segumientoprogramatico2.Temas set Tema = \"" + Tema7.getText() + "\"," + "HoraProg = \"" + HoraProg7.getText() + "\"," + "InicioProg = \"" + InicioProg7.getText() + "\"," + "FinProg = \"" + FinProg7.getText() + "\"," + "AvanceProg = \"" + AvanceProg7.getText() + "\"," + "HoraReal = \"" + HoraReal7.getText() + "\"," + "InicioReal = \"" + InicioReal7.getText() + "\"," + "FinReal = \"" + FinReal7.getText() + "\"," + "AvanceReal = \"" + AvanceReal7.getText() + "\" where Grupo = \"" + seleccion + "\" and NumeroTema = 7"; System.out.println(query); st = cnx.createStatement(); st.executeUpdate(query); } query = "SELECT count(Grupo) FROM segumientoprogramatico2.Temas where Grupo = \"" + seleccion + "\" and NumeroTema = 8"; st = cnx.createStatement(); rs = st.executeQuery(query); rs.next(); if (rs.getString(1).equals("1")) { query = "update segumientoprogramatico2.Temas set Tema = \"" + Tema8.getText() + "\"," + "HoraProg = \"" + HoraProg8.getText() + "\"," + "InicioProg = \"" + InicioProg8.getText() + "\"," + "FinProg = \"" + FinProg8.getText() + "\"," + "AvanceProg = \"" + AvanceProg8.getText() + "\"," + "HoraReal = \"" + HoraReal8.getText() + "\"," + "InicioReal = \"" + InicioReal8.getText() + "\"," + "FinReal = \"" + FinReal8.getText() + "\"," + "AvanceReal = \"" + AvanceReal8.getText() + "\" where Grupo = \"" + seleccion + "\" and NumeroTema = 8"; System.out.println(query); st = cnx.createStatement(); st.executeUpdate(query); } query = "SELECT count(Grupo) FROM segumientoprogramatico2.Temas where Grupo = \"" + seleccion + "\" and NumeroTema = 9"; st = cnx.createStatement(); rs = st.executeQuery(query); rs.next(); if (rs.getString(1).equals("1")) { query = "update segumientoprogramatico2.Temas set Tema = \"" + Tema9.getText() + "\"," + "HoraProg = \"" + HoraProg9.getText() + "\"," + "InicioProg = \"" + InicioProg9.getText() + "\"," + "FinProg = \"" + FinProg9.getText() + "\"," + "AvanceProg = \"" + AvanceProg9.getText() + "\"," + "HoraReal = \"" + HoraReal9.getText() + "\"," + "InicioReal = \"" + InicioReal9.getText() + "\"," + "FinReal = \"" + FinReal9.getText() + "\"," + "AvanceReal = \"" + AvanceReal9.getText() + "\" where Grupo = \"" + seleccion + "\" and NumeroTema = 9"; System.out.println(query); st = cnx.createStatement(); st.executeUpdate(query); } query = "SELECT count(Grupo) FROM segumientoprogramatico2.Temas where Grupo = \"" + seleccion + "\" and NumeroTema = 10"; st = cnx.createStatement(); rs = st.executeQuery(query); rs.next(); if (rs.getString(1).equals("1")) { query = "update segumientoprogramatico2.Temas set Tema = \"" + Tema10.getText() + "\"," + "HoraProg = \"" + HoraProg10.getText() + "\"," + "InicioProg = \"" + InicioProg10.getText() + "\"," + "FinProg = \"" + FinProg10.getText() + "\"," + "AvanceProg = \"" + AvanceProg10.getText() + "\"," + "HoraReal = \"" + HoraReal10.getText() + "\"," + "InicioReal = \"" + InicioReal10.getText() + "\"," + "FinReal = \"" + FinReal10.getText() + "\"," + "AvanceReal = \"" + AvanceReal10.getText() + "\" where Grupo = \"" + seleccion + "\" and NumeroTema = 10"; System.out.println(query); st = cnx.createStatement(); st.executeUpdate(query); } //LLENAR PRACTICA query = "SELECT count(Grupo) FROM segumientoprogramatico2.fecha_pract where Grupo = \"" + seleccion + "\" and NumPractica = 1"; st = cnx.createStatement(); rs = st.executeQuery(query); rs.next(); if (rs.getString(1).equals("1")) { String fecha1 = ""; if (FechaRealizada1.getText().equals("")) { fecha1 = "1111-11-11"; } else { fecha1 = FechaRealizada1.getText(); } query = "update segumientoprogramatico2.fecha_pract set Practica = \"" + Practica1.getText() + "\", " + "unidad = \"" + Unidad1.getText() + "\", " + "FechaProg = \"" + FechaProgramada1.getText() + "\"," + "FechaReal = \"" + fecha1 + "\" where Grupo = \"" + seleccion + "\" and NumPractica = 1"; st = cnx.createStatement(); st.executeUpdate(query); } query = "SELECT count(Grupo) FROM segumientoprogramatico2.fecha_pract where Grupo = \"" + seleccion + "\" and NumPractica = 2"; st = cnx.createStatement(); rs = st.executeQuery(query); rs.next(); if (rs.getString(1).equals("1")) { String fecha2 = ""; if (FechaRealizada2.getText().equals("")) { fecha2 = "1111-11-11"; } else { fecha2 = FechaRealizada2.getText(); } query = "update segumientoprogramatico2.fecha_pract set Practica = \"" + Practica2.getText() + "\", " + "unidad = \"" + Unidad2.getText() + "\", " + "FechaProg = \"" + FechaProgramada2.getText() + "\"," + "FechaReal = \"" + fecha2 + "\" where Grupo = \"" + seleccion + "\" and NumPractica = 2"; st = cnx.createStatement(); st.executeUpdate(query); } query = "SELECT count(Grupo) FROM segumientoprogramatico2.fecha_pract where Grupo = \"" + seleccion + "\" and NumPractica = 3"; st = cnx.createStatement(); rs = st.executeQuery(query); rs.next(); if (rs.getString(1).equals("1")) { String fecha3 = ""; if (FechaRealizada3.getText().equals("")) { fecha3 = "1111-11-11"; } else { fecha3 = FechaRealizada3.getText(); } query = "update segumientoprogramatico2.fecha_pract set Practica = \"" + Practica3.getText() + "\", " + "unidad = \"" + Unidad3.getText() + "\", " + "FechaProg = \"" + FechaProgramada3.getText() + "\"," + "FechaReal = \"" + fecha3 + "\" where Grupo = \"" + seleccion + "\" and NumPractica = 3"; st = cnx.createStatement(); st.executeUpdate(query); } query = "SELECT count(Grupo) FROM segumientoprogramatico2.fecha_pract where Grupo = \"" + seleccion + "\" and NumPractica = 4"; st = cnx.createStatement(); rs = st.executeQuery(query); rs.next(); if (rs.getString(1).equals("1")) { String fecha4 = ""; if (FechaRealizada4.getText().equals("")) { fecha4 = "1111-11-11"; } else { fecha4 = FechaRealizada4.getText(); } query = "update segumientoprogramatico2.fecha_pract set Practica = \"" + Practica4.getText() + "\", " + "unidad = \"" + Unidad4.getText() + "\", " + "FechaProg = \"" + FechaProgramada4.getText() + "\"," + "FechaReal = \"" + fecha4 + "\" where Grupo = \"" + seleccion + "\" and NumPractica = 4"; st = cnx.createStatement(); st.executeUpdate(query); } //VISITA query = "SELECT count(Grupo) FROM segumientoprogramatico2.visitas where Grupo = \"" + seleccion + "\""; st = cnx.createStatement(); rs = st.executeQuery(query); rs.next(); if (rs.getString(1).equals("1")) { String fecha1 = ""; String fecha2 = ""; if (FechaProgramadaVisita.getText().equals("")) { fecha1 = "1111-11-11"; } else { fecha1 = FechaProgramadaVisita.getText(); } if (FechaRealizadaVisita.getText().equals("")) { fecha2 = "1111-11-11"; } else { fecha2 = FechaRealizadaVisita.getText(); } query = "update segumientoprogramatico2.visitas set NombreEmpresa = \"" + NombreEmpresa.getText() + "\", " + "UnidadTematica = \"" + UnidadTematica.getText() + "\", " + "FechaProgramadaVisita = \"" + fecha1 + "\", " + "FechaRealizadaVisita = \"" + fecha2 + "\" where Grupo = \"" + seleccion + "\""; st = cnx.createStatement(); st.executeUpdate(query); } //PROGRAMA query = "select count(*) from segumientoprogramatico2.programa where grupo = \"" + seleccion + "\" and Semana = 1"; st = cnx.createStatement(); rs = st.executeQuery(query); rs.next(); if (rs.getString(1).equals("1")) { query = "update segumientoprogramatico2.programa set Unidad = " + EVUnidad1.getText() + "," + "TP = \"" + TP1.getText() + "\"," + "TR = \"" + TR1.getText() + "\"," + "EP = \"" + EP1.getText() + "\"," + "ER = \"" + ER1.getText() + "\"," + "FS = \"" + FS.getText() + "\" where grupo = \"" + seleccion + "\" and Semana = 1"; st = cnx.createStatement(); st.executeUpdate(query); } query = "select count(*) from segumientoprogramatico2.programa where grupo = \"" + seleccion + "\" and Semana = 2"; st = cnx.createStatement(); rs = st.executeQuery(query); rs.next(); if (rs.getString(1).equals("1")) { query = "update segumientoprogramatico2.programa set Unidad = " + EVUnidad2.getText() + "," + "TP = \"" + TP2.getText() + "\"," + "TR = \"" + TR2.getText() + "\"," + "EP = \"" + EP2.getText() + "\"," + "ER = \"" + ER2.getText() + "\"," + "FS = \"" + FS.getText() + "\" where grupo = \"" + seleccion + "\" and Semana = 2"; st = cnx.createStatement(); st.executeUpdate(query); } query = "select count(*) from segumientoprogramatico2.programa where grupo = \"" + seleccion + "\" and Semana = 3"; st = cnx.createStatement(); rs = st.executeQuery(query); rs.next(); if (rs.getString(1).equals("1")) { query = "update segumientoprogramatico2.programa set Unidad = " + EVUnidad3.getText() + "," + "TP = \"" + TP3.getText() + "\"," + "TR = \"" + TR3.getText() + "\"," + "EP = \"" + EP3.getText() + "\"," + "ER = \"" + ER3.getText() + "\"," + "FS = \"" + FS.getText() + "\" where grupo = \"" + seleccion + "\" and Semana = 3"; st = cnx.createStatement(); st.executeUpdate(query); } query = "select count(*) from segumientoprogramatico2.programa where grupo = \"" + seleccion + "\" and Semana = 4"; st = cnx.createStatement(); rs = st.executeQuery(query); rs.next(); if (rs.getString(1).equals("1")) { query = "update segumientoprogramatico2.programa set Unidad = " + EVUnidad4.getText() + "," + "TP = \"" + TP4.getText() + "\"," + "TR = \"" + TR4.getText() + "\"," + "EP = \"" + EP4.getText() + "\"," + "ER = \"" + ER4.getText() + "\"," + "FS = \"" + FS.getText() + "\" where grupo = \"" + seleccion + "\" and Semana = 4"; st = cnx.createStatement(); st.executeUpdate(query); } query = "select count(*) from segumientoprogramatico2.programa where grupo = \"" + seleccion + "\" and Semana = 5"; st = cnx.createStatement(); rs = st.executeQuery(query); rs.next(); if (rs.getString(1).equals("1")) { query = "update segumientoprogramatico2.programa set Unidad = " + EVUnidad5.getText() + "," + "TP = \"" + TP5.getText() + "\"," + "TR = \"" + TR5.getText() + "\"," + "EP = \"" + EP5.getText() + "\"," + "ER = \"" + ER5.getText() + "\"," + "FS = \"" + FS.getText() + "\" where grupo = \"" + seleccion + "\" and Semana = 5"; st = cnx.createStatement(); st.executeUpdate(query); } query = "select count(*) from segumientoprogramatico2.programa where grupo = \"" + seleccion + "\" and Semana = 6"; st = cnx.createStatement(); rs = st.executeQuery(query); rs.next(); if (rs.getString(1).equals("1")) { query = "update segumientoprogramatico2.programa set Unidad = " + EVUnidad6.getText() + "," + "TP = \"" + TP6.getText() + "\"," + "TR = \"" + TR6.getText() + "\"," + "EP = \"" + EP6.getText() + "\"," + "ER = \"" + ER6.getText() + "\"," + "FS = \"" + FS.getText() + "\" where grupo = \"" + seleccion + "\" and Semana = 6"; st = cnx.createStatement(); st.executeUpdate(query); } query = "select count(*) from segumientoprogramatico2.programa where grupo = \"" + seleccion + "\" and Semana = 7"; st = cnx.createStatement(); rs = st.executeQuery(query); rs.next(); if (rs.getString(1).equals("1")) { query = "update segumientoprogramatico2.programa set Unidad = " + EVUnidad7.getText() + "," + "TP = \"" + TP7.getText() + "\"," + "TR = \"" + TR7.getText() + "\"," + "EP = \"" + EP7.getText() + "\"," + "ER = \"" + ER7.getText() + "\"," + "FS = \"" + FS.getText() + "\" where grupo = \"" + seleccion + "\" and Semana = 7"; st = cnx.createStatement(); st.executeUpdate(query); } query = "select count(*) from segumientoprogramatico2.programa where grupo = \"" + seleccion + "\" and Semana = 9"; st = cnx.createStatement(); rs = st.executeQuery(query); rs.next(); if (rs.getString(1).equals("1")) { query = "update segumientoprogramatico2.programa set Unidad = " + EVUnidad9.getText() + "," + "TP = \"" + TP9.getText() + "\"," + "TR = \"" + TR9.getText() + "\"," + "EP = \"" + EP9.getText() + "\"," + "ER = \"" + ER9.getText() + "\"," + "FS = \"" + FS.getText() + "\" where grupo = \"" + seleccion + "\" and Semana = 9"; st = cnx.createStatement(); st.executeUpdate(query); } query = "select count(*) from segumientoprogramatico2.programa where grupo = \"" + seleccion + "\" and Semana = 10"; st = cnx.createStatement(); rs = st.executeQuery(query); rs.next(); if (rs.getString(1).equals("1")) { query = "update segumientoprogramatico2.programa set Unidad = " + EVUnidad10.getText() + "," + "TP = \"" + TP10.getText() + "\"," + "TR = \"" + TR10.getText() + "\"," + "EP = \"" + EP10.getText() + "\"," + "ER = \"" + ER10.getText() + "\"," + "FS = \"" + FS.getText() + "\" where grupo = \"" + seleccion + "\" and Semana = 10"; st = cnx.createStatement(); st.executeUpdate(query); } query = "select count(*) from segumientoprogramatico2.programa where grupo = \"" + seleccion + "\" and Semana = 11"; st = cnx.createStatement(); rs = st.executeQuery(query); rs.next(); if (rs.getString(1).equals("1")) { query = "update segumientoprogramatico2.programa set Unidad = " + EVUnidad11.getText() + "," + "TP = \"" + TP11.getText() + "\"," + "TR = \"" + TR11.getText() + "\"," + "EP = \"" + EP11.getText() + "\"," + "ER = \"" + ER11.getText() + "\"," + "FS = \"" + FS.getText() + "\" where grupo = \"" + seleccion + "\" and Semana = 11"; st = cnx.createStatement(); st.executeUpdate(query); } query = "select count(*) from segumientoprogramatico2.programa where grupo = \"" + seleccion + "\" and Semana = 12"; st = cnx.createStatement(); rs = st.executeQuery(query); rs.next(); if (rs.getString(1).equals("1")) { query = "update segumientoprogramatico2.programa set Unidad = " + EVUnidad12.getText() + "," + "TP = \"" + TP12.getText() + "\"," + "TR = \"" + TR12.getText() + "\"," + "EP = \"" + EP12.getText() + "\"," + "ER = \"" + ER12.getText() + "\"," + "FS = \"" + FS.getText() + "\" where grupo = \"" + seleccion + "\" and Semana = 12"; st = cnx.createStatement(); st.executeUpdate(query); } query = "select count(*) from segumientoprogramatico2.programa where grupo = \"" + seleccion + "\" and Semana = 13"; st = cnx.createStatement(); rs = st.executeQuery(query); rs.next(); if (rs.getString(1).equals("1")) { query = "update segumientoprogramatico2.programa set Unidad = " + EVUnidad13.getText() + "," + "TP = \"" + TP13.getText() + "\"," + "TR = \"" + TR13.getText() + "\"," + "EP = \"" + EP13.getText() + "\"," + "ER = \"" + ER13.getText() + "\"," + "FS = \"" + FS.getText() + "\" where grupo = \"" + seleccion + "\" and Semana = 13"; st = cnx.createStatement(); st.executeUpdate(query); } query = "select count(*) from segumientoprogramatico2.programa where grupo = \"" + seleccion + "\" and Semana = 14"; st = cnx.createStatement(); rs = st.executeQuery(query); rs.next(); if (rs.getString(1).equals("1")) { query = "update segumientoprogramatico2.programa set Unidad = " + EVUnidad14.getText() + "," + "TP = \"" + TP14.getText() + "\"," + "TR = \"" + TR14.getText() + "\"," + "EP = \"" + EP14.getText() + "\"," + "ER = \"" + ER14.getText() + "\"," + "FS = \"" + FS.getText() + "\" where grupo = \"" + seleccion + "\" and Semana = 14"; st = cnx.createStatement(); st.executeUpdate(query); } query = "select count(*) from segumientoprogramatico2.programa where grupo = \"" + seleccion + "\" and Semana = 15"; st = cnx.createStatement(); rs = st.executeQuery(query); rs.next(); if (rs.getString(1).equals("1")) { query = "update segumientoprogramatico2.programa set Unidad = " + EVUnidad15.getText() + "," + "TP = \"" + TP15.getText() + "\"," + "TR = \"" + TR15.getText() + "\"," + "EP = \"" + EP15.getText() + "\"," + "ER = \"" + ER15.getText() + "\"," + "FS = \"" + FS.getText() + "\" where grupo = \"" + seleccion + "\" and Semana = 15"; st = cnx.createStatement(); st.executeUpdate(query); } query = "select count(*) from segumientoprogramatico2.programa where grupo = \"" + seleccion + "\" and Semana = 16"; st = cnx.createStatement(); rs = st.executeQuery(query); rs.next(); if (rs.getString(1).equals("1")) { query = "update segumientoprogramatico2.programa set Unidad = " + EVUnidad16.getText() + "," + "TP = \"" + TP16.getText() + "\"," + "TR = \"" + TR16.getText() + "\"," + "EP = \"" + EP16.getText() + "\"," + "ER = \"" + ER16.getText() + "\"," + "FS = \"" + FS.getText() + "\" where grupo = \"" + seleccion + "\" and Semana = 16"; st = cnx.createStatement(); st.executeUpdate(query); } } catch (SQLException ex) { System.out.println(ex.getMessage()); } catch (ClassNotFoundException ex) { System.out.println(ex.getMessage()); } }//GEN-LAST:event_GuardarActionPerformed private void AbrirActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_AbrirActionPerformed String seleccion = ListaGrupos.getSelectedItem().toString(); try { Class.forName("com.mysql.jdbc.Driver"); Connection cnx = DriverManager.getConnection("jdbc:mysql://localhost:3306/segumientoprogramatico2", "root", "sql123"); String query = "SELECT * FROM segumientoprogramatico2.Materia where grupo = \"" + seleccion + "\""; System.out.println(query); Statement st = cnx.createStatement(); ResultSet rs = st.executeQuery(query); rs.next(); Materia.setText(rs.getString(1)); Catedratico.setText(rs.getString(2)); Carrera.setText(rs.getString(3)); Grupo.setText(rs.getString(4)); LunesInicio.setText(rs.getString(5)); LunesFin.setText(rs.getString(6)); MartesInicio.setText(rs.getString(7)); MartesFin.setText(rs.getString(8)); MiercolesInicio.setText(rs.getString(9)); MiercolesFIn.setText(rs.getString(10)); JuevesInicio.setText(rs.getString(11)); JuevesFin.setText(rs.getString(12)); ViernesInicio.setText(rs.getString(13)); ViernesFin.setText(rs.getString(14)); TotalEstudiantes.setText(rs.getString(15)); UnidadesEvaluadasALaFecha.setText(rs.getString(16)); Aprobados.setText(rs.getString(17)); Reprobados.setText(rs.getString(18)); NoAsisten.setText(rs.getString(19)); query = "SELECT count(Grupo) FROM segumientoprogramatico2.Temas where Grupo = \"" + seleccion + "\" and NumeroTema = 1"; st = cnx.createStatement(); rs = st.executeQuery(query); rs.next(); if (rs.getString(1).equals("1")) { query = "SELECT * FROM segumientoprogramatico2.Temas where Grupo = \"" + seleccion + "\" and NumeroTema = 1"; st = cnx.createStatement(); rs = st.executeQuery(query); rs.next(); Tema1.setText(rs.getString(3)); HoraProg1.setText(rs.getString(4)); InicioProg1.setText(rs.getString(5)); FinProg1.setText(rs.getString(6)); AvanceProg1.setText(rs.getString(7)); HoraReal1.setText(rs.getString(8)); InicioReal1.setText(rs.getString(9)); FinReal1.setText(rs.getString(10)); AvanceReal1.setText(rs.getString(11)); } query = "SELECT count(Grupo) FROM segumientoprogramatico2.Temas where Grupo = \"" + seleccion + "\" and NumeroTema = 2"; st = cnx.createStatement(); rs = st.executeQuery(query); rs.next(); if (rs.getString(1).equals("1")) { query = "SELECT * FROM segumientoprogramatico2.Temas where Grupo = \"" + seleccion + "\" and NumeroTema = 2"; st = cnx.createStatement(); rs = st.executeQuery(query); rs.next(); Tema2.setText(rs.getString(3)); HoraProg2.setText(rs.getString(4)); InicioProg2.setText(rs.getString(5)); FinProg2.setText(rs.getString(6)); AvanceProg2.setText(rs.getString(7)); HoraReal2.setText(rs.getString(8)); InicioReal2.setText(rs.getString(9)); FinReal2.setText(rs.getString(10)); AvanceReal2.setText(rs.getString(11)); } query = "SELECT count(Grupo) FROM segumientoprogramatico2.Temas where Grupo = \"" + seleccion + "\" and NumeroTema = 3"; st = cnx.createStatement(); rs = st.executeQuery(query); rs.next(); if (rs.getString(1).equals("1")) { query = "SELECT * FROM segumientoprogramatico2.Temas where Grupo = \"" + seleccion + "\" and NumeroTema = 3"; st = cnx.createStatement(); rs = st.executeQuery(query); rs.next(); Tema3.setText(rs.getString(3)); HoraProg3.setText(rs.getString(4)); InicioProg3.setText(rs.getString(5)); FinProg3.setText(rs.getString(6)); AvanceProg3.setText(rs.getString(7)); HoraReal3.setText(rs.getString(8)); InicioReal3.setText(rs.getString(9)); FinReal3.setText(rs.getString(10)); AvanceReal3.setText(rs.getString(11)); } query = "SELECT count(Grupo) FROM segumientoprogramatico2.Temas where Grupo = \"" + seleccion + "\" and NumeroTema = 4"; st = cnx.createStatement(); rs = st.executeQuery(query); rs.next(); if (rs.getString(1).equals("1")) { query = "SELECT * FROM segumientoprogramatico2.Temas where Grupo = \"" + seleccion + "\" and NumeroTema = 4"; st = cnx.createStatement(); rs = st.executeQuery(query); rs.next(); Tema4.setText(rs.getString(3)); HoraProg4.setText(rs.getString(4)); InicioProg4.setText(rs.getString(5)); FinProg4.setText(rs.getString(6)); AvanceProg4.setText(rs.getString(7)); HoraReal4.setText(rs.getString(8)); InicioReal4.setText(rs.getString(9)); FinReal4.setText(rs.getString(10)); AvanceReal4.setText(rs.getString(11)); } query = "SELECT count(Grupo) FROM segumientoprogramatico2.Temas where Grupo = \"" + seleccion + "\" and NumeroTema = 5"; st = cnx.createStatement(); rs = st.executeQuery(query); rs.next(); if (rs.getString(1).equals("1")) { query = "SELECT * FROM segumientoprogramatico2.Temas where Grupo = \"" + seleccion + "\" and NumeroTema = 5"; st = cnx.createStatement(); rs = st.executeQuery(query); rs.next(); Tema5.setText(rs.getString(3)); HoraProg5.setText(rs.getString(4)); InicioProg5.setText(rs.getString(5)); FinProg5.setText(rs.getString(6)); AvanceProg5.setText(rs.getString(7)); HoraReal5.setText(rs.getString(8)); InicioReal5.setText(rs.getString(9)); FinReal5.setText(rs.getString(10)); AvanceReal5.setText(rs.getString(11)); } query = "SELECT count(Grupo) FROM segumientoprogramatico2.Temas where Grupo = \"" + seleccion + "\" and NumeroTema = 6"; st = cnx.createStatement(); rs = st.executeQuery(query); rs.next(); if (rs.getString(1).equals("1")) { query = "SELECT * FROM segumientoprogramatico2.Temas where Grupo = \"" + seleccion + "\" and NumeroTema = 6"; st = cnx.createStatement(); rs = st.executeQuery(query); rs.next(); Tema6.setText(rs.getString(3)); HoraProg6.setText(rs.getString(4)); InicioProg6.setText(rs.getString(5)); FinProg6.setText(rs.getString(6)); AvanceProg6.setText(rs.getString(7)); HoraReal6.setText(rs.getString(8)); InicioReal6.setText(rs.getString(9)); FinReal6.setText(rs.getString(10)); AvanceReal6.setText(rs.getString(11)); } query = "SELECT count(Grupo) FROM segumientoprogramatico2.Temas where Grupo = \"" + seleccion + "\" and NumeroTema = 7"; st = cnx.createStatement(); rs = st.executeQuery(query); rs.next(); if (rs.getString(1).equals("1")) { query = "SELECT * FROM segumientoprogramatico2.Temas where Grupo = \"" + seleccion + "\" and NumeroTema = 7"; st = cnx.createStatement(); rs = st.executeQuery(query); rs.next(); Tema7.setText(rs.getString(3)); HoraProg7.setText(rs.getString(4)); InicioProg7.setText(rs.getString(5)); FinProg7.setText(rs.getString(6)); AvanceProg7.setText(rs.getString(7)); HoraReal7.setText(rs.getString(8)); InicioReal7.setText(rs.getString(9)); FinReal7.setText(rs.getString(10)); AvanceReal7.setText(rs.getString(11)); } query = "SELECT count(Grupo) FROM segumientoprogramatico2.Temas where Grupo = \"" + seleccion + "\" and NumeroTema = 8"; st = cnx.createStatement(); rs = st.executeQuery(query); rs.next(); if (rs.getString(1).equals("1")) { query = "SELECT * FROM segumientoprogramatico2.Temas where Grupo = \"" + seleccion + "\" and NumeroTema = 8"; st = cnx.createStatement(); rs = st.executeQuery(query); rs.next(); Tema8.setText(rs.getString(3)); HoraProg8.setText(rs.getString(4)); InicioProg8.setText(rs.getString(5)); FinProg8.setText(rs.getString(6)); AvanceProg8.setText(rs.getString(7)); HoraReal8.setText(rs.getString(8)); InicioReal8.setText(rs.getString(9)); FinReal8.setText(rs.getString(10)); AvanceReal8.setText(rs.getString(11)); } query = "SELECT count(Grupo) FROM segumientoprogramatico2.Temas where Grupo = \"" + seleccion + "\" and NumeroTema = 9"; st = cnx.createStatement(); rs = st.executeQuery(query); rs.next(); if (rs.getString(1).equals("1")) { query = "SELECT * FROM segumientoprogramatico2.Temas where Grupo = \"" + seleccion + "\" and NumeroTema = 9"; st = cnx.createStatement(); rs = st.executeQuery(query); rs.next(); Tema9.setText(rs.getString(3)); HoraProg9.setText(rs.getString(4)); InicioProg9.setText(rs.getString(5)); FinProg9.setText(rs.getString(6)); AvanceProg9.setText(rs.getString(7)); HoraReal9.setText(rs.getString(8)); InicioReal9.setText(rs.getString(9)); FinReal9.setText(rs.getString(10)); AvanceReal9.setText(rs.getString(11)); } query = "SELECT count(Grupo) FROM segumientoprogramatico2.Temas where Grupo = \"" + seleccion + "\" and NumeroTema = 10"; st = cnx.createStatement(); rs = st.executeQuery(query); rs.next(); if (rs.getString(1).equals("1")) { query = "SELECT * FROM segumientoprogramatico2.Temas where Grupo = \"" + seleccion + "\" and NumeroTema = 10"; st = cnx.createStatement(); rs = st.executeQuery(query); rs.next(); Tema10.setText(rs.getString(3)); HoraProg10.setText(rs.getString(4)); InicioProg10.setText(rs.getString(5)); FinProg10.setText(rs.getString(6)); AvanceProg10.setText(rs.getString(7)); HoraReal10.setText(rs.getString(8)); InicioReal10.setText(rs.getString(9)); FinReal10.setText(rs.getString(10)); AvanceReal10.setText(rs.getString(11)); } //LLENAR PRACTICA query = "SELECT count(Grupo) FROM segumientoprogramatico2.fecha_pract where Grupo = \"" + seleccion + "\" and NumPractica = 1"; st = cnx.createStatement(); rs = st.executeQuery(query); rs.next(); if (rs.getString(1).equals("1")) { query = "SELECT * FROM segumientoprogramatico2.fecha_pract where Grupo = \"" + seleccion + "\" and NumPractica = 1"; st = cnx.createStatement(); rs = st.executeQuery(query); rs.next(); Practica1.setText(rs.getString(3)); Unidad1.setText(rs.getString(4)); FechaProgramada1.setText(rs.getString(5)); FechaRealizada1.setText(rs.getString(6)); } query = "SELECT count(Grupo) FROM segumientoprogramatico2.fecha_pract where Grupo = \"" + seleccion + "\" and NumPractica = 2"; st = cnx.createStatement(); rs = st.executeQuery(query); rs.next(); if (rs.getString(1).equals("1")) { query = "SELECT * FROM segumientoprogramatico2.fecha_pract where Grupo = \"" + seleccion + "\" and NumPractica = 2"; st = cnx.createStatement(); rs = st.executeQuery(query); rs.next(); Practica2.setText(rs.getString(3)); Unidad2.setText(rs.getString(4)); FechaProgramada2.setText(rs.getString(5)); FechaRealizada2.setText(rs.getString(6)); } query = "SELECT count(Grupo) FROM segumientoprogramatico2.fecha_pract where Grupo = \"" + seleccion + "\" and NumPractica = 3"; st = cnx.createStatement(); rs = st.executeQuery(query); rs.next(); if (rs.getString(1).equals("1")) { query = "SELECT * FROM segumientoprogramatico2.fecha_pract where Grupo = \"" + seleccion + "\" and NumPractica = 3"; st = cnx.createStatement(); rs = st.executeQuery(query); rs.next(); Practica3.setText(rs.getString(3)); Unidad3.setText(rs.getString(4)); FechaProgramada3.setText(rs.getString(5)); FechaRealizada3.setText(rs.getString(6)); } query = "SELECT count(Grupo) FROM segumientoprogramatico2.fecha_pract where Grupo = \"" + seleccion + "\" and NumPractica = 4"; st = cnx.createStatement(); rs = st.executeQuery(query); rs.next(); if (rs.getString(1).equals("1")) { query = "SELECT * FROM segumientoprogramatico2.fecha_pract where Grupo = \"" + seleccion + "\" and NumPractica = 4"; st = cnx.createStatement(); rs = st.executeQuery(query); rs.next(); Practica4.setText(rs.getString(3)); Unidad4.setText(rs.getString(4)); FechaProgramada4.setText(rs.getString(5)); FechaRealizada4.setText(rs.getString(6)); } //VISITA query = "SELECT count(Grupo) FROM segumientoprogramatico2.visitas where Grupo = \"" + seleccion + "\""; st = cnx.createStatement(); rs = st.executeQuery(query); rs.next(); if (rs.getString(1).equals("1")) { query = "SELECT * FROM segumientoprogramatico2.visitas where Grupo = \"" + seleccion + "\""; st = cnx.createStatement(); rs = st.executeQuery(query); rs.next(); NombreEmpresa.setText(rs.getString(2)); UnidadTematica.setText(rs.getString(3)); FechaProgramadaVisita.setText(rs.getString(4)); FechaRealizadaVisita.setText(rs.getString(5)); } //PROGRAMA query = "select count(*) from segumientoprogramatico2.programa where grupo = \"" + seleccion + "\" and Semana = 1"; st = cnx.createStatement(); rs = st.executeQuery(query); rs.next(); if (rs.getString(1).equals("1")) { query = "select * from segumientoprogramatico2.programa where grupo = \"" + seleccion + "\" and Semana = 1"; st = cnx.createStatement(); rs = st.executeQuery(query); rs.next(); EVUnidad1.setText(rs.getString(3)); TP1.setText(rs.getString(4)); TR1.setText(rs.getString(5)); EP1.setText(rs.getString(6)); ER1.setText(rs.getString(7)); FS.setText(rs.getString(8)); } query = "select count(*) from segumientoprogramatico2.programa where grupo = \"" + seleccion + "\" and Semana = 2"; st = cnx.createStatement(); rs = st.executeQuery(query); rs.next(); if (rs.getString(1).equals("1")) { query = "select * from segumientoprogramatico2.programa where grupo = \"" + seleccion + "\" and Semana = 2"; st = cnx.createStatement(); rs = st.executeQuery(query); rs.next(); EVUnidad2.setText(rs.getString(3)); TP2.setText(rs.getString(4)); TR2.setText(rs.getString(5)); EP2.setText(rs.getString(6)); ER2.setText(rs.getString(7)); } query = "select count(*) from segumientoprogramatico2.programa where grupo = \"" + seleccion + "\" and Semana = 3"; st = cnx.createStatement(); rs = st.executeQuery(query); rs.next(); if (rs.getString(1).equals("1")) { query = "select * from segumientoprogramatico2.programa where grupo = \"" + seleccion + "\" and Semana = 3"; st = cnx.createStatement(); rs = st.executeQuery(query); rs.next(); EVUnidad3.setText(rs.getString(3)); TP3.setText(rs.getString(4)); TR3.setText(rs.getString(5)); EP3.setText(rs.getString(6)); ER3.setText(rs.getString(7)); } query = "select count(*) from segumientoprogramatico2.programa where grupo = \"" + seleccion + "\" and Semana = 4"; st = cnx.createStatement(); rs = st.executeQuery(query); rs.next(); if (rs.getString(1).equals("1")) { query = "select * from segumientoprogramatico2.programa where grupo = \"" + seleccion + "\" and Semana = 4"; st = cnx.createStatement(); rs = st.executeQuery(query); rs.next(); EVUnidad4.setText(rs.getString(3)); TP4.setText(rs.getString(4)); TR4.setText(rs.getString(5)); EP4.setText(rs.getString(6)); ER4.setText(rs.getString(7)); } query = "select count(*) from segumientoprogramatico2.programa where grupo = \"" + seleccion + "\" and Semana = 5"; st = cnx.createStatement(); rs = st.executeQuery(query); rs.next(); if (rs.getString(1).equals("1")) { query = "select * from segumientoprogramatico2.programa where grupo = \"" + seleccion + "\" and Semana = 5"; st = cnx.createStatement(); rs = st.executeQuery(query); rs.next(); EVUnidad5.setText(rs.getString(3)); TP5.setText(rs.getString(4)); TR5.setText(rs.getString(5)); EP5.setText(rs.getString(6)); ER5.setText(rs.getString(7)); } query = "select count(*) from segumientoprogramatico2.programa where grupo = \"" + seleccion + "\" and Semana = 6"; st = cnx.createStatement(); rs = st.executeQuery(query); rs.next(); if (rs.getString(1).equals("1")) { query = "select * from segumientoprogramatico2.programa where grupo = \"" + seleccion + "\" and Semana = 6"; st = cnx.createStatement(); rs = st.executeQuery(query); rs.next(); EVUnidad6.setText(rs.getString(3)); TP6.setText(rs.getString(4)); TR6.setText(rs.getString(5)); EP6.setText(rs.getString(6)); ER6.setText(rs.getString(7)); } query = "select count(*) from segumientoprogramatico2.programa where grupo = \"" + seleccion + "\" and Semana = 7"; st = cnx.createStatement(); rs = st.executeQuery(query); rs.next(); if (rs.getString(1).equals("1")) { query = "select * from segumientoprogramatico2.programa where grupo = \"" + seleccion + "\" and Semana = 7"; st = cnx.createStatement(); rs = st.executeQuery(query); rs.next(); EVUnidad7.setText(rs.getString(3)); TP7.setText(rs.getString(4)); TR7.setText(rs.getString(5)); EP7.setText(rs.getString(6)); ER7.setText(rs.getString(7)); } query = "select count(*) from segumientoprogramatico2.programa where grupo = \"" + seleccion + "\" and Semana = 8"; st = cnx.createStatement(); rs = st.executeQuery(query); rs.next(); if (rs.getString(1).equals("1")) { query = "select * from segumientoprogramatico2.programa where grupo = \"" + seleccion + "\" and Semana = 8"; st = cnx.createStatement(); rs = st.executeQuery(query); rs.next(); EVUnidad8.setText(rs.getString(3)); TP8.setText(rs.getString(4)); TR8.setText(rs.getString(5)); EP8.setText(rs.getString(6)); ER8.setText(rs.getString(7)); } query = "select count(*) from segumientoprogramatico2.programa where grupo = \"" + seleccion + "\" and Semana = 9"; st = cnx.createStatement(); rs = st.executeQuery(query); rs.next(); if (rs.getString(1).equals("1")) { query = "select * from segumientoprogramatico2.programa where grupo = \"" + seleccion + "\" and Semana = 9"; st = cnx.createStatement(); rs = st.executeQuery(query); rs.next(); EVUnidad9.setText(rs.getString(3)); TP9.setText(rs.getString(4)); TR9.setText(rs.getString(5)); EP9.setText(rs.getString(6)); ER9.setText(rs.getString(7)); } query = "select count(*) from segumientoprogramatico2.programa where grupo = \"" + seleccion + "\" and Semana = 10"; st = cnx.createStatement(); rs = st.executeQuery(query); rs.next(); if (rs.getString(1).equals("1")) { query = "select * from segumientoprogramatico2.programa where grupo = \"" + seleccion + "\" and Semana = 10"; st = cnx.createStatement(); rs = st.executeQuery(query); rs.next(); EVUnidad10.setText(rs.getString(3)); TP10.setText(rs.getString(4)); TR10.setText(rs.getString(5)); EP10.setText(rs.getString(6)); ER10.setText(rs.getString(7)); } query = "select count(*) from segumientoprogramatico2.programa where grupo = \"" + seleccion + "\" and Semana = 11"; st = cnx.createStatement(); rs = st.executeQuery(query); rs.next(); if (rs.getString(1).equals("1")) { query = "select * from segumientoprogramatico2.programa where grupo = \"" + seleccion + "\" and Semana = 11"; st = cnx.createStatement(); rs = st.executeQuery(query); rs.next(); EVUnidad11.setText(rs.getString(3)); TP11.setText(rs.getString(4)); TR11.setText(rs.getString(5)); EP11.setText(rs.getString(6)); ER11.setText(rs.getString(7)); } query = "select count(*) from segumientoprogramatico2.programa where grupo = \"" + seleccion + "\" and Semana = 12"; st = cnx.createStatement(); rs = st.executeQuery(query); rs.next(); if (rs.getString(1).equals("1")) { query = "select * from segumientoprogramatico2.programa where grupo = \"" + seleccion + "\" and Semana = 12"; st = cnx.createStatement(); rs = st.executeQuery(query); rs.next(); EVUnidad12.setText(rs.getString(3)); TP12.setText(rs.getString(4)); TR12.setText(rs.getString(5)); EP12.setText(rs.getString(6)); ER12.setText(rs.getString(7)); } query = "select count(*) from segumientoprogramatico2.programa where grupo = \"" + seleccion + "\" and Semana = 13"; st = cnx.createStatement(); rs = st.executeQuery(query); rs.next(); if (rs.getString(1).equals("1")) { query = "select * from segumientoprogramatico2.programa where grupo = \"" + seleccion + "\" and Semana = 13"; st = cnx.createStatement(); rs = st.executeQuery(query); rs.next(); EVUnidad13.setText(rs.getString(3)); TP13.setText(rs.getString(4)); TR13.setText(rs.getString(5)); EP13.setText(rs.getString(6)); ER13.setText(rs.getString(7)); } query = "select count(*) from segumientoprogramatico2.programa where grupo = \"" + seleccion + "\" and Semana = 14"; st = cnx.createStatement(); rs = st.executeQuery(query); rs.next(); if (rs.getString(1).equals("1")) { query = "select * from segumientoprogramatico2.programa where grupo = \"" + seleccion + "\" and Semana = 14"; st = cnx.createStatement(); rs = st.executeQuery(query); rs.next(); EVUnidad14.setText(rs.getString(3)); TP14.setText(rs.getString(4)); TR14.setText(rs.getString(5)); EP14.setText(rs.getString(6)); ER14.setText(rs.getString(7)); } query = "select count(*) from segumientoprogramatico2.programa where grupo = \"" + seleccion + "\" and Semana = 15"; st = cnx.createStatement(); rs = st.executeQuery(query); rs.next(); if (rs.getString(1).equals("1")) { query = "select * from segumientoprogramatico2.programa where grupo = \"" + seleccion + "\" and Semana = 15"; st = cnx.createStatement(); rs = st.executeQuery(query); rs.next(); EVUnidad15.setText(rs.getString(3)); TP15.setText(rs.getString(4)); TR15.setText(rs.getString(5)); EP15.setText(rs.getString(6)); ER15.setText(rs.getString(7)); } query = "select count(*) from segumientoprogramatico2.programa where grupo = \"" + seleccion + "\" and Semana = 16"; st = cnx.createStatement(); rs = st.executeQuery(query); rs.next(); if (rs.getString(1).equals("1")) { query = "select * from segumientoprogramatico2.programa where grupo = \"" + seleccion + "\" and Semana = 16"; st = cnx.createStatement(); rs = st.executeQuery(query); rs.next(); EVUnidad16.setText(rs.getString(3)); TP16.setText(rs.getString(4)); TR16.setText(rs.getString(5)); EP16.setText(rs.getString(6)); ER16.setText(rs.getString(7)); } cnx.close(); } catch (SQLException ex) { System.out.println(ex.getMessage()); } catch (ClassNotFoundException ex) { System.out.println(ex.getMessage()); } }//GEN-LAST:event_AbrirActionPerformed private void PDFActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_PDFActionPerformed String Nombre = JOptionPane.showInputDialog("Cmo se llamar el documento?"); BufferedImage img = new BufferedImage(jPanel1.getWidth(), jPanel1.getHeight(), BufferedImage.TYPE_INT_RGB); jPanel1.print(img.getGraphics()); try { File folder = new File("C:/Documentos/"); if (!folder.exists()) { folder.mkdir(); } ImageIO.write(img, "png", new File("C:/Documentos/" + Nombre + ".png")); } catch (IOException ex) { Logger.getLogger(GUI.class.getName()).log(Level.SEVERE, null, ex); } Document document = new Document(new com.itextpdf.text.Rectangle(1340, 1739), 0, 0, 0, 0); try { PdfWriter.getInstance(document, new FileOutputStream("C:/Documentos/" + Nombre + ".pdf")); document.open(); Image image1 = Image.getInstance("C:/Documentos/" + Nombre + ".png"); image1.scalePercent(100f); document.add(image1); File imagen = new File("C:/Documentos/" + Nombre + ".png"); imagen.delete(); document.close(); } catch (Exception e) { e.printStackTrace(); } }//GEN-LAST:event_PDFActionPerformed private void FSActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_FSActionPerformed // TODO add your handling code here: }//GEN-LAST:event_FSActionPerformed /** * @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(GUI.class.getName()).log(java.util.logging.Level.SEVERE, null, ex); } catch (InstantiationException ex) { java.util.logging.Logger.getLogger(GUI.class.getName()).log(java.util.logging.Level.SEVERE, null, ex); } catch (IllegalAccessException ex) { java.util.logging.Logger.getLogger(GUI.class.getName()).log(java.util.logging.Level.SEVERE, null, ex); } catch (javax.swing.UnsupportedLookAndFeelException ex) { java.util.logging.Logger.getLogger(GUI.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 GUI().setVisible(true); } }); } // Variables declaration - do not modify//GEN-BEGIN:variables private javax.swing.JButton Abrir; private javax.swing.JTextField Aprobados; private javax.swing.JLabel AvanceProg1; private javax.swing.JLabel AvanceProg10; private javax.swing.JLabel AvanceProg2; private javax.swing.JLabel AvanceProg3; private javax.swing.JLabel AvanceProg4; private javax.swing.JLabel AvanceProg5; private javax.swing.JLabel AvanceProg6; private javax.swing.JLabel AvanceProg7; private javax.swing.JLabel AvanceProg8; private javax.swing.JLabel AvanceProg9; private javax.swing.JTextField AvanceReal1; private javax.swing.JTextField AvanceReal10; private javax.swing.JTextField AvanceReal2; private javax.swing.JTextField AvanceReal3; private javax.swing.JTextField AvanceReal4; private javax.swing.JTextField AvanceReal5; private javax.swing.JTextField AvanceReal6; private javax.swing.JTextField AvanceReal7; private javax.swing.JTextField AvanceReal8; private javax.swing.JTextField AvanceReal9; private javax.swing.JLabel Carrera; private javax.swing.JLabel Catedratico; private javax.swing.JTextField EP1; private javax.swing.JTextField EP10; private javax.swing.JTextField EP11; private javax.swing.JTextField EP12; private javax.swing.JTextField EP13; private javax.swing.JTextField EP14; private javax.swing.JTextField EP15; private javax.swing.JTextField EP16; private javax.swing.JTextField EP2; private javax.swing.JTextField EP3; private javax.swing.JTextField EP4; private javax.swing.JTextField EP5; private javax.swing.JTextField EP6; private javax.swing.JTextField EP7; private javax.swing.JTextField EP8; private javax.swing.JTextField EP9; private javax.swing.JTextField ER1; private javax.swing.JTextField ER10; private javax.swing.JTextField ER11; private javax.swing.JTextField ER12; private javax.swing.JTextField ER13; private javax.swing.JTextField ER14; private javax.swing.JTextField ER15; private javax.swing.JTextField ER16; private javax.swing.JTextField ER2; private javax.swing.JTextField ER3; private javax.swing.JTextField ER4; private javax.swing.JTextField ER5; private javax.swing.JTextField ER6; private javax.swing.JTextField ER7; private javax.swing.JTextField ER8; private javax.swing.JTextField ER9; private javax.swing.JTextField EVUnidad1; private javax.swing.JTextField EVUnidad10; private javax.swing.JTextField EVUnidad11; private javax.swing.JTextField EVUnidad12; private javax.swing.JTextField EVUnidad13; private javax.swing.JTextField EVUnidad14; private javax.swing.JTextField EVUnidad15; private javax.swing.JTextField EVUnidad16; private javax.swing.JTextField EVUnidad2; private javax.swing.JTextField EVUnidad3; private javax.swing.JTextField EVUnidad4; private javax.swing.JTextField EVUnidad5; private javax.swing.JTextField EVUnidad6; private javax.swing.JTextField EVUnidad7; private javax.swing.JTextField EVUnidad8; private javax.swing.JTextField EVUnidad9; private javax.swing.JTextField FS; private javax.swing.JLabel FechaProgramada1; private javax.swing.JLabel FechaProgramada2; private javax.swing.JLabel FechaProgramada3; private javax.swing.JLabel FechaProgramada4; private javax.swing.JTextField FechaProgramadaVisita; private javax.swing.JTextField FechaRealizada1; private javax.swing.JTextField FechaRealizada2; private javax.swing.JTextField FechaRealizada3; private javax.swing.JTextField FechaRealizada4; private javax.swing.JTextField FechaRealizadaVisita; private javax.swing.JLabel FinProg1; private javax.swing.JLabel FinProg10; private javax.swing.JLabel FinProg2; private javax.swing.JLabel FinProg3; private javax.swing.JLabel FinProg4; private javax.swing.JLabel FinProg5; private javax.swing.JLabel FinProg6; private javax.swing.JLabel FinProg7; private javax.swing.JLabel FinProg8; private javax.swing.JLabel FinProg9; private javax.swing.JTextField FinReal1; private javax.swing.JTextField FinReal10; private javax.swing.JTextField FinReal2; private javax.swing.JTextField FinReal3; private javax.swing.JTextField FinReal4; private javax.swing.JTextField FinReal5; private javax.swing.JTextField FinReal6; private javax.swing.JTextField FinReal7; private javax.swing.JTextField FinReal8; private javax.swing.JTextField FinReal9; private javax.swing.JLabel Fondo; private javax.swing.JLabel Grupo; private javax.swing.JButton Guardar; private javax.swing.JLabel HoraProg1; private javax.swing.JLabel HoraProg10; private javax.swing.JLabel HoraProg2; private javax.swing.JLabel HoraProg3; private javax.swing.JLabel HoraProg4; private javax.swing.JLabel HoraProg5; private javax.swing.JLabel HoraProg6; private javax.swing.JLabel HoraProg7; private javax.swing.JLabel HoraProg8; private javax.swing.JLabel HoraProg9; private javax.swing.JTextField HoraReal1; private javax.swing.JTextField HoraReal10; private javax.swing.JTextField HoraReal2; private javax.swing.JTextField HoraReal3; private javax.swing.JTextField HoraReal4; private javax.swing.JTextField HoraReal5; private javax.swing.JTextField HoraReal6; private javax.swing.JTextField HoraReal7; private javax.swing.JTextField HoraReal8; private javax.swing.JTextField HoraReal9; private javax.swing.JLabel InicioProg1; private javax.swing.JLabel InicioProg10; private javax.swing.JLabel InicioProg2; private javax.swing.JLabel InicioProg3; private javax.swing.JLabel InicioProg4; private javax.swing.JLabel InicioProg5; private javax.swing.JLabel InicioProg6; private javax.swing.JLabel InicioProg7; private javax.swing.JLabel InicioProg8; private javax.swing.JLabel InicioProg9; private javax.swing.JTextField InicioReal1; private javax.swing.JTextField InicioReal10; private javax.swing.JTextField InicioReal2; private javax.swing.JTextField InicioReal3; private javax.swing.JTextField InicioReal4; private javax.swing.JTextField InicioReal5; private javax.swing.JTextField InicioReal6; private javax.swing.JTextField InicioReal7; private javax.swing.JTextField InicioReal8; private javax.swing.JTextField InicioReal9; private javax.swing.JLabel JuevesFin; private javax.swing.JLabel JuevesInicio; private javax.swing.JLabel LunesFin; private javax.swing.JLabel LunesInicio; private javax.swing.JLabel MartesFin; private javax.swing.JLabel MartesInicio; private javax.swing.JLabel Materia; private javax.swing.JLabel MiercolesFIn; private javax.swing.JLabel MiercolesInicio; private javax.swing.JTextField NoAsisten; private javax.swing.JTextField NombreEmpresa; private javax.swing.JButton PDF; private javax.swing.JLabel Practica1; private javax.swing.JLabel Practica2; private javax.swing.JLabel Practica3; private javax.swing.JLabel Practica4; private javax.swing.JTextField Reprobados; private javax.swing.JTextField TP1; private javax.swing.JTextField TP10; private javax.swing.JTextField TP11; private javax.swing.JTextField TP12; private javax.swing.JTextField TP13; private javax.swing.JTextField TP14; private javax.swing.JTextField TP15; private javax.swing.JTextField TP16; private javax.swing.JTextField TP2; private javax.swing.JTextField TP3; private javax.swing.JTextField TP4; private javax.swing.JTextField TP5; private javax.swing.JTextField TP6; private javax.swing.JTextField TP7; private javax.swing.JTextField TP8; private javax.swing.JTextField TP9; private javax.swing.JTextField TR1; private javax.swing.JTextField TR10; private javax.swing.JTextField TR11; private javax.swing.JTextField TR12; private javax.swing.JTextField TR13; private javax.swing.JTextField TR14; private javax.swing.JTextField TR15; private javax.swing.JTextField TR16; private javax.swing.JTextField TR2; private javax.swing.JTextField TR3; private javax.swing.JTextField TR4; private javax.swing.JTextField TR5; private javax.swing.JTextField TR6; private javax.swing.JTextField TR7; private javax.swing.JTextField TR8; private javax.swing.JTextField TR9; private javax.swing.JLabel Tema1; private javax.swing.JLabel Tema10; private javax.swing.JLabel Tema2; private javax.swing.JLabel Tema3; private javax.swing.JLabel Tema4; private javax.swing.JLabel Tema5; private javax.swing.JLabel Tema6; private javax.swing.JLabel Tema7; private javax.swing.JLabel Tema8; private javax.swing.JLabel Tema9; private javax.swing.JTextField TotalEstudiantes; private javax.swing.JLabel Unidad1; private javax.swing.JLabel Unidad2; private javax.swing.JLabel Unidad3; private javax.swing.JLabel Unidad4; private javax.swing.JTextField UnidadTematica; private javax.swing.JTextField UnidadesEvaluadasALaFecha; private javax.swing.JLabel ViernesFin; private javax.swing.JLabel ViernesInicio; private javax.swing.JPanel jPanel1; private javax.swing.JPanel jPanel2; private javax.swing.JScrollPane jScrollPane2; // End of variables declaration//GEN-END:variables }