Por favor se algem puder dar uma olhada no fonte abaixo, pois é meu projeto da facul e não consigo compilar, não acho o que tá errado e tenho que apresentar na segunda dia 24/11/2008.
import java.sql.*;
import javax.swing.*;
import java.awt.*;
import java.text.*;
public class projeto extends JFrame implements ActionListener, ItemListener
{
JLabel rotulodomi, rotulopes1, rotulopes2, rotulopes3, rotulopes4, rotulopes5,
rotulopes6, rotulopes7, rotulopes8, rotulodoc1, rotulodat1, rotulodoc2,
rotulodat2, rotulodoc3, rotulodat3, rotulodoc4, rotulodat4, rotulodoc5,
rotulodat5, rotulodoc6, rotulodat6, rotulodoc7, rotulodat7, rotulodoc8,
rotulodat8, rotulotop, rotulotor, rotulonuc, rotulonug;
JButton btGravar, btAlterar, btExcluir, btNovo, btLocalizar, btCancelar;
JFormattedTextField domi, pes1, pes2, pes3, pes4, pes5, pes6, pes7, pes8, doc1, dat1,
doc2, dat2, doc3, dat3, doc4, dat4, doc5, dat5, doc6, dat6, doc7,
dat7, doc8, dat8, top, tor, nuc, nug;
MaskFormatter mascaradomi, mascarapes1, mascarapes2, mascarapes3, mascarapes4, ascarapes5,
mascarapes6, mascarapes7, mascarapes8, mascaradoc1, mascaradat1, mascaradoc2, mascaradat2,
mascaradoc3, mascaradat3, mascaradoc4, mascaradat4, mascaradoc5, mascaradat5, mascaradoc6,
mascaradat6, mascaradoc7, mascaradat7, mascaradoc8, mascaradat8, mascaratop, mascarator,
mascaranuc, mascaranug;
JPanel tela=new JPanel();
ResultSet resultSet;
Statement statement;
public static void main(String args[])
{
JFrame tela=new projeto();
tela.setUndecorated(true);
tela.getRootPane().setWindowDecorationStyle(JRootPane.FRAME);
tela.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
tela.setVisible(true);
}
projeto()
{
tela.setLayout(new FlowLayout(FlowLayout.LEFT));
super("**CADASTRO**");
Container tela = getContentPane();
setLayout(null);
rotulodomi = new JLabel("Endereço*********************************: ");
rotulopes1 = new JLabel("Pessoa 1: ");
rotulodoc1 = new JLabel("Documento: ");
rotulodat1 = new JLabel("Dt Nascimento: ");
rotulopes2 = new JLabel("Pessoa 2: ");
rotulodoc2 = new JLabel("Documento: ");
rotulodat2 = new JLabel("Dt Nascimento: ");
rotulopes3 = new JLabel("Pessoa 3: ");
rotulodoc3 = new JLabel("Documento: ");
rotulodat3 = new JLabel("Dt Nascimento: ");
rotulopes4 = new JLabel("Pessoa 4: ");
rotulodoc4 = new JLabel("Documento: ");
rotulodat4 = new JLabel("Dt Nascimento: ");
rotulopes5 = new JLabel("Pessoa 5: ");
rotulodoc5 = new JLabel("Documento: ");
rotulodat5 = new JLabel("Dt Nascimento: ");
rotulopes6 = new JLabel("Pessoa 6: ");
rotulodoc6 = new JLabel("Documento: ");
rotulodat6 = new JLabel("Dt Nascimento: ");
rotulopes7 = new JLabel("Pessoa 7: ");
rotulodoc7 = new JLabel("Documento: ");
rotulodat7 = new JLabel("Dt Nascimento: ");
rotulopes8 = new JLabel("Pessoa 8: ");
rotulodoc8 = new JLabel("Documento: ");
rotulodat8 = new JLabel("Dt Nascimento: ");
rotulotop = new JLabel("Total de Pessoas: ");
rotulotor = new JLabel("Total da Renda: ");
rotulonuc = new JLabel("Nº de Crianças: ");
rotulonug = new JLabel("Nº de Gestantes: ");
btGravar = new JButton("Gravar");
btAlterar = new JButton("Alterar");
btExcluir = new JButton("Excluir");
btLocalizar = new JButton("Localizar");
btNovo = new JButton("Novo");
btCancelar = new JButton("Cancelar");
btGravar.setBackground(new Color(180,180,250));
btAlterar.setBackground(new Color(180,180,250));
btExcluir.setBackground(new Color(180,180,250));
btLocalizar.setBackground(new Color(180,180,250));
btNovo.setBackground(new Color(180,180,250));
btCancelar.setBackground(new Color(180,180,250));
btGravar.addActionListener(this);
btAlterar.addActionListener(this);
btExcluir.addActionListener(this);
btLocalizar.addActionListener(this);
btNovo.addActionListener(this);
btCancelar.addActionListener(this);
getContentPane().add(tela);
setTitle("Cadastro");
setSize(610,120);
setResizable(true);
setBotoes(true,true,false,false,false,false);
carregaResultSet();
rotulodomi.setBounds(50,20,100,20);
rotulopes1.setBounds(50,60,100,20);
rotulodoc1.setBounds(50,80,100,20);
rotulodat1.setBounds(550,80,100,20);
rotulopes2.setBounds(50,120,100,20);
rotulodoc2.setBounds(50,140,100,20);
rotulodat2.setBounds(550,140,100,20);
rotulopes3.setBounds(50,180,100,20);
rotulodoc3.setBounds(50,200,100,20);
rotulodat3.setBounds(550,200,100,20);
rotulopes4.setBounds(50,240,100,20);
rotulodoc4.setBounds(50,260,100,20);
rotulodat4.setBounds(550,260,100,20);
rotulopes5.setBounds(50,300,100,20);
rotulodoc5.setBounds(50,320,100,20);
rotulodat5.setBounds(550,320,100,20);
rotulopes6.setBounds(50,360,100,20);
rotulodoc6.setBounds(50,380,100,20);
rotulodat6.setBounds(550,380,100,20);
rotulopes7.setBounds(50,420,100,20);
rotulodoc7.setBounds(50,440,100,20);
rotulodat7.setBounds(550,440,100,20);
rotulopes8.setBounds(50,480,100,20);
rotulodoc8.setBounds(50,500,100,20);
rotulodat8.setBounds(550,500,100,20);
rotulotop.setBounds(50,580,100,20);
rotulotor.setBounds(250,580,100,20);
rotulonuc.setBounds(50,620,100,20);
rotulonug.setBounds(250,620,100,20);
try
{
mascaradomi = new MaskFormatter("*********************************************************************");
mascarapes1 = new MaskFormatter("***********************************************");
mascaradoc1 = new MaskFormatter("***********************************************");
mascaradat1 = new MaskFormatter("##/##/####");
mascarapes2 = new MaskFormatter("***********************************************");
mascaradoc2 = new MaskFormatter("***********************************************");
mascaradat2 = new MaskFormatter("##/##/####");
mascarapes3 = new MaskFormatter("***********************************************");
mascaradoc3 = new MaskFormatter("***********************************************");
mascaradat3 = new MaskFormatter("##/##/####");
mascarapes4 = new MaskFormatter("***********************************************");
mascaradoc4 = new MaskFormatter("***********************************************");
mascaradat4 = new MaskFormatter("##/##/####");
mascarapes5 = new MaskFormatter("***********************************************");
mascaradoc5 = new MaskFormatter("***********************************************");
mascaradat5 = new MaskFormatter("##/##/####");
mascarapes6 = new MaskFormatter("***********************************************");
mascaradoc6 = new MaskFormatter("***********************************************");
mascaradat6 = new MaskFormatter("##/##/####");
mascarapes7 = new MaskFormatter("***********************************************");
mascaradoc7 = new MaskFormatter("***********************************************");
mascaradat7 = new MaskFormatter("##/##/####");
mascarapes8 = new MaskFormatter("***********************************************");
mascaradoc8 = new MaskFormatter("***********************************************");
mascaradat8 = new MaskFormatter("##/##/####");
mascaratop = new MaskFormatter("##");
mascarator = new MaskFormatter("#.###,##");
mascaranuc = new MaskFormatter("##");
mascaranug = new MaskFormatter("##");
mascaradomi.setPlaceholderCharacter(' ');
mascarapes1.setPlaceholderCharacter(' ');
mascaradoc1.setPlaceholderCharacter(' ');
mascaradat1.setPlaceholderCharacter(' ');
mascarapes2.setPlaceholderCharacter(' ');
mascaradoc2.setPlaceholderCharacter(' ');
mascaradat2.setPlaceholderCharacter(' ');
mascarapes3.setPlaceholderCharacter(' ');
mascaradoc3.setPlaceholderCharacter(' ');
mascaradat3.setPlaceholderCharacter(' ');
mascarapes4.setPlaceholderCharacter(' ');
mascaradoc4.setPlaceholderCharacter(' ');
mascaradat4.setPlaceholderCharacter(' ');
mascarapes5.setPlaceholderCharacter(' ');
mascaradoc5.setPlaceholderCharacter(' ');
mascaradat5.setPlaceholderCharacter(' ');
mascarapes6.setPlaceholderCharacter(' ');
mascaradoc6.setPlaceholderCharacter(' ');
mascaradat6.setPlaceholderCharacter(' ');
mascarapes7.setPlaceholderCharacter(' ');
mascaradoc7.setPlaceholderCharacter(' ');
mascaradat7.setPlaceholderCharacter(' ');
mascarapes8.setPlaceholderCharacter(' ');
mascaradoc8.setPlaceholderCharacter(' ');
mascaradat8.setPlaceholderCharacter(' ');
mascaratop.setPlaceholderCharacter(' ');
mascarator.setPlaceholderCharacter(' ');
mascaranuc.setPlaceholderCharacter(' ');
mascaranug.setPlaceholderCharacter(' ');
}
catch(ParseException excp){}
domi= new JFormattedTextField(mascaradomi);
pes1 = new JFormattedTextField(mascarapes1);
doc1 = new JFormattedTextField(mascaradoc1);
dat1 = new JFormattedTextField(mascaradat1);
pes2 = new JFormattedTextField(mascarapes2);
doc2 = new JFormattedTextField(mascaradoc2);
dat2 = new JFormattedTextField(mascaradat2);
pes3 = new JFormattedTextField(mascarapes3);
doc3 = new JFormattedTextField(mascaradoc3);
dat3 = new JFormattedTextField(mascaradat3);
pes4 = new JFormattedTextField(mascarapes4);
doc4 = new JFormattedTextField(mascaradoc4);
dat4 = new JFormattedTextField(mascaradat4);
pes5 = new JFormattedTextField(mascarapes5);
doc5 = new JFormattedTextField(mascaradoc5);
dat5 = new JFormattedTextField(mascaradat5);
pes6 = new JFormattedTextField(mascarapes6);
doc6 = new JFormattedTextField(mascaradoc6);
dat6 = new JFormattedTextField(mascaradat6);
pes7 = new JFormattedTextField(mascarapes7);
doc7 = new JFormattedTextField(mascaradoc7);
dat7 = new JFormattedTextField(mascaradat7);
pes8 = new JFormattedTextField(mascarapes8);
doc8 = new JFormattedTextField(mascaradoc8);
dat8 = new JFormattedTextField(mascaradat8);
top = new JFormattedTextField(mascaratop);
tor = new JFormattedTextField(mascarator);
nuc = new JFormattedTextField(mascaranuc);
nug = new JFormattedTextField(mascaranug);
domi.setBounds(150,20,500,20);
pes1.setBounds(150,60,350,20);
doc1.setBounds(150,80,350,20);
dat1.setBounds(650,80,70,20);
pes2.setBounds(150,120,350,20);
doc2.setBounds(150,140,350,20);
dat2.setBounds(650,140,70,20);
pes3.setBounds(150,180,350,20);
doc3.setBounds(150,200,350,20);
dat3.setBounds(650,200,70,20);
pes4.setBounds(150,240,350,20);
doc4.setBounds(150,260,350,20);
dat4.setBounds(650,260,70,20);
pes5.setBounds(150,300,350,20);
doc5.setBounds(150,320,350,20);
dat5.setBounds(650,320,70,20);
pes6.setBounds(150,360,350,20);
doc6.setBounds(150,380,350,20);
dat6.setBounds(650,380,70,20);
pes7.setBounds(150,420,350,20);
doc7.setBounds(150,440,350,20);
dat7.setBounds(650,440,70,20);
pes8.setBounds(150,480,350,20);
doc8.setBounds(150,500,350,20);
dat8.setBounds(650,500,70,20);
top.setBounds(150,580,20,20);
tor.setBounds(350,580,55,20);
nuc.setBounds(150,620,20,20);
nug.setBounds(350,620,20,20);
btNovo.setBounds(350,720,30,30);
tela.add(rotulodomi);
tela.add(rotulopes1); tela.add(rotulodoc1); tela.add(rotulodat1);
tela.add(rotulopes2); tela.add(rotulodoc2); tela.add(rotulodat2);
tela.add(rotulopes3); tela.add(rotulodoc3); tela.add(rotulodat3);
tela.add(rotulopes4); tela.add(rotulodoc4); tela.add(rotulodat4);
tela.add(rotulopes5); tela.add(rotulodoc5); tela.add(rotulodat5);
tela.add(rotulopes6); tela.add(rotulodoc6); tela.add(rotulodat6);
tela.add(rotulopes7); tela.add(rotulodoc7); tela.add(rotulodat7);
tela.add(rotulopes8); tela.add(rotulodoc8); tela.add(rotulodat8);
tela.add(rotulotop);
tela.add(rotulotor);
tela.add(rotulonuc);
tela.add(rotulonug);
tela.add(domi);
tela.add(pes1); tela.add(doc1); tela.add(dat1);
tela.add(pes2); tela.add(doc2); tela.add(dat2);
tela.add(pes3); tela.add(doc3); tela.add(dat3);
tela.add(pes4); tela.add(doc4); tela.add(dat4);
tela.add(pes5); tela.add(doc5); tela.add(dat5);
tela.add(pes6); tela.add(doc6); tela.add(dat6);
tela.add(pes7); tela.add(doc7); tela.add(dat7);
tela.add(pes8); tela.add(doc8); tela.add(dat8);
tela.add(top);
tela.add(tor);
tela.add(nuc);
tela.add(nug);
tela.add(btNovo);
tela.add(btLocalizar);
tela.add(btGravar);
tela.add(btAlterar);
tela.add(btExcluir);
tela.add(btCancelar);
setSize(1000,800);
setVisible(true);
getContentPane().add(tela);
setTitle("Cadastramento de Beneficiarios");
setSize(610,120);
setResizable(false);
setBotoes(true,true,false,false,false,false);
carregaResultSet();
}
public static void main(String args[])
{
projeto app = new projeto();
app.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
}
public void actionPerformed(ActionEvent e)
{
if(e.getSource()==btNovo)
{
limpaCampos();
setBotoes(false,false,true,false,false,true);
return;
}
if(e.getSource()==btCancelar)
{
limpaCampos();
setBotoes(true,true,false,false,false,false);
return;
}
if(e.getSource()==btGravar)
gravar registro novo
{
try
{
String sql="INSERT INTO Projeto (domi,pes1,pes2,pes3,pes4,pes5,pes6,pes7,pes8," +
"doc1, dat1,doc2, dat2, doc3, dat3, doc4, dat4, doc5, dat5, doc6, dat6, doc7,"+
"dat7, doc8, dat8, top, tor, nuc, nug) Values ('" + //simples dupla
domi.getText() + "','" + //dssd
pes1.getText() + "','" + //dssd
pes2.getText() + "','" + //dssd
pes3.getText() + "','" + //dssd
pes4.getText() + "','" + //dssd
pes5.getText() + "','" + //dssd
pes6.getText() + "','" + //dssd
pes7.getText() + "','" + //dssd
pes8.getText() + "','" + //dssd
doc1.getText() + "','" + //dsds
doc2.getText() + "','" +
doc3.getText() + "','" +
doc4.getText() + "','" +
doc5.getText() + "','" +
doc6.getText() + "','" +
doc7.getText() + "','" +
doc8.getText() + "','" +
dat1.getText() + "','" +
dat2.getText() + "','" +
dat3.getText() + "','" +
dat4.getText() + "','" +
dat5.getText() + "','" +
dat6.getText() + "','" +
dat7.getText() + "','" +
dat8.getText() + "','" +
top.getText() + "','" +
tor.getText() + "','" +
nuc.getText() + "','" +
nug.getText() + "')";
statement.executeUpdate(sql);
JOptionPane.showMessageDialog(null,"Gravacao realizada com sucesso");
setBotoes(true,true,false,true,true,false);
}
catch(SQLException erro)
{
if(erro.getMessage().equals("General error"))
JOptionPane.showMessageDialog(null, "Beneficiario Cadastrado");
else
JOptionPane.showMessageDialog(null, "Nao posso gravar");
}
carregaResultSet();
}
//----------------Final da inclusao
if (e.getSource()==btAlterar)
//alterar um registro
{
try
{
String sql = "UPDATE Projeto SET " +
pes1.getText() + "','" + //dssd
pes2.getText() + "','" + //dssd
pes3.getText() + "','" + //dssd
pes4.getText() + "','" + //dssd
pes5.getText() + "','" + //dssd
pes6.getText() + "','" + //dssd
pes7.getText() + "','" + //dssd
pes8.getText() + "','" + //dssd
doc1.getText() + "','" + //dsds
doc2.getText() + "','" +
doc3.getText() + "','" +
doc4.getText() + "','" +
doc5.getText() + "','" +
doc6.getText() + "','" +
doc7.getText() + "','" +
doc8.getText() + "','" +
dat1.getText() + "','" +
dat2.getText() + "','" +
dat3.getText() + "','" +
dat4.getText() + "','" +
dat5.getText() + "','" +
dat6.getText() + "','" +
dat7.getText() + "','" +
dat8.getText() + "','" +
top.getText() + "','" +
tor.getText() + "','" +
nuc.getText() + "','" +
nug.getText() + "')";
statement.executeUpdate(sql);
"WHERE pes1 ='" + pes1.getText()+"'";
int r = statement.executeUpdate(sql);
if (r==1)
JOptionPane.showMessageDialog(null, "Alteracao realizada com sucesso");
else
JOptionPane.showMessageDialog(null, "Problemas na alteracao");
setBotoes(true,true,false,true,true,false);
}
catch(SQLException erro)
{
JOptionPane.showMessageDialog(null,"Não consigo alterar no banco");
}
carregaResultSet();
}
//-------------Final da alteracao
if (e.getSource()==btExcluir)
//Excluir um registro
{
try
{
String sql="SELECT pes1, titulo FROM Projeto Where pes1='"+ //
pes1.getText()+"'";
resultSet=statement.executeQuery(sql);
String nome="";
try
{
resultSet.next();
nome="Deletar o Beneficiario: " + resultSet.getString("Beneficiario");
}
catch(SQLException ex1)
{
JOptionPane.showMessageDialog(null, "Beneficiario nao cadastrado");
carregaResultSet();
return;
}
int n = JOptionPane.showConfirmDialog(null, nome,"",JOptionPane.YES_NO_OPTION);
if (n==JOptionPane.YES_OPTION)
{
sql="DELETE FROM Projeto Where pes1='"+pes1.getText()+"'";
int r=statement.executeUpdate(sql);
if(r==1)
JOptionPane.showMessageDialog(null,"Exclusao realizada com sucesso");
else
JOptionPane.showMessageDialog(null,"Nao foi possivel excluir o Beneficiario");
limpaCampos();
setBotoes(true,true,false,false,false,false);
}
}
catch(SQLException erro) { }
carregaResultSet();
}
//-------------Final da exclusao
if (e.getSource()==btLocalizar || e.getSource()==pes1)
{
try
{
String sql ="SELECT * FROM Filmes Where codigo ='"+ tfCodigo.getText()+"'";
resultSet=statement.executeQuery(sql);
resultSet.next();
atualizaCampos();
setBotoes(true,true,false,true, true,false);
}
catch(SQLException erro)
{
JOptionPane.showMessageDialog(null,"Beneficiario nao encontrado");
carregaResultSet();
return;
}
}
//-------------------Final da localizacao
}
public void carregaResultSet()
{
String url="jdbc:odbc:Projeto";
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection minhaConexao=DriverManager.getConnection(url);
statement=minhaConexao.createStatement(ResultSet. //
TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);;
resultSet=statement.executeQuery("SELECT * FROM Projeto");
}
catch(ClassNotFoundException erro)
{
System.out.println("Driver JDBC-ODBC nao encontrado");
}
catch(SQLException erro)
{
System.out.println("Problemas na conexao com a fonte de dados");
}
}
public static void limpaCampos()
{
domi.setText("");
pes1.setText("");
pes2.setText("");
pes3.setText("");
pes4.setText("");
pes5.setText("");
pes6.setText("");
pes7.setText("");
pes8.setText("");
doc1.setText("");
doc2.setText("");
doc3.setText("");
doc4.setText("");
doc5.setText("");
doc6.setText("");
doc7.setText("");
doc8.setText("");
dat1.setText("");
dat2.setText("");
dat3.setText("");
dat4.setText("");
dat5.setText("");
dat6.setText("");
dat7.setText("");
dat8.setText("");
top.setText("");
tor.setText("");
nuc.setText("");
nug.setText("");
}
public void atualizaCampos()
{
try
{
domi.setText(resultSet.getString("Endereco"));
pes1.setText(resultSet.getString("Pessoa 1"));
pes2.setText(resultSet.getString("Pessoa 2"));
pes3.setText(resultSet.getString("Pessoa 3"));
pes4.setText(resultSet.getString("Pessoa 4"));
pes5.setText(resultSet.getString("Pessoa 5"));
pes6.setText(resultSet.getString("Pessoa 6"));
pes7.setText(resultSet.getString("Pessoa 7"));
pes8.setText(resultSet.getString("Pessoa 8"));
doc1.setText(resultSet.getString("Documento 1"));
doc2.setText(resultSet.getString("Documento 2"));
doc3.setText(resultSet.getString("Documento 3"));
doc4.setText(resultSet.getString("Documento 4"));
doc5.setText(resultSet.getString("Documento 5"));
doc6.setText(resultSet.getString("Documento 6"));
doc7.setText(resultSet.getString("Documento 7"));
doc8.setText(resultSet.getString("Documento 8"));
dat1.setText(resultSet.getString("Data 1"));
dat2.setText(resultSet.getString("Data 2"));
dat3.setText(resultSet.getString("Data 3"));
dat4.setText(resultSet.getString("Data 4"));
dat5.setText(resultSet.getString("Data 5"));
dat6.setText(resultSet.getString("Data 6"));
dat7.setText(resultSet.getString("Data 7"));
dat8.setText(resultSet.getString("Data 8"));
top.setText(resultSet.getString("Total de Pessoas"));
tor.setText(resultSet.getString("Total Renda"));
nuc.setText(resultSet.getString("Numero de Criancas"));
nug.setText(resultSet.getString("Numero de Gestantes"));
}
catch(SQLException erro) {}
}
public void setBotoes(boolean btNovo, boolean btLocalizar, boolean btGravar, //
boolean btAlterar, boolean btExcluir, boolean btCancelar)
{
btNovo.setEnabled(btNovo);
btLocalizar.setEnabled(btLocalizar);
btGravar.setEnabled(btGravar);
btAlterar.setEnabled(btAlterar);
btExcluir.setEnabled(btExcluir);
btCancelar.setEnabled(btCancelar);
}
}
