java.sql.SQLException :no value specified for parameter 6

Question

when press update button it shows:

"java.sql.SQLException:parameter out of range(1>number of parameters,which is 0)".

 private void updateActionPerformed(java.awt.event.ActionEvent evt) {                                               
        try{
        Class.forName("com.mysql.jdbc.Driver");
        Connection conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/smakdb","root","kisal400");    
        String sql="Update itemk set name=?,type=?, buying price=?, selling price=?,description=? where itemid=?";
        pst=conn.prepareStatement(sql);

        pst.setString(1, name2.getText());
            String value=type2.getSelectedItem().toString();
                pst.setString(2,value);
        pst.setDouble(3,Double.parseDouble(buying2.getText()));
        pst.setDouble(4,Double.parseDouble(selling2.getText()));
        pst.setString(5,descript2.getText());

        pst.executeUpdate();
        JOptionPane.showMessageDialog(null, "updated!!!");
        conn.close();

        }catch(Exception e){

             JOptionPane.showMessageDialog(null, e);
        }

Your SQL appears to contain column names with spaces in them (e.g. buying price.) Even if this is allowable it's hardly recommended practice. You would probably have to have put quotes around those column names in the SQL... — RBH, Aug 26 '19 at 18:44
`no value specified for parameter 6` - The message is clear, you need to specify the 6th parameter `itemid` — Arnaud Claudel, Aug 26 '19 at 22:17
Possible duplicate of [java.sql.SQLException: No value specified for parameter 2](https://stackoverflow.com/questions/26993563/java-sql-sqlexception-no-value-specified-for-parameter-2) — Markus Deibel, Aug 27 '19 at 04:15

score 0 · Accepted Answer · answered Aug 26 '19 at 18:27

0

You have 6 question mark in the query, why not set the 6th parameter value?

You need set itemid as well.

answered Aug 26 '19 at 18:27

Qingfei Yuan

1,196
1
8
12

edited.now it shows" java.sql.SQLSyntaxErrorException.you have an error in your sql syntax." – kisal riff Aug 26 '19 at 18:42
Of course, it is wrong. `Update itemk set name=?,type=?, buying price=?, selling price=?,description=? where itemid=?` You are trying to say `buying_price` and `selling_price` right? – Qingfei Yuan Aug 26 '19 at 18:49
@kisalriff don't forget choose mine as answer:) – Qingfei Yuan Aug 26 '19 at 19:05

score 0 · Answer 2 · answered Aug 26 '19 at 18:30

0

In String sql you have six parameters "?" and once set five parameters.

answered Aug 26 '19 at 18:30

Luno S

46
3

edited.now it shows" java.sql.SQLSyntaxErrorException.you have an error in your sql syntax." – kisal riff Aug 26 '19 at 18:41

java.sql.SQLException :no value specified for parameter 6

2 Answers2