boa noite, pessoal!!!
tudo bem?
galera, estou tentando montar uma tabela com resultados de uma pesquisa com banco de dados,
mas estou tento o seguinte erro:
Exception in thread "AWT-EventQueue-0" java.lang.NoClassDefFoundError: DAO/ContatoDAO
at Formularios.FormularioContato.listarContatos(FormularioContato.java:384)
at Formularios.FormularioContato.jButton1ActionPerformed(FormularioContato.java:425)
at Formularios.FormularioContato.access$200(FormularioContato.java:27)
at Formularios.FormularioContato$3.actionPerformed(FormularioContato.java:204)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)
at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)
at
javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236)
at java.awt.Component.processMouseEvent(Component.java:6267)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3267)
at java.awt.Component.processEvent(Component.java:6032)
at java.awt.Container.processEvent(Container.java:2041)
at java.awt.Component.dispatchEventImpl(Component.java:4630)
at java.awt.Container.dispatchEventImpl(Container.java:2099)
at java.awt.Component.dispatchEvent(Component.java:4460)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4577)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4238)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4168)
at java.awt.Container.dispatchEventImpl(Container.java:2085)
at java.awt.Window.dispatchEventImpl(Window.java:2478)
at java.awt.Component.dispatchEvent(Component.java:4460)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:599)
at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161)
at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)
Caused by: java.lang.ClassNotFoundException: DAO.ContatoDAO
at java.net.URLClassLoader$1.run(URLClassLoader.java:202)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:190)
at java.lang.ClassLoader.loadClass(ClassLoader.java:307)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:301)
at java.lang.ClassLoader.loadClass(ClassLoader.java:248)
... 29 more
CONSTRUÍDO COM SUCESSO (tempo total: 6 segundos)(o meu foco é o erro, e descobrir a causa e a solução, mas por via das duvidas, postarei o
resto, está bem?
Valeu!)
Obrigado a todos!!
Horácio
a classe do formuláro é essa:
/*
* To change this template, choose Tools | Templates
* and open the template in the editor.
*/
/*
* FormularioContato.java
*
* Created on 16/01/2011, 16:30:00
*/
package Formularios;
import DAO.ContatoDAO;
import Logica.Contato;
import java.sql.SQLException;
import java.util.List;
import java.util.logging.Level;
import java.util.logging.Logger;
import javax.swing.JOptionPane;
import javax.swing.ListSelectionModel;
import javax.swing.table.DefaultTableModel;
/**
*
* @author Administrador
*/
public class FormularioContato extends javax.swing.JFrame {
DefaultTableModel tmContato = new DefaultTableModel(null, new String[]{"codigo",
"nome","telefone","sexo"});
List<Contato>contatos;
ListSelectionModel lsmContato;
/** Creates new form FormularioContato */
public FormularioContato() {
initComponents();
desabilitaDados();
}
/** 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() {
jScrollPane1 = new javax.swing.JScrollPane();
jTable1 = new javax.swing.JTable();
jScrollPane2 = new javax.swing.JScrollPane();
jTable2 = new javax.swing.JTable();
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();
codigo = new javax.swing.JTextField();
nome = new javax.swing.JTextField();
email = new javax.swing.JTextField();
sexo = new javax.swing.JTextField();
telefone = new javax.swing.JTextField();
jLabel5 = new javax.swing.JLabel();
jButton1 = new javax.swing.JButton();
pesquisar = new javax.swing.JTextField();
jPanel2 = new javax.swing.JPanel();
jBnovo = new javax.swing.JButton();
jBalterar = new javax.swing.JButton();
jBexcluir = new javax.swing.JButton();
jBsalvar = new javax.swing.JButton();
jBsair = new javax.swing.JButton();
jPanel3 = new javax.swing.JPanel();
jScrollPane3 = new javax.swing.JScrollPane();
jTable3 = new javax.swing.JTable();
jTable1.setModel(new javax.swing.table.DefaultTableModel(
new Object [][] {
{null, null, null, null},
{null, null, null, null},
{null, null, null, null},
{null, null, null, null}
},
new String [] {
"Title 1", "Title 2", "Title 3", "Title 4"
}
));
jScrollPane1.setViewportView(jTable1);
jTable2.setModel(new javax.swing.table.DefaultTableModel(
new Object [][] {
{null, null, null, null},
{null, null, null, null},
{null, null, null, null},
{null, null, null, null}
},
new String [] {
"Title 1", "Title 2", "Title 3", "Title 4"
}
));
jScrollPane2.setViewportView(jTable2);
setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
jPanel1.setBackground(new java.awt.Color(255, 255, 255));
jPanel1.setBorder(javax.swing.BorderFactory.createTitledBorder("Dados do Contato"));
jLabel1.setText("Código:");
jLabel2.setText("Nome:");
jLabel3.setText("E-mail:");
jLabel4.setText("Sexo:");
codigo.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
codigoActionPerformed(evt);
}
});
telefone.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
telefoneActionPerformed(evt);
}
});
jLabel5.setText("Telefone:");
javax.swing.GroupLayout jPanel1Layout = new javax.swing.GroupLayout(jPanel1);
jPanel1.setLayout(jPanel1Layout);
jPanel1Layout.setHorizontalGroup(
jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel1Layout.createSequentialGroup()
.addContainerGap()
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel1Layout.createSequentialGroup()
.addComponent(jLabel1)
.addGap(18, 18, 18)
.addComponent(codigo, javax.swing.GroupLayout.PREFERRED_SIZE, 42,
javax.swing.GroupLayout.PREFERRED_SIZE))
.addGroup(jPanel1Layout.createSequentialGroup()
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING,
false)
.addGroup(javax.swing.GroupLayout.Alignment.LEADING,
jPanel1Layout.createSequentialGroup()
.addComponent(jLabel3)
.addGap(18, 18, 18)
.addComponent(email))
.addGroup(javax.swing.GroupLayout.Alignment.LEADING,
jPanel1Layout.createSequentialGroup()
.addComponent(jLabel2)
.addGap(18, 18, 18)
.addComponent(nome, javax.swing.GroupLayout.PREFERRED_SIZE,
108, javax.swing.GroupLayout.PREFERRED_SIZE)))
.addGap(18, 18, 18)
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jLabel5)
.addComponent(jLabel4))
.addGap(18, 18, 18)
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(sexo, javax.swing.GroupLayout.PREFERRED_SIZE, 41,
javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(telefone, javax.swing.GroupLayout.PREFERRED_SIZE,
71, javax.swing.GroupLayout.PREFERRED_SIZE))))
.addContainerGap(315, Short.MAX_VALUE))
);
jPanel1Layout.linkSize(javax.swing.SwingConstants.HORIZONTAL, new
java.awt.Component[] {email, nome, telefone});
jPanel1Layout.setVerticalGroup(
jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel1Layout.createSequentialGroup()
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel1)
.addComponent(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(nome, javax.swing.GroupLayout.PREFERRED_SIZE,
javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel2)
.addComponent(jLabel4)
.addComponent(sexo, 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(jLabel3)
.addComponent(email, javax.swing.GroupLayout.PREFERRED_SIZE,
javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(telefone, javax.swing.GroupLayout.PREFERRED_SIZE,
javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel5))
.addContainerGap(14, Short.MAX_VALUE))
);
jButton1.setText("pesquisar");
jButton1.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jButton1ActionPerformed(evt);
}
});
pesquisar.setBackground(new java.awt.Color(255, 255, 255));
pesquisar.addKeyListener(new java.awt.event.KeyAdapter() {
public void keyPressed(java.awt.event.KeyEvent evt) {
pesquisarKeyPressed(evt);
}
});
jPanel2.setBackground(new java.awt.Color(255, 255, 255));
jPanel2.setBorder(new javax.swing.border.LineBorder(new java.awt.Color(204, 102, 0),
0, true));
jPanel2.setForeground(new java.awt.Color(255, 255, 255));
jBnovo.setText("Novo");
jBnovo.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jBnovoActionPerformed(evt);
}
});
jBalterar.setText("Alterar");
jBalterar.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jBalterarActionPerformed(evt);
}
});
jBexcluir.setText("Excluir");
jBsalvar.setText("Salvar");
jBsalvar.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jBsalvarActionPerformed(evt);
}
});
jBsair.setText("Sair");
javax.swing.GroupLayout jPanel2Layout = new javax.swing.GroupLayout(jPanel2);
jPanel2.setLayout(jPanel2Layout);
jPanel2Layout.setHorizontalGroup(
jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel2Layout.createSequentialGroup()
.addGap(148, 148, 148)
.addComponent(jBnovo)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(jBalterar)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(jBexcluir)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(jBsalvar)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(jBsair)
.addContainerGap(192, Short.MAX_VALUE))
);
jPanel2Layout.linkSize(javax.swing.SwingConstants.HORIZONTAL, new
java.awt.Component[] {jBalterar, jBexcluir, jBnovo, jBsair, jBsalvar});
jPanel2Layout.setVerticalGroup(
jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel2Layout.createSequentialGroup()
.addContainerGap()
.addGroup(jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jBnovo)
.addComponent(jBalterar)
.addComponent(jBexcluir)
.addComponent(jBsalvar)
.addComponent(jBsair))
.addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
);
jPanel3.setBackground(java.awt.Color.white);
jPanel3.setBorder(javax.swing.BorderFactory.createLineBorder(new java.awt.Color(0,
0, 0)));
jTable3.setModel(tmContato);
jScrollPane3.setViewportView(jTable3);
javax.swing.GroupLayout jPanel3Layout = new javax.swing.GroupLayout(jPanel3);
jPanel3.setLayout(jPanel3Layout);
jPanel3Layout.setHorizontalGroup(
jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel3Layout.createSequentialGroup()
.addContainerGap()
.addComponent(jScrollPane3, javax.swing.GroupLayout.DEFAULT_SIZE, 667,
Short.MAX_VALUE)
.addContainerGap())
);
jPanel3Layout.setVerticalGroup(
jPanel3Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(javax.swing.GroupLayout.Alignment.TRAILING,
jPanel3Layout.createSequentialGroup()
.addContainerGap()
.addComponent(jScrollPane3, javax.swing.GroupLayout.DEFAULT_SIZE, 163,
Short.MAX_VALUE)
.addContainerGap())
);
javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
getContentPane().setLayout(layout);
layout.setHorizontalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addContainerGap()
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(javax.swing.GroupLayout.Alignment.TRAILING,
layout.createSequentialGroup()
.addComponent(pesquisar, javax.swing.GroupLayout.DEFAULT_SIZE, 604,
Short.MAX_VALUE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(jButton1)
.addContainerGap())
.addGroup(javax.swing.GroupLayout.Alignment.TRAILING,
layout.createSequentialGroup()
.addComponent(jPanel1, javax.swing.GroupLayout.DEFAULT_SIZE,
javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addContainerGap())
.addGroup(javax.swing.GroupLayout.Alignment.TRAILING,
layout.createSequentialGroup()
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
.addComponent(jPanel3,
javax.swing.GroupLayout.Alignment.LEADING, javax.swing.GroupLayout.DEFAULT_SIZE,
javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addComponent(jPanel2, javax.swing.GroupLayout.DEFAULT_SIZE,
javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
.addContainerGap())))
);
layout.setVerticalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addContainerGap()
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(pesquisar, javax.swing.GroupLayout.PREFERRED_SIZE,
javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jButton1))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(jPanel1, javax.swing.GroupLayout.PREFERRED_SIZE,
javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(18, 18, 18)
.addComponent(jPanel2, javax.swing.GroupLayout.PREFERRED_SIZE,
javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(18, 18, 18)
.addComponent(jPanel3, javax.swing.GroupLayout.DEFAULT_SIZE,
javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addContainerGap())
);
pack();
}// </editor-fold>
private void codigoActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
}
private void telefoneActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
}
private void jBalterarActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
}
private void jBnovoActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
habilitaDados();
nome.setText("");
email.setText("");
telefone.setText("");
sexo.setText("");
}
public void desabilitaDados(){
codigo.setEditable(false);
nome.setEditable(false);
email.setEditable(false);
sexo.setEditable(false);
telefone.setEditable(false);
}
public void habilitaDados(){
nome.setEditable(true);
email.setEditable(true);
sexo.setEditable(true);
telefone.setEditable(true);
}
public void listarContatos() throws SQLException{
ContatoDAO dao = new ContatoDAO();
contatos = dao.getLista("%"+pesquisar.getText()+"%");
}
private void jBsalvarActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
try {
Contato c1 = new Contato();
c1.setNome(nome.getText());
c1.setTelefone(telefone.getText());
c1.setEmail(email.getText());
c1.setSexo(sexo.getText());
ContatoDAO dao = new ContatoDAO();
dao.adiciona(c1);
} catch (SQLException ex) {
Logger.getLogger(FormularioContato.class.getName()).log(Level.SEVERE, null, ex);
}
}
private void pesquisarKeyPressed(java.awt.event.KeyEvent evt) {
// TODO add your handling code here:
}
private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {
try {
listarContatos();
} catch (SQLException ex) {
Logger.getLogger(FormularioContato.class.getName()).log(Level.SEVERE, null, ex);
}
}
/**
* @param args the command line arguments
*/
public static void main(String args[]) {
java.awt.EventQueue.invokeLater(new Runnable() {
public void run() {
new FormularioContato().setVisible(true);
}
});
}
// Variables declaration - do not modify
private javax.swing.JTextField codigo;
private javax.swing.JTextField email;
private javax.swing.JButton jBalterar;
private javax.swing.JButton jBexcluir;
private javax.swing.JButton jBnovo;
private javax.swing.JButton jBsair;
private javax.swing.JButton jBsalvar;
private javax.swing.JButton jButton1;
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.JPanel jPanel1;
private javax.swing.JPanel jPanel2;
private javax.swing.JPanel jPanel3;
private javax.swing.JScrollPane jScrollPane1;
private javax.swing.JScrollPane jScrollPane2;
private javax.swing.JScrollPane jScrollPane3;
private javax.swing.JTable jTable1;
private javax.swing.JTable jTable2;
private javax.swing.JTable jTable3;
private javax.swing.JTextField nome;
private javax.swing.JTextField pesquisar;
private javax.swing.JTextField sexo;
private javax.swing.JTextField telefone;
// End of variables declaration
private void mostraPesquisa(List<Contato> contatos) {
if(contatos.size() == '0')
{
JOptionPane.showMessageDialog(null, "nenhum contato encontrato");
}
else
{ String[] linha=new String[]{null,null,null,null};
for (int i = 0; i < contatos.size(); i++) {
tmContato.addRow(linha);
tmContato.setValueAt(contatos.get(i).getCodigo(), i,0);
tmContato.setValueAt(contatos.get(i).getCodigo(), i,0);
tmContato.setValueAt(contatos.get(i).getNome(), i,0);
tmContato.setValueAt(contatos.get(i).getTelefone(), i,0);
tmContato.setValueAt(contatos.get(i).getSexo(), i,0);
}
}
}
}
e a classe que faz a pesquisa é:
package DAO;
import Logica.Contato;
import bancodedados.CriaConexao;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
public class ContatoDAO {
private Connection conexao;
public ContatoDAO() throws SQLException{
this.conexao=CriaConexao.getConexao();}
public void adiciona(Contato AddSimple) throws SQLException{
String sql="insert into contatos(nome, email, telefone,sexo)"+
"values(?,?,?,?)";
PreparedStatement stmt=conexao.prepareStatement(sql);
stmt.setString(1, AddSimple.getNome());
stmt.setString(2, AddSimple.getEmail());
stmt.setString(3, AddSimple.getTelefone());
stmt.setString(4, AddSimple.getSexo());
stmt.execute();
stmt.close();
}
public List<Contato> getLista(String nome) throws SQLException{
String sql="select * from contatos";
PreparedStatement stmt=this.conexao.prepareStatement(sql);
stmt.setString(1, nome);
ResultSet rs=stmt.executeQuery();
List<Contato> minhaLista = new ArrayList<Contato>();
while(rs.next()){
Contato listagem = new Contato();
listagem.setNome(rs.getString("nome"));
listagem.setTelefone(rs.getString("telefone"));
listagem.setEmail(rs.getString("email"));
listagem.setSexo(rs.getString("sexo"));
minhaLista.add(listagem);
}
rs.close();
stmt.close();
return minhaLista;
}
public void altera(Contato c1) throws SQLException{
String sql="update contatos set nome=?, email=?, telefone=?, sexo=? where codigo=?";
PreparedStatement stmt=conexao.prepareStatement(sql);
stmt.setString(1, c1.getNome());
stmt.setString(2, c1.getEmail());
stmt.setString(3, c1.getTelefone());
stmt.setString(4, c1.getSexo());
stmt.setLong(5, c1.getCodigo());
stmt.execute();
stmt.close();
}
public void remove(Contato c1) throws SQLException{
String sql="delete from contatos where codigo=?";
PreparedStatement stmt = conexao.prepareStatement(sql);
stmt.setLong(1, c1.getCodigo());
stmt.execute();
stmt.close();
}
}