• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

How to do File Upload using struts with db2?

ronney singh
Ranch Hand
Posts: 40
IBM DB2 Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello Everyone,
I am making this form in jsp:-

<form action="editmovie.do">
Movie Name: <input type="text" name="moviename" size="40">

Movie Certification:
<select name="certification">
<option value="A">A</option>
<option value="U">U</option>
<option value="U/A" selected>U/A</option>

Movie Details:
<textarea rows="5" cols="40" name="details"></textarea>

<input type="submit" name="Submit">

I want to give an option to user to upload a movie image. I want to do this with same ActionForm(editmovie.do) in this jsp form.
Please help me with this and please tell me that can I use different data type other than blob in DB2.
What if I want to store only name or link of image in database?
Action Class

package booktickets.actions;

import java.sql.ResultSet;
import java.sql.Statement;
import java.sql.Connection;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.apache.struts.action.Action;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;
import org.apache.struts.action.ActionMessage;
import org.apache.struts.action.ActionMessages;

import Singleton.SingltonConntn;
import booktickets.forms.EditFormBean;

* @version 1.0
* @author
public class EditmovieAction extends Action


public ActionForward execute(ActionMapping mapping, ActionForm form,
HttpServletRequest request, HttpServletResponse response)
throws Exception {

ActionMessages errors = new ActionMessages();
ActionForward forward = new ActionForward(); // return value

try {
EditFormBean e=(EditFormBean) form;
String mname = e.getMoviename();
String mcer=e.getCertification();
String mdet=e.getDetails();
Connection con=SingltonConntn.getConn();
Statement st=con.createStatement();
st.executeUpdate("insert into movies (m_name,m_certification,m_details) values('"+mname+"','"+mcer+"','"+mdet+"')");

// do something here

} catch (Exception e) {

// Report the error using the appropriate name and ID.
errors.add("name", new ActionMessage("id"));


// If a message is required, save the specified key(s)
// into the request for use by the <struts:errors> tag.

if (!errors.isEmpty()) {
saveErrors(request, errors);

// Forward control to the appropriate 'failure' URI (change name as desired)
// forward = mapping.findForward("failure");

} else {

// Forward control to the appropriate 'success' URI (change name as desired)
// forward = mapping.findForward("success");


// Finish with
return (forward);


please tell me the changes I have to do.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic