Wednesday, 28 August 2013

How to disable back button in Web Browser

 Disable back button in Web Browser

1)Using Filter In Web.xml
<filter>
<filter-name>noCacheFilter</filter-name>
<filter-class>com.LoginFilter</filter-class>
</filter>
<filter-mapping>
<filter-name>noCacheFilter</filter-name>
<url-pattern>*.jsp</url-pattern>
</filter-mapping>

Call The Servlet LoginFilter for every Request 
package com;

import java.io.IOException;

import javax.servlet.Filter;
import javax.servlet.FilterChain;
import javax.servlet.FilterConfig;
import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.ServletRequest;
import javax.servlet.ServletResponse;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;

import com.sap.mw.jco.JCO.Request;


public class LoginFilter implements Filter{


public void init(FilterConfig config) throws ServletException {
// If you have any <init-param> in web.xml, then you could get them
// here by config.getInitParameter("name") and assign it as field.
}

public void doFilter(ServletRequest req, ServletResponse res, FilterChain chain) throws IOException, ServletException {
HttpServletRequest request = (HttpServletRequest) req;
HttpServletResponse response = (HttpServletResponse) res;
HttpSession session = request.getSession(false);
System.out.println("filter called");

response.setHeader("Cache-Control", "no-cache, no-store, must-revalidate"); // HTTP 1.1.
response.setHeader("Pragma", "no-cache"); // HTTP 1.0.
response.setDateHeader("Expires", 0);
chain.doFilter(req, res);
//response.sendRedirect(request.getContextPath() + "/login.jsp"); // No logged-in user found, so redirect to login page.
}

public void destroy() {
// If you have assigned any expensive resources as field of
// this Filter class, then you could clean/close them here.
}

}





Thursday, 22 August 2013

Addition of number in Given String using Java Program

Addition of number in Given String using Java Program
Example
String is "121Bharat23"
Addition on 1+2+1+2+3=9

******************************************************
public class StringOperation {
public static void main(String[] args) {

String GivenString="121Bharat23";
int Total=0;
char stringarray[]=GivenString.toCharArray();
for(int i=0;i<stringarray.length;i++)
{
//System.out.println(stringarray[i]);
if(Character.isDigit(stringarray[i]))
{
int b = Character.getNumericValue(stringarray[i]);
             Total+=b;
}
}
System.out.println("Total=="+Total);

}
}
********************************************
Out Put
Total==9




Sorting Array (Bubble Sort)

public class Sorting {


public static void main(String[] args) {

int a[]={9,3,6,8,1,2,4,6};
for(int i=0;i<a.length;i++)
{
System.out.print(a[i]);
}
System.out.println("\n");
int temp;
for(int k=0;k<a.length;k++)
{
 for(int z=0;z<a.length-1;z++)
 {
if(a[z] > a[z+1])
{
temp=a[z];
a[z]=a[z+1];
a[z+1]=temp;
}

 }
}
for(int i=0;i<a.length;i++)
{
System.out.print(a[i]);
}
}

}


Out Put

93681246

12346689

Wednesday, 19 June 2013

Call The Stored Procedure Using Java Program

Step 1:

Create a Stored Procedure in MySQL.

For Eg.

 BEGIN
SELECT order_No,Person_Name,Posting_Date,PlantID,Material,Activity,WorkCenter,Yield_Entity,Yield_Unit,Confirmation FROM production_confirmation where (order_No like ordernumber) AND (PlantID like plant) AND (Person_Name like name) AND (Posting_Date like pdate) ;
END

Parameters:

ordernumber varchar(20),plant varchar(20),name varchar(20),pdate varchar(15)


Step 2;

Write a Java Program to Connection to MySQL


Class.forName("com.mysql.jdbc.Driver");

Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/project", "root",  "root");

Statement st=con.createStatement();

st.execute("call Store_Procedure('"+value1+"','"+value2+"','"+value3+"','"+value4+")");

ResultSet rs=(ResultSet) st.getResultSet();

rs.next();

String =rs.getString("order_No");

 

Done ................










Thursday, 16 May 2013

File Handling Using Java

Create Class File.Java
import FILE IO.*;

Example Code for Creating Folder



 // Report is the name of Folder Witch You want to create
    File path = new File("E:\\Report");
   System.out.println("path=="+path);

// Check Folder Is available Or Not  in given Directory

                     File file2 = new File("E:\\Report");
                    if (!file2.exists()) {
                    file2.mkdir();
                    }
//If Exist then Create Directory in file name and copy File into directory


