pessoal boa tarde, estou com dificuldade de fazer funcionar um JComboBox, preciso de carregar os dados de uma tabela com nome de “conta”, nao sei onde estou errando alias nao sei nem como fazer, estou pesquisando mas nao consegui concluir nada ainda. por favor me ajudem o nome do metodo é “comboSelecionaConta”
/*
* To change this template, choose Tools | Templates
* and open the template in the editor.
*/
/*
* ConciliaCheque.java
*
* Created on 18/08/2011, 15:18:33
*/
package br.com.foxmilenium.view;
import br.com.foxmilenium.model.ConectaBD;
import br.com.foxmilenium.vo.Cheque;
import br.com.foxmilenium.vo.Conta;
import br.com.foxmilenium.vo.FiltraData;
import br.com.foxmilenium.vo.MovimentoBanco;
import java.io.BufferedReader;
import java.io.File;
import java.io.FileNotFoundException;
import java.io.FileReader;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.text.NumberFormat;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Date;
import java.util.LinkedList;
import java.util.List;
import java.util.Scanner;
import java.util.logging.Level;
import java.util.logging.Logger;
import javax.swing.JComboBox;
import javax.swing.JFileChooser;
import javax.swing.JOptionPane;
/**
*
* @author DELL
*/
public final class ConciliaCheque extends javax.swing.JDialog {
/** Creates new form ConciliaCheque */
public ConciliaCheque(java.awt.Frame parent, boolean modal) {
super(parent, modal);
initComponents();
capturaData();
//centralizar Telas
setLocationRelativeTo(null);
comboSelecionaConta();
}
/** 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() {
jScrollPane1 = new javax.swing.JScrollPane();
JtCheque = new javax.swing.JTable();
jScrollPane2 = new javax.swing.JScrollPane();
jTBanco = new javax.swing.JTable();
jPanel1 = new javax.swing.JPanel();
jButton2 = new javax.swing.JButton();
jButton1 = new javax.swing.JButton();
jButton3 = new javax.swing.JButton();
jButton4 = new javax.swing.JButton();
jPanel2 = new javax.swing.JPanel();
jPanel3 = new javax.swing.JPanel();
jLabel2 = new javax.swing.JLabel();
jLabel3 = new javax.swing.JLabel();
jButton5 = new javax.swing.JButton();
jButton6 = new javax.swing.JButton();
JCbSelecionaBanco = new javax.swing.JComboBox();
JbSelecionaArquivo = new javax.swing.JButton();
lblDataAtual = new javax.swing.JLabel();
dataInicial = new javax.swing.JTextField();
dataFinal = new javax.swing.JTextField();
jLabel4 = new javax.swing.JLabel();
jLabel5 = new javax.swing.JLabel();
lblArquivoSelecionado = new javax.swing.JLabel();
jLabel1 = new javax.swing.JLabel();
jCBSelecionaConta = new javax.swing.JComboBox();
setDefaultCloseOperation(javax.swing.WindowConstants.DISPOSE_ON_CLOSE);
setTitle("Auto Posto Aladim -->Conciliação de Cheques");
JtCheque.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, null, null, null, null}
},
new String [] {
"Data Lançamento", "Vencimento", "Documento", "Motivo", "Valor", "Crédito/Débito"
}
));
jScrollPane1.setViewportView(JtCheque);
jTBanco.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, null, null, null, null}
},
new String [] {
"Data", "Agencia", "Conta Corrente", "Compensação", "TipoOperação", "Valor"
}
));
jScrollPane2.setViewportView(jTBanco);
jButton2.setText("Cancelar");
jButton1.setText("Baixar");
jButton3.setText("Salvar");
jButton4.setText("Sair");
jButton4.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jButton4ActionPerformed(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()
.addContainerGap()
.addComponent(jButton4, javax.swing.GroupLayout.PREFERRED_SIZE, 71, javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addComponent(jButton1)
.addGap(14, 14, 14)
.addComponent(jButton2)
.addGap(18, 18, 18)
.addComponent(jButton3)
.addContainerGap())
);
jPanel1Layout.setVerticalGroup(
jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel1Layout.createSequentialGroup()
.addContainerGap()
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jButton2)
.addComponent(jButton3)
.addComponent(jButton1)
.addComponent(jButton4))
.addContainerGap())
);
jPanel2.setBackground(new java.awt.Color(204, 204, 204));
javax.swing.GroupLayout jPanel2Layout = new javax.swing.GroupLayout(jPanel2);
jPanel2.setLayout(jPanel2Layout);
jPanel2Layout.setHorizontalGroup(
jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGap(0, 878, Short.MAX_VALUE)
);
jPanel2Layout.setVerticalGroup(
jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGap(0, 31, Short.MAX_VALUE)
);
jPanel3.setBackground(new java.awt.Color(204, 204, 204));
javax.swing.GroupLayout jPanel3Layout = new javax.swing.GroupLayout(jPanel3);
jPanel3.setLayout(jPanel3Layout);
jPanel3Layout.setHorizontalGroup(
jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGap(0, 866, Short.MAX_VALUE)
);
jPanel3Layout.setVerticalGroup(
jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGap(0, 30, Short.MAX_VALUE)
);
jLabel2.setText("Data Atual:");
jLabel3.setFont(new java.awt.Font("Tahoma", 1, 14));
jLabel3.setText("Dados Banco");
jButton5.setText("AutoSystem");
jButton5.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jButton5ActionPerformed(evt);
}
});
jButton6.setText("Carregar Arquivo Banco");
jButton6.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jButton6ActionPerformed(evt);
}
});
JCbSelecionaBanco.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "Selecione o Banco", "Banco do Brasil", "Banco HSBC", "Cooperativa Sicredi" }));
JbSelecionaArquivo.setText("Selecionar Arquivo");
JbSelecionaArquivo.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
JbSelecionaArquivoActionPerformed(evt);
}
});
lblDataAtual.setBorder(javax.swing.BorderFactory.createTitledBorder(null, "", javax.swing.border.TitledBorder.DEFAULT_JUSTIFICATION, javax.swing.border.TitledBorder.DEFAULT_POSITION, new java.awt.Font("Arial Black", 1, 10), new java.awt.Color(51, 102, 255))); // NOI18N
dataInicial.setBorder(javax.swing.BorderFactory.createBevelBorder(javax.swing.border.BevelBorder.RAISED));
dataInicial.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
dataInicialActionPerformed(evt);
}
});
dataFinal.setBorder(javax.swing.BorderFactory.createBevelBorder(javax.swing.border.BevelBorder.RAISED));
dataFinal.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
dataFinalActionPerformed(evt);
}
});
jLabel4.setText("Data Final");
jLabel5.setText("Data Inicial");
jLabel1.setText("Selecione a Conta");
jCBSelecionaConta.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "Selecione a Conta" }));
javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
getContentPane().setLayout(layout);
layout.setHorizontalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jPanel2, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addGroup(layout.createSequentialGroup()
.addGap(2, 2, 2)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jPanel3, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addComponent(jScrollPane2, javax.swing.GroupLayout.DEFAULT_SIZE, 866, Short.MAX_VALUE)
.addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup()
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 513, Short.MAX_VALUE)
.addComponent(jPanel1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(19, 19, 19))
.addComponent(jScrollPane1, javax.swing.GroupLayout.DEFAULT_SIZE, 866, Short.MAX_VALUE)
.addGroup(layout.createSequentialGroup()
.addComponent(jLabel3)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(jButton6)
.addGap(59, 59, 59)
.addComponent(JCbSelecionaBanco, javax.swing.GroupLayout.PREFERRED_SIZE, 166, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(148, 148, 148)
.addComponent(JbSelecionaArquivo)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addComponent(lblArquivoSelecionado, javax.swing.GroupLayout.DEFAULT_SIZE, 121, Short.MAX_VALUE))
.addGroup(layout.createSequentialGroup()
.addComponent(jLabel2)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(lblDataAtual, javax.swing.GroupLayout.PREFERRED_SIZE, 101, javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addComponent(jLabel5)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addComponent(dataInicial, javax.swing.GroupLayout.PREFERRED_SIZE, 80, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(28, 28, 28)
.addComponent(jLabel4)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addComponent(dataFinal, javax.swing.GroupLayout.PREFERRED_SIZE, 78, javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(jLabel1, javax.swing.GroupLayout.DEFAULT_SIZE, 92, Short.MAX_VALUE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(jCBSelecionaConta, javax.swing.GroupLayout.PREFERRED_SIZE, 186, javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addComponent(jButton5)))
.addContainerGap())
);
layout.setVerticalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addComponent(jPanel2, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jLabel2, javax.swing.GroupLayout.PREFERRED_SIZE, 21, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel5)
.addComponent(dataInicial, javax.swing.GroupLayout.PREFERRED_SIZE, 21, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel4)
.addComponent(jButton5, javax.swing.GroupLayout.PREFERRED_SIZE, 24, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(dataFinal, javax.swing.GroupLayout.PREFERRED_SIZE, 21, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel1)
.addComponent(jCBSelecionaConta, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addComponent(lblDataAtual, javax.swing.GroupLayout.PREFERRED_SIZE, 24, javax.swing.GroupLayout.PREFERRED_SIZE))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 240, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addGap(24, 24, 24)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel3)
.addComponent(lblArquivoSelecionado, javax.swing.GroupLayout.PREFERRED_SIZE, 23, javax.swing.GroupLayout.PREFERRED_SIZE)))
.addGroup(layout.createSequentialGroup()
.addGap(18, 18, 18)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jButton6)
.addComponent(JCbSelecionaBanco, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(JbSelecionaArquivo))))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(jScrollPane2, javax.swing.GroupLayout.PREFERRED_SIZE, 235, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(8, 8, 8)
.addComponent(jPanel1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(jPanel3, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
);
pack();
}// </editor-fold>
private void jButton6ActionPerformed(java.awt.event.ActionEvent evt) {
if (diretorio == null) {
JOptionPane.showMessageDialog(null, "Selecione o Arquivo do Banco:");
} else if (JCbSelecionaBanco.getSelectedIndex() == 0) {
JOptionPane.showMessageDialog(null, "Selecione o Banco:");
} else {
File f = diretorio;
BufferedReader in = null;
try {
in = new BufferedReader(new FileReader(f));
} catch (FileNotFoundException ex) {
System.out.println("Não foi possível ler o arquivo, selecione outro arquivo!! ");
}
Scanner sc = new Scanner(in);
List<MovimentoBanco> listaMovimento = new ArrayList<MovimentoBanco>();
if (JCbSelecionaBanco.getSelectedIndex() == 3) {
int count = 0;
NumberFormat nf = NumberFormat.getCurrencyInstance();
while (sc.hasNextLine()) {
count++;
String linha = sc.nextLine();
if (count > 2) {
MovimentoBanco mov = new MovimentoBanco();
mov.setAgencia(linha.substring(53, 57));
mov.setConta(linha.substring(65, 71));
mov.setRazaoSocial(linha.substring(72, 101));
mov.setValor(linha.substring(160, 168));
mov.setLancamento(linha.substring(176, 201));
mov.setTipo(linha.substring(201, 202));
if (mov.getValor() != null && !mov.getValor().trim().equals("")) {
double valor = Double.parseDouble(mov.getValor().trim()) / 100;
mov.setValor(nf.format(valor));
}
listaMovimento.add(mov);
}
}
}
//Layout Banco Brasil
if (JCbSelecionaBanco.getSelectedIndex() == 1) {
int count = 0;
NumberFormat nf = NumberFormat.getCurrencyInstance();
while (sc.hasNextLine()) {
count++;
String linha = sc.nextLine();
if (count > 2) {
MovimentoBanco mov = new MovimentoBanco();
mov.setAgencia(linha.substring(53, 57));
mov.setConta(linha.substring(65, 71));
mov.setRazaoSocial(linha.substring(72, 101));
mov.setValor(linha.substring(160, 168));
mov.setLancamento(linha.substring(176, 201));
mov.setTipo(linha.substring(201, 202));
if (mov.getValor() != null && !mov.getValor().trim().equals("")) {
double valor = Double.parseDouble(mov.getValor().trim()) / 100;
mov.setValor(nf.format(valor));
}
listaMovimento.add(mov);
}
matriz(listaMovimento);
}
}
//layout Banco HSC
if (JCbSelecionaBanco.getSelectedIndex() == 2) {
int count = 0;
NumberFormat nf = NumberFormat.getCurrencyInstance();
while (sc.hasNextLine()) {
count++;
String linha = sc.nextLine();
if (count > 2) {
MovimentoBanco mov = new MovimentoBanco();
mov.setAgencia(linha.substring(53, 57));
mov.setConta(linha.substring(65, 71));
mov.setRazaoSocial(linha.substring(72, 101));
mov.setValor(linha.substring(160, 168));
mov.setLancamento(linha.substring(176, 201));
mov.setTipo(linha.substring(201, 202));
if (mov.getValor() != null && !mov.getValor().trim().equals("")) {
double valor = Double.parseDouble(mov.getValor().trim()) / 100;
mov.setValor(nf.format(valor));
}
listaMovimento.add(mov);
matriz(listaMovimento);
}
}
/*
//criando uma matriz
Object[][] obj = new Object[listaMovimento.size()][8];
for (int i = 0; i < listaMovimento.size(); i++) {
MovimentoBanco mov = listaMovimento.get(i);
obj[i][0] = new SimpleDateFormat("dd/MM/yyyy").format(new Date());
obj[i][1] = mov.getAgencia();
obj[i][2] = mov.getConta();
obj[i][3] = mov.getLancamento();
obj[i][4] = "";
obj[i][5] = mov.getValor();
obj[i][6] = mov.getTipo();
}
jTBanco.setModel(new javax.swing.table.DefaultTableModel(
obj,
new String[]{
"Data", "Agencia", "Conta Corrente", "Compensação", "Tipo Operação", "Valor", "Tipo", "Opção"
}));
**/
}
}
}
public void matriz(List moviment) {
MovimentoBanco mov = new MovimentoBanco();
//criando uma matriz
Object[][] obj = new Object[moviment.size()][8];
for (int i = 0; i < moviment.size(); i++) {
mov = (MovimentoBanco) moviment.get(i);
obj[i][0] = new SimpleDateFormat("dd/MM/yyyy").format(new Date());
obj[i][1] = mov.getAgencia();
obj[i][2] = mov.getConta();
obj[i][3] = mov.getLancamento();
obj[i][4] = "";
obj[i][5] = mov.getValor();
obj[i][6] = mov.getTipo();
}
jTBanco.setModel(new javax.swing.table.DefaultTableModel(
obj,
new String[]{
"Data", "Agencia", "Conta Corrente", "Compensação", "Tipo Operação", "Valor", "Tipo", "Opção"
}));
}
private void jButton4ActionPerformed(java.awt.event.ActionEvent evt) {
System.exit(WIDTH);
// TODO add your handling code here:
}
private void jButton5ActionPerformed(java.awt.event.ActionEvent evt) {
try {
Connection c = new ConectaBD().ConectaAgora();
//java.sql.CallableStatement stmt = c.prepareCall("select * from movto where data between ? and ? ");
java.sql.CallableStatement stmt = c.prepareCall("select movto.data, movto.documento, movto.motivo, motivo_movto.nome, movto.valor from"
+ " movto, motivo_movto where movto.motivo = motivo_movto.grid AND"
+ " data between ? and ? and child=0 order by valor ");
SimpleDateFormat df = new SimpleDateFormat("dd/MM/yyyy");
java.sql.Date data1 = new java.sql.Date(df.parse(dataInicial.getText()).getTime());
java.sql.Date data2 = new java.sql.Date(df.parse(dataFinal.getText()).getTime());
//String contaBanco = new String(JTSelecionaContaBanco.getText());
stmt.setDate(1, data1);
stmt.setDate(2, data2);
//stmt.setString(3, contaBanco);
ResultSet rs = stmt.executeQuery();
List<Cheque> lista = new LinkedList<Cheque>();
NumberFormat nf = NumberFormat.getCurrencyInstance();
while (rs.next()) {
Cheque cheque = new Cheque();
cheque.setData(rs.getString("data"));
cheque.setDocumento(rs.getString("documento"));
cheque.setNome(rs.getString("nome"));
// cheque.setFornecedor(rs.getString("fornecedor"));
cheque.setValorCheque(nf.format(rs.getString("valor") == null ? 0 : rs.getDouble("valor")));
lista.add(cheque);
}
//criando uma matriznull
Object[][] obj = new Object[lista.size()][4];
for (int i = 0; i < lista.size(); i++) {
Cheque chk = lista.get(i);
obj[i][0] = chk.getData();
obj[i][1] = chk.getDocumento();
obj[i][2] = chk.getNome();
//obj[i][3] = chk.getFornecedor();
obj[i][3] = chk.getValorCheque();
}
JtCheque.setModel(new javax.swing.table.DefaultTableModel(
obj,
new String[]{
"Data Lançamento", "Documento", "Motivo", "Valor","Crédito/Débito"
}));
rs.close();
stmt.close();
c.close();
} catch (SQLException ex) {
Logger.getLogger(ConciliaCheque.class.getName()).log(Level.SEVERE, null, ex);
} catch (ParseException ex) {
JOptionPane.showMessageDialog(null, "Datas Inválidas");
}
}
[color=red]//JComboBox
public void comboSelecionaConta(){[/color][size=18] [/size]
try {
Connection c = new ConectaBD().ConectaAgora();
java.sql.CallableStatement combo =c.prepareCall("select nome from conta");
//combo.setString(1, JCbSelecionaBanco);
ResultSet rsCombo = combo.executeQuery();
JCbSelecionaBanco = (JComboBox) rsCombo;
rsCombo.close();
combo.close();
c.close();
} catch (SQLException ex) {
Logger.getLogger(ConciliaCheque.class.getName()).log(Level.SEVERE, null, ex);
}
}
private void JbSelecionaArquivoActionPerformed(java.awt.event.ActionEvent evt) {
this.AbreArquivo();
}
private void dataInicialActionPerformed(java.awt.event.ActionEvent evt) {
FiltraData data = new FiltraData();
data.setDataFinal(null);
}
private void dataFinalActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
}
public void capturaData() {
String data = new SimpleDateFormat("dd/MM/yyyy").format(new Date());
lblDataAtual.setText(data);
}
/**
* @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(ConciliaCheque.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
} catch (InstantiationException ex) {
java.util.logging.Logger.getLogger(ConciliaCheque.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
} catch (IllegalAccessException ex) {
java.util.logging.Logger.getLogger(ConciliaCheque.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
} catch (javax.swing.UnsupportedLookAndFeelException ex) {
java.util.logging.Logger.getLogger(ConciliaCheque.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
}
//</editor-fold>
/* Create and display the dialog */
java.awt.EventQueue.invokeLater(new Runnable() {
public void run() {
ConciliaCheque dialog = new ConciliaCheque(new javax.swing.JFrame(), true);
dialog.addWindowListener(new java.awt.event.WindowAdapter() {
@Override
public void windowClosing(java.awt.event.WindowEvent e) {
System.exit(0);
}
});
dialog.setVisible(true);
}
});
}
File diretorio = null;
public void AbreArquivo() {
JFileChooser arquivo = new JFileChooser();
int retorno = arquivo.showOpenDialog(null);
if (retorno == JFileChooser.APPROVE_OPTION) {
diretorio = arquivo.getSelectedFile();
lblArquivoSelecionado.setText("Selecionado: " + diretorio.getName());
//JOptionPane.showMessageDialog(null,arquivo);
//JOptionPane.showMessageDialog(null, "Ok Arquivo Selecionado");
} else {
JOptionPane.showMessageDialog(null, "Não Foi Possivel localizar o Arquivo");
}
}
// Variables declaration - do not modify
private javax.swing.JComboBox JCbSelecionaBanco;
private javax.swing.JButton JbSelecionaArquivo;
private javax.swing.JTable JtCheque;
private javax.swing.JTextField dataFinal;
private javax.swing.JTextField dataInicial;
private javax.swing.JButton jButton1;
private javax.swing.JButton jButton2;
private javax.swing.JButton jButton3;
private javax.swing.JButton jButton4;
private javax.swing.JButton jButton5;
private javax.swing.JButton jButton6;
private javax.swing.JComboBox jCBSelecionaConta;
private javax.swing.JLabel jLabel1;
private javax.swing.JLabel jLabel2;
private javax.swing.JLabel jLabel3;
private javax.swing.JLabel jLabel4;
private javax.swing.JLabel jLabel5;
private javax.swing.JPanel jPanel1;
private javax.swing.JPanel jPanel2;
private javax.swing.JPanel jPanel3;
private javax.swing.JScrollPane jScrollPane1;
private javax.swing.JScrollPane jScrollPane2;
private javax.swing.JTable jTBanco;
private javax.swing.JLabel lblArquivoSelecionado;
private javax.swing.JLabel lblDataAtual;
// End of variables declaration
}ao executar da esse erro abaixo.
run:
Exception in thread “AWT-EventQueue-0” java.lang.ClassCastException: org.postgresql.jdbc4.Jdbc4ResultSet cannot be cast to javax.swing.JComboBox
at br.com.foxmilenium.view.ConciliaCheque.comboSelecionaConta(ConciliaCheque.java:572)
at br.com.foxmilenium.view.ConciliaCheque.(ConciliaCheque.java:52)
at br.com.foxmilenium.view.ConciliaCheque$7.run(ConciliaCheque.java:642)
at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209)
at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:641)
at java.awt.EventQueue.access$000(EventQueue.java:84)
at java.awt.EventQueue$1.run(EventQueue.java:602)
at java.awt.EventQueue$1.run(EventQueue.java:600)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:611)
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)