I am trying to insert data into specific columns (5th and 6th) of a table. My
PreparedStatement code is as follows:
PreparedStatement pst1 = connection.prepareStatement("insert into CustomerPayment (End_Time,Paid) values (?,?) where PC_Used ='"+cmbpcname.getSelectedItem().toString()+"'"); pst1.setString(5,lblendtime.getText()); pst1.setString(6,lblamount.getText().substring(3,5)); pst1.execute();
Is this query right? I am getting error running that query. Any suggestion would be of great help.