Erro ao atualizar banco de dados mysql

20/03/2010 22:49:37 forms.ConferenciaRecargas jButtonConfirmarRecebimentoActionPerformed
SEVERE: null
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '='2', loja='3', data='20/03/2010', hora='22:28', vendedor='111', valor='100,00',' at line 1
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
        at com.mysql.jdbc.Util.getInstance(Util.java:381)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2542)
        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1734)
        at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:995)
        at dao.VendaDAO.confirmaRecebimento(VendaDAO.java:66)
        at forms.ConferenciaRecargas.confirmaRecebimento(ConferenciaRecargas.java:360)
        at forms.ConferenciaRecargas.jButtonConfirmarRecebimentoActionPerformed(ConferenciaRecargas.java:329)
        at forms.ConferenciaRecargas.access$100(ConferenciaRecargas.java:30)
        at forms.ConferenciaRecargas$2.actionPerformed(ConferenciaRecargas.java:110)
        at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)
        at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318)
        at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)
        at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)
        at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236)
        at java.awt.Component.processMouseEvent(Component.java:6263)
        at javax.swing.JComponent.processMouseEvent(JComponent.java:3255)
        at java.awt.Component.processEvent(Component.java:6028)
        at java.awt.Container.processEvent(Container.java:2041)
        at java.awt.Component.dispatchEventImpl(Component.java:4630)
        at java.awt.Container.dispatchEventImpl(Container.java:2099)
        at java.awt.Component.dispatchEvent(Component.java:4460)
        at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4574)
        at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4238)
        at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4168)
        at java.awt.Container.dispatchEventImpl(Container.java:2085)
        at java.awt.Window.dispatchEventImpl(Window.java:2475)
        at java.awt.Component.dispatchEvent(Component.java:4460)
        at java.awt.EventQueue.dispatchEvent(EventQueue.java:599)
        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)

package dao;

import conexao.CriaConexao;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import modelos.DadosDaVenda;

/**
 *
 * @author marcus/+/LaraSoft/+/
 */
public class VendaDAO {

    // Inicia a conexão com o banco de dados
    private Connection conexao;

    // Construtor da classe VendaDao
    public VendaDAO() throws SQLException {
        this.conexao = CriaConexao.getConexao();
    }

    // Método que adiciona o contato ao banco de dados
    public void adiciona(DadosDaVenda v1) throws SQLException {
        // Prepara a conexão com o banco de dados
        String sql = "insert into lancamentoRecarga(loja,data,hora,vendedor,valor,operadora,ddd,numeroCelular)"
                + "values(?,?,?,?,?,?,?,?)";
        PreparedStatement stmt = conexao.prepareStatement(sql);

        // Seta os valores a serem inseridos no banco de dados
        // stmt.setString(1, v1.getNdc());
        stmt.setString(1, v1.getLoja());
        stmt.setString(2, v1.getDia());
        stmt.setString(3, v1.getHora());
        stmt.setString(4, v1.getVendedor());
        stmt.setString(5, v1.getValor());
        stmt.setString(6, v1.getOperadora());
        stmt.setString(7, v1.getDdd());
        stmt.setString(8, v1.getNumeroCelular());


        // Executa o código sql
        stmt.execute();
        stmt.close();
    }

    public void confirmaRecebimento(DadosDaVenda pend) throws SQLException {
        String sql = "update lancamentoRecarga ndc=?, loja=?, data=?, hora=?, vendedor=?, valor=?, operadora=?, ddd=?, numeroCelular=?, nsu=?, caixa=? where ndc like 2";
        PreparedStatement stmt = conexao.prepareStatement(sql);

        stmt.setString(1, pend.getNdc());
        stmt.setString(2, pend.getLoja());
        stmt.setString(3, pend.getDia());
        stmt.setString(4, pend.getHora());
        stmt.setString(5, pend.getVendedor());
        stmt.setString(6, pend.getValor());
        stmt.setString(7, pend.getOperadora());
        stmt.setString(8, pend.getDdd());
        stmt.setString(9, pend.getNumeroCelular());
        stmt.setString(10, pend.getNsu());
        stmt.setString(11, pend.getCaixa());

        stmt.execute();
        stmt.close();
    }

