Criar metodo com matriz

1 resposta
fabiobufalari

Pessoal a duvida é o seguinte
fiz uma tabela preenchi, em seguida criei uma matriz, funcionou beleza, somente pra um layout"banco"

quando implementei outros bancos nao funciona por que precisa de executar as instruções a seguir a idéia seria fazer um metodo para executar logo apos cada layout .
mas nao consigo fazer esse metodo da muitos erros alguem pode me ajudar ?

Object[][] obj = new Object[listaMovimento.size()][8];


            for (int i = 0; i < listaMovimento.size(); i++) {
                Movimento 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"
                    }));
        } else {
            JOptionPane.showMessageDialog(null, "Banco ainda Não implementado");
        }
    }

Código Completo

/*
 * 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.FiltraData;
import br.com.foxmilenium.vo.Movimento;
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.JFileChooser;
import javax.swing.JOptionPane;
import javax.swing.table.TableModel;

/**
 *
 * @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);

    }

    /** 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();
        txtDataAtual = new javax.swing.JTextField();
        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();

        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}
            },
            new String [] {
                "Data", "Descrição", "Tipo Operação", "Valor"
            }
        ));
        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" }));

        txtDataAtual.setBorder(javax.swing.BorderFactory.createBevelBorder(javax.swing.border.BevelBorder.RAISED));
        txtDataAtual.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                txtDataAtualActionPerformed(evt);
            }
        });

        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");

        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)
                    .addGroup(layout.createSequentialGroup()
                        .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)
                                .addGap(18, 18, 18)
                                .addComponent(jButton6)
                                .addGap(18, 18, 18)
                                .addComponent(JCbSelecionaBanco, javax.swing.GroupLayout.PREFERRED_SIZE, 166, javax.swing.GroupLayout.PREFERRED_SIZE)
                                .addGap(34, 34, 34)
                                .addComponent(txtDataAtual, javax.swing.GroupLayout.PREFERRED_SIZE, 104, javax.swing.GroupLayout.PREFERRED_SIZE)
                                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
                                .addComponent(JbSelecionaArquivo)
                                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
                                .addComponent(lblArquivoSelecionado, javax.swing.GroupLayout.DEFAULT_SIZE, 148, Short.MAX_VALUE)))
                        .addContainerGap())
                    .addGroup(layout.createSequentialGroup()
                        .addComponent(jLabel2)
                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                        .addComponent(lblDataAtual, javax.swing.GroupLayout.PREFERRED_SIZE, 101, javax.swing.GroupLayout.PREFERRED_SIZE)
                        .addGap(64, 64, 64)
                        .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, 43, Short.MAX_VALUE)
                        .addComponent(jButton5)
                        .addGap(209, 209, 209))))
        );
        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(jButton5, javax.swing.GroupLayout.PREFERRED_SIZE, 24, javax.swing.GroupLayout.PREFERRED_SIZE)
                        .addComponent(jLabel5)
                        .addComponent(dataInicial, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                        .addComponent(dataFinal, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                        .addComponent(jLabel4))
                    .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)
                .addGap(24, 24, 24)
                .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(jLabel3)
                    .addComponent(jButton6)
                    .addComponent(JCbSelecionaBanco, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(txtDataAtual, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(JbSelecionaArquivo)
                    .addComponent(lblArquivoSelecionado, javax.swing.GroupLayout.PREFERRED_SIZE, 23, javax.swing.GroupLayout.PREFERRED_SIZE))
                .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<Movimento> listaMovimento = new ArrayList<Movimento>();
        if (JCbSelecionaBanco.getSelectedIndex() == 3) {
            int count = 0;
            NumberFormat nf = NumberFormat.getCurrencyInstance();
            while (sc.hasNextLine()) {
                count++;
                String linha = sc.nextLine();
                if (count > 2) {
                    Movimento mov = new Movimento();
                    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) {
                    Movimento mov = new Movimento();
                    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 HSC    
        if (JCbSelecionaBanco.getSelectedIndex() == 2) {
            int count = 0;
            NumberFormat nf = NumberFormat.getCurrencyInstance();
            while (sc.hasNextLine()) {
                count++;
                String linha = sc.nextLine();
                if (count > 2) {
                    Movimento mov = new Movimento();
                    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);
                }

            }



            //criando uma matriz
            Object[][] obj = new Object[listaMovimento.size()][8];


            for (int i = 0; i < listaMovimento.size(); i++) {
                Movimento 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"
                    }));
        } else {
            JOptionPane.showMessageDialog(null, "Banco ainda Não implementado");
        }
    }

}                                        
/*
    public void matriz(List moviment) {

        Movimento mov = new Movimento();
        //criando uma matriz
        Object[][] obj = new Object[moviment.size()][8];


        for (int i = 0; i < moviment.size(); i++) {
            mov = (Movimento)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 txtDataAtualActionPerformed(java.awt.event.ActionEvent evt) {                                             
}                                            

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 ? ");

            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());
            stmt.setDate(1, data1);
            stmt.setDate(2, data2);

            ResultSet rs = stmt.executeQuery();


            List<Cheque> lista = new LinkedList<Cheque>();
            NumberFormat nf = NumberFormat.getCurrencyInstance();
            while (rs.next()) {
                Cheque cheque = new Cheque();

                cheque.setContaCorrente(rs.getString("pessoa"));
                cheque.setEmpresaEmitente(rs.getString("conta_debitar"));
                cheque.setNumeroCheque(rs.getString("documento"));
                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.getContaCorrente();
                obj[i][1] = chk.getEmpresaEmitente();
                obj[i][2] = chk.getValorCheque();
                obj[i][3] = chk.getNumeroCheque();
            }


            JtCheque.setModel(new javax.swing.table.DefaultTableModel(
                    obj,
                    new String[]{
                        "Conta Corrente", "Empresa Emitente", "Valor", "Numero"
                    }));

            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");
        }


    }                                        

    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.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;
    private javax.swing.JTextField txtDataAtual;
    // End of variables declaration                   
}

1 Resposta

J

Fabio,

sua duvida está um pouco confusa. Talvez eu possa ajudar, mas preciso entender o que você quer.

Criado 26 de outubro de 2011
Ultima resposta 30 de out. de 2011
Respostas 1
Participantes 2