RAMSIS-CODE

Wednesday 16 March 2016

Excel make a query

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

Sunday 24 January 2016

File upload validation with jquery

$(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>

<div>

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

</div>

</form>

Wednesday 29 July 2015

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="javascript: void(0);loadAjax();">Click here to load get data via Ajax</a><br /><br />
        <div id="results"></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>

Wednesday 15 July 2015

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");

Wednesday 25 February 2015

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;

}

Saturday 21 February 2015

How to send Email to multiple recipients with multiple text messages via SMTP with javaMail

Here i am going to showing how to Send email in java using Gmail SMTP and JavaMail API.

I have used one dependency jar "javax.mail.jar"

package com.mail.system;

import java.util.Properties;

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;

public class EmailTest {

public static void main(String[] args) {

String mailSmtpHost = "smtp.gmail.com";

String[] mailTo = {"mail1@gmail.com","mail2@hotmail.com"};
String mailCc = "ccMail@rediffmail.com";
String mailFrom = "fromMail@gmail.com";
String mailSubject = "Email from Java";
String[] mailText = {"send email for gmail domain","send email to hotmail domain"};

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

sendEmail(mailTo[i], mailCc, mailFrom, mailSubject, mailText[i], mailSmtpHost);
}
}

public static void sendEmail(String to, String cc, String from, String subject, String text, String smtpHost) {
try {
Properties properties = new Properties();
properties.put("mail.smtp.host", smtpHost);
//Session emailSession = Session.getDefaultInstance(properties);

// If you want to use SSL
properties.put("mail.smtp.socketFactory.port", "465");
properties.put("mail.smtp.socketFactory.class", "javax.net.ssl.SSLSocketFactory");
properties.put("mail.smtp.auth", "true");
properties.put("mail.smtp.port", "465");

Session emailSession = Session.getDefaultInstance(properties, new Authenticator() {
@Override
protected PasswordAuthentication getPasswordAuthentication() {
String username = "fromMail@gmail.com";
String password = "password";
return new PasswordAuthentication(username,password);

}
});

Message emailMessage = new MimeMessage(emailSession);
emailMessage.addRecipient(Message.RecipientType.TO, new InternetAddress(to));
emailMessage.addRecipient(Message.RecipientType.CC, new InternetAddress(cc));
emailMessage.setFrom(new InternetAddress(from));
emailMessage.setSubject(subject);
emailMessage.setText(text);

emailSession.setDebug(true);
Transport transport = emailSession.getTransport("smtp");
transport.send(emailMessage);
System.out.println("Mail successfully Send to ....."+to);
transport.close();
System.out.println("\n");
System.out.println("Transport Session Close .....");
} catch (AddressException e) {
e.printStackTrace();
} catch (MessagingException e) {
e.printStackTrace();
}
}

}

Thursday 30 October 2014

How to Convert Tables 'MyISAM' to 'InnoDB' Engine in mysql database

-- QUERY TO CONVERT TABLES 'MyISAM' to 'InnoDB' Engine

SET @DATABASE_NAME = 'database';

SELECT CONCAT('ALTER TABLE ', table_name, ' ENGINE=InnoDB;') AS sql_statements
FROM    information_schema.tables AS tb
WHERE   table_schema = @DATABASE_NAME
AND     `ENGINE` = 'MyISAM'
AND     `TABLE_TYPE` = 'BASE TABLE'
ORDER BY table_name DESC;

-- QUERY TO CONVERT TABLES 'InnoDB' TO 'MyISAM' ENGINE

SET @DATABASE_NAME = 'database';

SELECT CONCAT('ALTER TABLE ', table_name, ' ENGINE=MyISAM;') AS sql_statements
FROM    information_schema.tables AS tb
WHERE   table_schema = @DATABASE_NAME
AND     `ENGINE` = 'InnoDB'
AND     `TABLE_TYPE` = 'BASE TABLE'
ORDER BY table_name DESC;

Pages