    public List<DadosDaVenda> getLista() throws SQLException {
        String sql = "select * from lancamentoRecarga where loja like 3";
        PreparedStatement stmt = this.conexao.prepareStatement(sql);
        ResultSet rs = stmt.executeQuery();
        List<DadosDaVenda> listaVendas = new ArrayList<DadosDaVenda>();

        while (rs.next()) {
            DadosDaVenda dv = new DadosDaVenda();
            dv.setNdc(rs.getString("ndc"));
            dv.setLoja(rs.getString("loja"));
            dv.setDia(rs.getString("data"));
            dv.setHora(rs.getString("hora"));
            dv.setVendedor(rs.getString("vendedor"));
            dv.setValor(rs.getString("valor"));
            dv.setOperadora(rs.getString("operadora"));
            dv.setDdd(rs.getString("ddd"));
            dv.setNumeroCelular(rs.getString("numeroCelular"));
            dv.setNsu(rs.getString("nsu"));
            dv.setCaixa(rs.getString("caixa"));

            listaVendas.add(dv);
        }
        rs.close();
        stmt.close();

        return listaVendas;
    }
    /**
    public List<DadosDaVenda> getLista(String ndc) throws SQLException {
    String sql = "select * from controleRecarga where ndc like ?";
    PreparedStatement stmt = this.conexao.prepareStatement(sql);
    stmt.setString(1, ndc);
    ResultSet rs = stmt.executeQuery();
    List<DadosDaVenda> listaVendas = new ArrayList<DadosDaVenda>();

    while (rs.next()) {
    DadosDaVenda dv = new DadosDaVenda();
    dv.setNdc(rs.getString("ndc"));
    dv.setLoja(rs.getString("loja"));
    dv.setDia(rs.getString("data"));
    dv.setHora(rs.getString("hora"));
    dv.setVendedor(rs.getString("vendedor"));
    dv.setValor(rs.getString("valor"));
    dv.setOperadora(rs.getString("operadora"));
    dv.setDdd(rs.getString("ddd"));
    dv.setNumeroCelular(rs.getString("numeroCelular"));
    dv.setRecebido(rs.getBoolean("recebido"));

    listaVendas.add(dv);
    }
    rs.close();
    stmt.close();

    return listaVendas;
    }
     */
}

package forms;

import dao.VendaDAO;
import java.sql.SQLException;
import java.util.List;
import java.util.logging.Level;
import java.util.logging.Logger;
import javax.swing.JOptionPane;
import javax.swing.JTable;
import javax.swing.ListSelectionModel;
import javax.swing.event.ListSelectionEvent;
import javax.swing.event.ListSelectionListener;
import javax.swing.table.DefaultTableModel;
import modelos.DadosDaVenda;

/**
 *
 * @author marcus
 */
public class ConferenciaRecargas extends javax.swing.JFrame {

    DefaultTableModel tmConferencia = new DefaultTableModel(null, new String[]{"Ndc", "Loja", "Data", "Hora", "Vendedor", "Valor", "Operadora", "DDD", "Número do celular", "NSU", "Caixa",});
    List<DadosDaVenda> controleRecarga;
    ListSelectionModel lsmDadosDaVenda;

