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();
}
}