public void insertSupplierData(supplier tempSupplier) throws SQLException{  
        
            try {
                databaseConnector = myConnector.getConnection();
                 
                SQLQuery = "INSERT INTO familydoctor.supplier "+"VALUES(?,?,?,?,?)";
                PreparedStatement preparedStatement = databaseConnector.prepareStatement(SQLQuery);
            
                preparedStatement.setString(1, tempSupplier.getName());
                preparedStatement.setString(2, tempSupplier.getContactDetails());
                preparedStatement.setInt(3, tempSupplier.getPhnNo());
                preparedStatement.setString(4, tempSupplier.getMail());
                preparedStatement.setFloat(5,0);
                preparedStatement.executeUpdate(); 
            
            } 
            catch (SQLException e) {
                System.out.println(e.getMessage());
            } 
          
            finally {
                if (stmnt != null) {
                    stmnt.close();
                }
                if (databaseConnector != null) {
                    databaseConnector.close();
                }
            }
    }