<%@page import="java.io.*"%>
<%@page import="java.util.*"%>
<%@page import="org.apache.poi.hssf.usermodel.HSSFSheet"%>
<%@page import="org.apache.poi.hssf.usermodel.HSSFWorkbook"%>
<%@page import="org.apache.poi.hssf.usermodel.HSSFRow"%>
<%@page import="org.apache.poi.hssf.usermodel.HSSFCell"%>
<%@page import="javax.mail.*" %>
<%@page import="javax.mail.internet.*" %>
<%@page import="java.net.*"%>
<%! public ArrayList list = new ArrayList();
public ArrayList listName = new ArrayList();
static int count=0;
ArrayList listTen = new ArrayList();
ArrayList nameTen = new ArrayList();
PrintWriter pw = null;
public int total = 20;
%>
<center>
<h1>Reading The data from excel</h1>
<table border="1">
<%
short a=0;
short b=1;
short c=2;
short d=3;
int l=0;
String value1="", value2="",value3=" ", value4="";
String file1=request.getParameter("file");
String path = "D:\\"+file1;
out.print(path);
String filename =path;
if (filename != null && !filename.equals("")) {
try
{
FileInputStream fs =new FileInputStream(filename);
HSSFWorkbook wb = new HSSFWorkbook(fs);
for (int k = 0; k < wb.getNumberOfSheets(); k++){
int j=l+1;
HSSFSheet sheet = wb.getSheetAt(k);
int rows = sheet.getPhysicalNumberOfRows();
for (int r = 0; r < rows; r++){
HSSFRow row = sheet.getRow(r);
int cells = row.getPhysicalNumberOfCells();
out.write("<br>");
HSSFCell cell4 = row.getCell(a);
value4 = cell4.getStringCellValue();
HSSFCell cell3 = row.getCell(b);
value2 = cell3.getStringCellValue();
list.add(value4);
listName.add(value2);
fs.close();
%>
</center>
<%
}
l++;
}
}
catch(Exception e)
{
System.out.println("File Error"+e);
}
list.remove("Email");
listName.remove("Name");
// String host="smtp.gmail.com", user="issacbalaji@gmail.com", pass="umeara1978";//for gmail
String host="mail.techmamidi.com", user="promotions@mmad.in", pass="123456";// for techmamidi
String SSL_FACTORY = "javax.net.ssl.SSLSocketFactory";
int size = list.size();
out.print("size"+size);
int p=0;
for(int m=0; m<size; m++)
{
//out.print(m+" "+listTen.size());
++p;
if(p==1)
{
ArrayList listTen = new ArrayList();
ArrayList nameTen = new ArrayList();
listTen.add(list.get(m));
nameTen.add(listName.get(m));
String []to = new String[listTen.size()];
listTen.toArray(to);
String []name = new String[1];
nameTen.toArray(name);
//perfect till here
String from ="promotions@mmad.in"; //Email id of the recipient
String subject = "Browse Internet on TV.";//"Promotional Offer From MMAD";
/******************contetc starts**********************/
File fileBody = new File("D:\\wowtvmini.txt");
StringBuffer contents1 = new StringBuffer();
BufferedReader reader1 = null;
try
{
reader1 = new BufferedReader(new FileReader(fileBody));
String text = null;
while ((text = reader1.readLine()) != null)
{
contents1.append(text).append(System.getProperty("line.separator"));
}
} catch (FileNotFoundException e)
{
e.printStackTrace();
}
catch (IOException e)
{
e.printStackTrace();
}
finally {
try {
if (reader1 != null)
{
reader1.close();
}
} catch (IOException e)
{
out.print("Error in file");
}
}
/******************contents ends*************************/
String template=" <b>"+"Dear "+name[0]+"</b>"+contents1.toString()
+"<a href='http://i.mmad.in/unsubscribe.php?uid="
+ name[0]+"&eid="+to[0]+"'>Click here</a>"
+"</td></tr></table><p> </p></o:p></span></p></td></tr></table></div></td><td width=32 style='width:24.0pt;padding:0cm 0cm 0cm 0cm'></td></tr></table></div></td></tr></table></div></div></body></html>";
// String template="Hai";
try {
boolean sessionDebug = true;
Properties props = System.getProperties();
// props.put("mail.smtp.starttls.enable", "true"); // added this line
// props.put("mail.smtp.host", host);
//props.put("mail.smtp.user", from);
//props.put("mail.smtp.password", pass);
///props.put("mail.gmail.port", "465");
// props.put("mail.smtp.auth", "true");
props.put("mail.transport.protocol", "smtp");
props.put("mail.smtp.starttls.enable", "true");
// props.put("mail.smtp.host", "smtp.gmail.com");//for gmail server
props.put("mail.smtp.host", "smtp.techmamidi.com");//for techmamidi server
props.put("mail.smtp.auth", "true");
// use your gmail account username here
props.put("mail.smtp.user", "promotions@mmad.in");
props.put("mail.smtp.port", "465");
props.put("mail.mime.charset", "ISO-8859-1");
props.put("mail.smtp.socketFactory.port", "465");
props.put("mail.smtp.socketFactory.fallback", "false");
props.put("mail.smtp.socketFactory.class", "javax.net.ssl.SSLSocketFactory");
/*
props.put("mail.host", host);
props.put("mail.transport.protocol.", "smtp");
props.put("mail.smtp.auth", "true");
props.put("mail.smtp.", "true");
props.put("smtp.gmail.com", "465");
props.put("mail.smtp.socketFactory.fallback", "false");
props.put("mail.smtp.socketFactory.class", SSL_FACTORY);
*/
Session mailSession = Session.getDefaultInstance(props, null);
mailSession.setDebug(sessionDebug);
Message msg = new MimeMessage(mailSession);
// msg.setFrom(new InternetAddress(from,"MMAD(Mobility Makes A Difference)",""));
msg.setFrom(new InternetAddress(from,"Anushka",""));
javax.mail.internet.InternetAddress[] address = new
javax.mail.internet.InternetAddress[to.length];
int i;
for (i = 0; i < to.length; i++)
address[i] = new javax.mail.internet.InternetAddress(to[i]);
msg.setRecipients(Message.RecipientType.BCC, address);
if(m==total)
{
Calendar time=Calendar.getInstance();
msg.addRecipient(Message.RecipientType.TO,new InternetAddress("dump@techmamidi.com"));
total=total+20;
String fname="D://Mail_17tth_January2013.txt";
pw = new PrintWriter(new FileWriter(fname, true));
pw.println("Mail sent successfully to"+total+"People=("+time.getTime()+")");
pw.println("=======================================");
pw.flush();
}
msg.setSubject(subject);
msg.setContent(template,"text/html"); // use setText if you want to send text
Transport transport = mailSession.getTransport("smtp");
transport.connect(host, user, pass);
try {
transport.sendMessage(msg,msg.getAllRecipients());
Thread.sleep(5000);
}
catch(Exception err){
out.println("Error "+err.getMessage());
}
transport.close();
response.sendRedirect("Browse.jsp?msg="+total);
}
catch(Exception e)
{
out.print("Error in Sending mail//"+e.getMessage());
} finally {
//Close the PrintWriter
if (pw != null)
pw.close();
}
p=0;
listTen.clear();
//boolean check = listTen.isEmpty();
// out.print("Boolean----"+check);
}//if Twenty completes
}//for untill sends all mails
}
%>
