Forum:

how to call stored procedure through jsp code

Greenhorn

Posts: 5

posted 9 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Hi all,
I have a .csv file ,and I have written a jsp code which uploads csv file to a local folder .
Now I want to upload that csv file to database using stored procedure.
Below I have included the code which uploads the csv to database.

<%@page import="org.apache.commons.fileupload.*,java.util.*,java.io.*"%>
<%@page import="java.sql.*"%>
<!DOCTYPE HTML>
<html>
<head>
</head>
<body>
<img border="1" src="img/tss.JPG" alt="portal" />
<br><br><br><br><br><br>
<%
try{
				Connection connection = null;
				String connectionURL = "jdbc:sqlserver://192.168.1.3\\SQLSERVER2008R2;databaseName=TestTally";
				Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver").newInstance();
				connection = DriverManager.getConnection(connectionURL, "sa", "admin_123");			 
				 CallableStatement cstmt = null;
   // JSP to handle  uploading
   
   // Create a new file upload handler 
   DiskFileUpload upload = new DiskFileUpload();
   
   // parse request
   List items = upload.parseRequest(request);
   
   // get uploaded file 
   FileItem  file = (FileItem) items.get(0);
   String source = file.getName();
   
   // get target filename
   FileItem  name = (FileItem) items.get(1);
   String  target = name.getString();
      
   File outfile = new File("D:\\Uploader Test\\" +  target);
   file.write(outfile);
   
   out.println("Upload Is Successful!");
   
   File f1 = new File("D:\\a.txt");
  
		if(f1.length()!=0)
		{
			/*FileOutputStream erasor = new FileOutputStream(f1);
			erasor.write((new String()).toByteArray());
			erasor.close(); */
			f1.delete();
		}
	 
		String str1=null;
        String str2=null;
        String str3=null;
		String v=null;
        int cnt=0,len1=0,len2=0;

//Creating Scanner instnace to read File in Java
		
        Scanner scnr = new Scanner(outfile);

//Reading each line of file using Scanner class
       
	   int lineNumber = 1;
       while(scnr.hasNextLine())
		{
            String line = scnr.nextLine();
            cnt=line.length();

for(int i=0;i<3;i++)
			{
				if (Character.isDigit(line.charAt(i)))
					str1=line;
				else
					str2=line;
			}

len1=str1.length();
			len2=str2.length();
			
			if(len1!=len2)
			{
				str3=str1+str2;

FileWriter fw = new FileWriter(f1.getAbsoluteFile(),true);
				BufferedWriter bw = new BufferedWriter(fw);
                       
				bw.write(str3);
                bw.newLine();

//out.println("done");

bw.close();
			}
			/*else
			{
				//copyFileUsingJava7Files(outfile,f1);
			}*/
				
				lineNumber++;
        }
	
					//call SP_Petty_Cash_Demo(?)
			
				  String SQL = "{call SP_Petty_Cash_Demo(?)}";
				  
				cstmt = connection.prepareCall (SQL);
				
				 ResultSet rs = cstmt.executeQuery();
				out.println(cstmt);
				cstmt.close();
%>
<script>
alert("file uploaded Succesfully");
</script>		
			
<%
//response.SendRedirect("homepage.jsp");
    }
	catch (Exception e) 
	{
			e.getMessage();
	}
%>
<div align="middle">
<a href="homepage.jsp"> Back to Homepage. </a>
</div>
</body>
</html>

thanks in advance.

Ulf Dittmer

Rancher

Posts: 43081

posted 9 years ago