The code below works fine when i remove this part (+"AND ref = '"+Mref.getText()+"'");)  but doesn’t work with it:

pst1=  con.prepareStatement(" SELECT  price from article where barcode = '"+Mbarcode.getText()+"'" +"AND ref = '"+Mref.getText()+"'");
ResultSet rs1 ;
rs1= pst1.executeQuery(); ```

thisis the table named article in my database

barcode | name  |qty    |price  |vendor |ref    | maxremise 
READ MORE:  Massage Services: Everything You Need To Know

related posts:

November 3, 2022

October 12, 2022

October 6, 2022

October 6, 2022

Leave a Reply

Your email address will not be published. Required fields are marked *

{"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}