netbeans - Parameticindex 超出范围，因此我的数据库中有 7 个参数，如果我尝试更新数据，则会出现此错误

Question

私人无效jButton1ActionPerformed（java.awt.event.ActionEvent evt）{
尝试{

        Class.forName("com.mysql.jdbc.Driver");
        
         con =  DriverManager.getConnection("jdbc:mysql://localhost:3306/kilanuser","root","");
        String sql = "UPDATE customers SET Name=?,Date=?,Product=?,'Total Price=?,PhoneNumber=?,Address=?' WHERE Serial=?";
        
         pst = con.prepareStatement(sql);
         
         pst.setString(7,serialfield.getText());
        pst.setString(1,namefield.getText());
         pst.setString(2,date);
          pst.setString(3,bricksq.getSelectedItem().toString());
           pst.setString(4,totalprice.getText());
            pst.setString(5,numfield.getText());
             pst.setString(6,addressfield.getText());
             pst.executeUpdate();
            
             
             JOptionPane.showMessageDialog(null,"Bill Updated");
             
          
        
        
        
    } 
    catch(Exception e){
        JOptionPane.showMessageDialog(null,e);
        
    }
    
}                                 

我已附上服务器图像以及错误图像

标签： netbeans