Boa noite .
Criei um jtable onde será exibido o resultado de uma consulta ao Banco de Dados ,onde tem um campo Date .
A Jtable exibe os dados ,porém é preciso converter a data para o padrão Brasileiro.
Código da JTable :
public class consultaAtendimento extends javax.swing.JFrame {
/**
* Creates new form consultaAtendimento
*/
public consultaAtendimento() {
initComponents();
}
/**
* 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() {
jPanel1 = new javax.swing.JPanel();
jLabel1 = new javax.swing.JLabel();
txtRA = new javax.swing.JFormattedTextField();
jLabel2 = new javax.swing.JLabel();
btnBuscar = new javax.swing.JButton();
txtNome = new javax.swing.JTextField();
btnLimpaNovoAtend = new javax.swing.JButton();
jScrollPane1 = new javax.swing.JScrollPane();
tabela = new javax.swing.JTable();
jMenuBar1 = new javax.swing.JMenuBar();
jMenu1 = new javax.swing.JMenu();
jMenuItem7 = new javax.swing.JMenuItem();
jMenuItem8 = new javax.swing.JMenuItem();
jMenuItem9 = new javax.swing.JMenuItem();
jMenuItem10 = new javax.swing.JMenuItem();
jMenu3 = new javax.swing.JMenu();
jMenuItem5 = new javax.swing.JMenuItem();
jMenuItem6 = new javax.swing.JMenuItem();
jMenu2 = new javax.swing.JMenu();
jMenuItem2 = new javax.swing.JMenuItem();
jMenuItem3 = new javax.swing.JMenuItem();
jMenuItem4 = new javax.swing.JMenuItem();
setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
jPanel1.setBorder(javax.swing.BorderFactory.createLineBorder(new java.awt.Color(0, 0, 0)));
jLabel1.setText("RA");
txtRA.setBorder(javax.swing.BorderFactory.createLineBorder(new java.awt.Color(0, 0, 0)));
try {
txtRA.setFormatterFactory(new javax.swing.text.DefaultFormatterFactory(new javax.swing.text.MaskFormatter("####/##-#")));
} catch (java.text.ParseException ex) {
ex.printStackTrace();
}
jLabel2.setText("NOME");
btnBuscar.setIcon(new javax.swing.ImageIcon(getClass().getResource("/Imagens/Pesquisar2.png"))); // NOI18N
btnBuscar.setBorder(javax.swing.BorderFactory.createLineBorder(new java.awt.Color(0, 0, 0)));
btnBuscar.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
btnBuscarActionPerformed(evt);
}
});
txtNome.setBorder(javax.swing.BorderFactory.createLineBorder(new java.awt.Color(0, 0, 0)));
btnLimpaNovoAtend.setIcon(new javax.swing.ImageIcon(getClass().getResource("/Imagens/limpar3.png"))); // NOI18N
btnLimpaNovoAtend.setBorder(javax.swing.BorderFactory.createLineBorder(new java.awt.Color(0, 0, 0)));
btnLimpaNovoAtend.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
btnLimpaNovoAtendActionPerformed(evt);
}
});
javax.swing.GroupLayout jPanel1Layout = new javax.swing.GroupLayout(jPanel1);
jPanel1.setLayout(jPanel1Layout);
jPanel1Layout.setHorizontalGroup(
jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel1Layout.createSequentialGroup()
.addGap(25, 25, 25)
.addComponent(jLabel1)
.addGap(18, 18, 18)
.addComponent(txtRA, javax.swing.GroupLayout.PREFERRED_SIZE, 68, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(54, 54, 54)
.addComponent(jLabel2)
.addGap(29, 29, 29)
.addComponent(txtNome, javax.swing.GroupLayout.PREFERRED_SIZE, 304, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(18, 18, 18)
.addComponent(btnBuscar, javax.swing.GroupLayout.PREFERRED_SIZE, 48, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(18, 18, 18)
.addComponent(btnLimpaNovoAtend, javax.swing.GroupLayout.PREFERRED_SIZE, 45, javax.swing.GroupLayout.PREFERRED_SIZE)
.addContainerGap(45, Short.MAX_VALUE))
);
jPanel1Layout.setVerticalGroup(
jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel1Layout.createSequentialGroup()
.addGap(41, 41, 41)
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel1)
.addComponent(txtRA, javax.swing.GroupLayout.PREFERRED_SIZE, 26, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel2)
.addComponent(txtNome, javax.swing.GroupLayout.PREFERRED_SIZE, 26, javax.swing.GroupLayout.PREFERRED_SIZE))
.addContainerGap(42, Short.MAX_VALUE))
.addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanel1Layout.createSequentialGroup()
.addGap(0, 0, Short.MAX_VALUE)
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
.addComponent(btnLimpaNovoAtend, javax.swing.GroupLayout.PREFERRED_SIZE, 48, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(btnBuscar, javax.swing.GroupLayout.PREFERRED_SIZE, 48, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGap(29, 29, 29))
);
tabela.setBorder(new javax.swing.border.MatteBorder(null));
tabela.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 [] {
"RA", "NOME", "DATA", "HORA", "OBS"
}
) {
Class[] types = new Class [] {
java.lang.String.class, java.lang.String.class, java.lang.String.class, java.lang.String.class, java.lang.String.class
};
boolean[] canEdit = new boolean [] {
true, true, true, false, true
};
public Class getColumnClass(int columnIndex) {
return types [columnIndex];
}
public boolean isCellEditable(int rowIndex, int columnIndex) {
return canEdit [columnIndex];
}
});
jScrollPane1.setViewportView(tabela);
jMenuBar1.setBorder(javax.swing.BorderFactory.createLineBorder(new java.awt.Color(0, 0, 0)));
jMenu1.setText("Arquivo");
jMenuItem7.setText("Salvar");
jMenu1.add(jMenuItem7);
jMenuItem8.setText("Salvar Como ");
jMenu1.add(jMenuItem8);
jMenuItem9.setText("Imprimir");
jMenu1.add(jMenuItem9);
jMenuItem10.setText("Sair");
jMenu1.add(jMenuItem10);
jMenuBar1.add(jMenu1);
jMenu3.setText("Editar");
jMenuItem5.setText("Cadastro de Membros");
jMenu3.add(jMenuItem5);
jMenuItem6.setText("Cadastro de Pacientes");
jMenu3.add(jMenuItem6);
jMenuBar1.add(jMenu3);
jMenu2.setText("Ajuda");
jMenuItem2.setText("Sobre");
jMenu2.add(jMenuItem2);
jMenuItem3.setText("Desenvolvedores");
jMenu2.add(jMenuItem3);
jMenuItem4.setText("Verificar atualizações");
jMenu2.add(jMenuItem4);
jMenuBar1.add(jMenu2);
setJMenuBar(jMenuBar1);
javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
getContentPane().setLayout(layout);
layout.setHorizontalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup()
.addContainerGap(33, Short.MAX_VALUE)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING, false)
.addComponent(jPanel1, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addComponent(jScrollPane1))
.addGap(29, 29, 29))
);
layout.setVerticalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addGap(20, 20, 20)
.addComponent(jPanel1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(34, 34, 34)
.addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 399, javax.swing.GroupLayout.PREFERRED_SIZE)
.addContainerGap(17, Short.MAX_VALUE))
);
pack();
}// </editor-fold>
private void btnBuscarActionPerformed(java.awt.event.ActionEvent evt) {
// Botão Buscar
DefaultTableModel modelotabela = (DefaultTableModel) tabela.getModel();
modelotabela.setColumnCount(5);
modelotabela.setRowCount(0);
tabela.getColumnModel().getColumn(0).setHeaderValue("ra");
tabela.getColumnModel().getColumn(1).setHeaderValue("nome");
tabela.getColumnModel().getColumn(2).setHeaderValue("data");
tabela.getColumnModel().getColumn(3).setHeaderValue("hora");
tabela.getColumnModel().getColumn(4).setHeaderValue("observacao");
Dados d = new Dados();
Conectar c = new Conectar();
//select membro,pastor,hora from cadatendimentos where data_atend = '" + txtDataPesquisaAtemdimentos.getText() + "'"
ResultSet rs = d.consulta("select ra,nome,data,hora,observacao from atendimento where ra = '" + txtRA.getText() + "'" + "||" + "nome = '"+ txtNome.getText() + "'");
int linha = 0;
//new SimpleDateFormat("dd/MM/yyyy").format(retorno.getDate("data"))
try {
while(rs.next()) {
modelotabela.addRow(new String[modelotabela.getColumnCount()]);
modelotabela.setValueAt(rs.getString("ra"), linha, 0);
modelotabela.setValueAt(rs.getString("nome"), linha, 1);
modelotabela.setValueAt (rs.getString("data"), linha, 2);
modelotabela.setValueAt(rs.getString("hora"), linha, 3);
modelotabela.setValueAt(rs.getString("observacao"), linha, 4);
linha++;
}
}
catch (Exception e) {
System.err.println("Erro: " + e);
}
txtRA.setText("");
txtNome.setText("");
}
private void btnLimpaNovoAtendActionPerformed(java.awt.event.ActionEvent evt) {
//Limpando os campos
txtRA.setText("");
txtNome.setText("");
}
/**
* @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(consultaAtendimento.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
} catch (InstantiationException ex) {
java.util.logging.Logger.getLogger(consultaAtendimento.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
} catch (IllegalAccessException ex) {
java.util.logging.Logger.getLogger(consultaAtendimento.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
} catch (javax.swing.UnsupportedLookAndFeelException ex) {
java.util.logging.Logger.getLogger(consultaAtendimento.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
}
//</editor-fold>
//</editor-fold>
/* Create and display the form */
java.awt.EventQueue.invokeLater(new Runnable() {
public void run() {
new consultaAtendimento().setVisible(true);
}
});
}
// Variables declaration - do not modify
private javax.swing.JButton btnBuscar;
private javax.swing.JButton btnLimpaNovoAtend;
private javax.swing.JLabel jLabel1;
private javax.swing.JLabel jLabel2;
private javax.swing.JMenu jMenu1;
private javax.swing.JMenu jMenu2;
private javax.swing.JMenu jMenu3;
private javax.swing.JMenuBar jMenuBar1;
private javax.swing.JMenuItem jMenuItem10;
private javax.swing.JMenuItem jMenuItem2;
private javax.swing.JMenuItem jMenuItem3;
private javax.swing.JMenuItem jMenuItem4;
private javax.swing.JMenuItem jMenuItem5;
private javax.swing.JMenuItem jMenuItem6;
private javax.swing.JMenuItem jMenuItem7;
private javax.swing.JMenuItem jMenuItem8;
private javax.swing.JMenuItem jMenuItem9;
private javax.swing.JPanel jPanel1;
private javax.swing.JScrollPane jScrollPane1;
private javax.swing.JTable tabela;
private javax.swing.JTextField txtNome;
private javax.swing.JFormattedTextField txtRA;
// End of variables declaration
}