void TablaDiccionario() { try { // arreglo con los titulos de la tabla String[] titulos = { "TABLA", "COLUMNA", "TIPO_DATOS", "ADMIT.NULOS", "AUTO_INCREMENTO", "LLAVE", "COMENTARIO" }; model = new DefaultTableModel(null, titulos); // enviamos el arreglo en el modelo de la tabla String[] fila = new String[7]; // recogemos los datos para pasar a la tabla ResultSet rs = new ManejoBD().Consultar_Diccionario("tareadb"); try { // agregamos los valores en el arreglo while (rs.next()) { fila[0] = rs.getString("Tabla"); fila[1] = rs.getString("Columna"); fila[3] = rs.getString("Admite_Nulos"); fila[2] = rs.getString("Tipo_Datos"); fila[4] = rs.getString("Se_Autoincrementa"); fila[5] = rs.getString("Llave"); fila[6] = rs.getString("Comentario"); model.addRow(fila); // agregamos los valores en el modelo de la tabla } Tdiccionario.setModel(model); // agregamos valores en la tabla } catch (SQLException ex) { Logger.getLogger(Ejecucion.class.getName()).log(Level.SEVERE, null, ex); } } catch (ClassNotFoundException | SQLException ex) { Logger.getLogger(Ejecucion.class.getName()).log(Level.SEVERE, null, ex); } }
@SuppressWarnings("unchecked") // <editor-fold defaultstate="collapsed" desc="Generated Code">//GEN-BEGIN:initComponents private void initComponents() { jLabel1 = new javax.swing.JLabel(); jScrollPane1 = new javax.swing.JScrollPane(); Tdiccionario = new javax.swing.JTable(); jPanel1 = new javax.swing.JPanel(); jButton2 = new javax.swing.JButton(); lblporcentaje3 = new javax.swing.JLabel(); jLabel4 = new javax.swing.JLabel(); jButton1 = new javax.swing.JButton(); jComboBox1 = new javax.swing.JComboBox(); jComboBox2 = new javax.swing.JComboBox(); jLabel2 = new javax.swing.JLabel(); jLabel3 = new javax.swing.JLabel(); jScrollPane2 = new javax.swing.JScrollPane(); Trecomendaciones = new javax.swing.JTable(); jPanel3 = new javax.swing.JPanel(); jScrollPane3 = new javax.swing.JScrollPane(); jtableF = new javax.swing.JTable(); jButton3 = new javax.swing.JButton(); setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE); jLabel1.setFont(new java.awt.Font("Tahoma", 1, 14)); // NOI18N jLabel1.setText("Diccionario Base Datos"); Tdiccionario.setModel( new javax.swing.table.DefaultTableModel( new Object[][] { {null, null, null, null}, {null, null, null, null}, {null, null, null, null}, {null, null, null, null} }, new String[] {"Title 1", "Title 2", "Title 3", "Title 4"})); Tdiccionario.addMouseListener( new java.awt.event.MouseAdapter() { public void mouseClicked(java.awt.event.MouseEvent evt) { TdiccionarioMouseClicked(evt); } }); jScrollPane1.setViewportView(Tdiccionario); javax.swing.GroupLayout jPanel1Layout = new javax.swing.GroupLayout(jPanel1); jPanel1.setLayout(jPanel1Layout); jPanel1Layout.setHorizontalGroup( jPanel1Layout .createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGap(0, 509, Short.MAX_VALUE)); jPanel1Layout.setVerticalGroup( jPanel1Layout .createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGap(0, 0, Short.MAX_VALUE)); jButton2.setText("Mostrar Diccionario"); jButton2.addMouseListener( new java.awt.event.MouseAdapter() { public void mouseClicked(java.awt.event.MouseEvent evt) { jButton2MouseClicked(evt); } }); lblporcentaje3.setFont(new java.awt.Font("Cantarell", 0, 18)); // NOI18N lblporcentaje3.setText(":v"); jLabel4.setText("Porcentaje de similitud"); jButton1.setText("Aceptar"); jButton1.addMouseListener( new java.awt.event.MouseAdapter() { public void mouseClicked(java.awt.event.MouseEvent evt) { jButton1MouseClicked(evt); } }); jButton1.addActionListener( new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jButton1ActionPerformed(evt); } }); jComboBox1.setModel( new javax.swing.DefaultComboBoxModel( new String[] {"Item 1", "Item 2", "Item 3", "Item 4"})); jComboBox1.addActionListener( new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jComboBox1ActionPerformed(evt); } }); jComboBox2.setModel( new javax.swing.DefaultComboBoxModel( new String[] {"Item 1", "Item 2", "Item 3", "Item 4"})); jComboBox2.addActionListener( new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jComboBox2ActionPerformed(evt); } }); jLabel2.setFont(new java.awt.Font("Tahoma", 0, 12)); // NOI18N jLabel2.setText("Tablas disponibles"); jLabel3.setFont(new java.awt.Font("Tahoma", 1, 14)); // NOI18N jLabel3.setText("RECOMENDACIONES jOIN"); Trecomendaciones.setModel( new javax.swing.table.DefaultTableModel( new Object[][] { {null, null, null, null}, {null, null, null, null}, {null, null, null, null}, {null, null, null, null} }, new String[] {"Title 1", "Title 2", "Title 3", "Title 4"})); jScrollPane2.setViewportView(Trecomendaciones); jtableF.setModel( new javax.swing.table.DefaultTableModel( new Object[][] { {null, null, null, null}, {null, null, null, null}, {null, null, null, null}, {null, null, null, null} }, new String[] {"Title 1", "Title 2", "Title 3", "Title 4"})); jScrollPane3.setViewportView(jtableF); javax.swing.GroupLayout jPanel3Layout = new javax.swing.GroupLayout(jPanel3); jPanel3.setLayout(jPanel3Layout); jPanel3Layout.setHorizontalGroup( jPanel3Layout .createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup( jPanel3Layout .createSequentialGroup() .addContainerGap() .addComponent( jScrollPane3, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))); jPanel3Layout.setVerticalGroup( jPanel3Layout .createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup( jPanel3Layout .createSequentialGroup() .addContainerGap() .addComponent( jScrollPane3, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))); jButton3.setText("Presentar"); jButton3.addActionListener( new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent evt) { jButton3ActionPerformed(evt); } }); javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane()); getContentPane().setLayout(layout); layout.setHorizontalGroup( layout .createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup( layout .createSequentialGroup() .addGroup( layout .createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup( layout .createSequentialGroup() .addGap(53, 53, 53) .addComponent(jButton2)) .addGroup( layout .createSequentialGroup() .addContainerGap() .addComponent( jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 821, javax.swing.GroupLayout.PREFERRED_SIZE)) .addComponent( jPanel1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE) .addGroup( layout .createSequentialGroup() .addGroup( layout .createParallelGroup( javax.swing.GroupLayout.Alignment.LEADING) .addGroup( layout .createSequentialGroup() .addGap(32, 32, 32) .addGroup( layout .createParallelGroup( javax.swing.GroupLayout.Alignment .TRAILING) .addComponent( lblporcentaje3, javax.swing.GroupLayout .PREFERRED_SIZE, 154, javax.swing.GroupLayout .PREFERRED_SIZE) .addGroup( layout .createSequentialGroup() .addComponent( jScrollPane2, javax.swing.GroupLayout .PREFERRED_SIZE, 421, javax.swing.GroupLayout .PREFERRED_SIZE) .addGap(81, 81, 81) .addComponent(jButton3) .addGap(57, 57, 57)))) .addGroup( layout .createSequentialGroup() .addGroup( layout .createParallelGroup( javax.swing.GroupLayout.Alignment .LEADING) .addGroup( layout .createSequentialGroup() .addGap(144, 144, 144) .addComponent(jLabel3)) .addGroup( layout .createSequentialGroup() .addGroup( layout .createParallelGroup( javax.swing .GroupLayout .Alignment .LEADING) .addGroup( layout .createSequentialGroup() .addGap( 203, 203, 203) .addGroup( layout .createParallelGroup( javax .swing .GroupLayout .Alignment .LEADING) .addComponent( jLabel2) .addComponent( jButton1))) .addGroup( layout .createSequentialGroup() .addGap( 76, 76, 76) .addComponent( jComboBox1, javax.swing .GroupLayout .PREFERRED_SIZE, 107, javax.swing .GroupLayout .PREFERRED_SIZE) .addGap( 131, 131, 131) .addComponent( jComboBox2, javax.swing .GroupLayout .PREFERRED_SIZE, 110, javax.swing .GroupLayout .PREFERRED_SIZE))) .addGap(31, 31, 31) .addComponent(jLabel4))) .addGap(46, 46, 46))) .addComponent( jPanel3, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)) .addGroup( layout .createSequentialGroup() .addGap(427, 427, 427) .addComponent( jLabel1, javax.swing.GroupLayout.PREFERRED_SIZE, 212, javax.swing.GroupLayout.PREFERRED_SIZE))) .addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))); layout.setVerticalGroup( layout .createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING) .addGroup( layout .createSequentialGroup() .addGap(21, 21, 21) .addComponent(jLabel1) .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED) .addComponent(jButton2) .addGap(18, 18, 18) .addComponent( jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 180, javax.swing.GroupLayout.PREFERRED_SIZE) .addGroup( layout .createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING) .addGroup( layout .createSequentialGroup() .addComponent(jLabel2) .addGap(42, 42, 42) .addGroup( layout .createParallelGroup( javax.swing.GroupLayout.Alignment.LEADING) .addGroup( layout .createSequentialGroup() .addGroup( layout .createParallelGroup( javax.swing.GroupLayout.Alignment .BASELINE) .addComponent( jComboBox1, javax.swing.GroupLayout .PREFERRED_SIZE, javax.swing.GroupLayout .DEFAULT_SIZE, javax.swing.GroupLayout .PREFERRED_SIZE) .addComponent( jComboBox2, javax.swing.GroupLayout .PREFERRED_SIZE, javax.swing.GroupLayout .DEFAULT_SIZE, javax.swing.GroupLayout .PREFERRED_SIZE)) .addPreferredGap( javax.swing.LayoutStyle.ComponentPlacement .RELATED) .addComponent(jButton1) .addGap(18, 18, 18) .addComponent(jLabel3) .addGap(18, 18, 18) .addComponent( jScrollPane2, javax.swing.GroupLayout.PREFERRED_SIZE, 119, javax.swing.GroupLayout.PREFERRED_SIZE) .addGap(0, 69, Short.MAX_VALUE)) .addComponent( jPanel3, javax.swing.GroupLayout.PREFERRED_SIZE, 0, Short.MAX_VALUE)) .addPreferredGap( javax.swing.LayoutStyle.ComponentPlacement.RELATED)) .addGroup( layout .createSequentialGroup() .addGap(74, 74, 74) .addComponent(jLabel4) .addGap(31, 31, 31) .addComponent( lblporcentaje3, javax.swing.GroupLayout.PREFERRED_SIZE, 56, javax.swing.GroupLayout.PREFERRED_SIZE) .addGap(54, 54, 54) .addComponent(jButton3) .addPreferredGap( javax.swing.LayoutStyle.ComponentPlacement.RELATED, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))) .addComponent( jPanel1, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE) .addGap(87, 87, 87))); pack(); } // </editor-fold>//GEN-END:initComponents