Discussoes de Programacao e Tecnologia

Duvida com List<Object[]>

6 respostas
Francisco_Miguel
Francisco_Miguel

Galera, tenho um lista de 25 elementos que sao do tipo Object[], dentro deste elementos tenho 7 elementos que tenho que pegar.

como faco isso??
de uma olhada na imagem que peguei…

2008/11/19/7eab4ea16666d66f80eb6c3f63517bb9_47366.jpg716×374 36.7 KB

Alura Desenvolvimento Back-End Java Sua Carreira em desenvolvimento back-end Java: dos fundamentos à arquitetura de sistemas...

6 Respostas

Naruffy
Naruffy

Faz com dois fors mesmo para interar eles

for(Object[] objeto : lista) {
  for(int i = 0; i < objeto.length; i++) {
      // Faz o que você precisa fazer
  }
}
davidtiagoconceicao
davidtiagoconceicao

Você pode usar dois for-each:

for(Object[] objects : lista){
    for(Object obj : objects){
    }
}

Edit: Naruffy, só agora vi seu post…

Francisco_Miguel
Francisco_Miguel

pois é galera, mas como faco para pegar o valor que esta dentro do array de Object, pois cada elemento dentro dele ta com tipo diferente,
um é Integer o outro é BigDecimal o outro é char…

quero colocar este valores numa lista de forma de tipo de dado java mesmo, tipo Long, string …

como faco??

davidtiagoconceicao
davidtiagoconceicao

Você quer dividir os elementos por tipo?
Não sei se há uma solução trivial para isso. Provavelmente você vai ter que separar os objetos conforme o getClass() deles.

B
Bruno_Laturner

Se cada posição tiver sempre o mesmo tipo de elemento, você só precisa fazer os casts para cada um.

for (Object[] objects : lista)
{  
  Integer a = (Integer) objects[0];
  Integer b = (Integer) objects[1];
  BigDecimal c = (BigDecimal) objects[2];
  String d = (String) objects[3];
  BigDecimal e = (BigDecimal) objects[4];
  BigDecimal f = (BigDecimal) objects[5];
  String g = (String) objects[6];
}

O ideal mesmo era fazer uma classe com esses 7 atributos e passar um Object[] para o construtor dele, que faria o trabalho de conversões.

for (Object[] objects : lista)
{  
  MeuTipoDeDado dado = new MeuTipoDeDado(objects);
  // depois faça o que quiser
}
R
renatosoares

Boa tarde, pessoal …

Preciso de ajuda, neste exato momento, de voces …

Tenho um Campo JFormattedTextField, alterei o nome da variavel, para JtxtFieldCPF, gostaria que após eu digitasse o CPF, e sai-se de foco, executaria uma SQL, que faria uma select no banco de dados, uma consulta, verificando se o CPF digitado é igual ao CPF da consulta; caso fosse igual retornaria o nome do cliente no campo JtextField (nome da variavel JtxtFieldNome).

Anexei, duas fotos, Form Vendas, e do Form Vendas - Codigo;

No Form Vendas - Codigo, na parte preta, é p codigo da select no banco .

Coloquei este codigo, no evente KeyPressed e KeyTyped e não funcionou.

Gostaria de saber se tem como fazer com o evento FocusLost, e como ficaria o codigo ?

Preciso de ajuda !!!

/*

  • Venda.java
  • Created on 24 de Outubro de 2008, 17:56
    */

package Forms;

import ConexaoBancoDados.Conexao;

import Classes.*;

import java.sql.SQLException;

import java.text.SimpleDateFormat;

import java.util.logging.Level;

import java.util.logging.Logger;

import javax.swing.JOptionPane;

/**
*

  • @author  Renato Soares

*/

public class Venda extends javax.swing.JFrame {

private static final long serialVersionUID = 1L;

Conexao conexao = new Conexao();

    /** Creates new form Venda */

public Venda() {

initComponents();

    jtxtFieldCodigo.setEditable(false);
 jtxtFieldData.setEditable(false);
 jtxtFieldCPF.setEditable(false);
 jtxtFieldNome.setEditable(false);
 jtxtFieldPlaca.setEditable(false);
 jtxtFieldModelo.setEditable(false);
 jtxtFieldPreco.setEditable(false);
 
 btnNovo.setEnabled(true);
 btnAlterar.setEnabled(true);
 btnSalvar.setEnabled(false);
 btnExcluir.setEnabled(true);
 btnCancelar.setEnabled(false);
 btnPrimeiro.setEnabled(true);
 btnAnterior.setEnabled(true);
 btnProximo.setEnabled(true);
 btnUltimo.setEnabled(true);
 
 btnNovo.requestFocus();

    }

