我如何从orderserviceimpl.java类中的用户表获取电子邮件数据

Question

如何从orderserviceimpl.java类中的用户表获取emailID，以便可以发送 在调用senttextextemail（字符串电子邮件）时作为字符串 OrderServiceImpl.java类？

user.java class

@Setter
@Getter
@EqualsAndHashCode
@ToString
@NoArgsConstructor
//@AllArgsConstructor
@Entity
@Table(name = "`user`", uniqueConstraints = {@UniqueConstraint(columnNames = "email")})
public class User {

  public User(String email, String name, String password, String address) {
      this.email = email;
      this.name = name;
      this.password = password;
      this.address = address;
  }

  @Id
  @Column(name = "userId")
  @GeneratedValue(strategy = GenerationType.AUTO)
  private Long id;
  
  @Size(max = 50)
  @Email
  private String email;
  @Size(max = 50)
  @NotBlank
  private String name;
  @Size(max = 100)
  @NotBlank
  private String password;
  @Size(max = 50)
  @NotBlank
  private String address;
  
  @ManyToMany(fetch = FetchType.LAZY)
  @JoinTable(name = "cart", joinColumns = @JoinColumn(name = "userId"),
  inverseJoinColumns = @JoinColumn(name  = "foodId"))
  private List<Food> cart = new ArrayList<Food>();
  
  @ManyToMany(fetch = FetchType.LAZY)
  @JoinTable(name = "user_roles", joinColumns = @JoinColumn(name = "userId"),
  inverseJoinColumns = @JoinColumn(name  = "roleId"))
  private Set<Role> roles = new HashSet<Role>();

}

order.java class

@Setter
@Getter
@EqualsAndHashCode
@ToString
@NoArgsConstructor
//@AllArgsConstructor
@Entity
@Table(name = "orders", uniqueConstraints = {@UniqueConstraint(columnNames = "orderTransaction")})
public class Order {
    
    @Id
    @Column(name = "orderId")
    @GeneratedValue(strategy = GenerationType.AUTO)
    private Long id;
    
    @Size(max = 50)
    @NotBlank
    private String orderTime;
    
    @Size(max = 50)
    @NotBlank
    private String orderTransaction;
    
    @OneToMany(fetch = FetchType.LAZY)
    @JoinTable(name = "users_orders", joinColumns = @JoinColumn(name = "orderId"),
    inverseJoinColumns = @JoinColumn(name  = "userId"))
    private List<Order> orders = new ArrayList<Order>();

}

emailserviceimpl.java class

@Service
public class EmailServiceImpl implements EmailService {

    private static final Logger logger = LoggerFactory
            .getLogger(EmailServiceImpl.class);
    @Autowired
    private JavaMailSender javaMailSender;

    @Override
    //Sending User Object
    public void sendTextEmail(String email) {
        logger.info("Simple Email sending start");

        SimpleMailMessage simpleMessage = new SimpleMailMessage();
        simpleMessage.setTo(email); //Enter customer email 
        simpleMessage.setSubject("Spring Boot=> Sending simple email");
        simpleMessage.setText("Dear hunger buddy customer Hope you are doing well.");
        javaMailSender.send(simpleMessage);

        logger.info("Simple Email sent");

    }
}

orderserviceimpl.java类

@Service
public class OrderServiceImpl implements OrderService{

    private static final String String = null;
    @Autowired
    private EmailService emailService;
    @Autowired
    private OrderRepo orderRepo;
    
    /*@Autowired 
    private User register;*/
    
    @Override
    public Order addOrder(Order order) throws AlreadyExistsException {
        if(orderRepo.existsById(order.getId())) {
            throw new AlreadyExistsException("This record already exists");
        }
        else
        {
        
            //long temp=order.getId();
            //Optional<User> optional = userRepo.findById(temp);
            String email = null;
            emailService.sendTextEmail(email);
            
            return orderRepo.save(order);
            
        }
    }
    
    @Override
    public Optional<List<Order>> getAllOrder() {
        return Optional.ofNullable(orderRepo.findAll());
    }

    @Override
    public Optional<Order> getOrderById(Long id) throws IdNotFoundException {
        Optional<Order> optional = orderRepo.findById(id);
        if (!optional.isPresent()) {
            throw new IdNotFoundException("Sorry Order Not Found");
        }
        return optional;
    }
}

我删除了所有导入语句，以节省读者的时间。

谢谢

Answer 1

我认为您在order实体定义中有一个合乎逻辑的问题。 订单不包含其他订单列表。但是它应该包含下订单的用户。因此，该定义应如下纠正：

@Setter
@Getter
@EqualsAndHashCode
@ToString
@NoArgsConstructor
@Entity
@Table(name = "orders", uniqueConstraints = {@UniqueConstraint(columnNames = "orderTransaction")})
public class Order {
    @Id
    @Column(name = "orderId")
    @GeneratedValue(strategy = GenerationType.AUTO)
    private Long id;
    
    @Size(max = 50)
    @NotBlank
    private String orderTime;
    
    @Size(max = 50)
    @NotBlank
    private String orderTransaction;
    
    @OneToOne(fetch = FetchType.LAZY)
    @JoinTable(name = "users_orders", joinColumns = @JoinColumn(name = "orderId"),
    inverseJoinColumns = @JoinColumn(name  = "userId"))
    private User user;
}

然后在orderserviceimpl中，您可以使用以下方式访问用户信息：

User user = order.getUser();
String emailId = user.getEmail();