ITMS emailschedular

package com.itms.resource;

import java.text.SimpleDateFormat;

import java.util.Calendar;

import java.util.Date;

import java.util.HashMap;

import java.util.Properties;

import java.util.ResourceBundle;

import java.util.Vector;

import javax.mail.Authenticator;

import javax.mail.Message;

import javax.mail.MessagingException;

import javax.mail.PasswordAuthentication;

import javax.mail.Session;

import javax.mail.Transport;

import javax.mail.internet.AddressException;

import javax.mail.internet.InternetAddress;

import javax.mail.internet.MimeMessage;

import org.apache.log4j.Logger;

import org.quartz.Job;

import org.quartz.JobExecutionContext;

import org.quartz.JobExecutionException;

import com.itms.bo.EmailSchedularBO;

import com.itms.dao.VException;

public class EmailSchedular implements Job{

static final Logger _log=Logger.getLogger(com.itms.resource.EmailSchedular.class);

static ResourceBundle szResBundl = ResourceBundle.getBundle("com/itms/resource/mailProperties");

String message = szResBundl.getString("MESSAGE_EMAIL_SCHEDULAR");

String subject= szResBundl.getString("SUBJECT_EMAIL_SCHEDULAR");

EmailSchedularBO szMailJob7DaysBO;

HashMap szHmap=null;

HashMap szMap=null; 

HashMap szMapW=null;

HashMap mailMap=null;

Vector szVec = null;

Vector szVec1 = null;

SimpleDateFormat sdf = new SimpleDateFormat("yyyy-mm-dd hh:mm:ss");

java.util.Date utildate = new Date();

java.sql.Date sqlDate = new java.sql.Date(utildate.getTime());

Calendar calendar = Calendar.getInstance();

public void execute(JobExecutionContext jExeCtx) throws JobExecutionException {

// TODO Auto-generated method stub

System.out.println("<<< TestSchedular start >>> ");

try {

_log.info("In MailJob7Days Schedular >> job method >> ");

System.out.println("In MailJob7Days Schedular >> job method >> ");

szMailJob7DaysBO = new EmailSchedularBO(); 

szHmap= new HashMap();

mailMap=new HashMap();

szMapW= new HashMap();

szMap= new HashMap();

szVec= new Vector();

szVec1= new Vector();

try{

System.out.println("Email schedular srart for sending Mail ... ");

String toDayDate=sqlDate+"";

System.out.println(toDayDate);

// szHmap.put("", "");

szVec = szMailJob7DaysBO.getApprovedPreClerance(szHmap);

System.out.println("szVec -- "+szVec.size() +" -- "+szVec1.size());

String userName ="";

String submittedDate=""; 

String itms ="";

// System.out.println(szMapW.get("RowNum") +" "+ szMapW.get("alldate"));

// System.out.println(szMap.get("EMAIL_ID")); //APPROVAL_DATE

for(int k=0;k<szVec.size();k++){

szMap = (HashMap) szVec.get(k);

System.out.println("szMap: : "+ szMap);

szVec1 =szMailJob7DaysBO.getWorkingDay(szMap);

System.out.println("szVec1== "+szVec1);

userName =(String) szMap.get("EMPLOYEE_NAME"); 

for(int i=0;i<szVec1.size();i++)

{

szMapW = (HashMap) szVec1.get(i);

System.out.println("alldate  >> "+szMapW.get("alldate"));

}

submittedDate =(String) szMap.get("SUBMITTED_ON");

String date1 = submittedDate;

System.out.println("date1 >>"+date1);

String [] datePass1 = submittedDate.split(" ",0);

                    //System.out.println("datePass1 "+datePass1[0]);

itms =(String) szMap.get("PRE_ITMS_NO");

message = message.replaceAll("#USER#",userName);

message = message.replaceAll("#DATE#",datePass1[0]);

subject = subject.replaceAll("#ITMSNO#",itms);

subject = subject.replaceAll("#DATE#",datePass1[0]);

mailMap.put("ITMS_NO", itms);

mailMap.put("EMP_OS_NAME", userName);

mailMap.put("EMAIL_ID", szMap.get("EMAIL_ID"));

mailMap.put("MESSAGE", " ");

mailMap.put("CCEMAIL", " ");

mailMap.put("EMAIL_DATE", toDayDate);

String [] allDate1 = szMapW.get("alldate").toString().split(" ");

String dt = allDate1[0];

System.out.println(dt+" ================= dt  >> " +toDayDate);

if(dt.equals(toDayDate)){

//EmailSend.sendEmail((String) szMap.get("EMAIL_ID"), "", subject, message);

szMailJob7DaysBO.insertEmailSchedular(mailMap);

}

 }

}catch(Exception ex){

ex.printStackTrace();

System.out.println("MailJob7Days Exception >> "+ex);

} catch (VException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

} catch (Exception e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

}

}

google mail setting

https://www.google.com/settings/security/lesssecureapps

Excel make a query

="INSERT INTO MST_ITMS_ROLE_MAPPING  (EMP_OS_NAME,EMP_CODE,ROLE_ID,MAPPING_ID) VALUES('"&A2&"','"&B2&"','"&C2&"','"&D2&"');"

File upload validation with jquery

<script src="js/jquery-1.8.3.js"></script>

<script type="text/javascript">

    $(function () {

        $('#files').change(

            function () {

                var fileExtension = ['jpeg', 'jpg'];

                if ($.inArray($(this).val().split('.').pop().toLowerCase(), fileExtension) == -1) {

                     //alert("Only '.jpeg','.jpg' formats are allowed.");

                   // $('#files').attr("disabled", true);

                    $('#lblmsg').html("Only '.jpeg','.jpg' formats are allowed.");

$(this).val('');

                }

                else {

                    $('#files').attr("disabled", false);

                    $('#lblmsg').html(" ");

                } 

            })  

    })  

</script>

<form id="form1" action="home.html">

<div>  

File Upload <input type="file" id="files" ></input>

<input type="submit" value="submit" id="btnsubmit"></input>

</div> 

<label id ="lblmsg" style="color:RED">****</label>

</form>

How to show loading image while calling AJAX request

 


<html xmlns="http://www.w3.org/1999/xhtml">
<head>
    <style>
            body, html {
            margin:0;
            padding;
            height:100%
        }

        a {
            font-size:1.25em;
        }

        #content {
            padding:25px;
        }