    /** 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”)

// 

private void initComponents() {

      jPanel1 = new javax.swing.JPanel();

jLabel1 = new javax.swing.JLabel();

jLabel2 = new javax.swing.JLabel();

jLabel3 = new javax.swing.JLabel();

jLabel4 = new javax.swing.JLabel();

jtxtFieldNome = new javax.swing.JTextField();

jLabel5 = new javax.swing.JLabel();

jLabel6 = new javax.swing.JLabel();

jtxtFieldModelo = new javax.swing.JTextField();

jLabel7 = new javax.swing.JLabel();

jtxtFieldPreco = new javax.swing.JTextField();

jLabel8 = new javax.swing.JLabel();

btnPrimeiro = new javax.swing.JButton();

btnAnterior = new javax.swing.JButton();

btnProximo = new javax.swing.JButton();

btnUltimo = new javax.swing.JButton();

btnCancelar = new javax.swing.JButton();

btnExcluir = new javax.swing.JButton();

btnSalvar = new javax.swing.JButton();

btnAlterar = new javax.swing.JButton();

btnNovo = new javax.swing.JButton();

btnSair = new javax.swing.JButton();

jSeparator1 = new javax.swing.JSeparator();

jSeparator2 = new javax.swing.JSeparator();

jLabel9 = new javax.swing.JLabel();

jLabel10 = new javax.swing.JLabel();

jtxtFieldCodigo = new javax.swing.JTextField();

jSeparator3 = new javax.swing.JSeparator();

jLabel11 = new javax.swing.JLabel();

jScrollPane1 = new javax.swing.JScrollPane();

jTableVenda = new javax.swing.JTable();

jtxtFieldData = new javax.swing.JFormattedTextField();

jtxtFieldPlaca = new javax.swing.JFormattedTextField();

jtxtFieldCPF = new javax.swing.JFormattedTextField();

jtxtFieldCPF1 = new javax.swing.JFormattedTextField();

      setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);

      jLabel1.setFont(new java.awt.Font(“Arial”, 1, 18));
      jLabel1.setText(“Vendas de Veiculos”);

      jLabel2.setFont(new java.awt.Font(“Tahoma”, 1, 11));
      jLabel2.setText(“Data”);

      jLabel3.setFont(new java.awt.Font(“Tahoma”, 1, 11));
      jLabel3.setText(“CPF”);

      jLabel4.setFont(new java.awt.Font(“Tahoma”, 1, 11));
      jLabel4.setText(“Nome”);

      jtxtFieldNome.setFont(new java.awt.Font(“Tahoma”, 1, 11));

      jLabel5.setFont(new java.awt.Font(“Tahoma”, 1, 11));
      jLabel5.setText(“Placa”);

      jLabel6.setFont(new java.awt.Font(“Tahoma”, 1, 11));
      jLabel6.setText(“Modelo”);

      jtxtFieldModelo.setFont(new java.awt.Font(“Tahoma”, 1, 11));

      jLabel7.setFont(new java.awt.Font(“Tahoma”, 1, 11));
      jLabel7.setText(“Preço”);

      jtxtFieldPreco.setFont(new java.awt.Font(“Tahoma”, 1, 11));
      jtxtFieldPreco.setForeground(new java.awt.Color(255, 0, 0));

      jLabel8.setFont(new java.awt.Font(“Tahoma”, 1, 11));
      jLabel8.setText(“R$”);

      btnPrimeiro.setFont(new java.awt.Font(“Tahoma”, 1, 11));
      btnPrimeiro.setText("<<");

      btnAnterior.setFont(new java.awt.Font(“Tahoma”, 1, 11));
      btnAnterior.setText("<");

      btnProximo.setFont(new java.awt.Font(“Tahoma”, 1, 11));
      btnProximo.setText(">");

      btnUltimo.setFont(new java.awt.Font(“Tahoma”, 1, 11));
      btnUltimo.setText(">>");

      btnCancelar.setFont(new java.awt.Font(“Tahoma”, 1, 11));

btnCancelar.setText(“Cancelar”);

btnCancelar.addActionListener(new java.awt.event.ActionListener() {

public void actionPerformed(java.awt.event.ActionEvent evt) {

btnCancelarActionPerformed(evt);

}

});

      btnExcluir.setFont(new java.awt.Font(“Tahoma”, 1, 11));

btnExcluir.setText(“Excluir”);

btnExcluir.addActionListener(new java.awt.event.ActionListener() {

public void actionPerformed(java.awt.event.ActionEvent evt) {

btnExcluirActionPerformed(evt);

}

});

      btnSalvar.setFont(new java.awt.Font(“Tahoma”, 1, 11));

btnSalvar.setText(“Salvar”);

btnSalvar.addActionListener(new java.awt.event.ActionListener() {

public void actionPerformed(java.awt.event.ActionEvent evt) {

btnSalvarActionPerformed(evt);

}

});

      btnAlterar.setFont(new java.awt.Font(“Tahoma”, 1, 11));

btnAlterar.setText(“Alterar”);

btnAlterar.addActionListener(new java.awt.event.ActionListener() {

public void actionPerformed(java.awt.event.ActionEvent evt) {

btnAlterarActionPerformed(evt);

}

});

      btnNovo.setFont(new java.awt.Font(“Tahoma”, 1, 11));

btnNovo.setText(“Novo”);

btnNovo.addActionListener(new java.awt.event.ActionListener() {

public void actionPerformed(java.awt.event.ActionEvent evt) {

btnNovoActionPerformed(evt);

}

});

      btnSair.setFont(new java.awt.Font(“Tahoma”, 1, 11));

btnSair.setText(“Sair”);

btnSair.addActionListener(new java.awt.event.ActionListener() {

public void actionPerformed(java.awt.event.ActionEvent evt) {

btnSairActionPerformed(evt);

}

});

      jLabel9.setFont(new java.awt.Font(“Tahoma”, 1, 11));
      jLabel9.setText(“Veículo”);

      jLabel10.setFont(new java.awt.Font(“Tahoma”, 1, 11));
      jLabel10.setText(“Código”);

      jtxtFieldCodigo.setFont(new java.awt.Font(“Tahoma”, 1, 11));
      jtxtFieldCodigo.setForeground(new java.awt.Color(255, 0, 0));

      jLabel11.setFont(new java.awt.Font(“Tahoma”, 1, 11));
      jLabel11.setText(“Cliente”);

      jTableVenda.setModel(new javax.swing.table.DefaultTableModel(

new Object [][] {

{null, null, null, null, null, null, null},

{null, null, null, null, null, null, null},

{null, null, null, null, null, null, null},

{null, null, null, null, null, null, null}

},

new String [] {

“Código”, “Data”, “CPF”, “Nome”, “Placa”, “Modelo”, “Preço”

}

));

jScrollPane1.setViewportView(jTableVenda);

      jtxtFieldData.setForeground(new java.awt.Color(255, 0, 0));

try {

jtxtFieldData.setFormatterFactory(new javax.swing.text.DefaultFormatterFactory(new javax.swing.text.MaskFormatter("##/##/####")));

} catch (java.text.ParseException ex) {

ex.printStackTrace();

}

jtxtFieldData.setFont(new java.awt.Font(“Tahoma”, 1, 11));

      try {

jtxtFieldPlaca.setFormatterFactory(new javax.swing.text.DefaultFormatterFactory(new javax.swing.text.MaskFormatter("###-####")));

} catch (java.text.ParseException ex) {

ex.printStackTrace();

}

      try {

jtxtFieldCPF.setFormatterFactory(new javax.swing.text.DefaultFormatterFactory(new javax.swing.text.MaskFormatter("###.###.###-##")));

} catch (java.text.ParseException ex) {

ex.printStackTrace();

}

      try {

jtxtFieldCPF1.setFormatterFactory(new javax.swing.text.DefaultFormatterFactory(new javax.swing.text.MaskFormatter("###.###.###-##")));

} catch (java.text.ParseException ex) {

ex.printStackTrace();

}

jtxtFieldCPF1.addFocusListener(new java.awt.event.FocusAdapter() {

public void focusLost(java.awt.event.FocusEvent evt) {

jtxtFieldCPF1FocusLost(evt);

}

});

      javax.swing.GroupLayout jPanel1Layout = new javax.swing.GroupLayout(jPanel1);

jPanel1.setLayout(jPanel1Layout);

jPanel1Layout.setHorizontalGroup(

jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addGroup(jPanel1Layout.createSequentialGroup()

.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addGroup(jPanel1Layout.createSequentialGroup()

.addContainerGap()

.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addGroup(jPanel1Layout.createSequentialGroup()

.addGap(157, 157, 157)

.addComponent(btnPrimeiro)

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)

.addComponent(btnAnterior, javax.swing.GroupLayout.PREFERRED_SIZE, 41, javax.swing.GroupLayout.PREFERRED_SIZE)

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)

.addComponent(btnProximo)

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)

.addComponent(btnUltimo)

.addGap(165, 165, 165))

.addGroup(jPanel1Layout.createSequentialGroup()

.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addGroup(jPanel1Layout.createSequentialGroup()

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)

.addComponent(jLabel11)

.addGap(446, 446, 446))

.addGroup(jPanel1Layout.createSequentialGroup()

.addComponent(jLabel9)

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 419, Short.MAX_VALUE))

.addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanel1Layout.createSequentialGroup()

.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)

.addComponent(jScrollPane1, javax.swing.GroupLayout.Alignment.LEADING, javax.swing.GroupLayout.DEFAULT_SIZE, 459, Short.MAX_VALUE)

.addComponent(jSeparator1, javax.swing.GroupLayout.Alignment.LEADING, javax.swing.GroupLayout.DEFAULT_SIZE, 459, Short.MAX_VALUE)

.addGroup(javax.swing.GroupLayout.Alignment.LEADING, jPanel1Layout.createSequentialGroup()

.addComponent(jLabel5)

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)

.addComponent(jtxtFieldPlaca, javax.swing.GroupLayout.PREFERRED_SIZE, 72, javax.swing.GroupLayout.PREFERRED_SIZE)

.addGap(18, 18, 18)

.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addGroup(jPanel1Layout.createSequentialGroup()

.addGap(51, 51, 51)

.addComponent(jtxtFieldModelo, javax.swing.GroupLayout.PREFERRED_SIZE, 146, javax.swing.GroupLayout.PREFERRED_SIZE))

.addComponent(jLabel6))

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)

.addComponent(jLabel7)

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)

.addComponent(jLabel8)

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)

.addComponent(jtxtFieldPreco, javax.swing.GroupLayout.DEFAULT_SIZE, 71, Short.MAX_VALUE))

.addComponent(jSeparator2, javax.swing.GroupLayout.Alignment.LEADING, javax.swing.GroupLayout.DEFAULT_SIZE, 459, Short.MAX_VALUE)

.addGroup(javax.swing.GroupLayout.Alignment.LEADING, jPanel1Layout.createSequentialGroup()

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)

.addComponent(jLabel3)

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)

.addComponent(jtxtFieldCPF, javax.swing.GroupLayout.PREFERRED_SIZE, 114, javax.swing.GroupLayout.PREFERRED_SIZE)

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)

.addComponent(jLabel4)

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)

.addComponent(jtxtFieldNome, javax.swing.GroupLayout.DEFAULT_SIZE, 281, Short.MAX_VALUE))

.addGroup(jPanel1Layout.createSequentialGroup()

.addComponent(jLabel10)

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)

.addComponent(jtxtFieldCodigo, javax.swing.GroupLayout.PREFERRED_SIZE, 63, javax.swing.GroupLayout.PREFERRED_SIZE)

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 251, Short.MAX_VALUE)

.addComponent(jLabel2)

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)

.addComponent(jtxtFieldData, javax.swing.GroupLayout.PREFERRED_SIZE, 66, javax.swing.GroupLayout.PREFERRED_SIZE))

.addComponent(jSeparator3, javax.swing.GroupLayout.DEFAULT_SIZE, 459, Short.MAX_VALUE))

.addGap(26, 26, 26)))

.addGap(39, 39, 39)))

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)

.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING, false)

.addComponent(btnAlterar, javax.swing.GroupLayout.Alignment.LEADING, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)

.addComponent(btnNovo, javax.swing.GroupLayout.Alignment.LEADING, javax.swing.GroupLayout.DEFAULT_SIZE, 80, Short.MAX_VALUE))

.addGroup(jPanel1Layout.createSequentialGroup()

.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)

.addComponent(btnExcluir, javax.swing.GroupLayout.DEFAULT_SIZE, 81, Short.MAX_VALUE)

.addComponent(btnSalvar, javax.swing.GroupLayout.Alignment.LEADING, javax.swing.GroupLayout.DEFAULT_SIZE, 81, Short.MAX_VALUE)

.addComponent(btnCancelar, javax.swing.GroupLayout.Alignment.LEADING, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)

.addComponent(btnSair, javax.swing.GroupLayout.PREFERRED_SIZE, 64, javax.swing.GroupLayout.PREFERRED_SIZE))

.addGap(174, 174, 174))))

.addGroup(jPanel1Layout.createSequentialGroup()

.addGap(239, 239, 239)

.addComponent(jLabel1))

.addGroup(jPanel1Layout.createSequentialGroup()

.addGap(123, 123, 123)

.addComponent(jtxtFieldCPF1, javax.swing.GroupLayout.PREFERRED_SIZE, 114, javax.swing.GroupLayout.PREFERRED_SIZE)))

.addContainerGap())

);

jPanel1Layout.setVerticalGroup(

jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addGroup(jPanel1Layout.createSequentialGroup()

.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addGroup(jPanel1Layout.createSequentialGroup()

.addContainerGap()

.addComponent(jLabel1)

.addGap(37, 37, 37)

.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)

.addComponent(jLabel10)

.addComponent(jLabel2)

.addComponent(jtxtFieldData, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)

.addComponent(jtxtFieldCodigo, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)

.addComponent(jSeparator3, javax.swing.GroupLayout.PREFERRED_SIZE, 10, javax.swing.GroupLayout.PREFERRED_SIZE)

.addGap(2, 2, 2)

.addComponent(jLabel11)

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)

.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)

.addComponent(jLabel3)

.addComponent(jLabel4)

.addComponent(jtxtFieldNome, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)

.addComponent(jtxtFieldCPF, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)

.addComponent(jSeparator2, javax.swing.GroupLayout.PREFERRED_SIZE, 13, javax.swing.GroupLayout.PREFERRED_SIZE)

.addGap(1, 1, 1)

.addComponent(jLabel9)

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)

.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)

.addComponent(jLabel5)

.addComponent(jLabel6)

.addComponent(jtxtFieldModelo, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)

.addComponent(jLabel7)

.addComponent(jLabel8)

.addComponent(jtxtFieldPreco, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)

.addComponent(jtxtFieldPlaca, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)

.addComponent(jSeparator1, javax.swing.GroupLayout.PREFERRED_SIZE, 10, javax.swing.GroupLayout.PREFERRED_SIZE)

.addGap(1, 1, 1)

.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)

.addComponent(btnProximo)

.addComponent(btnUltimo)

.addComponent(btnAnterior)

.addComponent(btnPrimeiro))

.addGap(18, 18, 18)

.addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 106, javax.swing.GroupLayout.PREFERRED_SIZE))

.addGroup(jPanel1Layout.createSequentialGroup()

.addGap(70, 70, 70)

.addComponent(btnNovo)

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)

.addComponent(btnAlterar)

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)

.addComponent(btnSalvar, javax.swing.GroupLayout.PREFERRED_SIZE, 23, javax.swing.GroupLayout.PREFERRED_SIZE)

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)

.addComponent(btnExcluir)

.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)

.addComponent(btnCancelar)

.addGap(43, 43, 43)

.addComponent(btnSair)))

.addGap(18, 18, 18)

.addComponent(jtxtFieldCPF1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)

.addContainerGap(46, Short.MAX_VALUE))

);

      javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());

getContentPane().setLayout(layout);

layout.setHorizontalGroup(

layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addGroup(layout.createSequentialGroup()

.addComponent(jPanel1, javax.swing.GroupLayout.PREFERRED_SIZE, 651, javax.swing.GroupLayout.PREFERRED_SIZE)

.addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))

);

layout.setVerticalGroup(

layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)

.addGroup(layout.createSequentialGroup()

.addComponent(jPanel1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)

.addContainerGap(14, Short.MAX_VALUE))

);

      pack();
      }// 

private void btnSairActionPerformed(java.awt.event.ActionEvent evt) {

conexao.desconecta();

dispose();

}

private void btnNovoActionPerformed(java.awt.event.ActionEvent evt) {

jtxtFieldCodigo.setEditable(false);

jtxtFieldData.setEditable(false);

jtxtFieldCPF.setEditable(true);

jtxtFieldNome.setEditable(false);

jtxtFieldPlaca.setEditable(true);

jtxtFieldModelo.setEditable(false);

jtxtFieldPreco.setEditable(false);

jtxtFieldData.setText(new SimpleDateFormat("dd/MM/yyyy").format(new java.util.Date()));
    
    btnNovo.setEnabled(false);
    btnAlterar.setEnabled(false);
    btnSalvar.setEnabled(true);
    btnExcluir.setEnabled(false);
    btnCancelar.setEnabled(true);
    btnPrimeiro.setEnabled(false);
    btnAnterior.setEnabled(false);
    btnProximo.setEnabled(false);
    btnUltimo.setEnabled(false);
    
    jtxtFieldCPF.requestFocus();

}

private void btnAlterarActionPerformed(java.awt.event.ActionEvent evt) {

jtxtFieldCodigo.setEditable(false);

jtxtFieldData.setEditable(false);

jtxtFieldCPF.setEditable(true);

jtxtFieldNome.setEditable(false);

jtxtFieldPlaca.setEditable(true);

jtxtFieldModelo.setEditable(false);

jtxtFieldPreco.setEditable(false);

btnNovo.setEnabled(false);
    btnAlterar.setEnabled(false);
    btnSalvar.setEnabled(true);
    btnExcluir.setEnabled(false);
    btnCancelar.setEnabled(true);
    btnPrimeiro.setEnabled(false);
    btnAnterior.setEnabled(false);
    btnProximo.setEnabled(false);
    btnUltimo.setEnabled(false);
    
    jtxtFieldCPF.requestFocus();

}

private void btnSalvarActionPerformed(java.awt.event.ActionEvent evt) {

jtxtFieldCodigo.setEditable(false);

jtxtFieldData.setEditable(false);

jtxtFieldCPF.setEditable(false);

jtxtFieldNome.setEditable(false);

jtxtFieldPlaca.setEditable(false);

jtxtFieldModelo.setEditable(false);

jtxtFieldPreco.setEditable(false);

btnNovo.setEnabled(true);
    btnAlterar.setEnabled(true);
    btnSalvar.setEnabled(false);
    btnExcluir.setEnabled(true);
    btnCancelar.setEnabled(false);
    btnPrimeiro.setEnabled(true);
    btnAnterior.setEnabled(true);
    btnProximo.setEnabled(true);
    btnUltimo.setEnabled(true);
    
    btnNovo.requestFocus();

}

private void btnExcluirActionPerformed(java.awt.event.ActionEvent evt) {

jtxtFieldCodigo.setEditable(false);

jtxtFieldData.setEditable(false);

jtxtFieldCPF.setEditable(false);

jtxtFieldNome.setEditable(false);

jtxtFieldPlaca.setEditable(false);

jtxtFieldModelo.setEditable(false);

jtxtFieldPreco.setEditable(false);

btnNovo.setEnabled(true);
    btnAlterar.setEnabled(true);
    btnSalvar.setEnabled(false);
    btnExcluir.setEnabled(true);
    btnCancelar.setEnabled(false);
    btnPrimeiro.setEnabled(true);
    btnAnterior.setEnabled(true);
    btnProximo.setEnabled(true);
    btnUltimo.setEnabled(true);
    
    btnNovo.requestFocus();

}

private void btnCancelarActionPerformed(java.awt.event.ActionEvent evt) {

jtxtFieldCodigo.setEditable(false);

jtxtFieldData.setEditable(false);

jtxtFieldCPF.setEditable(false);

jtxtFieldNome.setEditable(false);

jtxtFieldPlaca.setEditable(false);

jtxtFieldModelo.setEditable(false);

jtxtFieldPreco.setEditable(false);

btnNovo.setEnabled(true);
    btnAlterar.setEnabled(true);
    btnSalvar.setEnabled(false);
    btnExcluir.setEnabled(true);
    btnCancelar.setEnabled(false);
    btnPrimeiro.setEnabled(true);
    btnAnterior.setEnabled(true);
    btnProximo.setEnabled(true);
    btnUltimo.setEnabled(true);
    
    btnNovo.requestFocus();

}

[color=red][b]private void jtxtFieldCPF1FocusLost(java.awt.event.FocusEvent evt) {

buscaCliente();

}

public void buscaCliente(){
    try{
    conexao.executeQuery("select * from cliente where CPF = '"+jtxtFieldCPF.getText()+"'");
    if (result() == true){
        while (conexao.resultSet.next()){
            jtxtFieldNome.setText(conexao.resultSet.getString("Nome"));
        }
    }
    }catch (SQLException erro){
        JOptionPane.showMessageDialog(null,"Erro: "+erro,"ERRO",JOptionPane.ERROR_MESSAGE);
    }
}

private boolean result(){
    if (conexao.resultSet != null)
        return true;
    else return false;
}[/b][/color]

  [b] [color=blue] /*
    String query = "select cliente.Nome from cliente where CPF = '"+jtxtFieldCPF.getText()+"'";
    conexao.executeQuery(query);
    //conexao.executeQuery("select cliente.Nome from cliente where CPF = '"+jtxtFieldCPF.getText()+"'");
    if (jtxtFieldCPF.getText() == query){
        try {
            jtxtFieldNome.setText(conexao.resultSet.getString("Nome"));
        } catch (SQLException erro) {
            JOptionPane.showMessageDialog(null,"Erro: "+erro,"ERRO",JOptionPane.ERROR_MESSAGE);
        }
    }
    */[/color][/b]

/**
* @param args the command line arguments
*/
public static void main(String args[]) {
    java.awt.EventQueue.invokeLater(new Runnable() {
        public void run() {
            new Venda().setVisible(true);
        }
    });
}

// Variables declaration - do not modify                     
private javax.swing.JButton btnAlterar;
private javax.swing.JButton btnAnterior;
private javax.swing.JButton btnCancelar;
private javax.swing.JButton btnExcluir;
private javax.swing.JButton btnNovo;
private javax.swing.JButton btnPrimeiro;
private javax.swing.JButton btnProximo;
private javax.swing.JButton btnSair;
private javax.swing.JButton btnSalvar;
private javax.swing.JButton btnUltimo;
private javax.swing.JLabel jLabel1;
private javax.swing.JLabel jLabel10;
private javax.swing.JLabel jLabel11;
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 jPanel1;
private javax.swing.JScrollPane jScrollPane1;
private javax.swing.JSeparator jSeparator1;
private javax.swing.JSeparator jSeparator2;
private javax.swing.JSeparator jSeparator3;
private javax.swing.JTable jTableVenda;
private javax.swing.JFormattedTextField jtxtFieldCPF;
private javax.swing.JFormattedTextField jtxtFieldCPF1;
private javax.swing.JTextField jtxtFieldCodigo;
private javax.swing.JFormattedTextField jtxtFieldData;
private javax.swing.JTextField jtxtFieldModelo;
private javax.swing.JTextField jtxtFieldNome;
private javax.swing.JFormattedTextField jtxtFieldPlaca;
private javax.swing.JTextField jtxtFieldPreco;
// End of variables declaration

}

Criado 19 de novembro de 2008
Ultima resposta 19 de nov. de 2008
Respostas 6
Participantes 5

Topicos relacionados

Como saber se um mes tem 4 ou 5 semanas?[RESOLVIDO] 31 respostas Como converter inteiro para string! 13 respostas Comando SELECT para selecionar intervalo de data SQL SERVER 12 respostas &, &&, |, ||. Qndo usar? 6 respostas O método split 12 respostas
Alura POO: o que é programação orientada a objetos? Aprenda os conceitos básicos da programação orientada a objetos, como classes, objetos, herança, encapsulamento e polimorfismo, com exemplos.
Casa do Codigo Inteligencia Artificial e ChatGPT: Da revolucao dos... Por Fabricio Carraro — Casa do Codigo