how to send multiple data in a table in a mail application?

[Rd Dari]

Hi all,

I am sending mail using java and in this data is showing which i am sending in a table but this data not send dynamically only a single data in the mail table.

Please tell me how it is possible

code is here:

/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
/*
 * To change this template, choose Tools | Templates
 * and open the template in the editor.
 */
package src;
import java.util.Date;
import java.util.ArrayList;
import java.util.Properties;
import javax.activation.DataHandler;
import javax.activation.FileDataSource;
import javax.mail.Message;
import javax.mail.MessagingException;
import javax.mail.Multipart;
import javax.mail.Session;
import javax.mail.Transport;
import javax.mail.internet.InternetAddress;
import javax.mail.internet.MimeBodyPart;
import javax.mail.internet.MimeMessage;
import javax.mail.internet.MimeMultipart;
import java.io.*;
import java.sql.*;
import java.io.File;
import java.io.IOException;
import javax.net.ssl.SSLSocket.*;
import java.sql.Connection;
import java.util.Iterator;
import javax.activation.DataSource;
import javax.servlet.*;
import javax.servlet.http.*;
import org.omg.CORBA.Request;

public class MailSending extends Object
{
    JdbcHelper1 jdbc=new JdbcHelper1();
    Connection con=null;
    Statement stmt=null;
    Statement stmt1=null;
    Statement stmt2=null;
    ResultSet rs=null;
    ResultSet rs1=null;
    ResultSet rs2=null;
    
    String sql;
    String sql1;
    String sql2;
    String society_name=null;
    String resi_name=null;
    String flat_no=null;
    String tower_no=null;
    String contact=null;
    String email_id=null;
    String cat=null;
    String subcat=null;
    String quan=null;
    String unit=null;
    String rate=null;
    String total=null;
    ArrayList ar=new ArrayList();
   // String user=null;
    //String cate=null;

