首页 > 解决方案 > 在 Java 中形成邮件正文

问题描述

目前正在从事一个项目,我的DataRetrival课程将在 java Mail API 主体中设置。

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.List;
//import com.mysql.jdbc.Statement;
public class DataRetrival {

    public List<Employee> javaData() {
        DatabaseConnect dc = new DatabaseConnect();
        Connection con;

        List<Employee> employees = new ArrayList<>();
        try {
            con = dc.connect();
            String query ="SELECT * FROM employee";
            Statement st = con.createStatement();
            ResultSet rs = st.executeQuery(query);

               while (rs.next())
                  {

                  Employee emp = new Employee();
                   emp.setID(rs.getInt("ID"));
                   emp.setEmployee_Number(rs.getString("Employee_Number"));
                   emp.setFirstName(rs.getString("FirstName"));
                   emp.setLastName(rs.getString("LastName"));
                   emp.setEmailAddress(rs.getString("EmailAddress"));
                   emp.setPdfName(rs.getString("PdfName"));
                   emp.setEmailAddress(rs.getString("Sup_EmailAddress")); 
                   employees.add(emp);


                   String employeeNumber = rs.getString("Employee_Number");
                   System.out.println(employeeNumber);

                  }

        } catch (Exception e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
        return employees;
    }

像这样创建新实例。

DataRetrival dtr = new DataRetrival();

从这个新实例或任何其他方法中,我想用代码段中提到的上述字段EmailAddress填充包含另一个名为JavaMail的类的InterenetAddress.parse字段的字段;

message.setRecipients(Message.RecipientType.TO,
                    InternetAddress.parse(Want get called Email_Adress));

标签: javajakarta-mail

解决方案


来自评论

我想调用 javaData() 并将 getEmailAddress 获取到另一个类

致电javaData()

DataRetrival dtr = new DataRetrival();
List<Employee> employees = dtr.javaData();

得到getEmailAddress

for (Employee employee : employees) {
    String emailAddress = employee.getEmailAddress();
    // use value here
}

上述两种构造都是核心 Java 特性,所以我建议您(重新)阅读您的 Java 指南,了解如何进行方法调用如何迭代列表


推荐阅读