Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • 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>
</select>

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

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

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+"')");
forward=mapping.findForward("check");

// 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