Erro de syntax sql java

Programação
#1

To tendo um problema pra adicionar uns campos no banco de dados mysql sempre que executo a função de adicionar o produto ele retorna um erro, porém ja revisei tudo e nao tem erro de escrita

erro que retorna:
java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘system,memoria,tecm,velocidadem,maxm,processador,modelop,nucleosp,velocidadep,pl’ at line 1

Codigo de cadastro:

public void adicionar() {

    String sql = "insert into notebooks(descricao,categoria,codebar,serial,marca,modelo,ref,cor,system,memoria,tecm,velocidadem,maxm,processador,modelop,nucleosp,velocidadep,placavideo,modelopg,tipopg,memoriapg,armazena,slotum,slotdois,resotela,taxatela,tamanhotela,bateria,duracaob,carregador,leitor,blue,teclado,garantia,usbdois,usbtres,entradas,precoc,precom,precov,qtde,undm,qtdemb,local,status,fornecedor,obs,datac,log) values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)"; //49

try {
            String user = TelaPrincipal.lblUsuario.getText();
            Date data = new Date();
            DateFormat formatador = DateFormat.getDateInstance(DateFormat.LONG);
            String date = formatador.format(data);
            String log = user + "==" + date;

            pst = conexao.prepareStatement(sql);

            pst.setString(1, nDescricao.getText());
            pst.setString(2, nCategoria.getSelectedItem().toString());
            pst.setString(3, nCodBar.getText());
            pst.setString(4, serieNote.getText());
            pst.setString(5, nMarca.getSelectedItem().toString());
            pst.setString(6, nModelo.getSelectedItem().toString());
            pst.setString(7, nREF.getText());
            pst.setString(8, nCor.getText());
            pst.setString(9, nSystem.getText());
            pst.setString(10, nMemoria.getSelectedItem().toString());
            pst.setString(11, nTecM.getSelectedItem().toString());
            pst.setString(12, nVeloM.getSelectedItem().toString());
            pst.setString(13, capmemoriaNote.getSelectedItem().toString());
            pst.setString(14, nProcess.getSelectedItem().toString());
            pst.setString(15, nModelProcess.getText());
            pst.setString(16, nNucleosP.getText());
            pst.setString(17, nVelocidadep.getText());
            pst.setString(18, cbPlacaVideo.getSelectedItem().toString());
            pst.setString(19, txModeloVideo.getText());
            pst.setString(20, cbTipoRamVideo.getSelectedItem().toString());
            pst.setString(21, cbRamVideo.getSelectedItem().toString());
            pst.setString(22, cbArmazena.getSelectedItem().toString());
            pst.setString(23, cbCapArmazena.getSelectedItem().toString());
            pst.setString(24, cbCapArmazena1.getSelectedItem().toString());
            pst.setString(25, cbReso.getSelectedItem().toString());
            pst.setString(26, cbTaxa.getSelectedItem().toString());
            pst.setString(27, cbTamanho.getSelectedItem().toString());
            pst.setString(28, cbBateria.getSelectedItem().toString());
            pst.setString(29, txDurab.getText());
            pst.setString(30, cbCarregador.getSelectedItem().toString());
            pst.setString(31, cbLeitor.getSelectedItem().toString());
            pst.setString(32, cbBlue.getSelectedItem().toString());
            pst.setString(33, cbTeclado.getSelectedItem().toString());
            pst.setString(34, cbGarantia.getSelectedItem().toString());
            pst.setInt(35, (int) spUsb2.getValue());
            pst.setInt(36, (int) spUsb3.getValue());
            pst.setString(37, nEntradas.getText());
            pst.setString(38, txtPrecoCusto.getText());
            pst.setString(39, txtPrecoMin.getText());
            pst.setString(40, txtPrecoVenda.getText());
            pst.setInt(41, (int) spQtde.getValue());
            pst.setString(42, nMedida.getSelectedItem().toString());
            pst.setInt(43, (int) spQtdEmb.getValue());
            pst.setString(44, nLocal.getSelectedItem().toString());
            pst.setString(45, nStatus.getSelectedItem().toString());
            pst.setString(46, nForne.getSelectedItem().toString());
            pst.setString(47, nObs.getText());
            pst.setString(48, txtDataC.getText());
            pst.setString(49, log);

            if ((nDescricao.getText().isEmpty())) {
                JOptionPane.showMessageDialog(null, "Preencha todos os campos obrigatórios!!");

            } else {
                int adicionado = pst.executeUpdate();
                if (adicionado > 0) {
                    ImageIcon icon = new ImageIcon(Toolkit.getDefaultToolkit().getImage(getClass().getResource("/src/checklist.png")));
                    JOptionPane.showMessageDialog(null, "Notebook adicionado com sucesso!", "MENSAGEM", JOptionPane.INFORMATION_MESSAGE, icon);
                    //TextBairro.setText(null);
                    btCad.setEnabled(true);
                }

            }
        } catch (Exception e) {
            JOptionPane.showMessageDialog(null, e, "ERRO", JOptionPane.ERROR_MESSAGE);
            System.out.println(e);
        }
    }

alguém sabe onde ta o erro?

#2

Você tem as colunas ref, local e log.
Isso não são palavras reservadas do SQL?

#3

Conseguir resolver cara, valeu, era realmente isso, só que o erro tava nas palavras System e serial, que também são reservadas do mysqll!!!

1 curtida