Problemas com codigo e botao pesquisar

20/02/2020

0

Ola a todos estou com um grande problema,estou fazendo um cadastro e nele eu preciso pesquisar algumas fichas já digitadas,porem não consigo chamar os dados da pesquisa segue os codigos e o erro.grato



package modeloDao;

import modeloConection.ConexaoBD;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.util.logging.Level;
import java.util.logging.Logger;
import javax.swing.JOptionPane;
import modeloBeans.BeansCadastro;


public class DaoCadastros {

ConexaoBD conex = new ConexaoBD();
BeansCadastro mod = new BeansCadastro();


public void Salvar (BeansCadastro mod){
conex.conexao();
try {
PreparedStatement pst = conex.con.prepareStatement("insert into cadastro (nome_paciente,rg,conjunto_destino,observacao) values (?,?,?,?)");
pst.setString(1, mod.getNome());
pst.setInt(2, mod.getRg());
pst.setInt(3, mod.getConjuntodestino());
pst.setString(4, mod.getObservacao());
pst.execute();
JOptionPane.showMessageDialog(null, "Dados inseridos com Sucesso!");
} catch (SQLException ex) {
JOptionPane.showMessageDialog(null,"Erro ao Inserir Dados Contactar Augusto ou Junior:"+ex);
}


conex.desconecta();
}

public BeansCadastro buscaCadastro (BeansCadastro mod){ // metodo responsavel por pesquisa do cadastro

conex.conectadb();
conex.executaSql ("select *from cadastro where lower(nome_paciente) like lower('%" + mod.getPesquisar() + "%')");
try {
if(conex.rs.first()){
mod.setNome(conex.rs.getString("nome_paciente"));
mod.setRg(conex.rs.getInt("rg"));
mod.setConjuntodestino(conex.rs.getInt("conjunto_destino"));
mod.setObservacao(conex.rs.getString("observacao"));

}
} catch (SQLException ex) {
JOptionPane.showMessageDialog(null,"Erro ao buscar" + ex);
}

conex.desconecta();
return null;
}



O ERRO È............

Exception in thread "AWT-EventQueue-0" java.lang.UnsupportedOperationException: Not supported yet.
at modeloConection.ConexaoBD.conectadb(ConexaoBD.java:66)
at modeloDao.DaoCadastros.buscaCadastro(DaoCadastros.java:39)
at visao.FormCadastro.jButtonPesquisarActionPerformed(FormCadastro.java:282)
at visao.FormCadastro.access$200(FormCadastro.java:9)
at visao.FormCadastro$3.actionPerformed(FormCadastro.java:125)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2022)
at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2348)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:402)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:259)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:252)
at java.awt.Component.processMouseEvent(Component.java:6533)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3324)
at java.awt.Component.processEvent(Component.java:6298)
at java.awt.Container.processEvent(Container.java:2236)
at java.awt.Component.dispatchEventImpl(Component.java:4889)
at java.awt.Container.dispatchEventImpl(Container.java:2294)
at java.awt.Component.dispatchEvent(Component.java:4711)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4888)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4525)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4466)
at java.awt.Container.dispatchEventImpl(Container.java:2280)
at java.awt.Window.dispatchEventImpl(Window.java:2746)
at java.awt.Component.dispatchEvent(Component.java:4711)
at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:758)
at java.awt.EventQueue.access$500(EventQueue.java:97)
at java.awt.EventQueue$3.run(EventQueue.java:709)
at java.awt.EventQueue$3.run(EventQueue.java:703)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:76)
at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:86)
at java.awt.EventQueue$4.run(EventQueue.java:731)
at java.awt.EventQueue$4.run(EventQueue.java:729)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:76)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:728)
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:201)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:116)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:105)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:93)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:82)
Exception in thread "AWT-EventQueue-0" java.lang.UnsupportedOperationException: Not supported yet.
Augusto Whitaker

Augusto Whitaker

Responder

Posts

20/02/2020

Augusto Whitaker

Ola a todos estou com um grande problema,estou fazendo um cadastro e nele eu preciso pesquisar algumas fichas já digitadas,porem não consigo chamar os dados da pesquisa segue os codigos e o erro.grato



