Java na empresa!

Programação Java
#1

Essa é pra galera que tem mais experiência em aplicações empresariais hauhaua ou os verdadeiros javeiros rs…

Precios de uma idéia interessante para:

No meu programa existirá uma tela para o usuário lançar pedidos de vendas, nisso ele pode lançar 1 ou mais de 100 itens.

A minha idéia é a seguinte: crio TextField normal, com os campos e coloco um botão incluir produto, que ao incluir ele adiciona a uma tela, tipo um tableModel e grava no banco direto.

Agora gostaria de sugestões, de algo mais fácil ou mais funcional para isso.

Se alguém já fez algum programa do tipo,e quiser compartilhar a experiência…

Valeu!

#2

Vê se isso te ajuda: http://www.guj.com.br/posts/list/10673.java

#3

Daniel, o que preciso fazer é exatamente a sua figura…
Por fim, vc acabou uitlizando Jtable ou deixou daquele jeito?

Vc não que rdisponibilizar um pouco de seu código pra mim não rs…sei que não vou entender quase nada mas já seria um grande espelho para me basear…

Valeu! 8)

#4

Acabei usando JTable e criando um renderer e um table model ao meu gosto, que acabou me dando BEM MENOS trabalho do que montar aquela tela usando outros componentes e assumindo o controle daquele monstro.

Penei um pouco para “visualizar” todo o modelo do JTable, mas depois que você “enxerga” fica facinho.

Infelizmente estou sem o código, pois fiz isso num cliente que está longe daqui.

Mas basicamente é o seguinte, você precisa construir um renderer se deseja ter uma coluna com alguma característica diferente da padrão, por exemplo uma área de texto com um botão pesquisar, como no meu caso. Pra outras coisas como combobox e cores, o JTable já faz isso. Veja nos exemplos.

E o model eu criei um para trabalhar exclusivamente com o tipo de dados que eu queria, no caso era algo como: Pedido -> Itens Pedido -> Produtos.

#5

Ei Daniel vi sua figura JTable , tava reparando tbm… vc utilizo MDI para os frames ?

#6

Sim!

#7

Vc já utilizo o JASPEReports IReports ?

#8

Muito pouco, pouquíssimo.

#9

Preciso gera um relatorio mas ta foda com JASPER IReports to apanhando , como vc gera relatorios ? Crystal Reports ?

#10

Como eu disse, usei pouquíssimo. Mas fiz um teste simples com o iReport/Jasper e parece fácil. Para ajudar a Java Magazine tem duas edições com artigos sobre o assunto (edições 13 e 21).

#11

e aí paulinho, vc jah achou a solucao p o seu problema???

#12

Aeamorin blz?

Pior que não cara, tá meio complicado viu…vc tem alguma solução???

#13

tenho um código que eu faço os lançamentos, salvo no banco e atualizo na JTable, ta meio bagunçado já que sou iniciante, mas acho q dah pra tirar algo proveito

segue o codigo

/*
 * MovEmbarque.java
 *
 * Created on 12 de Abril de 2005, 10:43
 */

package transportes;

import java.util.*;
import java.text.*;
import javax.swing.*;
import javax.swing.table.DefaultTableModel;
import java.sql.*;
import java.util.Date;
import javax.swing.text.MaskFormatter;



/**
 *
 * @author  Administrator
 */
public class MovEmbarque extends javax.swing.JDialog {
    
    /** Creates new form MovEmbarque */
    public MovEmbarque(java.awt.Frame parent, boolean modal) {
        super(parent, modal);
        initComponents();
        
        try
        {
            MaskFormatter fdata = new MaskFormatter("##/##/####");
            tdat = new JFormattedTextField(fdata);
            tpini = new JFormattedTextField(fdata);
            tpfin = new JFormattedTextField(fdata);
            
            tdat.setEditable(false);
            tpini.setEditable(false);
            tpfin.setEditable(false);
            
            tdat.setBounds(340,10, 100,20);
            tpini.setBounds(10,20, 70,20);
            tpfin.setBounds(140, 20, 70, 20);
            
            pCampos.add(tdat);
            pperiodo.add(tpini);
            pperiodo.add(tpfin);
        }
        catch (ParseException ep)
        {
            // nao faz nada
        }
               
        SimpleDateFormat sdf = new SimpleDateFormat("dd/MM/yyyy");
        Date nDat = new Date();
        GregorianCalendar cal = new GregorianCalendar();
        cal.setTime(nDat);
        cal.add(Calendar.DAY_OF_MONTH,-1);
        Date dateIni = cal.getTime();
        cal.setTime(nDat);
        cal.add(Calendar.DAY_OF_MONTH,1);
        Date dateFin = cal.getTime();

        String yDat = sdf.format(dateIni).toString();
        String sDat = sdf.format(nDat).toString();
        String tDat = sdf.format(dateFin).toString();

        tpini.setText(yDat);
        tdat.setText(sDat);
        tpfin.setText(tDat);
        BuscaBanco();
        
        disableUpdate();
    }
    