if (file2.exists())
{
      File file1 = new File("E:\\Report\\"+filename+"\\"+filename);
                if (file1.mkdir()) {
                System.out.println("File Name Directory is created!");
                File uploadedFile = new File(file1 + "/" + filename);
                item.write(uploadedFile);
               
                } else {
                System.out.println("Failed to create directory!");
                }
      }





Delete Empty Directory
use This Code
File directory = new File("E:\\Report\\"+filename);
directory.delete();

//If the directory contain File then use this code


File fin = new File("E:\\Filename");
   System.out.println("fin-"+fin);

   for (File file : fin.listFiles()) {
       try {
FileDeleteStrategy.FORCE.delete(file);
System.out.println("delete");
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
      // Delete when directory is empty
              fin.delete();
   }





Tuesday, 14 May 2013

Upload and Download multiple files at a time using JSP-Servlet

Step 1:
Upload and Download multiple files at a time using JSP-Servlet.

for eg code

function displayTable(data)
{
   $("#Uploadfile table").remove();
if(data!="null"||data!="undefind")
{
    var objArray=JSON.parse(data);
    var count=1;                                      //  UserName,filename,filepath,FileID,Uplodated_Datetime                                                                                                                                          
var glacc="<center><table border='1'><tr align='center'><th></th><th>User Namer</th><th>file Name</th><th>File ID</th><th>Date Of uploading</th></tr>";
$.each(objArray, function(index,jsonObject){

glacc+="<tr align='center'><td id='uploadfile"+count+"' onclick='getid(this.id)'><a href='#'>download</a></td><td id='name"+count+"'>"+jsonObject.UserName+"</td><td id='filename"+count+"'>"+jsonObject.filename+"</td><td id='fileid"+count+"'>"+jsonObject.FileID+"</a></td><td>"+jsonObject.Uplodated_Datetime+"</td></tr>";
count=count+1;
});

 glacc+="</table></center>";
      $("#Uploadfile").append(glacc);
      $("#printPage").show();

}
}


function showfile(hid)
{
var id=hid.substring(4,hid.length);
var act=$("#activity"+id).text();

var complance=$("#complance"+id).text();
complance=complance.substring(0,10);

var name=$("#name"+id).text();

//alert("name="+name+"complance="+complance+"act="+act);
waiting_effect_on();
$.ajax({ type: "Post", url: "show_uploadfile",
data:{flag:1,Username:name,activity:act,c_date:complance},
cache:false,
success : function(data){
waiting_effect_off();
alert(data);
if(data=="]")
{
msg_box('No File Avilable','A',function(result){

});
}
else
{
$("#submitDIV2").show();
displayTable(data);
}

}
});

}











Step 2:

 click on Link to download file
  call this function 


function getid(id)
{

   $.ajax({ type: "Post", url: "downloadfile",
data:{filename:filename},
cache:false,
success : function(data){
window.location.href="tempdownloadfile.jsp?backurl="+window.location.href;

}
});

}


Step 3:
write code on Downloadfile.jsp


<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>Insert title here</title>

<script type="text/javascript">


function whatFile()
{
alert("1");
var url='file:///' + 'C://Users/1100lt031/Desktop/2012-White-Jaguar-XKR-S-Convertible-3Q-Front-1152x2048.jpg';
alert(url);
window.open(url,'Download');
}

function startDownload()
{
   var url='http://localhost:8080/Project/Report/1368005388533/REC_ADVT_16_2013.pdf';
  /*  var url="file:///E:/Siddharth/Relese Statergy/Multi Level Purchase Order Release Strategy.pdf";
  alert(url); */
  window.open(url,'Download');

}
</script>


</head>
<body>
<input type="button" onclick="startDownload();"/>
<a href="download/VB6IP.zip">Download</a>
<a href="http://localhost:8080/Project/Multi Level Purchase Order Release Strategy.pdf">http://localhost:8080/Project/Multi Level Purchase Order Release Strategy.pdf</a>


</body>
</html>

Step 4:
Output:










Multiple File Uploading Using JSP -Servlet

Step 1:
 Create JSP And Add Controls.

<input type="button" value="Upload file..." onclick="upload();">







Step 2:
 Oen Uploading  JSP file in Window


 window.open("uploadfile.jsp","Test","width=300,height=300,scrollbars=1,resizable=1");












Step 3:

 Control Add on  uploadfile.jsp


Write Code On  uploadfile.jsp.

<html xmlns="http://www.w3.org/1999/xhtml" dir="ltr">
<head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8"/>
<link rel="stylesheet" href="js/jquery.plupload.queue/css/jquery.plupload.queue.css" type="text/css" media="screen" />
<title>Plupload - Events example</title>
<style type="text/css">
body {
font-family:Verdana, Geneva, sans-serif;
font-size:13px;
color:#333;
background:url(../bg.jpg);
}
</style>

<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.5.1/jquery.min.js"></script>
<script type="text/javascript" src="http://bp.yahooapis.com/2.4.21/browserplus-min.js"></script>

<script type="text/javascript" src="js/plupload.js"></script>
<script type="text/javascript" src="js/plupload.gears.js"></script>
<script type="text/javascript" src="js/plupload.silverlight.js"></script>
<script type="text/javascript" src="js/plupload.flash.js"></script>
<script type="text/javascript" src="js/plupload.browserplus.js"></script>
<script type="text/javascript" src="js/plupload.html4.js"></script>
<script type="text/javascript" src="js/plupload.html5.js"></script>
<script type="text/javascript" src="js/jquery.plupload.queue/jquery.plupload.queue.js"></script>

</head>
<body>
<script type="text/javascript">
$(function() {
function log() {
var str = "";

plupload.each(arguments, function(arg) {
var row = "";

if (typeof(arg) != "string") {
plupload.each(arg, function(value, key) {
// Convert items in File objects to human readable form
if (arg instanceof plupload.File) {
// Convert status to human readable
switch (value) {
case plupload.QUEUED:
value = 'QUEUED';
break;

case plupload.UPLOADING:
value = 'UPLOADING';
break;

case plupload.FAILED:
value = 'FAILED';
break;

case plupload.DONE:
value = 'DONE';
break;
}
}

if (typeof(value) != "function") {
row += (row ? ', ': '') + key + '=' + value;
}
});

str += row + " ";
} else {
str += arg + " ";
}
});

$('#log').val($('#log').val() + str + "\r\n");
}

$("#uploader").pluploadQueue({
// General settings
runtimes: 'html5,gears,browserplus,silverlight,flash,html4',
url: 'uploadfile',
max_file_size: '10mb',
chunk_size: '1mb',
unique_names: true,

// Resize images on clientside if we can
resize: {width: 320, height: 240, quality: 90},

// Specify what files to browse for
filters: [
{title : "Image files", extensions : "jpg,gif,png"},
{title : "Zip files", extensions : "zip"},
{title : "Text files", extensions : "txt"},
{title : "excel files", extensions : "xls"},
{title : "PDF files", extensions : "pdf"}
],

// Flash/Silverlight paths

// PreInit events, bound before any internal events
preinit: {
Init: function(up, info) {
log('[Init]', 'Info:', info, 'Features:', up.features);
},

UploadFile: function(up, file) {
log('[UploadFile]', file);

// You can override settings before the file is uploaded
// up.settings.url = 'upload.php?id=' + file.id;
// up.settings.multipart_params = {param1: 'value1', param2: 'value2'};
}
},

// Post init events, bound after the internal events
init: {
Refresh: function(up) {
// Called when upload shim is moved
log('[Refresh]');
},

StateChanged: function(up) {
// Called when the state of the queue is changed
log('[StateChanged]', up.state == plupload.STARTED ? "STARTED": "STOPPED");
},

QueueChanged: function(up) {
// Called when the files in queue are changed by adding/removing files
log('[QueueChanged]');
},

UploadProgress: function(up, file) {
// Called while a file is being uploaded
log('[UploadProgress]', 'File:', file, "Total:", up.total);
},

FilesAdded: function(up, files) {
// Callced when files are added to queue
log('[FilesAdded]');

plupload.each(files, function(file) {
log('  File:', file);
});
},

FilesRemoved: function(up, files) {
// Called when files where removed from queue
log('[FilesRemoved]');

plupload.each(files, function(file) {
log('  File:', file);
});
},

FileUploaded: function(up, file, info) {
// Called when a file has finished uploading
log('[FileUploaded] File:', file, "Info:", info);
},

ChunkUploaded: function(up, file, info) {
// Called when a file chunk has finished uploading
log('[ChunkUploaded] File:', file, "Info:", info);
},

Error: function(up, args) {
// Called when a error has occured

// Handle file specific error and general error
if (args.file) {
log('[error]', args, "File:", args.file);
} else {
log('[error]', args);
}
}
}
});

$('#log').val('');
$('#clear').click(function(e) {
e.preventDefault();
$("#uploader").pluploadQueue().splice();
});
});
</script>
</body>
</html>


















Step 4:

Write Code On Servlet


 boolean isMultipart = ServletFileUpload.isMultipartContent(request);

   if (isMultipart) {
        FileItemFactory factory = new DiskFileItemFactory();
        ServletFileUpload upload = new ServletFileUpload(factory);

        try {
            List items = upload.parseRequest(request);
            System.out.println("items=="+items);
            Iterator iterator = items.iterator();
            while (iterator.hasNext()) {
                FileItem item = (FileItem) iterator.next();
                System.out.println("item=="+item);
                if (!item.isFormField()) {
                    String fileName = item.getName();
                    fileName=fileName;
                    fileName=fileName.replaceAll("\\s","");
                    System.out.println("fileName=="+fileName);

                    String root = getServletContext().getRealPath("/");
                    System.out.println("root=="+root);
                 
                    File path = new File(root + "/Report");
                    File path1 = new File("E:\\Report");
                    System.out.println("path=="+path);
                 
                                     
                 
                    File file2 = new File("C:\\Users\\Bharat\\
                                             workspace\\Juno Eclipse\\23.04.2013\\Project
                                              \\WebContent\\Report");
                    if (!file2.exists()) {
                    file2.mkdir();
                    }
                 
                 
                 
                if (file2.exists()) {
                File file1 = new File("C:\\Users\\Bharat\\workspace
                                                          \\Juno Eclipse\\23.04.2013\\Project
                                                             \\WebContent\\Report\\"+millisec);
                if (file1.mkdir()) {
                System.out.println("Directory is created!");
                File uploadedFile = new File(file1 + "/" + fileName);
                item.write(uploadedFile);
               
                } else {
                System.out.println("Failed to create directory!");
                }
                }
                 
                       String fid="http://localhost:8080/Project/Report/"+millisec+"/"+fileName;
                   session.setAttribute("fileName", fileName);
                 
                   session.setAttribute("fileID", fid);
               
                 
                        File uploadedFile = new File(file2 + "/" + fileName);
                   // File uploadedFile = new File(path1 + "/" +"/"+name+"/"
                                    +"/"+currDate+"/"+ fileName);
                    System.out.println(uploadedFile.getAbsolutePath());
                  //  item.write(uploadedFile);
                    System.out.println("sucess fully uploding.....");
                 
             
                   /* if (path.exists()) {
                        boolean status = path.mkdirs();
                    }
                    */
               
                File f=new File("C:\\Users\\Bharat\\workspace
                                           \\Juno Eclipse\\23.04.2013\\Project
                                           \\Report\\"+millisec+"\\"+fileName);
                    String file_path="C:\\Users\\Bharat
                                                       \\workspace\\Juno Eclipse\\23.04.2013\\Project\\Report
                                                      \\"+millisec+"\\"+fileName;
                    file_path=file_path.replace("\\", "/");
                    //File uploadedFile = new File(path2 + "/" + fileName);
                   // System.out.println("uploadedFile=="+uploadedFile);
                  /*  File uploadedFile = new File(path1 + "/" + fileName);
                   // File uploadedFile = new File(path1 + "/" +"/"+name+"/"+"/"+currDate+"/"+ fileName);
                    System.out.println(uploadedFile.getAbsolutePath());
                    item.write(uploadedFile);
                    System.out.println("sucess fully uploding.....");*/
                 
                    try
            {
            con = DBManager.openDBConnection();
            con.setAutoCommit(false);
            st = con.createStatement();
            String query = "insert into uploading_file(File,UserName,filename,filepath,FileID
                                                              ,Uplodated_Datetime,activity,Compliance_date)
                                                             values ('"+f+"','"+name+"','"+fileName+"','"+file_path+"',
                                                          '"+millisec+"','"+currDate+"','"+Activity+"','"+Compliance_date+"')";
            System.out.println("query = "+query);
            int ack = st.executeUpdate(query);
            //System.out.println("ack = "+ack);
            //System.out.println("succuess with first query.");
            }
                    catch(Exception e)
                    {
                    e.printStackTrace();
                    }
                   // out.print("sucess");
                }
             
            }
        } catch (FileUploadException e) {
            e.printStackTrace();
        } catch (Exception e) {
            e.printStackTrace();
        }
 
    }
   else
   {
    System.out.println("UN sucess  uploding.....");
    //out.print("Not Uploading....");
   }


try {
con.commit();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}


Step 5:

Click on Upload Button 















check on Folder Upload file