"No value specified for parameter 1" when executing PreparedStatement

Question

"No value specified for parameter 1" when executing PreparedStatement

Navigation

#1 by (4 votes)
#2 by (2 votes)

2

I am testing insert here and the following error appears to me:

Exception in thread "main" java.sql.SQLException: No value specified for parameter 1

Dao

package modelo;

    import java.sql.Connection;
    import java.sql.PreparedStatement;
    import java.sql.SQLException;
    import java.util.Calendar;

    public class PessoaDao {
        public void insere(PessoaBean pessoa) throws SQLException{  

            // conectando
            Connection con = new ConexaoMysql().getConexao();

            // cria um preparedStatement
            String sql = "insert into exemplo" +
                    " (nome,numero,dataExemplo)" +
                    " values (?,?,?)";
            PreparedStatement stmt = con.prepareStatement(sql);

            // executa
            stmt.execute();
            stmt.close();

            System.out.println("Gravado!");

            con.close();
        }
    }

Bean

package modelo;

import java.util.Calendar;

public class PessoaBean {
    private int Idexemplo;
    private String nome;
    private float numero; 
    private Calendar dataExemplo;

    public int getIdexemplo() {
        return Idexemplo;
    }
    public void setIdexemplo(int idexemplo) {
        Idexemplo = idexemplo;
    }
    public String getNome() {
        return nome;
    }
    public void setNome(String nome) {
        this.nome = nome;
    }
    public float getNumero() {
        return numero;
    }
    public void setNumero(float numero) {
        this.numero = numero;
    }
    public Calendar getDataExemplo() {
        return dataExemplo;
    }
    public void setDataExemplo(Calendar dataExemplo) {
        this.dataExemplo = dataExemplo;
    }
}

Main

package modelo;



import java.sql.Connection;
import java.sql.SQLException;
import java.util.Calendar;


public class Teste {
    public static void main(String[] args) throws SQLException {
        Connection c = new ConexaoMysql().getConexao();
        System.out.println("Conexão aberta!");
        c.close();

         PessoaBean p = new PessoaBean();  

         PessoaDao dao = new PessoaDao();  

          p.setNome("José da Silva");  
          p.setNumero(1232); 
          p.setDataExemplo(Calendar.getInstance());  


          dao.insere(p);  


    }
}

java jdbc

asked by anonymous 07.07.2015 / 00:08

2 answers

2

You need to enter the values in the insert, use the prepared statement's set method.

String sql = "insert into exemplo (nome,numero,dataExemplo) values (?,?,?)";
PreparedStatement stmt = con.prepareStatement(sql);

stmt.setString(1,  'valor1');
stmt.setString(2,  'valor2');
stmt.setString(3,  'valor3');

07.07.2015 / 00:12

PHP logic error in construct if elseif else addClass () is adding class to a href="" instead of img src=""

score 4 · Accepted Answer

In this method:

public class PessoaDao {
    public void insere(PessoaBean pessoa) throws SQLException{  

        // conectando
        Connection con = new ConexaoMysql().getConexao();

        // cria um preparedStatement
        String sql = "insert into exemplo" +
                " (nome,numero,dataExemplo)" +
                " values (?,?,?)";
        PreparedStatement stmt = con.prepareStatement(sql);

        // executa
        stmt.execute();
        stmt.close();

        System.out.println("Gravado!");

        con.close();
    }
}

You forgot to put this in:

stmt.setString(1, pessoa.getNome());
stmt.setFloat(2, pessoa.getNumero());
stmt.setTimestamp(3, new Timestamp(pessoa.getDataExemplo().getTimeInMillis()));

You have to put this before stmt.execute(); .

In addition, it's a good practice to use try-with-resources to avoid that in the case of SQLException , you have resources open. This way, your method looks like this:

public class PessoaDao {
    public void insere(PessoaBean pessoa) throws SQLException {

        // cria um preparedStatement
        String sql = "insert into exemplo" +
                " (nome,numero,dataExemplo)" +
                " values (?,?,?)";

        // conectando
        try (Connection con = new ConexaoMysql().getConexao();
             PreparedStatement stmt = con.prepareStatement(sql))
        {

            stmt.setString(1, pessoa.getNome());
            stmt.setFloat(2, pessoa.getNumero());
            stmt.setTimestamp(3, new Timestamp(pessoa.getDataExemplo().getTimeInMillis()));

            // executa
            stmt.execute();
        }

        System.out.println("Gravado!");
    }
}