public void findVendor() {

        String vatEntered = vendorID.getText();


        try
        {
         String myDriver = "com.mysql.jdbc.Driver";
         String myUrl = "jdbc:mysql://localhost:3306/masterdata_db?autoReconnect=true&useSSL=false";
         Class.forName(myDriver);
         Connection conn = DriverManager.getConnection(myUrl, "root", "");

         Statement st = conn.createStatement();


         String check = "SELECT * FROM vendorcreation WHERE VAT = 'vatEntered' ";
         ResultSet resultSet = st.executeQuery(check);

         boolean status = true;
         if(resultSet.next()==status){

             nameSelected.setText(resultSet.getString(1));
             adressSelected.setText(resultSet.getString(2));
             countrySelected.setText(resultSet.getString(3));
             vatSelected.setText(resultSet.getString(4));
             ptermsSelected.setText(resultSet.getString(5));

             conn.close();

         }

         else {

             JOptionPane.showMessageDialog(null, "NO DATA FOUND! FIRST YOU MUST CREATE IT", "Inane error",JOptionPane.ERROR_MESSAGE);
             dispose();
             new CreateVendor().setVisible(true);
             }


        }
        catch (Exception e)
        {
            e.printStackTrace();
        }


    }