        #fade {
            display: none;
            position:absolute;
            top: 0%;
            left: 0%;
            width: 100%;
            height: 100%;
            background-color: #ababab;
            z-index: 1001;
            -moz-opacity: 0.8;
            opacity: .70;
            filter: alpha(opacity=80);
        }

        #modal {
            display: none;
            position: absolute;
            top: 45%;
            left: 45%;
            width: 100px;
            height: 100px;
            padding:20px 15px 15px;
            border: 3px solid #ababab;
            box-shadow:1px 1px 10px #ababab;
            border-radius:20px;
            background-color: white;
            z-index: 1002;
            text-align:center;
            overflow: auto;
        }

        #results {
            font-size:1.25em;
            color:red
        }
   
    </style>
   
   
    <script>
            function openModal() {
                document.getElementById('modal').style.display = 'block';
                document.getElementById('fade').style.display = 'block';
        }

        function closeModal() {
            document.getElementById('modal').style.display = 'none';
            document.getElementById('fade').style.display = 'none';
        }
               
        function loadAjax() {
            document.getElementById('results').innerHTML = '';
            openModal();
            var xhr = false;
            if (window.XMLHttpRequest) {
                xhr = new XMLHttpRequest();
            }
            else {
                xhr = new ActiveXObject("Microsoft.XMLHTTP");
            }
            if (xhr) {
                xhr.onreadystatechange = function () {
                    if (xhr.readyState == 4 && xhr.status == 200) {
                        closeModal();
                        document.getElementById("results").innerHTML = xhr.responseText;
                    }
                }
                xhr.open("GET", "load.jsp", true);
                xhr.send(null);
            }
        }
   
    </script
</head>
<body>
    <div id="content">

        <!--<a href="/articles/1506-how-to-display-image-spinner-ajax-request">Click here to return to the
        tutorial.</a><br /><br /> <h2>Demo</h2> -->
   
       
        <a href="javascript: void(0);loadAjax();">Click here to load get data via Ajax</a><br /><br />
        <div id="results"><!-- Results are displayed here --></div>
        <div id="fade"></div>
        <div id="modal">
            <img id="loader" style="width:95px;height:95px;border:0px;" src="loadImage.gif" />
        </div>
    </div>
</body>
</html>

Preventing User to go back after logout in jsp

 <%

  response.setHeader("Cache-Control","no-cache");

  response.setHeader("Cache-Control","no-store");

  response.setHeader("Pragma","no-cache");

  response.setDateHeader ("Expires", 0);

  if(session.getAttribute("user")==null)

      response.sendRedirect("index.jsp");

  %> 

How to generate a random alpha numeric String in java.

package com.digit;

import java.util.Date;

import java.util.Random;

public class RandumString {

public static void main(String args[]){

//Randum ren= new Randum();

String a = Randum.generateRandomString(6);

System.out.println(a);

}

}

class Randum{

private static Random random = new Random((new Date()).getTime());

    public static String generateRandomString(int length) {

      char[] values = {'a','b','c','d','e','f','g','h','i','j',

               'k','l','m','n','o','p','q','r','s','t',

               'u','v','w','x','y','z','0','1','2','3',

               '4','5','6','7','8','9'};

      String out = "";

      for (int i=0;i<length;i++) {

          int idx=random.nextInt(values.length);

        out += values[idx];

      }

      return out;

    }

}