    /**
     * insere um novo registro ou altera um registro existente
     */
    public void insert()
    {
        conecta();
        try
        {
            query = "select carga from tab_mov_emb where carga = \"" + tcarga.getText() + "\"";
            stm = con.prepareStatement(query);
            rs = stm.executeQuery();
            
            if(rs.next())
            {
               query = "update tab_mov_emb set vend = \"" + tcodVend.getText() + "\", rota = \"" + tcodRota.getText() + "\", placa = \"" + tplacaVeic.getText() + "\", lombp = \"" + tcodLombp.getText() + "\", lombs = \"" + tcodLombs.getText() + "\", data = \"" + tdat.getText() + "\"  where carga = \"" + tcarga.getText() + "\"";  
               stm = con.prepareStatement(query);
               stm.execute();
            }
            else
            {
                query = "insert into tab_mov_emb(carga,vend,rota,placa,lombp,lombs,data) values ('" + tcarga.getText() + "','" + tcodVend.getText() +"','" + tcodRota.getText() +"','" + tplacaVeic.getText() +"','" + tcodLombp.getText() +"','" + tcodLombs.getText() +"','" + tdat.getText() + "')";
                stm = con.prepareStatement(query);
                stm.execute();
            }
            limpaCampos();
            bok.setEnabled(false);
            bdel.setEnabled(false);
            disableUpdate();
        }
        catch (SQLException ex)
        {
            JOptionPane.showMessageDialog(null,ex,"Erro",JOptionPane.ERROR_MESSAGE);
        }
    }
    
    public void conecta()
    {
        try
        {
            Class.forName("com.mysql.jdbc.Driver");
            con = DriverManager.getConnection("jdbc:mysql://192.168.4.3:3306/dbtransp",usuario, senha);
        }
        catch (ClassNotFoundException ex)
        {
            JOptionPane.showMessageDialog(null,ex,"Erro",JOptionPane.ERROR_MESSAGE);
        }
        catch (SQLException ex)
        {
            JOptionPane.showMessageDialog(null,ex,"Erro",JOptionPane.ERROR_MESSAGE);
        }
    }
    
    public void BuscaBanco()
    {
        limpaJTable();
        
        conecta();
        try
        {
            query = "select * from tab_mov_emb where data >= \"" + tpini.getText() + "\" and data <= \"" + tpfin.getText() + "\"";
            stm = con.prepareStatement(query);
            rs = stm.executeQuery();
            
            rsmd = rs.getMetaData();
            
            if(rs!=null)
            {
                rs.beforeFirst();
                while(rs.next())
                {
                    nLinha = new Vector();
                    
                    String qVeic = "select * from tab_veic where placa_veic = \"" + rs.getString("placa") + "\"";
                    String qVend = "select * from tab_vend where cod_vend = \"" + rs.getString("vend") + "\"";
                    String qRota = "select * from tab_rota where cod_rota = \"" + rs.getString("rota") + "\"";
                    String qLombp = "select * from tab_lomb where cod_lomb = \"" + rs.getString("lombp") + "\"";
                    String qLombs = "select * from tab_lomb where cod_lomb = \"" + rs.getString("lombs") + "\"";
                    
                    stm = con.prepareStatement(qVeic);
                    rsVeic = stm.executeQuery();
                    stm = con.prepareStatement(qVend);
                    rsVend = stm.executeQuery();
                    stm = con.prepareStatement(qRota);
                    rsRota = stm.executeQuery();
                    stm = con.prepareStatement(qLombp);
                    rsLombp = stm.executeQuery();
                    stm = con.prepareStatement(qLombs);
                    rsLombs = stm.executeQuery();
                    
                    
                    nLinha.addElement(rs.getObject(1));
                    nLinha.addElement(rs.getObject(7));
                    nLinha.addElement(rs.getObject(4));
                    
                    if(rsVeic.next())
                    {
                        nLinha.addElement(rsVeic.getObject(2));
                        nLinha.addElement(rsVeic.getObject(3));
                    }
                    else
                    {
                        nLinha.addElement("");
                        nLinha.addElement("");
                    }
                    
                    if(rsVend.next())
                    {
                        nLinha.addElement(rsVend.getObject(2));
                    }
                    else
                    {
                        nLinha.addElement("");
                    }
                    
                    if(rsRota.next())
                    {
                        nLinha.addElement(rsRota.getObject(2));
                    }
                    else
                    {
                        nLinha.addElement("");
                    }
                    
                    if(rsLombp.next())
                    {
                        nLinha.addElement(rsLombp.getObject(2));
                    }
                    else
                    {
                        nLinha.addElement("");
                    }
                    
                    if(rsLombs.next())
                    {
                        nLinha.addElement(rsLombs.getObject(2));
                    }
                    else
                    {
                        nLinha.addElement("");
                    }
                                        
                    Object ObjLinha = new Object();
                    DefaultTableModel dtm = (DefaultTableModel)tab.getModel();
                    dtm.addRow(nLinha);
                }
            }
        }
        catch (SQLException ex)
        {
            JOptionPane.showMessageDialog(null,ex,"Erro",JOptionPane.ERROR_MESSAGE);
        }
    }
    
