Erro - Campo Sexo

0 respostas
L

Quando eu compilo essa tela , ela esta apresentando o erro no campo "Sexo" ,

[Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near 'Masculino'.

No banco de dados ta inserindo normalmente

Segue o codigo abaixo :

import java.awt.*;

import java.awt.event.*;
import javax.swing.*;
import java.sql.*;
import java.util.*;

public class medico extends JFrame {


  private JLabel JLtitulo = new JLabel("Cadastro Médico");
  private JLabel JLID = new JLabel("ID Médico");
  private JLabel Jlnome = new JLabel("Nome Médico");
  private JLabel Jlnas = new JLabel("Data Nascimento");
  private JLabel Jlend = new JLabel("Endereço");
  private JLabel jlsexo = new JLabel("Sexo");
  private JLabel Jlcpf = new JLabel("CPF");
  private JLabel Jlrg = new JLabel("RG");
  private JLabel Jltel = new JLabel("Telefone Cel.");
  private JLabel Jlres = new JLabel("Telefone Res.");
  private JLabel Jlreg = new JLabel("Registro Médico");
  private JTextField JTid = new JTextField("");
  private JTextField JTnome = new JTextField("");
  private JTextField JTnas = new JTextField("");
  private JTextField JTrua = new JTextField("");  
  private JTextField JTsexo = new JTextField("");
  private JTextField JTcpf = new JTextField("");
  private JTextField JTrg = new JTextField("");
  private JTextField JTcel = new JTextField("");
  private JTextField JTres = new JTextField("");
  private JTextField JTreg = new JTextField("");
  private JLabel Jlesp = new JLabel("Especialidade");
  private JTextField JTesp = new JTextField("");
  private JButton JBadd = new JButton("Cadastrar");
 // private JButton JBalt = new JButton("Alterar");
  private JButton JBexit = new JButton("Sair");


  public medico() {
    try {
      mostra();
    } catch(Exception ex) {
      ex.printStackTrace();
    }
  }

  public void mostra() throws Exception {

    this.getContentPane().setLayout(null);
    this.setSize(639, 487);
    this.setTitle("Cadastro Médico");
    this.setResizable(false);
    this.setVisible(true);

    JLtitulo.setBounds(new Rectangle(268, 8, 120, 13));
    this.getContentPane().add(JLtitulo, null);
    JLID.setBounds(new Rectangle(12, 76, 110, 13));
    this.getContentPane().add(JLID, null);
    Jlnome.setBounds(new Rectangle(12, 108, 110, 13));
    this.getContentPane().add(Jlnome, null);
    Jlnas.setBounds(new Rectangle(12, 138, 110, 13));
    this.getContentPane().add(Jlnas, null);
    Jlend.setBounds(new Rectangle(12, 168, 110, 13));
    this.getContentPane().add(Jlend, null);
    
  
    jlsexo.setBounds(new Rectangle(12, 195, 110, 13));
    this.getContentPane().add(jlsexo, null);
    Jlcpf.setBounds(new Rectangle(12, 228, 110, 13));
    this.getContentPane().add(Jlcpf, null);
    Jlrg.setBounds(new Rectangle(12, 259, 110, 13));
    this.getContentPane().add(Jlrg, null);
    Jltel.setBounds(new Rectangle(12, 291, 110, 13));
    this.getContentPane().add(Jltel, null);
    Jlres.setBounds(new Rectangle(12, 322, 110, 13));
    this.getContentPane().add(Jlres, null);
    Jlreg.setBounds(new Rectangle(12, 350, 110, 13));
    this.getContentPane().add(Jlreg, null);
    JTid.setBounds(new Rectangle(155, 74, 100, 21));
    this.getContentPane().add(JTid, null);
    JTnome.setBounds(new Rectangle(155, 105, 300, 21));
    this.getContentPane().add(JTnome, null);
    JTnas.setBounds(new Rectangle(155, 134, 100, 21));
    this.getContentPane().add(JTnas, null);
    JTrua.setBounds(new Rectangle(155, 164, 130, 21));
    this.getContentPane().add(JTrua, null);
    

    JTsexo.setBounds(new Rectangle(155, 194, 100, 21));
    this.getContentPane().add(JTsexo, null);
    JTcpf.setBounds(new Rectangle(155, 224, 100, 21));
    this.getContentPane().add(JTcpf, null);
    JTrg.setBounds(new Rectangle(155, 254, 100, 21));
    this.getContentPane().add(JTrg, null);
    JTcel.setBounds(new Rectangle(155, 284, 100, 21));
    this.getContentPane().add(JTcel, null);
    JTres.setBounds(new Rectangle(155, 315, 100, 21));
    this.getContentPane().add(JTres, null);
    JTreg.setBounds(new Rectangle(155, 345, 100, 21));
    this.getContentPane().add(JTreg, null);
    Jlesp.setBounds(new Rectangle(12, 379, 110, 13));
    this.getContentPane().add(Jlesp, null);
    JTesp.setBounds(new Rectangle(155, 375, 400, 21));
    this.getContentPane().add(JTesp, null);
    
    JBadd.setBounds(new Rectangle(150, 410, 100, 30));
    this.getContentPane().add(JBadd, null);
    JBadd.addActionListener (new ActionListener() {
      public void actionPerformed(ActionEvent e) {
        try
          {   
                String drv = "sun.jdbc.odbc.JdbcOdbcDriver";
                String url = "jdbc:odbc:Luiz";
          
                Connection con;
                Class.forName(drv);
                con = DriverManager.getConnection(url,"Luiz","");
                
                Statement SQL_Comando;
                SQL_Comando = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY);  
                
                if(JTid.getText().equals("") || JTnome.getText().equals("") || JTnas.getText().equals("") || JTrua.getText().equals("") || 
                 JTsexo.getText().equals("") || JTcpf.getText().equals("") || JTrg.getText().equals("") || 
                JTcel.getText().equals("") || JTres.getText().equals("") || JTreg.getText().equals("") || JTesp.getText().equals(""))
               
               {
                         JOptionPane.showMessageDialog(null,"Preencher campos");
               }
               else
               {
                   
//                   JTid JTnome JTnas JTrua JTcidade  JTsexo JTcpf JTrg JTcel JTres JTreg  JTesp
    
                    int id = Integer.parseInt(JTid.getText());  
                    String nome = JTnome.getText();
                    String nasc = JTnas.getText();
                    String rua = JTrua.getText();
                    String sexo = JTsexo.getText();
                    String esp = JTesp.getText();
                    int cpf = Integer.parseInt(JTcpf.getText());
                    int rg = Integer.parseInt(JTrg.getText());
                    int cel = Integer.parseInt(JTcel.getText());
                    int res = Integer.parseInt(JTres.getText());
                    int reg = Integer.parseInt(JTreg.getText());
                    
                    
                    String sql = "insert into Medico (ID_Medico, Nome_Medico, Nasc, Endereco, Sexo, CPF, RG_Medico, Tel_Cel, Tel_Res, Reg_Medico, Espec) values (";
                    sql = sql+"'"+JTid.getText()+"','"+JTnome.getText();
                    sql = sql+"', '"+JTnas.getText()+"', '"+JTrua.getText()+"', ', '"+JTsexo.getText()+"', '"+JTcpf.getText();
                    sql = sql+"', '"+JTrg.getText()+"', '"+JTcel.getText()+"', '"+JTres.getText()+"', '"+JTreg.getText()+"','"+JTesp.getText()+"')";
                    
                    int rows = SQL_Comando.executeUpdate(sql);
                    JOptionPane.showMessageDialog(null,"Registro incluido com sucesso!:"+rows);                
               } 
              con.close();        
            }    
            catch(ClassNotFoundException er1)
            {
                 System.out.println(er1.getMessage());
            }    
            catch(SQLException er2)
            {
                 System.out.println(er2.getMessage());
            }
        
    }});
 
    JBexit.setBounds(new Rectangle(300, 410, 100, 30));
    this.getContentPane().add(JBexit, null); 
    JBexit.addActionListener (new ActionListener() {
      public void actionPerformed(ActionEvent e) {
        dispose();
    }});
    this.addWindowListener(new WindowAdapter() {
    public void windowClosing(WindowEvent e) {
         aoFechar(e);
      }});
  }

  private void aoFechar(WindowEvent e) {
    System.exit(0);
  }

  public static void main(String args[]) {
    medico janela = new medico();
   
  }
}
Criado 16 de novembro de 2009
Respostas 0
Participantes 1