package modeloDao;

import modeloConection.ConexaoBD;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.util.logging.Level;
import java.util.logging.Logger;
import javax.swing.JOptionPane;
import modeloBeans.BeansCadastro;


public class DaoCadastros {



Resolvido !!

Aparentemente eu sou uma lesma e estou comecando no mundo da programação,foi um erro bobo de sintaxe mas que serve para mostrar o quando a atenção aos minimos detalhes é importante,
o erro esta na linha!!!= conex.executaSql ("select *from cadastro where lower(nome_paciente) like lower('%" + mod.getPesquisar() + "%')");


ConexaoBD conex = new ConexaoBD();
BeansCadastro mod = new BeansCadastro();


public void Salvar (BeansCadastro mod){
conex.conexao();
try {
PreparedStatement pst = conex.con.prepareStatement("insert into cadastro (nome_paciente,rg,conjunto_destino,observacao) values (?,?,?,?)");
pst.setString(1, mod.getNome());
pst.setInt(2, mod.getRg());
pst.setInt(3, mod.getConjuntodestino());
pst.setString(4, mod.getObservacao());
pst.execute();
JOptionPane.showMessageDialog(null, "Dados inseridos com Sucesso!");
} catch (SQLException ex) {
JOptionPane.showMessageDialog(null,"Erro ao Inserir Dados Contactar Augusto ou Junior:"+ex);
}


conex.desconecta();
}

public BeansCadastro buscaCadastro (BeansCadastro mod){ // metodo responsavel por pesquisa do cadastro

conex.conectadb();
conex.executaSql ("select *from cadastro where lower(nome_paciente) like lower('%" + mod.getPesquisar() + "%')");
try {
if(conex.rs.first()){
mod.setNome(conex.rs.getString("nome_paciente"));
mod.setRg(conex.rs.getInt("rg"));
mod.setConjuntodestino(conex.rs.getInt("conjunto_destino"));
mod.setObservacao(conex.rs.getString("observacao"));

}
} catch (SQLException ex) {
JOptionPane.showMessageDialog(null,"Erro ao buscar" + ex);
}

conex.desconecta();
return null;
}



O ERRO È............

Exception in thread "AWT-EventQueue-0" java.lang.UnsupportedOperationException: Not supported yet.
at modeloConection.ConexaoBD.conectadb(ConexaoBD.java:66)
at modeloDao.DaoCadastros.buscaCadastro(DaoCadastros.java:39)
at visao.FormCadastro.jButtonPesquisarActionPerformed(FormCadastro.java:282)
at visao.FormCadastro.access$200(FormCadastro.java:9)
at visao.FormCadastro$3.actionPerformed(FormCadastro.java:125)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2022)
at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2348)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:402)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:259)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:252)
at java.awt.Component.processMouseEvent(Component.java:6533)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3324)
at java.awt.Component.processEvent(Component.java:6298)
at java.awt.Container.processEvent(Container.java:2236)
at java.awt.Component.dispatchEventImpl(Component.java:4889)
at java.awt.Container.dispatchEventImpl(Container.java:2294)
at java.awt.Component.dispatchEvent(Component.java:4711)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4888)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4525)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4466)
at java.awt.Container.dispatchEventImpl(Container.java:2280)
at java.awt.Window.dispatchEventImpl(Window.java:2746)
at java.awt.Component.dispatchEvent(Component.java:4711)
at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:758)
at java.awt.EventQueue.access$500(EventQueue.java:97)
at java.awt.EventQueue$3.run(EventQueue.java:709)
at java.awt.EventQueue$3.run(EventQueue.java:703)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:76)
at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:86)
at java.awt.EventQueue$4.run(EventQueue.java:731)
at java.awt.EventQueue$4.run(EventQueue.java:729)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:76)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:728)
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:201)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:116)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:105)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:93)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:82)
Exception in thread "AWT-EventQueue-0" java.lang.UnsupportedOperationException: Not supported yet.
Responder

Utilizamos cookies para fornecer uma melhor experiência para nossos usuários, consulte nossa política de privacidade.

Aceitar