    public void limpaJTable()
    {
        int lLinha = tab.getRowCount();
        //int [] lLinha = Tab.getSelectedRows();

        DefaultTableModel dtm = (DefaultTableModel)tab.getModel();
        
        for (int i = lLinha-1;i >=0; i--)
        {
            dtm.removeRow(i);
        }
    }
    
    public void select(Object codConsulta)
    {
        conecta();
        try
        {
            query = "select * from tab_mov_emb where carga = \"" + codConsulta + "\"";
            stm = con.prepareStatement(query);
            rs = stm.executeQuery();
            
            if(rs.next())
            {
                tcarga.setText(rs.getString("carga"));
                tcodVend.setText(rs.getString("vend"));
                tcodRota.setText(rs.getString("rota"));
                tplacaVeic.setText(rs.getString("placa"));
                tcodLombp.setText(rs.getString("lombp"));
                tcodLombs.setText(rs.getString("lombs"));
            }
            
            selectVend(tcodVend.getText());
            selectRota(tcodRota.getText());
            selectVeic(tplacaVeic.getText());
            selectLombp(tcodLombp.getText());
            selectLombs(tcodLombs.getText());
        }
        catch (SQLException ex)
        {
           JOptionPane.showMessageDialog(null,ex,"Erro",JOptionPane.ERROR_MESSAGE); 
        }
    }
    
    public void delete(Object codConsulta)
    {
        disableUpdate();
        conecta();
        try
        {
            query = "select * from tab_mov_emb where carga = \"" + codConsulta + "\"";
            stm = con.prepareStatement(query);
            rs = stm.executeQuery();
            if(rs.next())
            {
                delete = JOptionPane.showConfirmDialog(null,"Deseja excluir a Carga " + rs.getString("carga") + "?","Mensagem",JOptionPane.YES_NO_OPTION);
                if(delete == JOptionPane.YES_OPTION)
                {
                    stm = con.prepareStatement("delete from tab_mov_emb where carga = \"" + codSelected + "\"");
                    stm.executeUpdate();
                    limpaCampos();
                }
            }
            BuscaBanco();
            bdel.setEnabled(false);
        }
        catch (SQLException ex)
        {
            JOptionPane.showMessageDialog(null,ex,"Erro!!!",JOptionPane.ERROR_MESSAGE);
        }
        disableUpdate();
    }
    
    public void selectLinha()
    {
        int sLinha = tab.getSelectedRow();
        int sColuna = 0;
        
        codSelected = tab.getValueAt(sLinha,0);
        select(codSelected);
    }
    
    public void deleteLinha()
    {
        int sLinha = tab.getSelectedRow();
        int sColuna = 0;
        
        codSelected = tab.getValueAt(sLinha,0);
        delete(codSelected);
    }
    
    public void consultaVend()
    {
        ConVend conVend = new ConVend(null,true);
        conVend.show();
        selectVend(conVend.codSelected);
    }
    
    public void consultaRota()
    {
        ConRota conRota = new ConRota(null, true);
        conRota.show();
        selectRota(conRota.codSelected);
    }
    
    public void consultaVeic()
    {
        ConVeic conVeic = new ConVeic(null, true);
        conVeic.show();
        selectVeic(conVeic.codSelected);
    }
    
    public void consultaLombp()
    {
        ConLomb conLomb = new ConLomb(null, true);
        conLomb.show();
        selectLombp(conLomb.codSelected);
    }

    public void consultaLombs()
    {
        ConLomb conLomb = new ConLomb(null, true);
        conLomb.show();
        selectLombs(conLomb.codSelected);
    }
    
    public void selectVend(Object codConsulta)
    {
        conecta();
        try
        {
            query = "select * from tab_vend where cod_vend = \"" + codConsulta + "\"";
            stm = con.prepareStatement(query);
            rs = stm.executeQuery();
            
            if(rs.next())
            {
                tcodVend.setText(rs.getString("cod_vend"));
                tdesVend.setText(rs.getString("des_vend"));
            }
        }
        catch (SQLException ex)
        {
           JOptionPane.showMessageDialog(null,ex,"Erro",JOptionPane.ERROR_MESSAGE); 
        }
    }
    
    public void selectRota(Object codConsulta)
    {
        conecta();
        try
        {
            query = "select * from tab_rota where cod_rota = \"" + codConsulta + "\"";
            stm = con.prepareStatement(query);
            rs = stm.executeQuery();
            
            if(rs.next())
            {
                tcodRota.setText(rs.getString("cod_rota"));
                tdesRota.setText(rs.getString("des_rota"));
            }
        }
        catch (SQLException ex)
        {
           JOptionPane.showMessageDialog(null,ex,"Erro",JOptionPane.ERROR_MESSAGE); 
        }
    }
    
