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.
*/
// <editor-fold defaultstate="collapsed" desc=" Generated Code ">
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);
}
// </editor-fold>
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;
}