struts 1 code for file download from database (Struts forum at Coderanch)

Greenhorn

Posts: 11

posted 9 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Please help me with the code to upload and then download file from database ,on select of month & year from jsp page and then click on download button,i am using procedures for db
please help,i am new to struts

Deepa Siva

Greenhorn

Posts: 11

posted 9 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Joe Ess wrote:Welcome to the JavaRanch.
What have you tried so far?

I am getting null while returning

struts config.xml

DBRankUpload.jsp

<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>

<%@ taglib uri="/WEB-INF/tags/struts-html.tld" prefix="html"%>
<%@ taglib uri="/WEB-INF/tags/struts-logic.tld" prefix="logic"%>
<%@ taglib uri="/WEB-INF/tags/struts-bean.tld" prefix="bean"%>

<%@page import = "com.dao.*,com.common.*,java.util.*, java.text.SimpleDateFormat" %>
<%@page import="com.common.JScript" %>
<%@ page import="java.sql.* , oracle.jdbc.driver.OracleTypes,oracle.sql.*" %>
<%@page import="java.io.*"%>
<%@page import="javax.servlet.*"%>
<%@page import="java.text.DecimalFormat" %>
<%@ page import="com.form.FileUploadForm" %>
<% 
    String username = (String) session.getAttribute(Constants.USER_NAME); 
    String comname = (String) session.getAttribute(Constants.COM_NAME);
	String userrole=(String) session.getAttribute(Constants.USER_ROLE);
	String user=(String) session.getAttribute(Constants.USER_NAME);
	String comcd=(String) session.getAttribute(Constants.COM_CODE);
	CallableStatement cstmt = null;
	ResultSet rs= null;

%>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html:html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>MEA - DistributorRank</title>
<link rel="stylesheet" type="text/css" href="../css/layout.css"/>
<link rel="stylesheet" type="text/css" href="../css/reset.css"/>
<script type="text/javascript" src="../Scripts/jquery.js"></script>
<link rel=stylesheet type="text/css" href="../css/stylebbs.css">

</script>

<%
String month=request.getParameter("month");
String year=request.getParameter("year");
out.println("year" +year);
%>

</script>
</head>
<table  >
<tr>
<td >
<img     />
</td>
<td  >
<img     />
</td>
</tr>

<tr>
<td  >
<a >Logout</a>
<img    />
<%=username%>(<%=comname%>)
</td>
</tr>
</table>
<html:form  method="post" action="/Upload">
<table border="0"      >
<tr >
<tr>
   <td >
	
		        <table border="0"       >
				<img      />
                <tr> <img      ><%= new java.util.Date()%> /> </tr>
               <tr>

<tr    > 	<select id="year" style="WIDTH: "100px" name="year">
    </select> 
      
      <select id="month" size="1" name="month">
      <option value="01" >January</option>
 
      <option value="02">February</option>
 
      <option value="03">March</option>
 
      <option value="04">April</option>
 
      <option value="05">May</option>
 
      <option value="06">June</option>
 
      <option value="07">July</option>
 
      <option value="08">August</option>
 
      <option value="09">September</option>
 
      <option value="10">October</option>
 
      <option value="11">November</option>
 
      <option value="12">December</option>
    </select>
	<input type="image"  src="../images/upload.jpg" width="80" height="30" align="right" alt="submit"/>
     
		</tr>
		<tr> <img      /></tr>

upload_page.jsp

<%@ taglib uri="/WEB-INF/tags/struts-html.tld" prefix="html"%>
<%@ taglib uri="/WEB-INF/tags/struts-logic.tld" prefix="logic"%>
<%@ taglib uri="/WEB-INF/tags/struts-bean.tld" prefix="bean"%>

<%@page import = "com.dao.*,com.common.*,java.util.*, java.text.SimpleDateFormat" %>
<%@page import="com.common.JScript" %>
<%@ page import="java.sql.* , oracle.jdbc.driver.OracleTypes,oracle.sql.*" %>
<%@page import="java.io.*,java.lang.*"%>
<%@page import="javax.servlet.*"%>
<%@page import="java.text.DecimalFormat" %>
<%@ page import="java.sql.*" %>
<%@ page import="com.form.FileUploadForm" %>
 <script type="text/javascript" src="../Scripts/swfobject_moodified.js"></script>

</script>

<% 
    String username = (String) session.getAttribute(Constants.USER_NAME); 
    String comname = (String) session.getAttribute(Constants.COM_NAME);
	String userrole=(String) session.getAttribute(Constants.USER_ROLE);
	String user=(String) session.getAttribute(Constants.USER_NAME);
	String comcd=(String) session.getAttribute(Constants.COM_CODE);
	CallableStatement cstmt = null;
	ResultSet rs= null;

%>
	
	
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<HTml>
<HEAD><TITLE>Display file upload form to the user</TITLE></HEAD> 
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<link rel="stylesheet" type="text/css" href="../css/layout.css"/>
<link rel="stylesheet" type="text/css" href="../css/reset.css"/>
<script type="text/javascript" src="../Scripts/jquery.js"></script>
<link rel=stylesheet type="text/css" href="../css/stylebbs.css">

</script>
 <%
String month=request.getParameter("month");
String year=request.getParameter("year");
out.println("year" +year);
%>
</head>
<table  >
<tr>
<td >
<img     />
</td>
<td  >
<img     />
</td>
</tr>

<tr>
<td  >
<a >Logout</a>
<img    />
<%=username%>(<%=comname%>)
</td>
</tr>
</table>
<html:form method="post" action="">
<table border="0"      >
<tr >
<tr>
   <td >
	
		        <table border="0"       >
				<img      />
                <tr> <img       /> </tr>
               <tr>
	<tr    > 	<select id="year" style="WIDTH: "100px" name="year">
    </select> 
      
      <select id="month" size="1" name="month">
      <option value="01" >January</option>
 
      <option value="02">February</option>
 
      <option value="03">March</option>
 
      <option value="04">April</option>
 
      <option value="05">May</option>
 
      <option value="06">June</option>
 
      <option value="07">July</option>
 
      <option value="08">August</option>
 
      <option value="09">September</option>
 
      <option value="10">October</option>
 
      <option value="11">November</option>
 
      <option value="12">December</option>
    </select>
<BODY bgcolor="#99CCCC">
        <p> </p>

<br>
        <h4 align="center">Select File to Upload</h4>
        <form id="form1" enctype="multipart/form-data" action="/UploadFile" method="post">
            <table >

<tr>
                    <td>Browse File  </td>
                    <td><input align="center" type="file"  name="csvfile" />
                </tr>
            </table>	
            <p/>
            <center><input align="center" type="submit" value="Upload File"/></cente></body>
		
</html:form>

Deepa Siva

Greenhorn

Posts: 11

posted 9 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Joe Ess wrote:I added Code Tags to your post to make it easier to read. Please use them in the future.

I am getting null while returning

Can you narrow that down for us? It's always a good idea to post a stack trace since that has the line number an error occurred on.
It's also a good idea to try to Isolate The Problem before posting several hundred lines of code. You have a lot going on in the code above. The more specific you can make your example code, the more help we can be.

Action Class is returning null pointer exception ,where it should return success
this is my struts config.xml