    public void selectVeic(Object codConsulta)
    {
        conecta();
        try
        {
            query = "select * from tab_veic where placa_veic = \"" + codConsulta + "\"";
            stm = con.prepareStatement(query);
            rs = stm.executeQuery();
            
            if(rs.next())
            {
                tplacaVeic.setText(rs.getString("placa_veic"));
                tdesVeic.setText(rs.getString("transp_veic"));
                ttipoVeic.setText(rs.getString("tipo_veic"));
            }
        }
        catch (SQLException ex)
        {
           JOptionPane.showMessageDialog(null,ex,"Erro",JOptionPane.ERROR_MESSAGE); 
        }
    }
    
    public void selectLombp(Object codConsulta)
    {
        conecta();
        try
        {
            query = "select * from tab_lomb where cod_lomb = \"" + codConsulta + "\"";
            stm = con.prepareStatement(query);
            rs = stm.executeQuery();
            
            if(rs.next())
            {
                tcodLombp.setText(rs.getString("cod_lomb"));
                tdesLombp.setText(rs.getString("des_lomb"));
            }
        }
        catch (SQLException ex)
        {
           JOptionPane.showMessageDialog(null,ex,"Erro",JOptionPane.ERROR_MESSAGE); 
        }
    }
    
    public void enableUpdate()
    {
        tcodVend.setEditable(true);
        tcodRota.setEditable(true);
        tplacaVeic.setEditable(true);
        tcodLombp.setEditable(true);
        tcodLombs.setEditable(true);
        
        bcvend.setEnabled(true);
        bcrota.setEnabled(true);
        bcveic.setEnabled(true);
        bclombp.setEnabled(true);
        bclombs.setEnabled(true);
    }
    
    public void disableUpdate()
    {
        tcodVend.setEditable(false);
        tcodRota.setEditable(false);
        tplacaVeic.setEditable(false);
        tcodLombp.setEditable(false);
        tcodLombs.setEditable(false);
        
        bcvend.setEnabled(false);
        bcrota.setEnabled(false);
        bcveic.setEnabled(false);
        bclombp.setEnabled(false);
        bclombs.setEnabled(false);
    }
    
    public void limpaCampos()
    {
        tcarga.setText("");
        tcodVend.setText("");
        tdesVend.setText("");
        tcodRota.setText("");
        tdesRota.setText("");
        tplacaVeic.setText("");
        tdesVeic.setText("");
        ttipoVeic.setText("");
        tcodLombp.setText("");
        tdesLombp.setText("");
        tcodLombs.setText("");
        tdesLombs.setText("");
    }
    
