Ola Pessual estou com uma duvida que me tirou o sono, não consigo fazer rodar a ´lógica no projeto, queia que quando escolhesse uma opção acendess um combo e quando escolhesse outra habilitasse o outro, simples, mas não funciona e uma outra duvida no campo valor gostaria que fosse float mas se coloco meu banco como moeda ele não roda, o que devo fazer, segue o código que fiz:
package Cadastro;
import Utilitarios.conexao;
import java.sql.SQLException;
import javax.swing.JOptionPane;
/**
*
* @author Tiago
*/
public class Produtos extends javax.swing.JFrame {
int navega = 0;
conexao cad_produtos;
/** Creates new form Produtos */
public Produtos() {
initComponents();
cad_produtos = new conexao();
cad_produtos.conecta();//invoca o metodo conecta
//JOptionPane.showMessageDialog(null,"Conectou","Conexão",JOptionPane.INFORMATION_MESSAGE);
cad_produtos.executeSQL("select * from Cad_Produtos");
try
{
cad_produtos.resultset.first();
jComboBox_TipoP.setSelectedItem(cad_produtos.resultset.getString("Tipo"));
jComboBox_OrigemC.setSelectedItem(cad_produtos.resultset.getString("OrigemC"));
jComboBox_OrigemM.setSelectedItem(cad_produtos.resultset.getString("OrigemM"));
textField_CodigoP.setText(cad_produtos.resultset.getString("Codigo"));
textField_CodigoP.setEnabled(false);
textField_NomeP.setText(cad_produtos.resultset.getString("Nome"));
textField_ValorP.setText(cad_produtos.resultset.getString("Valor"));
textField_DescricaoP.setText(cad_produtos.resultset.getString("Descricao"));
}
catch(SQLException erro)
{
if (navega ==1){
JOptionPane.showMessageDialog(null,"Você ja está no primeiro Registro");
}else if(navega ==2){
JOptionPane.showMessageDialog(null,"Você ja está no ultimo Registro");
}else
JOptionPane.showMessageDialog(null,"Não localizou dados "+erro);
navega=0;
}
}
/** This method is called from within the constructor to
* initialize the form.
* WARNING: Do NOT modify this code. The content of this method is
* always regenerated by the Form Editor.
*/
@SuppressWarnings("unchecked")
// <editor-fold defaultstate="collapsed" desc="Generated Code">
private void initComponents() {
jPanel1 = new javax.swing.JPanel();
textField_CodigoP = new java.awt.TextField();
label_Codigo = new java.awt.Label();
label_NomeP = new java.awt.Label();
label_ValorP = new java.awt.Label();
label_DescriçãoP = new java.awt.Label();
textField_NomeP = new java.awt.TextField();
textField_ValorP = new java.awt.TextField();
textField_DescricaoP = new java.awt.TextField();
jPanel2 = new javax.swing.JPanel();
jButton_first = new javax.swing.JButton();
jButton_previus = new javax.swing.JButton();
jButton_next = new javax.swing.JButton();
jButton_last = new javax.swing.JButton();
jPanel3 = new javax.swing.JPanel();
jButton_alterar = new javax.swing.JButton();
jButton_excluir = new javax.swing.JButton();
jButton_salvar = new javax.swing.JButton();
jButton_novo = new javax.swing.JButton();
jComboBox_TipoP = new javax.swing.JComboBox();
jLabel1 = new javax.swing.JLabel();
jLabel2 = new javax.swing.JLabel();
jLabel3 = new javax.swing.JLabel();
jComboBox_OrigemM = new javax.swing.JComboBox();
jComboBox_OrigemC = new javax.swing.JComboBox();
setDefaultCloseOperation(javax.swing.WindowConstants.DISPOSE_ON_CLOSE);
setCursor(new java.awt.Cursor(java.awt.Cursor.DEFAULT_CURSOR));
jPanel1.setBackground(new java.awt.Color(255, 255, 255));
label_Codigo.setText("Código");
label_NomeP.setText("Nome");
label_ValorP.setText("Valor");
label_DescriçãoP.setText("Descrição");
textField_NomeP.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
textField_NomePActionPerformed(evt);
}
});
jPanel2.setBackground(new java.awt.Color(255, 255, 255));
jButton_first.setIcon(new javax.swing.ImageIcon(getClass().getResource("/Imagens/go-first.png"))); // NOI18N
jButton_first.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jButton_firstActionPerformed(evt);
}
});
jButton_previus.setIcon(new javax.swing.ImageIcon(getClass().getResource("/Imagens/go-previous.png"))); // NOI18N
jButton_previus.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jButton_previusActionPerformed(evt);
}
});
jButton_next.setIcon(new javax.swing.ImageIcon(getClass().getResource("/Imagens/go-next.png"))); // NOI18N
jButton_next.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jButton_nextActionPerformed(evt);
}
});
jButton_last.setIcon(new javax.swing.ImageIcon(getClass().getResource("/Imagens/go-last.png"))); // NOI18N
jButton_last.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jButton_lastActionPerformed(evt);
}
});
javax.swing.GroupLayout jPanel2Layout = new javax.swing.GroupLayout(jPanel2);
jPanel2.setLayout(jPanel2Layout);
jPanel2Layout.setHorizontalGroup(
jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanel2Layout.createSequentialGroup()
.addComponent(jButton_first)
.addGap(18, 18, 18)
.addComponent(jButton_previus)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 28, Short.MAX_VALUE)
.addComponent(jButton_next)
.addGap(18, 18, 18)
.addComponent(jButton_last))
);
jPanel2Layout.setVerticalGroup(
jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jButton_next)
.addComponent(jButton_last)
.addComponent(jButton_first)
.addComponent(jButton_previus))
);
jPanel3.setBackground(new java.awt.Color(255, 255, 255));
jButton_alterar.setIcon(new javax.swing.ImageIcon(getClass().getResource("/Imagens/alterar.png"))); // NOI18N
jButton_alterar.setText("Alterar");
jButton_excluir.setIcon(new javax.swing.ImageIcon(getClass().getResource("/Imagens/edit-delete.png"))); // NOI18N
jButton_excluir.setText("Excluir");
jButton_salvar.setIcon(new javax.swing.ImageIcon(getClass().getResource("/Imagens/media-floppy.png"))); // NOI18N
jButton_salvar.setText("Salvar");
jButton_novo.setIcon(new javax.swing.ImageIcon(getClass().getResource("/Imagens/novo.png"))); // NOI18N
jButton_novo.setText("Novo");
jButton_novo.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jButton_novoActionPerformed(evt);
}
});
javax.swing.GroupLayout jPanel3Layout = new javax.swing.GroupLayout(jPanel3);
jPanel3.setLayout(jPanel3Layout);
jPanel3Layout.setHorizontalGroup(
jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanel3Layout.createSequentialGroup()
.addComponent(jButton_novo)
.addGap(27, 27, 27)
.addComponent(jButton_salvar)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 30, Short.MAX_VALUE)
.addComponent(jButton_alterar)
.addGap(36, 36, 36)
.addComponent(jButton_excluir))
);
jPanel3Layout.setVerticalGroup(
jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jButton_novo)
.addComponent(jButton_alterar)
.addComponent(jButton_excluir)
.addComponent(jButton_salvar))
);
jComboBox_TipoP.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "Escolha uma opção", "Massas", "Carnes", "Doces", "Bolos", "Bebidas", "Guarnições" }));
jComboBox_TipoP.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jComboBox_TipoPActionPerformed(evt);
}
});
jLabel1.setText("Tipo do Produto");
jLabel2.setText("Origem");
jLabel3.setText("Origem");
jComboBox_OrigemM.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "Escolha uma Opção", "Prontas", "Semi-Prontas", "Pre-cozidas", "In Natura" }));
jComboBox_OrigemC.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "Escolha uma opção", "Suina", "Bovina", "Aves", "Peixes" }));
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()
.addGap(50, 50, 50)
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jPanel2, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jPanel3, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)))
.addGroup(jPanel1Layout.createSequentialGroup()
.addGap(22, 22, 22)
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel1Layout.createSequentialGroup()
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(label_NomeP, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(label_ValorP, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(label_DescriçãoP, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(textField_NomeP, javax.swing.GroupLayout.PREFERRED_SIZE, 423, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(textField_ValorP, javax.swing.GroupLayout.PREFERRED_SIZE, 106, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(textField_DescricaoP, javax.swing.GroupLayout.PREFERRED_SIZE, 395, javax.swing.GroupLayout.PREFERRED_SIZE)))
.addGroup(jPanel1Layout.createSequentialGroup()
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(label_Codigo, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel1))
.addGap(26, 26, 26)
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(textField_CodigoP, javax.swing.GroupLayout.PREFERRED_SIZE, 78, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGroup(jPanel1Layout.createSequentialGroup()
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
.addComponent(jLabel3)
.addGroup(jPanel1Layout.createSequentialGroup()
.addComponent(jComboBox_TipoP, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(35, 35, 35)
.addComponent(jLabel2)))
.addGap(18, 18, 18)
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jComboBox_OrigemC, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jComboBox_OrigemM, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))))))))
.addContainerGap(197, Short.MAX_VALUE))
);
jPanel1Layout.setVerticalGroup(
jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel1Layout.createSequentialGroup()
.addContainerGap()
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
.addComponent(textField_CodigoP, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(label_Codigo, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jComboBox_TipoP, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel1)
.addComponent(jLabel2)
.addComponent(jComboBox_OrigemC, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGap(18, 18, 18)
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel3)
.addComponent(jComboBox_OrigemM, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGap(54, 54, 54)
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(label_NomeP, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(textField_NomeP, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(label_ValorP, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(textField_ValorP, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGap(23, 23, 23)
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(label_DescriçãoP, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(textField_DescricaoP, javax.swing.GroupLayout.PREFERRED_SIZE, 82, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGap(21, 21, 21)
.addComponent(jPanel2, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(26, 26, 26)
.addComponent(jPanel3, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(55, 55, 55))
);
label_Codigo.getAccessibleContext().setAccessibleName("Codigo");
javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
getContentPane().setLayout(layout);
layout.setHorizontalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jPanel1, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
);
layout.setVerticalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jPanel1, javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.DEFAULT_SIZE, 471, Short.MAX_VALUE)
);
java.awt.Dimension screenSize = java.awt.Toolkit.getDefaultToolkit().getScreenSize();
setBounds((screenSize.width-728)/2, (screenSize.height-509)/2, 728, 509);
}// </editor-fold>
private void textField_NomePActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
}
private void jButton_lastActionPerformed(java.awt.event.ActionEvent evt) {
try {
cad_produtos.resultset.last();
mostrar_dados();
} catch(SQLException erro) {
JOptionPane.showMessageDialog(null,"Não localizou dados "+erro);
}
}
private void jButton_nextActionPerformed(java.awt.event.ActionEvent evt) {
try {
navega=2;
cad_produtos.resultset.next();
mostrar_dados();
} catch(SQLException erro) {
JOptionPane.showMessageDialog(null,"Não localizou dados "+erro);
}
}
private void jButton_previusActionPerformed(java.awt.event.ActionEvent evt) {
try {
navega = 1;
cad_produtos.resultset.previous();
mostrar_dados();
} catch(SQLException erro) {
JOptionPane.showMessageDialog(null,"Não localizou dados "+erro);
}
}
private void jButton_firstActionPerformed(java.awt.event.ActionEvent evt) {
try {
navega = 1;
cad_produtos.resultset.first();
mostrar_dados();
} catch(SQLException erro) {
JOptionPane.showMessageDialog(null,"Não localizou dados "+erro);
}
}
private void jButton_novoActionPerformed(java.awt.event.ActionEvent evt) {
textField_NomeP.setText("");
textField_ValorP.setText("");
textField_DescricaoP.setText("");
jComboBox_TipoP.setSelectedItem("Escolha uma opção");
jComboBox_OrigemC.setSelectedItem("Escolha uma opção");
jComboBox_OrigemM.setSelectedItem("Escolha uma Opção");
textField_NomeP.requestFocus();
}
private void jComboBox_TipoPActionPerformed(java.awt.event.ActionEvent evt) {
if(jComboBox_TipoP.getSelectedItem().toString().equals("Carnes")){
jComboBox_OrigemM.setEnabled(false);
jComboBox_OrigemC.setEnabled(true);
}else if(jComboBox_TipoP.getSelectedItem().toString().equals("Massas")){
jComboBox_OrigemM.setEnabled(true);
jComboBox_OrigemC.setEnabled(false);
}else
jComboBox_OrigemM.setEnabled(false);
jComboBox_OrigemC.setEnabled(false);
}
/**
* @param args the command line arguments
*/
public static void main(String args[]) {
java.awt.EventQueue.invokeLater(new Runnable() {
public void run() {
new Produtos().setVisible(true);
}
});
}
// Variables declaration - do not modify
private javax.swing.JButton jButton_alterar;
private javax.swing.JButton jButton_excluir;
private javax.swing.JButton jButton_first;
private javax.swing.JButton jButton_last;
private javax.swing.JButton jButton_next;
private javax.swing.JButton jButton_novo;
private javax.swing.JButton jButton_previus;
private javax.swing.JButton jButton_salvar;
private javax.swing.JComboBox jComboBox_OrigemC;
private javax.swing.JComboBox jComboBox_OrigemM;
private javax.swing.JComboBox jComboBox_TipoP;
private javax.swing.JLabel jLabel1;
private javax.swing.JLabel jLabel2;
private javax.swing.JLabel jLabel3;
private javax.swing.JPanel jPanel1;
private javax.swing.JPanel jPanel2;
private javax.swing.JPanel jPanel3;
private java.awt.Label label_Codigo;
private java.awt.Label label_DescriçãoP;
private java.awt.Label label_NomeP;
private java.awt.Label label_ValorP;
private java.awt.TextField textField_CodigoP;
private java.awt.TextField textField_DescricaoP;
private java.awt.TextField textField_NomeP;
private java.awt.TextField textField_ValorP;
// End of variables declaration
public void mostrar_dados()
{
try
{
textField_CodigoP.setText(cad_produtos.resultset.getString("Codigo"));
jComboBox_TipoP.setSelectedItem(cad_produtos.resultset.getString("Tipo"));
jComboBox_OrigemM.setSelectedItem(cad_produtos.resultset.getString("OrigemM"));
jComboBox_OrigemC.setSelectedItem(cad_produtos.resultset.getString("OrigemC"));
textField_NomeP.setText(cad_produtos.resultset.getString("Nome"));
textField_ValorP.setText(cad_produtos.resultset.getString("Valor"));
textField_DescricaoP.setText(cad_produtos.resultset.getString("Descricao"));
}
catch(SQLException erro)
{
if (navega ==1){
JOptionPane.showMessageDialog(null,"Você ja está no primeiro Registro");
}else if(navega ==2){
JOptionPane.showMessageDialog(null,"Você ja está no ultimo Registro");
}else
JOptionPane.showMessageDialog(null,"Não localizou dados "+erro);
navega=0;
}
}
}