Member Avatar for altjen

Im having ap roblem with this.
1.JPG

after I press Save button that image show up

it doesnt execute this code

   String te1 = tf1.getText();
        String te2 = TA3.getText();
        String te3 = TA2.getText();
        String te4 = TA1.getText();
        String te5 = tf2.getText();
        String te6 = TL1.getText();
         String sql = "UPDATE DataImput SET SubjectName='"+te1+"' ,VATnumber='"+te3+"' ,Service='"+te5+"' ,Price='"+te2+"' ,TotalAmount='"+te4+"' WHERE InvoiceNumber='"+te6+"'";

           pst=conn.prepareStatement(sql);
     JOptionPane.showMessageDialog(null, "Data Updated");


              pst.execute();
        }catch(Exception e){        
            JOptionPane.showMessageDialog(null, e);            
        }finally{
    try{
       rs.close();
       pst.close();                
    }
        catch(Exception e){        
        }                
    }

how can I deal with this problem? please it is important

  • 1 Contributor
  • 1 Reply
  • 253 Views
  • 5 Minutes Discussion Span
  • Latest Post Latest Post by altjen
Member Avatar for altjen

Problem solved! had to import this when form load

   conn=Javaconnection.ConnectDb();
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.