Meu código é esse…
/*
* To change this template, choose Tools | Templates
* and open the template in the editor.
*/
/*
* RegistroMateriaisComprados.java
*
* Created on 19-giu-2009, 17:05:32
*/
package Utilitarios;
import BancoDeDados.Conexao;
import java.sql.SQLException;
import javax.swing.table.DefaultTableModel;
import javax.swing.JOptionPane;
/**
*
* @author Aluno-A2
*/
public class RegistroMateriaisComprados extends javax.swing.JFrame {
Conexao con_CompraMaterial;
/** Creates new form RegistroMateriaisComprados */
public RegistroMateriaisComprados() {
initComponents();
con_CompraMaterial = new Conexao();
con_CompraMaterial.conecta();
con_CompraMaterial.executeSQL("select * from CompraMaterial");
preencher_jtable();
}
/** 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">
private void initComponents() {
jMenuBar2 = new javax.swing.JMenuBar();
jMenu5 = new javax.swing.JMenu();
jMenu6 = new javax.swing.JMenu();
jPanel1 = new javax.swing.JPanel();
jLabel1 = new javax.swing.JLabel();
jTextField1 = new javax.swing.JTextField();
jLabel2 = new javax.swing.JLabel();
jTextField2 = new javax.swing.JTextField();
jScrollPane1 = new javax.swing.JScrollPane();
jTable1 = new javax.swing.JTable();
jMenuBar1 = new javax.swing.JMenuBar();
jMenu4 = new javax.swing.JMenu();
jMenu7 = new javax.swing.JMenu();
jMenu5.setText("File");
jMenuBar2.add(jMenu5);
jMenu6.setText("Edit");
jMenuBar2.add(jMenu6);
setTitle("Registro dos Materias Comprados");
setResizable(false);
jPanel1.setBackground(new java.awt.Color(204, 204, 204));
jLabel1.setText("Procurar:");
org.jdesktop.layout.GroupLayout jPanel1Layout = new org.jdesktop.layout.GroupLayout(jPanel1);
jPanel1.setLayout(jPanel1Layout);
jPanel1Layout.setHorizontalGroup(
jPanel1Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
.add(jPanel1Layout.createSequentialGroup()
.addContainerGap()
.add(jLabel1)
.addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
.add(jTextField2, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, 120, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
.add(18, 18, 18)
.add(jTextField1, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, 123, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
.add(138, 138, 138)
.add(jLabel2)
.add(59, 59, 59))
);
jPanel1Layout.setVerticalGroup(
jPanel1Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
.add(org.jdesktop.layout.GroupLayout.TRAILING, jPanel1Layout.createSequentialGroup()
.addContainerGap(23, Short.MAX_VALUE)
.add(jPanel1Layout.createParallelGroup(org.jdesktop.layout.GroupLayout.BASELINE)
.add(jTextField1, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
.add(jLabel1)
.add(jTextField2, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE))
.addContainerGap())
.add(jPanel1Layout.createSequentialGroup()
.addContainerGap()
.add(jLabel2)
.addContainerGap(42, Short.MAX_VALUE))
);
jTable1.setModel(new javax.swing.table.DefaultTableModel(
new Object [][] {
{null, null, null, null, null},
{null, null, null, null, null},
{null, null, null, null, null},
{null, null, null, null, null}
},
new String [] {
"codigo", "material", "precototal", "quantidade", "data"
}
));
jScrollPane1.setViewportView(jTable1);
jMenuBar1.setBackground(new java.awt.Color(255, 255, 255));
jMenu4.setBackground(new java.awt.Color(255, 255, 255));
jMenu4.setIcon(new javax.swing.ImageIcon(getClass().getResource("/Utilitarios/imprimir.JPG"))); // NOI18N
jMenuBar1.add(jMenu4);
jMenu7.setBackground(new java.awt.Color(255, 255, 255));
jMenu7.setIcon(new javax.swing.ImageIcon(getClass().getResource("/Utilitarios/Sair.JPG"))); // NOI18N
jMenu7.addMouseListener(new java.awt.event.MouseAdapter() {
public void mousePressed(java.awt.event.MouseEvent evt) {
jMenu7MousePressed(evt);
}
});
jMenuBar1.add(jMenu7);
setJMenuBar(jMenuBar1);
org.jdesktop.layout.GroupLayout layout = new org.jdesktop.layout.GroupLayout(getContentPane());
getContentPane().setLayout(layout);
layout.setHorizontalGroup(
layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
.add(org.jdesktop.layout.GroupLayout.TRAILING, jScrollPane1, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, 542, Short.MAX_VALUE)
.add(jPanel1, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, 542, Short.MAX_VALUE)
);
layout.setVerticalGroup(
layout.createParallelGroup(org.jdesktop.layout.GroupLayout.LEADING)
.add(layout.createSequentialGroup()
.add(jPanel1, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, org.jdesktop.layout.GroupLayout.DEFAULT_SIZE, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(org.jdesktop.layout.LayoutStyle.RELATED)
.add(jScrollPane1, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE, 248, org.jdesktop.layout.GroupLayout.PREFERRED_SIZE)
.addContainerGap(41, Short.MAX_VALUE))
);
java.awt.Dimension screenSize = java.awt.Toolkit.getDefaultToolkit().getScreenSize();
setBounds((screenSize.width-550)/2, (screenSize.height-425)/2, 550, 425);
}// </editor-fold>
private void jMenu7MousePressed(java.awt.event.MouseEvent evt) {
dispose();
// TODO add your handling code here:
}
/**
* @param args the command line arguments
*/
public static void main(String args[]) {
java.awt.EventQueue.invokeLater(new Runnable() {
public void run() {
new RegistroMateriaisComprados().setVisible(true);
}
});
}
// Variables declaration - do not modify
private javax.swing.JLabel jLabel1;
private javax.swing.JLabel jLabel2;
private javax.swing.JMenu jMenu4;
private javax.swing.JMenu jMenu5;
private javax.swing.JMenu jMenu6;
private javax.swing.JMenu jMenu7;
private javax.swing.JMenuBar jMenuBar1;
private javax.swing.JMenuBar jMenuBar2;
private javax.swing.JPanel jPanel1;
private javax.swing.JScrollPane jScrollPane1;
private javax.swing.JTable jTable1;
private javax.swing.JTextField jTextField1;
private javax.swing.JTextField jTextField2;
// End of variables declaration
public void preencher_jtable()
{
jTable1.getColumnModel().getColumn(0).setPreferredWidth(20);
jTable1.getColumnModel().getColumn(1).setPreferredWidth(150);
jTable1.getColumnModel().getColumn(2).setPreferredWidth(20);
jTable1.getColumnModel().getColumn(3).setPreferredWidth(20);
jTable1.getColumnModel().getColumn(4).setPreferredWidth(20);
DefaultTableModel modelo = (DefaultTableModel)jTable1.getModel();
modelo.setNumRows(0);
try
{
while (con_CompraMaterial.resultset.next())
modelo.addRow(new Object [] {con_CompraMaterial.resultset.getString("codigo"),
con_CompraMaterial.resultset.getString("material"),
con_CompraMaterial.resultset.getString("precototal"),
con_CompraMaterial.resultset.getString("quantidade"),
con_CompraMaterial.resultset.getString("data")});
con_CompraMaterial.resultset.first();
}
catch (SQLException erro){
JOptionPane.showMessageDialog(null,"Erro ao listar no JTable ");
}
}
}