    /** Creates new form ConferenciaRecargas */
    public ConferenciaRecargas() {
        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() {

        jLabel1 = new javax.swing.JLabel();
        jPanel3 = new javax.swing.JPanel();
        jLabelHora = new javax.swing.JLabel();
        jTHora = new javax.swing.JTextField();
        jLabelVendedor = new javax.swing.JLabel();
        jTVendedor = new javax.swing.JTextField();
        jLabelValor = new javax.swing.JLabel();
        jTValor = new javax.swing.JTextField();
        jLOperadora = new javax.swing.JLabel();
        jTOperadora = new javax.swing.JTextField();
        jLabelNumeroCelular = new javax.swing.JLabel();
        jTNumeroCelular = new javax.swing.JTextField();
        jButtonConfirmarRecebimento = new javax.swing.JButton();
        jLabel2 = new javax.swing.JLabel();
        jTNdc = new javax.swing.JTextField();
        jLabel3 = new javax.swing.JLabel();
        jTData = new javax.swing.JTextField();
        jLabelHora1 = new javax.swing.JLabel();
        jTDdd = new javax.swing.JTextField();
        jLabelVendedor1 = new javax.swing.JLabel();
        jTNsu = new javax.swing.JTextField();
        jPanel1 = new javax.swing.JPanel();
        jScrollPane1 = new javax.swing.JScrollPane();
        jTableControle = new javax.swing.JTable();
        jTLoja = new javax.swing.JTextField();
        jLabelLoja = new javax.swing.JLabel();
        jPanel4 = new javax.swing.JPanel();
        jButtonRecargasPendentes = new javax.swing.JButton();
        jLabelLoja1 = new javax.swing.JLabel();
        jTCaixa = new javax.swing.JTextField();
        jMenuBar1 = new javax.swing.JMenuBar();
        jMenu1 = new javax.swing.JMenu();
        jMenuItem1 = new javax.swing.JMenuItem();

        setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);

        jLabel1.setFont(new java.awt.Font("Ouhod-Bold", 0, 24));
        jLabel1.setText("Conferência de recargas");

        jPanel3.setBorder(javax.swing.BorderFactory.createTitledBorder("Dados da venda"));

        jLabelHora.setText("Hora:");

        jLabelVendedor.setText("Vendedor:");

        jLabelValor.setText("Valor:");

        jLOperadora.setText("Operadora:");

        jLabelNumeroCelular.setText("Número do celular:");

        jTNumeroCelular.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jTNumeroCelularActionPerformed(evt);
            }
        });

        jButtonConfirmarRecebimento.setText("Confirmar recebimento");
        jButtonConfirmarRecebimento.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButtonConfirmarRecebimentoActionPerformed(evt);
            }
        });

        jLabel2.setText("NDC:");

        jTNdc.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jTNdcActionPerformed(evt);
            }
        });

        jLabel3.setText("Data:");

        jTData.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jTDataActionPerformed(evt);
            }
        });

        jLabelHora1.setText("DDD:");

        jLabelVendedor1.setText("NSU:");

        javax.swing.GroupLayout jPanel3Layout = new javax.swing.GroupLayout(jPanel3);
        jPanel3.setLayout(jPanel3Layout);
        jPanel3Layout.setHorizontalGroup(
            jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(jPanel3Layout.createSequentialGroup()
                .addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
                    .addGroup(jPanel3Layout.createSequentialGroup()
                        .addGap(13, 13, 13)
                        .addComponent(jLabel2)
                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                        .addComponent(jTNdc, javax.swing.GroupLayout.PREFERRED_SIZE, 62, javax.swing.GroupLayout.PREFERRED_SIZE)
                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                        .addComponent(jLabelHora)
                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                        .addComponent(jTHora, javax.swing.GroupLayout.PREFERRED_SIZE, 72, javax.swing.GroupLayout.PREFERRED_SIZE)
                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                        .addComponent(jLabel3)
                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                        .addComponent(jTData, javax.swing.GroupLayout.PREFERRED_SIZE, 62, javax.swing.GroupLayout.PREFERRED_SIZE)
                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                        .addComponent(jLabelVendedor)
                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                        .addComponent(jTVendedor, javax.swing.GroupLayout.PREFERRED_SIZE, 60, javax.swing.GroupLayout.PREFERRED_SIZE)
                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                        .addComponent(jLabelValor)
                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                        .addComponent(jTValor, javax.swing.GroupLayout.PREFERRED_SIZE, 80, javax.swing.GroupLayout.PREFERRED_SIZE))
                    .addGroup(jPanel3Layout.createSequentialGroup()
                        .addContainerGap()
                        .addComponent(jLabelVendedor1)
                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                        .addComponent(jTNsu, javax.swing.GroupLayout.PREFERRED_SIZE, 60, javax.swing.GroupLayout.PREFERRED_SIZE)
                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                        .addComponent(jButtonConfirmarRecebimento)))
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addComponent(jLOperadora)
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addComponent(jTOperadora, javax.swing.GroupLayout.PREFERRED_SIZE, 57, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addComponent(jLabelHora1)
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addComponent(jTDdd, javax.swing.GroupLayout.PREFERRED_SIZE, 43, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addComponent(jLabelNumeroCelular)
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addComponent(jTNumeroCelular, javax.swing.GroupLayout.DEFAULT_SIZE, 155, Short.MAX_VALUE)
                .addContainerGap())
        );
        jPanel3Layout.setVerticalGroup(
            jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(jPanel3Layout.createSequentialGroup()
                .addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(jLabel2)
                    .addComponent(jTNdc, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(jTNumeroCelular, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(jLabelHora)
                    .addComponent(jTHora, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(jLabel3)
                    .addComponent(jTData, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(jLabelVendedor)
                    .addComponent(jTVendedor, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(jTValor, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(jLabelValor)
                    .addComponent(jTOperadora, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(jLOperadora)
                    .addComponent(jLabelHora1)
                    .addComponent(jTDdd, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(jLabelNumeroCelular))
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 12, Short.MAX_VALUE)
                .addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(jLabelVendedor1)
                    .addComponent(jTNsu, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(jButtonConfirmarRecebimento)))
        );

        jPanel1.setBorder(javax.swing.BorderFactory.createTitledBorder("Controle de recargas"));

        jTableControle.setModel(tmConferencia);
        jTableControle.setSelectionMode(ListSelectionModel.SINGLE_SELECTION);
        lsmDadosDaVenda = jTableControle.getSelectionModel();
        lsmDadosDaVenda.addListSelectionListener(new ListSelectionListener(){
            public void valueChanged(ListSelectionEvent e){
                if(! e.getValueIsAdjusting()){
                    jTableLinhaSelecionada(jTableControle);
                }
            }
        });
        jScrollPane1.setViewportView(jTableControle);

        javax.swing.GroupLayout jPanel1Layout = new javax.swing.GroupLayout(jPanel1);
        jPanel1.setLayout(jPanel1Layout);
        jPanel1Layout.setHorizontalGroup(
            jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addComponent(jScrollPane1, javax.swing.GroupLayout.DEFAULT_SIZE, 1230, Short.MAX_VALUE)
        );
        jPanel1Layout.setVerticalGroup(
            jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addComponent(jScrollPane1, javax.swing.GroupLayout.DEFAULT_SIZE, 152, Short.MAX_VALUE)
        );

        jTLoja.setEditable(false);
        jTLoja.setText("3");
        jTLoja.setFocusable(false);
        jTLoja.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jTLojaActionPerformed(evt);
            }
        });

        jLabelLoja.setText("Loja:");

        jButtonRecargasPendentes.setText("Visualizar recargas pendentes");
        jButtonRecargasPendentes.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jButtonRecargasPendentesActionPerformed(evt);
            }
        });

        javax.swing.GroupLayout jPanel4Layout = new javax.swing.GroupLayout(jPanel4);
        jPanel4.setLayout(jPanel4Layout);
        jPanel4Layout.setHorizontalGroup(
            jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(jPanel4Layout.createSequentialGroup()
                .addGap(501, 501, 501)
                .addComponent(jButtonRecargasPendentes)
                .addContainerGap(532, Short.MAX_VALUE))
        );
        jPanel4Layout.setVerticalGroup(
            jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addComponent(jButtonRecargasPendentes)
        );

        jLabelLoja1.setText("Operador de caixa:");

        jMenuBar1.setBackground(java.awt.Color.orange);

        jMenu1.setText("Outras funções");

        jMenuItem1.setAccelerator(javax.swing.KeyStroke.getKeyStroke(java.awt.event.KeyEvent.VK_O, java.awt.event.InputEvent.CTRL_MASK));
        jMenuItem1.setText("Troca de operador");
        jMenu1.add(jMenuItem1);

        jMenuBar1.add(jMenu1);

        setJMenuBar(jMenuBar1);

        javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
        getContentPane().setLayout(layout);
        layout.setHorizontalGroup(
            layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(layout.createSequentialGroup()
                .addContainerGap()
                .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addComponent(jPanel4, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                    .addComponent(jPanel1, javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                    .addGroup(layout.createSequentialGroup()
                        .addComponent(jLabel1)
                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 692, Short.MAX_VALUE)
                        .addComponent(jLabelLoja)
                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                        .addComponent(jTLoja, javax.swing.GroupLayout.PREFERRED_SIZE, 34, javax.swing.GroupLayout.PREFERRED_SIZE)
                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                        .addComponent(jLabelLoja1)
                        .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                        .addComponent(jTCaixa, javax.swing.GroupLayout.PREFERRED_SIZE, 51, javax.swing.GroupLayout.PREFERRED_SIZE))
                    .addComponent(jPanel3, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
                .addContainerGap())
        );
        layout.setVerticalGroup(
            layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(layout.createSequentialGroup()
                .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                    .addComponent(jLabel1)
                    .addComponent(jLabelLoja1)
                    .addComponent(jLabelLoja)
                    .addComponent(jTLoja, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addComponent(jTCaixa, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addComponent(jPanel1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                .addComponent(jPanel4, 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)
                .addContainerGap(106, Short.MAX_VALUE))
        );

        pack();
    }// </editor-fold>

    private void jTNumeroCelularActionPerformed(java.awt.event.ActionEvent evt) {                                                
        // TODO add your handling code here:
}                                               

    private void jButtonConfirmarRecebimentoActionPerformed(java.awt.event.ActionEvent evt) {                                                            
        try {
            confirmaRecebimento();
        } catch (SQLException ex) {
            Logger.getLogger(ConferenciaRecargas.class.getName()).log(Level.SEVERE, null, ex);
        }
}                                                           

    private void jTLojaActionPerformed(java.awt.event.ActionEvent evt) {                                       
        // TODO add your handling code here:
}                                      

    protected void listarVendas() throws SQLException {
        VendaDAO dao = new VendaDAO();
        controleRecarga = dao.getLista();
        mostraPesquisa(controleRecarga);
    }

    private void confirmaRecebimento() throws SQLException {
        if (jTableControle.getSelectedRow() != -1) {
            DadosDaVenda pend = new DadosDaVenda();
            VendaDAO dao = new VendaDAO();
            pend.setNdc(String.valueOf(jTNdc.getText()));
            pend.setLoja(String.valueOf(jTLoja.getText()));
            pend.setDia(String.valueOf(jTData.getText()));
            pend.setHora(String.valueOf(jTHora.getText()));
            pend.setVendedor(String.valueOf(jTVendedor.getText()));
            pend.setValor(String.valueOf(jTValor.getText()));
            pend.setOperadora(String.valueOf(jTOperadora.getText()));
            pend.setDdd(String.valueOf(jTDdd.getText()));
            pend.setNumeroCelular(String.valueOf(jTNumeroCelular.getText()));
            pend.setNsu(String.valueOf(jTNsu.getText()));
            pend.setCaixa(String.valueOf(jTCaixa.getText()));
            dao.confirmaRecebimento(pend);
            JOptionPane.showMessageDialog(null, "Venda recebida com sucesso!");
        }
    }

    private void jTableLinhaSelecionada(JTable jTableControle) {
        jTNdc.setText(String.valueOf(controleRecarga.get(jTableControle.getSelectedRow()).getNdc()));
        jTLoja.setText(String.valueOf(controleRecarga.get(jTableControle.getSelectedRow()).getLoja()));
        jTData.setText(String.valueOf(controleRecarga.get(jTableControle.getSelectedRow()).getDia()));
        jTHora.setText(controleRecarga.get(jTableControle.getSelectedRow()).getHora());
        jTVendedor.setText(controleRecarga.get(jTableControle.getSelectedRow()).getVendedor());
        jTValor.setText(controleRecarga.get(jTableControle.getSelectedRow()).getValor());
        jTDdd.setText(controleRecarga.get(jTableControle.getSelectedRow()).getDdd());
        jTOperadora.setText(controleRecarga.get(jTableControle.getSelectedRow()).getOperadora());
        jTNumeroCelular.setText(controleRecarga.get(jTableControle.getSelectedRow()).getNumeroCelular());
        jTNsu.setText(controleRecarga.get(jTableControle.getSelectedRow()).getNsu());
        jTCaixa.setText(controleRecarga.get(jTableControle.getSelectedRow()).getCaixa());
    }

    private void jTNdcActionPerformed(java.awt.event.ActionEvent evt) {                                      
        // TODO add your handling code here:
    }                                     

    private void jButtonRecargasPendentesActionPerformed(java.awt.event.ActionEvent evt) {                                                         
        try {
            listarVendas();
        } catch (SQLException ex) {
            JOptionPane.showMessageDialog(null, "Não existem recargas de celular para receber!");
        }
    }                                                        

    private void jTDataActionPerformed(java.awt.event.ActionEvent evt) {                                       
        // 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 ConferenciaRecargas().setVisible(true);
            }
        });
    }
    // Variables declaration - do not modify
    private javax.swing.JButton jButtonConfirmarRecebimento;
    private javax.swing.JButton jButtonRecargasPendentes;
    private javax.swing.JLabel jLOperadora;
    private javax.swing.JLabel jLabel1;
    private javax.swing.JLabel jLabel2;
    private javax.swing.JLabel jLabel3;
    private javax.swing.JLabel jLabelHora;
    private javax.swing.JLabel jLabelHora1;
    private javax.swing.JLabel jLabelLoja;
    private javax.swing.JLabel jLabelLoja1;
    private javax.swing.JLabel jLabelNumeroCelular;
    private javax.swing.JLabel jLabelValor;
    private javax.swing.JLabel jLabelVendedor;
    private javax.swing.JLabel jLabelVendedor1;
    private javax.swing.JMenu jMenu1;
    private javax.swing.JMenuBar jMenuBar1;
    private javax.swing.JMenuItem jMenuItem1;
    private javax.swing.JPanel jPanel1;
    private javax.swing.JPanel jPanel3;
    private javax.swing.JPanel jPanel4;
    private javax.swing.JScrollPane jScrollPane1;
    private javax.swing.JTextField jTCaixa;
    private javax.swing.JTextField jTData;
    private javax.swing.JTextField jTDdd;
    private javax.swing.JTextField jTHora;
    private javax.swing.JTextField jTLoja;
    private javax.swing.JTextField jTNdc;
    private javax.swing.JTextField jTNsu;
    private javax.swing.JTextField jTNumeroCelular;
    private javax.swing.JTextField jTOperadora;
    private javax.swing.JTextField jTValor;
    private javax.swing.JTextField jTVendedor;
    private javax.swing.JTable jTableControle;
    // End of variables declaration

    private void mostraPesquisa(List<DadosDaVenda> controleRecarga) {
        while (tmConferencia.getRowCount() > 0) {
            tmConferencia.removeRow(0);
        }
        if (controleRecarga.size() == 0) {
            JOptionPane.showMessageDialog(null, "Não existem recargas de celular para confirmar!");
        } else {
            String[] linha = new String[]{null, null, null, null, null, null, null, null};
            for (int i = 0; i < controleRecarga.size(); i++) {
                tmConferencia.addRow(linha);
                tmConferencia.setValueAt(controleRecarga.get(i).getNdc(), i, 0);
                tmConferencia.setValueAt(controleRecarga.get(i).getLoja(), i, 1);
                tmConferencia.setValueAt(controleRecarga.get(i).getDia(), i, 2);
                tmConferencia.setValueAt(controleRecarga.get(i).getHora(), i, 3);
                tmConferencia.setValueAt(controleRecarga.get(i).getVendedor(), i, 4);
                tmConferencia.setValueAt(controleRecarga.get(i).getValor(), i, 5);
                tmConferencia.setValueAt(controleRecarga.get(i).getOperadora(), i, 6);
                tmConferencia.setValueAt(controleRecarga.get(i).getDdd(), i, 7);
                tmConferencia.setValueAt(controleRecarga.get(i).getNumeroCelular(), i, 8);
            }
        }
    }
}