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