        public String  MailToVendor(String vendor_name,String email,String user,String cate) throws FileNotFoundException
        {
       // HttpServletRequest request = null;
      // HttpSession ss =request.getSession(true);
       // String user=(String)ss.getAttribute("user");
       // String cate=(String)ss.getAttribute("cate");
        
        //System.out.println("Username in the vendor mailing servlet..... " + user);
        //System.out.println("Category in the vendor mailing servlet..... " + cate);
        PreparedStatement pst = null;
        String status = null;
        Exception ex = null;
        String url=null;
        String username = "[e-mail]";
        String from = "[e-mail]";
        String host = "smtp.gmail.com";

        String subject = "ORDER FOR ONLINE BOOKING ORDERS";
        String pass = "reshma123456";
        String port = "465";
        File attachment = null;
        
       // System.out.println("Username in the vendor mailing servlet..... " + user);
        try {
            //String user=request.("username");
         con=jdbc.getConnection();
         
        /*stmt2=con.createStatement();
         sql2="select username,category from history_grocery";
         rs2=stmt2.executeQuery(sql2);
         System.out.println("Grocery History query is " + sql2);
         while(rs2.next())
             {
                user=rs2.getString(1);
                cate=rs2.getString(2);
             }*/
         System.out.println("*** user**** "+user+"\n"+"&&& category&&&&&&& " + cate);
         stmt=con.createStatement();
         sql="select society_name,name_of_owner,appartment_no,tower_no,mobileno_ofmainperson,emailid_ofmainperson from appartment where emailid_ofmainperson='"+user+"'";
         rs=stmt.executeQuery(sql);
         System.out.println("Appartment query is " + sql);
         while(rs.next())
             {
                society_name=rs.getString(1);
                resi_name=rs.getString(2);
                flat_no=rs.getString(3);
                tower_no=rs.getString(4);
                contact=rs.getString(5);
                email_id=rs.getString(6);
             }
        /* ArrayList arr=null;
         if(ar!=null)
         {
             Iterator it=ar.iterator();
             while(it.hasNext())
             {
                 arr=(ArrayList)it.next();
                 System.out.println("ARRAYLIST IN MAILING...... "+arr);
                 
             }
         }*/
             
             
         
             
            url="http://localhost:8084/FacilitySupervisor/show_uploadedimg_details.jsp";
            // create some properties and get the default Session
            Properties props = new Properties();
            props.put("mail.smtp.user", username);
            props.put("mail.smtp.host", host);
            if (!"".equals(port)) 
            {
                props.put("mail.smtp.port", port);
            }
            
            if (!"".equals("true")) 
            {
                props.put("mail.smtp.starttls.enable", "true");
            }
            
             props.put("mail.smtp.auth", "true");
             
            if (true) 
            {
                props.put("mail.smtp.debug", "true");
            }
            else
            {
                props.put("mail.smtp.debug", "false");
            }
            
            if (!"".equals(port)) 
            {
                props.put("mail.smtp.socketFactory.port", port);
            }
            
            if (!"".equals("javax.net.ssl.SSLSocketFactory")) 
            {
                props.put("mail.smtp.socketFactory.class", "javax.net.ssl.SSLSocketFactory");
            }
            
            if (!"".equals("false")) {
                props.put("mail.smtp.socketFactory.fallback", "false");
            }
            // Authenticator auth = new SMTPAuthenticator();
            Session session = Session.getInstance(props, null);
            session.setDebug(true);
            MimeMessage msg = new MimeMessage(session); // create a message
            msg.setFrom(new InternetAddress(from));
            msg.setSubject(subject);
            MimeBodyPart mbp1 = new MimeBodyPart();// create and fill the first message part
          //  mbp1.setText(msgText1);
            MimeBodyPart mbp2 = new MimeBodyPart();// create the second message part
            Multipart mp = new MimeMultipart(); // create the Multipart and add its parts to it
            mp.addBodyPart(mbp1);
            if (attachment != null) {
                File filename1 = attachment;
                FileDataSource fds = new FileDataSource(filename1);
                mbp2.setDataHandler(new DataHandler(fds));
                mbp2.setFileName(fds.getName());
                // mbp2.setFileName(filename);
                mp.addBodyPart(mbp2);
            }
            msg.setContent(mp);// add the Multipart to the message
            msg.setSentDate(new Date()); // set the Date: header
         stmt1=con.createStatement();
         sql1="select category,subcategory,quantity,units,price_tqty,total_amount from history_grocery where username='"+user+"'and category='"+cate+"'";
         rs1=stmt1.executeQuery(sql1);
         System.out.println("History grocery qry is=====  " + sql1);
         //int index=0;
         while(rs1.next())
         {
                cat=rs1.getString(1);
                subcat=rs1.getString(2);
                quan=rs1.getString(3);
                unit=rs1.getString(4);
                rate=rs1.getString(5);
                total=rs1.getString(6);
               // ar.add(1,subcat);
               // ar.add(2,quan);
               // ar.add(3,unit);
               // ar.add(4,rate);
               // ar.add(5,total);
               // index++;
                
         }
           String html="<html><head>"
                    + "<title>"+msg.getSubject()+"</title>"
                    + "</head>"+"<LINK REL='stylesheet' HREF='stylesheet/fac_css.css' TYPE='text/css'>"
                    + "<body>"
                    +"<table width='900' cellpadding='0' cellspacing='0' border='0'>"
                    +"<tr><td class ='text12' width='100%'><br>I ordered all the following items.Please deliver all the same items on the given below address:</td></tr><tr>"
                    +"<td height='5'></td></tr>"
                    +"<tr><td></td></tr>"
                    +"<tr><td height='5'></td></tr>"
                    +"<tr><td><table border='1' width='800' cellpadding='2' cellspacing='1' bgColor='#B6AFA9' style='border-collapse: collapse' bordercolor='#EBDA2A' align='left'>"
                    +"<tr bgColor=#CD919E class='centerheading' align='left'>"
                            +"<td width='30' style='color: #FFFFFF;'><b>Category</b></td>"
                            +"<td width='35' style='color: #FFFFFF;'><b>Subcategory</b></td>"
                            +"<td width='30' style='color: #FFFFFF;'><b>Quantity</b></td>"
                            +"<td width='30' style='color: #FFFFFF;'><b>Units</b></td>"
                            +"<td width='30' style='color: #FFFFFF;'><b>Rate</b></td>"
                            +"<td width='30' style='color: #FFFFFF;'><b>Total</b></td>"
                   + "</tr>"
                   +"<tr>"
                        +"<td width='30' style='color: #EEE9E9;'>"+cat+"</b></td>"
                            +"<td width='35' style='color: #EEE9E9;'>"+subcat+"</td>"
                            +"<td width='30' style='color: #EEE9E9;'>"+quan+"</td>"
                            +"<td width='30' style='color: #EEE9E9;'>"+unit+"</td>"
                            +"<td width='30' style='color: #EEE9E9;'>"+rate+"</td>"
                            +"<td width='30' style='color: #EEE9E9;'>"+total+"</td>"
                   +"</tr>"
                    +"</table>"
                +"</td>"
        +"</tr>"
        +"<tr>"
             +"<td height='6'></td>"
        +"</tr>"
        +"<tr>"
            +"<td class ='text12' width='100%'><a href="+url+" style='font-weight: bolder;'>Give Order Online Here---->>>>></a>."+"</td>"
        +"</tr>"
        +"<tr>"
             +"<td height='15'></td>"
        +"</tr>"
        +"<tr><td  class ='text12' width='100%'>"+"Regards"+"</td></tr>"
        +"<tr><td  class ='text12' width='100%'>"+"Society Name: "+society_name+"</td></tr>"
        +"<tr><td  class ='text12' width='100%'>"+"Resident Name: "+resi_name+"</td></tr>"
        +"<tr><td  class ='text12' width='100%'>"+"Flat No: "+flat_no+"</td></tr>"
        +"<tr><td  class ='text12' width='100%'>"+"Tower No: "+tower_no+"</td></tr>"
        +"<tr><td  class ='text12' width='100%'>"+"Ph: "+contact+"</td></tr>"
        +"<tr><td  class ='text12' width='100%'>"+"E-mail: "+email_id+"</td></tr>"
        +"</table>"
        +"</body></html>";
        //HTMLDataSource is an inner class
        msg.setDataHandler(new DataHandler(new HTMLDataSource(html)));
         
            Transport transport = session.getTransport("smtp");
            transport.connect(host, username, pass);
            try {
                 String tos = email;
              //  InternetAddress[] address ;//= {new InternetAddress(to)};
              // for (int i = 0; i < tos.length; i++) {
                   // if (tos[i].trim().equalsIgnoreCase("")) {
                   // } else {//
                       InternetAddress[] address= {new InternetAddress(tos)};
                        msg.addRecipient(Message.RecipientType.TO, new InternetAddress(tos));
                        msg.setRecipients(Message.RecipientType.TO, address);
               msg.setRecipients(Message.RecipientType.CC, "[e-mail]");
               msg.setRecipients(Message.RecipientType.CC, "[e-mail]");
               msg.setRecipients(Message.RecipientType.CC, "[e-mail]");
               msg.setRecipients(Message.RecipientType.BCC, "[e-mail]");
               msg.saveChanges(); // this is must
               transport.sendMessage(msg, msg.getAllRecipients());
               status="OK";
           // }
             //  }
            } finally {
                transport.close();
            }
        } catch (MessagingException mex) {
            mex.printStackTrace();
            if ((ex = mex.getNextException()) != null) {
                ex.printStackTrace();
            }
            status=null;
        }finally{
            System.out.println("The status in mail sending file is=="+status);
            return status;
        }
    }