    public void selectLombs(Object codConsulta)
    {
        conecta();
        try
        {
            query = "select * from tab_lomb where cod_lomb = \"" + codConsulta + "\"";
            stm = con.prepareStatement(query);
            rs = stm.executeQuery();
            
            if(rs.next())
            {
                tcodLombs.setText(rs.getString("cod_lomb"));
                tdesLombs.setText(rs.getString("des_lomb"));
            }
        }
        catch (SQLException ex)
        {
           JOptionPane.showMessageDialog(null,ex,"Erro",JOptionPane.ERROR_MESSAGE); 
        }
    }
    /** 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.
     */
    // &lt;editor-fold defaultstate="collapsed" desc=" Generated Code "&gt;                          
    private void initComponents() {
        pCampos = new javax.swing.JPanel();
        jLabel1 = new javax.swing.JLabel();
        tcodVend = new javax.swing.JFormattedTextField();
        jLabel3 = new javax.swing.JLabel();
        tdesVend = new javax.swing.JFormattedTextField();
        bcvend = new javax.swing.JToggleButton();
        jLabel4 = new javax.swing.JLabel();
        tcodRota = new javax.swing.JFormattedTextField();
        tdesRota = new javax.swing.JFormattedTextField();
        bcrota = new javax.swing.JToggleButton();
        jLabel5 = new javax.swing.JLabel();
        tplacaVeic = new javax.swing.JFormattedTextField();
        tdesVeic = new javax.swing.JFormattedTextField();
        bcveic = new javax.swing.JToggleButton();
        ttipoVeic = new javax.swing.JFormattedTextField();
        jLabel6 = new javax.swing.JLabel();
        tcodLombp = new javax.swing.JFormattedTextField();
        tdesLombp = new javax.swing.JFormattedTextField();
        jLabel7 = new javax.swing.JLabel();
        tcodLombs = new javax.swing.JFormattedTextField();
        tdesLombs = new javax.swing.JFormattedTextField();
        bclombp = new javax.swing.JToggleButton();
        bclombs = new javax.swing.JToggleButton();
        jLabel8 = new javax.swing.JLabel();
        tcarga = new javax.swing.JFormattedTextField();
        pperiodo = new javax.swing.JPanel();
        bedidat = new javax.swing.JButton();
        jLabel2 = new javax.swing.JLabel();
        jLabel9 = new javax.swing.JLabel();
        jPanel2 = new javax.swing.JPanel();
        bfec = new javax.swing.JButton();
        bok = new javax.swing.JButton();
        bdel = new javax.swing.JButton();
        bedi = new javax.swing.JButton();
        bcon = new javax.swing.JButton();
        bfec1 = new javax.swing.JButton();
        bdat = new javax.swing.JToggleButton();
        pTab = new javax.swing.JPanel();
        jScrollPane1 = new javax.swing.JScrollPane();
        tab = new javax.swing.JTable();

        getContentPane().setLayout(null);

        setDefaultCloseOperation(javax.swing.WindowConstants.DISPOSE_ON_CLOSE);
        pCampos.setLayout(null);

        pCampos.setBorder(new javax.swing.border.EtchedBorder());
        jLabel1.setFont(new java.awt.Font("Tahoma", 0, 11));
        jLabel1.setHorizontalAlignment(javax.swing.SwingConstants.RIGHT);
        jLabel1.setText("Data:");
        pCampos.add(jLabel1);
        jLabel1.setBounds(280, 10, 60, 14);

        tcodVend.setEditable(false);
        tcodVend.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                tcodVendActionPerformed(evt);
            }
        });
        tcodVend.addFocusListener(new java.awt.event.FocusAdapter() {
            public void focusLost(java.awt.event.FocusEvent evt) {
                tcodVendFocusLost(evt);
            }
        });

        pCampos.add(tcodVend);
        tcodVend.setBounds(70, 30, 90, 20);

        jLabel3.setFont(new java.awt.Font("Tahoma", 0, 11));
        jLabel3.setHorizontalAlignment(javax.swing.SwingConstants.RIGHT);
        jLabel3.setText("Vendedor:");
        pCampos.add(jLabel3);
        jLabel3.setBounds(10, 30, 60, 14);

        tdesVend.setEditable(false);
        tdesVend.setFocusable(false);
        pCampos.add(tdesVend);
        tdesVend.setBounds(160, 30, 280, 20);

        bcvend.setFont(new java.awt.Font("Tahoma", 0, 11));
        bcvend.setText("...");
        bcvend.setFocusable(false);
        bcvend.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                bcvendActionPerformed(evt);
            }
        });

        pCampos.add(bcvend);
        bcvend.setBounds(440, 30, 30, 20);

        jLabel4.setFont(new java.awt.Font("Tahoma", 0, 11));
        jLabel4.setHorizontalAlignment(javax.swing.SwingConstants.RIGHT);
        jLabel4.setText("Rota:");
        pCampos.add(jLabel4);
        jLabel4.setBounds(10, 50, 60, 14);

        tcodRota.setEditable(false);
        tcodRota.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                tcodRotaActionPerformed(evt);
            }
        });
        tcodRota.addFocusListener(new java.awt.event.FocusAdapter() {
            public void focusLost(java.awt.event.FocusEvent evt) {
                tcodRotaFocusLost(evt);
            }
        });

        pCampos.add(tcodRota);
        tcodRota.setBounds(70, 50, 90, 20);

        tdesRota.setEditable(false);
        tdesRota.setFocusable(false);
        pCampos.add(tdesRota);
        tdesRota.setBounds(160, 50, 280, 20);

        bcrota.setFont(new java.awt.Font("Tahoma", 0, 11));
        bcrota.setText("...");
        bcrota.setFocusable(false);
        bcrota.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                bcrotaActionPerformed(evt);
            }
        });

        pCampos.add(bcrota);
        bcrota.setBounds(440, 50, 30, 20);

        jLabel5.setFont(new java.awt.Font("Tahoma", 0, 11));
        jLabel5.setHorizontalAlignment(javax.swing.SwingConstants.RIGHT);
        jLabel5.setText("Ve\u00edculo:");
        pCampos.add(jLabel5);
        jLabel5.setBounds(10, 70, 60, 14);

        tplacaVeic.setEditable(false);
        tplacaVeic.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                tplacaVeicActionPerformed(evt);
            }
        });
        tplacaVeic.addFocusListener(new java.awt.event.FocusAdapter() {
            public void focusLost(java.awt.event.FocusEvent evt) {
                tplacaVeicFocusLost(evt);
            }
        });

        pCampos.add(tplacaVeic);
        tplacaVeic.setBounds(70, 70, 90, 20);

        tdesVeic.setEditable(false);
        tdesVeic.setFocusable(false);
        pCampos.add(tdesVeic);
        tdesVeic.setBounds(160, 70, 180, 20);

        bcveic.setFont(new java.awt.Font("Tahoma", 0, 11));
        bcveic.setText("...");
        bcveic.setFocusable(false);
        bcveic.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                bcveicActionPerformed(evt);
            }
        });

        pCampos.add(bcveic);
        bcveic.setBounds(440, 70, 30, 20);

        ttipoVeic.setEditable(false);
        ttipoVeic.setFocusable(false);
        pCampos.add(ttipoVeic);
        ttipoVeic.setBounds(340, 70, 100, 20);

        jLabel6.setFont(new java.awt.Font("Tahoma", 0, 11));
        jLabel6.setHorizontalAlignment(javax.swing.SwingConstants.RIGHT);
        jLabel6.setText("Lombador:");
        pCampos.add(jLabel6);
        jLabel6.setBounds(10, 90, 60, 14);

        tcodLombp.setEditable(false);
        tcodLombp.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                tcodLombpActionPerformed(evt);
            }
        });
        tcodLombp.addFocusListener(new java.awt.event.FocusAdapter() {
            public void focusLost(java.awt.event.FocusEvent evt) {
                tcodLombpFocusLost(evt);
            }
        });

        pCampos.add(tcodLombp);
        tcodLombp.setBounds(70, 90, 90, 20);

        tdesLombp.setEditable(false);
        tdesLombp.setFocusable(false);
        pCampos.add(tdesLombp);
        tdesLombp.setBounds(160, 90, 280, 20);

        jLabel7.setFont(new java.awt.Font("Tahoma", 0, 11));
        jLabel7.setHorizontalAlignment(javax.swing.SwingConstants.RIGHT);
        jLabel7.setText("Lombador:");
        pCampos.add(jLabel7);
        jLabel7.setBounds(10, 110, 60, 14);

        tcodLombs.setEditable(false);
        tcodLombs.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                tcodLombsActionPerformed(evt);
            }
        });
        tcodLombs.addFocusListener(new java.awt.event.FocusAdapter() {
            public void focusLost(java.awt.event.FocusEvent evt) {
                tcodLombsFocusLost(evt);
            }
        });

        pCampos.add(tcodLombs);
        tcodLombs.setBounds(70, 110, 90, 20);

        tdesLombs.setEditable(false);
        tdesLombs.setFocusable(false);
        pCampos.add(tdesLombs);
        tdesLombs.setBounds(160, 110, 280, 20);

        bclombp.setFont(new java.awt.Font("Tahoma", 0, 11));
        bclombp.setText("...");
        bclombp.setFocusable(false);
        bclombp.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                bclombpActionPerformed(evt);
            }
        });

        pCampos.add(bclombp);
        bclombp.setBounds(440, 90, 30, 20);

        bclombs.setFont(new java.awt.Font("Tahoma", 0, 11));
        bclombs.setText("...");
        bclombs.setFocusable(false);
        bclombs.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                bclombsActionPerformed(evt);
            }
        });

        pCampos.add(bclombs);
        bclombs.setBounds(440, 110, 30, 20);

        jLabel8.setFont(new java.awt.Font("Tahoma", 0, 11));
        jLabel8.setHorizontalAlignment(javax.swing.SwingConstants.RIGHT);
        jLabel8.setText("Carga:");
        pCampos.add(jLabel8);
        jLabel8.setBounds(10, 10, 60, 14);

        tcarga.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                tcargaActionPerformed(evt);
            }
        });
        tcarga.addFocusListener(new java.awt.event.FocusAdapter() {
            public void focusLost(java.awt.event.FocusEvent evt) {
                tcargaFocusLost(evt);
            }
        });

        pCampos.add(tcarga);
        tcarga.setBounds(70, 10, 90, 20);

        pperiodo.setLayout(null);

        pperiodo.setBorder(new javax.swing.border.TitledBorder(new javax.swing.border.EtchedBorder(), "Per\u00edodo"));
        bedidat.setIcon(new javax.swing.ImageIcon(getClass().getResource("/edit.png")));
        bedidat.setFocusable(false);
        bedidat.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                bedidatActionPerformed(evt);
            }
        });

        pperiodo.add(bedidat);
        bedidat.setBounds(210, 20, 40, 30);

        jLabel2.setIcon(new javax.swing.ImageIcon(getClass().getResource("/2leftarrow.png")));
        pperiodo.add(jLabel2);
        jLabel2.setBounds(85, 20, 20, 20);

        jLabel9.setIcon(new javax.swing.ImageIcon(getClass().getResource("/2rightarrow.png")));
        pperiodo.add(jLabel9);
        jLabel9.setBounds(120, 20, 20, 20);

        pCampos.add(pperiodo);
        pperiodo.setBounds(480, 10, 260, 80);

        jPanel2.setLayout(null);

        jPanel2.setBackground(new java.awt.Color(153, 153, 153));
        jPanel2.setBorder(new javax.swing.border.EtchedBorder());
        bfec.setIcon(new javax.swing.ImageIcon(getClass().getResource("/exit.png")));
        bfec.setFocusable(false);
        bfec.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                bfecActionPerformed(evt);
            }
        });

        jPanel2.add(bfec);
        bfec.setBounds(210, 5, 40, 30);

        bok.setIcon(new javax.swing.ImageIcon(getClass().getResource("/button_ok.png")));
        bok.setEnabled(false);
        bok.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                bokActionPerformed(evt);
            }
        });
        bok.addKeyListener(new java.awt.event.KeyAdapter() {
            public void keyPressed(java.awt.event.KeyEvent evt) {
                bokKeyPressed(evt);
            }
        });

        jPanel2.add(bok);
        bok.setBounds(170, 5, 40, 30);

        bdel.setIcon(new javax.swing.ImageIcon(getClass().getResource("/button_cancel.png")));
        bdel.setEnabled(false);
        bdel.setFocusable(false);
        bdel.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                bdelActionPerformed(evt);
            }
        });

        jPanel2.add(bdel);
        bdel.setBounds(130, 5, 40, 30);

        bedi.setIcon(new javax.swing.ImageIcon(getClass().getResource("/edit.png")));
        bedi.setFocusable(false);
        bedi.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                bediActionPerformed(evt);
            }
        });

        jPanel2.add(bedi);
        bedi.setBounds(50, 5, 40, 30);

        bcon.setIcon(new javax.swing.ImageIcon(getClass().getResource("/find.png")));
        bcon.setFocusable(false);
        bcon.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                bconActionPerformed(evt);
            }
        });

        jPanel2.add(bcon);
        bcon.setBounds(10, 5, 40, 30);

        bfec1.setIcon(new javax.swing.ImageIcon(getClass().getResource("/fileclose.png")));
        bfec1.setFocusable(false);
        bfec1.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                bfec1ActionPerformed(evt);
            }
        });

        jPanel2.add(bfec1);
        bfec1.setBounds(90, 5, 40, 30);

        pCampos.add(jPanel2);
        jPanel2.setBounds(480, 100, 260, 40);

        bdat.setFont(new java.awt.Font("Tahoma", 0, 11));
        bdat.setText("...");
        bdat.setFocusable(false);
        bdat.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                bdatActionPerformed(evt);
            }
        });

        pCampos.add(bdat);
        bdat.setBounds(440, 10, 30, 20);

        getContentPane().add(pCampos);
        pCampos.setBounds(10, 10, 760, 150);

        pTab.setLayout(null);

        pTab.setBorder(new javax.swing.border.EtchedBorder());
        jScrollPane1.setFocusable(false);
        tab.setFont(new java.awt.Font("Tahoma", 0, 11));
        tab.setModel(new DefaultTableModel(
            new Object [][]{},
            new String [] {
                "Carga","Data","Placa","Transportadora","Tipo Veículo","Vendedor","Rota","Lombador","Lombador"
            }
        ));
        tab.getColumnModel().getColumn(0).setPreferredWidth(80);
        tab.getColumnModel().getColumn(0).setResizable(false);
        tab.getColumnModel().getColumn(1).setPreferredWidth(100);
        tab.getColumnModel().getColumn(1).setResizable(false);
        tab.getColumnModel().getColumn(2).setPreferredWidth(80);
        tab.getColumnModel().getColumn(2).setResizable(false);
        tab.getColumnModel().getColumn(3).setPreferredWidth(250);
        tab.getColumnModel().getColumn(3).setResizable(false);
        tab.getColumnModel().getColumn(4).setPreferredWidth(80);
        tab.getColumnModel().getColumn(4).setResizable(false);
        tab.getColumnModel().getColumn(5).setPreferredWidth(250);
        tab.getColumnModel().getColumn(5).setResizable(false);
        tab.getColumnModel().getColumn(6).setPreferredWidth(150);
        tab.getColumnModel().getColumn(6).setResizable(false);
        tab.getColumnModel().getColumn(7).setPreferredWidth(250);
        tab.getColumnModel().getColumn(7).setResizable(false);
        tab.getColumnModel().getColumn(8).setPreferredWidth(250);
        tab.getColumnModel().getColumn(8).setResizable(false);

        tab.setAutoResizeMode(javax.swing.JTable.AUTO_RESIZE_OFF);
        tab.setFocusable(false);
        jScrollPane1.setViewportView(tab);

        pTab.add(jScrollPane1);
        jScrollPane1.setBounds(10, 10, 690, 270);

        getContentPane().add(pTab);
        pTab.setBounds(10, 170, 710, 290);

        java.awt.Dimension screenSize = java.awt.Toolkit.getDefaultToolkit().getScreenSize();
        setBounds((screenSize.width-785)/2, (screenSize.height-495)/2, 785, 495);
    }
    // &lt;/editor-fold&gt;                        

    private void bfec1ActionPerformed(java.awt.event.ActionEvent evt) {                                      
// TODO add your handling code here:
        disableUpdate();
        bok.setEnabled(false);
        bdel.setEnabled(false);
    }                                     

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

    private void bokKeyPressed(java.awt.event.KeyEvent evt) {                               
// TODO add your handling code here:
        insert();
        BuscaBanco();
    }                              

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

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

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

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

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

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

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

    private void tcargaFocusLost(java.awt.event.FocusEvent evt) {                                 
// TODO add your handling code here:
        Object codConsulta = tcarga.getText();
        select(codConsulta);
    }                                

    private void bdatActionPerformed(java.awt.event.ActionEvent evt) {                                     
// TODO add your handling code here:
        if(tdat.isEditable() == false)
        {
            tdat.setEditable(true);
            tdat.requestFocus();
        }
        else
        {
            tdat.setEditable(false);
            tcarga.requestFocus();
        }
    }                                    

    private void bconActionPerformed(java.awt.event.ActionEvent evt) {                                     
// TODO add your handling code here:
        selectLinha();
        bdel.setEnabled(true);
    }                                    

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

    private void bediActionPerformed(java.awt.event.ActionEvent evt) {                                     
// TODO add your handling code here:
        enableUpdate();
        bok.setEnabled(true);
    }                                    

    private void tcodLombsFocusLost(java.awt.event.FocusEvent evt) {                                    
// TODO add your handling code here:
        Object codConsulta = tcodLombs.getText();
        selectLombs(codConsulta);
        bok.setEnabled(true);
    }                                   

    private void tcodLombpFocusLost(java.awt.event.FocusEvent evt) {                                    
// TODO add your handling code here:
        Object codConsulta = tcodLombp.getText();
        selectLombp(codConsulta);
    }                                   

    private void tplacaVeicFocusLost(java.awt.event.FocusEvent evt) {                                     
// TODO add your handling code here:
        Object codConsulta = tplacaVeic.getText();
        selectVeic(codConsulta);
    }                                    

    private void tcodRotaFocusLost(java.awt.event.FocusEvent evt) {                                   
// TODO add your handling code here:
        Object codConsulta = tcodRota.getText();
        selectRota(codConsulta);
    }                                  

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

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

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

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

    private void tcodVendFocusLost(java.awt.event.FocusEvent evt) {                                   
// TODO add your handling code here:
        Object codConsulta = tcodVend.getText();
        selectVend(codConsulta);
    }                                  

    private void bcvendActionPerformed(java.awt.event.ActionEvent evt) {                                       
// TODO add your handling code here:
        consultaVend();
    }                                      
    
    private void bedidatActionPerformed(java.awt.event.ActionEvent evt) {                                        
// TODO add your handling code here:
        
        if (tpini.isEditable() == false && tpfin.isEditable()== false)
        {
            tpini.setEditable(true);
            tpfin.setEditable(true);
            tpini.requestFocus();
        }
        else
        {
            tpini.setEditable(false);
            tpfin.setEditable(false);
            BuscaBanco();
        }
    }                                       
    
    /**
     * @param args the command line arguments
     */
    public static void main(String args[]) {
        java.awt.EventQueue.invokeLater(new Runnable() {
            public void run() {
                new MovEmbarque(new javax.swing.JFrame(), true).setVisible(true);
            }
        });
    }
    
    // Variables declaration - do not modify                     
    private javax.swing.JToggleButton bclombp;
    private javax.swing.JToggleButton bclombs;
    private javax.swing.JButton bcon;
    private javax.swing.JToggleButton bcrota;
    private javax.swing.JToggleButton bcveic;
    private javax.swing.JToggleButton bcvend;
    private javax.swing.JToggleButton bdat;
    private javax.swing.JButton bdel;
    private javax.swing.JButton bedi;
    private javax.swing.JButton bedidat;
    private javax.swing.JButton bfec;
    private javax.swing.JButton bfec1;
    private javax.swing.JButton bok;
    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.JLabel jLabel6;
    private javax.swing.JLabel jLabel7;
    private javax.swing.JLabel jLabel8;
    private javax.swing.JLabel jLabel9;
    private javax.swing.JPanel jPanel2;
    private javax.swing.JScrollPane jScrollPane1;
    private javax.swing.JPanel pCampos;
    private javax.swing.JPanel pTab;
    private javax.swing.JPanel pperiodo;
    private javax.swing.JTable tab;
    private javax.swing.JFormattedTextField tcarga;
    private javax.swing.JFormattedTextField tcodLombp;
    private javax.swing.JFormattedTextField tcodLombs;
    private javax.swing.JFormattedTextField tcodRota;
    private javax.swing.JFormattedTextField tcodVend;
    private javax.swing.JFormattedTextField tdesLombp;
    private javax.swing.JFormattedTextField tdesLombs;
    private javax.swing.JFormattedTextField tdesRota;
    private javax.swing.JFormattedTextField tdesVeic;
    private javax.swing.JFormattedTextField tdesVend;
    private javax.swing.JFormattedTextField tplacaVeic;
    private javax.swing.JFormattedTextField ttipoVeic;
    // End of variables declaration                   
    private javax.swing.JFormattedTextField tdat;
    private javax.swing.JFormattedTextField tpini;
    private javax.swing.JFormattedTextField tpfin;
    
    public JTextArea sai = null;
    public String ndata = null;
    
    public Connection con = null;
    public ResultSet rs = null;
    
    public ResultSet rsVeic = null;
    public ResultSet rsVend = null;
    public ResultSet rsRota = null;
    public ResultSet rsLombp = null;
    public ResultSet rsLombs = null;
    
    public PreparedStatement stm = null;
    public String query = null;
    public ResultSetMetaData rsmd = null;
    public Vector nLinha = null;
    public Object codSelected = null;
    
    public int delete;
}
#14

Ae Aeamorin, obrigado pelo código, vou tentar tirar proveito dele,

dê uma olhada em:

http://www.guj.com.br/posts/list/23576.java#125930

Lá está especificado melhor o meu problema atual.

Mesmo assim valeu! 8)

#15