Tuesday, 21 March 2017

Simple file upload in jsp

<HTML>
<HEAD>
<TITLE>Display file upload form to the user</TITLE>
</HEAD>
<BODY>
<FORM ENCTYPE="multipart/form-data" ACTION="upload.jsp" METHOD=POST>
<br>
<br>
<br>
<center>
<table border="0" bgcolor=#ccFDDEE>
      <tr>
            <center>
            <td colspan="2" align="center"><B>UPLOAD THE FILE</B>
            <center>
            </td>
      </tr>
      <tr>
            <td colspan="2" align="center"></td>
      </tr>
      <tr>
            <td><b>Choose the file To Upload:</b></td>
            <td><INPUT NAME="file" TYPE="file"></td>
      </tr>
      <tr>
            <td colspan="2" align="center"></td>
      </tr>
      <tr>
            <td colspan="2" align="center"><input type="submit"
                  value="Send File"></td>
      </tr>
      <table>
            </center>
            </FORM>
</BODY>
</HTML>





<%@ page import="java.io.*"%>
<%
      String saveFile = "";
      String contentType = request.getContentType();
      if ((contentType != null) && (contentType.indexOf("multipart/form-data") >= 0)) {
            DataInputStream in = new DataInputStream(request.getInputStream());
            int formDataLength = request.getContentLength();
            byte dataBytes[] = new byte[formDataLength];
            int byteRead = 0;
            int totalBytesRead = 0;
            while (totalBytesRead < formDataLength) {
                  byteRead = in.read(dataBytes, totalBytesRead, formDataLength);
                  totalBytesRead += byteRead;
            }
            String file = new String(dataBytes);
            saveFile = file.substring(file.indexOf("filename=\"") + 10);
            saveFile = saveFile.substring(0, saveFile.indexOf("\n"));
            saveFile = saveFile.substring(saveFile.lastIndexOf("\\") + 1, saveFile.indexOf("\""));
            int lastIndex = contentType.lastIndexOf("=");
            String boundary = contentType.substring(lastIndex + 1, contentType.length());
            int pos;
            pos = file.indexOf("filename=\"");
            pos = file.indexOf("\n", pos) + 1;
            pos = file.indexOf("\n", pos) + 1;
            pos = file.indexOf("\n", pos) + 1;
            int boundaryLocation = file.indexOf(boundary, pos) - 4;
            int startPos = ((file.substring(0, pos)).getBytes()).length;
            int endPos = ((file.substring(0, boundaryLocation)).getBytes()).length;
   saveFile = "/var/lib/tomcat/webapps/manual_pull/file_uploads/" + saveFile;
  
  try{
            File ff = new File(saveFile);
            FileOutputStream fileOut = new FileOutputStream(ff);
            fileOut.write(dataBytes, startPos, (endPos - startPos));
            fileOut.flush();
            fileOut.close();
  }catch(Exception e){
  out.println(e.getMessage());
  }
%><Br>
<table border="2">
      <tr>
            <td><b>You have successfully upload the file by the name of:</b>
            <%
                  out.println(saveFile);
                  }
            %>
            </td>
      </tr>
</table>

Thursday, 16 March 2017

File upload using JSP

<%@ include file="shared/config.jsp"%>
<%@ include file="view/header.jsp"%>
<?xml version="1.0"?>
<!DOCTYPE html PUBLIC "-//WAPFORUM//DTD XHTML Mobile 1.0//EN" "http://www.wapforum.org/DTD/xhtml-mobile10.dtd">

<%@ page import="org.apache.commons.fileupload.*, org.apache.commons.fileupload.servlet.ServletFileUpload, org.apache.commons.fileupload.disk.DiskFileItemFactory, org.apache.commons.io.FilenameUtils, java.util.*, java.io.File, java.lang.Exception" %>


<html xmlns="http://www.w3.org/1999/xhtml">
  <head>
    <title>File Upload Example</title>
  </head>

  <body>
    <h1>Data Received at the Server</h1>
    <hr/>
    <p>

<%
String exFilename="test.sql";

if (ServletFileUpload.isMultipartContent(request)){
  ServletFileUpload servletFileUpload = new ServletFileUpload(new DiskFileItemFactory());
  List fileItemsList = servletFileUpload.parseRequest(request);

  String optionalFileName = "";
  FileItem fileItem = null;

  Iterator it = fileItemsList.iterator();
  while (it.hasNext()){
    FileItem fileItemTemp = (FileItem)it.next();
    if (fileItemTemp.isFormField()){
%>

<b>Name-value Pair Info:</b><br/>
Field name: <%= fileItemTemp.getFieldName() %><br/>
Field value: <%= fileItemTemp.getString() %><br/><br/>

<%
      if (fileItemTemp.getFieldName().equals("filename"))
        optionalFileName = fileItemTemp.getString();
    }
    else
      fileItem = fileItemTemp;
  }

  if (fileItem!=null){
    String fileName = fileItem.getName();
%>

<b>Uploaded File Info:</b><br/>
Content type: <%= fileItem.getContentType() %><br/>
Field name: <%= fileItem.getFieldName() %><br/>
File name: <%= fileName %><br/>
File size: <%= fileItem.getSize() %><br/><br/>

<%
    /* Save the uploaded file if its size is greater than 0. */
    if (fileItem.getSize() > 0){
      if (optionalFileName.trim().equals(""))
        fileName = FilenameUtils.getName(fileName);
      else
        fileName = optionalFileName;

      String dirName = "/var/lib/tomcat/webapps/manual_pull/file_uploads/";
 exFilename=dirName+fileName;
      File saveTo = new File(dirName + fileName);
      try {
        fileItem.write(saveTo);
%>

<b>The uploaded file has been saved successfully.</b>

<%
      }
      catch (Exception e){
 out.println(e);
%>

<b>An error occurred when we tried to save the uploaded file.</b>

<%
      }
    }
  }
}
%>
<%
boolean res;
String cmd="/usr/local/mysql/bin/mysql -u root -p test < "+exFilename;
out.println(cmd);
try{
res = lib.exec(cmd);
out.println(res);
//out.println("*********no****");
}catch(Exception e){
//out.println("*********yes****");
out.println(e.getMessage());
}


%>
    </p>
  </body>
</html>
<%@ include file="view/footer.jsp"%>

Monday, 25 February 2013

Thursday, 17 January 2013

Send mail from localserver

<%@page import="sun.font.Script"%>
<%@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="&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<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>&nbsp;</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
   
   
      }
     %>
   
   
   

Monday, 9 July 2012