        static class HTMLDataSource implements DataSource {
        private String html;

        public HTMLDataSource(String htmlString) {
            html = htmlString;
        }

        // Return html string in an InputStream.
        // A new stream must be returned each time.
        public InputStream getInputStream() throws IOException {
            if (html == null) throw new IOException("Null HTML");
            return new ByteArrayInputStream(html.getBytes());
        }

        public OutputStream getOutputStream() throws IOException {
            throw new IOException("This DataHandler cannot write HTML");
        }

        public String getContentType() {
            return "text/html";
        }

        public String getName() {
            return "JAF text/html dataSource to send e-mail only";
        }
    }


}

mail output is here....

I ordered all the following items.Please deliver all the same items on the given below address:


[b]
Category    Subcategory   Quantity       Units            Rate      Total
Gift Items    Soft Toys           3             Dozzens          10      30.0[/b]

Give Order Online Here---->>>>>.

Regards
Society Name: Orchid Petals#FAC000001
Resident Name: GAURAV BANSAL
Flat No: 201
Tower No: 1
Ph: 9876543213
E-mail: [e-mail]

i want to send in this table multiple data.....

Thanks in advanced

[Mahendra Suda]

           String html="<html><head>"
                    + "<title>"+msg.getSubject()+"</title>"
                    + "</head>"+"<LINK REL='stylesheet' HREF='stylesheet/fac_css.css' TYPE='text/css'>"
                    + "<body>"
                    +"<table    border='0'>"
                    +"<tr><td class ='text12' ><br>I ordered all the following items.Please deliver all the same items on the given below address:</td></tr><tr>"
                    +"<td ></td></tr>"
                    +"<tr><td></td></tr>"
                    +"<tr><td ></td></tr>"
                    +"<tr><td><table border='1'       >"
                    +"<tr  class='centerheading' >"
                            +"<td  ><b>Category</b></td>"
                            +"<td  ><b>Subcategory</b></td>"
                            +"<td  ><b>Quantity</b></td>"
                            +"<td  ><b>Units</b></td>"
                            +"<td  ><b>Rate</b></td>"
                            +"<td  ><b>Total</b></td>"
                   + "</tr>";
           while(rs1.next())
           {
                  cat=rs1.getString(1);
                  subcat=rs1.getString(2);
                  quan=rs1.getString(3);
                  unit=rs1.getString(4);
                  rate=rs1.getString(5);
                  total=rs1.getString(6);
                 // ar.add(1,subcat);
                 // ar.add(2,quan);
                 // ar.add(3,unit);
                 // ar.add(4,rate);
                 // ar.add(5,total);
                 // index++;
                  html = html +"<tr>"
                  +"<td  >"+cat+"</b></td>"
                      +"<td  >"+subcat+"</td>"
                      +"<td  >"+quan+"</td>"
                      +"<td  >"+unit+"</td>"
                      +"<td  >"+rate+"</td>"
                      +"<td  >"+total+"</td>"
             +"</tr>";
                  
           }
           html = html +"</table>"
                +"</td>"
        +"</tr>"
        +"<tr>"
             +"<td ></td>"
        +"</tr>"
        +"<tr>"
            +"<td class ='text12' ><a   rel="nofollow">Give Order Online Here---->>>>></a>."+"</td>"
        +"</tr>"
        +"<tr>"
             +"<td ></td>"
        +"</tr>"
        +"<tr><td  class ='text12' >"+"Regards"+"</td></tr>"
        +"<tr><td  class ='text12' >"+"Society Name: "+society_name+"</td></tr>"
        +"<tr><td  class ='text12' >"+"Resident Name: "+resi_name+"</td></tr>"
        +"<tr><td  class ='text12' >"+"Flat No: "+flat_no+"</td></tr>"
        +"<tr><td  class ='text12' >"+"Tower No: "+tower_no+"</td></tr>"
        +"<tr><td  class ='text12' >"+"Ph: "+contact+"</td></tr>"
        +"<tr><td  class ='text12' >"+"E-mail: "+email_id+"</td></tr>"
        +"</table>"
        +"</body></html>";

As your requirement you are running while loop at wrong place, so in your code only one values will be there in all the property, instead you have to generate the report data inside while loop.. Try above code of replacement of while loop and Html string... Should work.

[Rd Dari]

Hi Mahendra Suda ,


Thank you so much I done it from your help...
Really this site is so helpful and so friendly...

Thanks once again..