Forum:

upload data and image at the same time

Ranch Hand

Posts: 98

posted 11 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Hello
I need to send data from a form to a database but... this form have a field input also. I trying to send all the data together (image and input text values) but I can't.
Is to say in the database I just get the image but not the input text values! I read in someplace that is not possible but...I had seen that working fine in some websites!
What is wrong?
Here the code that I am -testing:
1)the jsp form:

<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
   "http://www.w3.org/TR/html4/loose.dtd">

<html>
    <form enctype="multipart/form-data" action="subirImagen" method="post">
        <br><br><br>
        <center>
            <table bgcolor="violet" border="1" >
                <tr>
                    <center>
                        <td colspan="2"><p align="center"><B>Upload File</B>
                    </td></center>
                </tr>
                 <tr>
                    <td><b>Cedula: </b></td>
                    <td><input type="text" name="cedula" value="" /></td>
                </tr>
                 <tr>
                    <td><b>Nombres </b></td>
                    <td><input type="text" name="nombre" value="" /></td>
                </tr>
                <tr>
                    <td><b>Choose file:</b></td>
                    <td><INPUT NAME="file" TYPE="file"></td>
                </tr>
                
                <tr>
                    <td colspan="2"><p align="right"><input type="submit" value="Send File" ></p></td>
                </tr>
            </table>
        </center>
        <a href="mostrar.jsp">Mostrar Imagen</a>
    </form>
</html>

2) and the uploadimage servlet

import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;

public class subirImagen extends HttpServlet {

@Override
    public void doPost(HttpServletRequest request, HttpServletResponse response) throws IOException, ServletException {

PrintWriter out = response.getWriter();
        String contentType = request.getContentType();
        String nombre = request.getParameter("nombre");
        String cedula = request.getParameter("cedula");
        System.out.println("cedula----" + cedula);
        System.out.println("nombre----" + nombre);

if ((contentType != null) && (contentType.indexOf("multipart/form-data") >= 0)) {
            DataInputStream in = new DataInputStream(request.getInputStream());
            int formDataLength = request.getContentLength();
            byte dataBytes[] = new byte[formDataLength];
            int byteRead = 0;
            int totalBytesRead = 0;
            while (totalBytesRead < formDataLength) {
                byteRead = in.read(dataBytes, totalBytesRead, formDataLength);
                totalBytesRead += byteRead;
            }

String file = new String(dataBytes);
            String saveFile = file.substring(file.indexOf("filename=\"") + 10);
            saveFile = saveFile.substring(0, saveFile.indexOf("\n"));
            saveFile = saveFile.substring(saveFile.lastIndexOf("\\") + 1, saveFile.indexOf("\""));
            int lastIndex = contentType.lastIndexOf("=");
            String boundary = contentType.substring(lastIndex + 1, contentType.length());

int pos;
            pos = file.indexOf("filename=\"");
            pos = file.indexOf("\n", pos) + 1;
            pos = file.indexOf("\n", pos) + 1;
            pos = file.indexOf("\n", pos) + 1;
            int boundaryLocation = file.indexOf(boundary, pos) - 4;
            int startPos = ((file.substring(0, pos)).getBytes()).length;
            int endPos = ((file.substring(0, boundaryLocation)).getBytes()).length;

FileOutputStream fileOut = new FileOutputStream(saveFile);
            fileOut.write(dataBytes, startPos, (endPos - startPos));
            fileOut.flush();
            fileOut.close();

out.println("Archivo cargando satifactoriamente :" + saveFile);

Connection connection = null;
            String connectionURL = "jdbc:mysql://spontedev:3306/imagenes";
            ResultSet rs = null;
            PreparedStatement psmnt = null;
            FileInputStream fis;
            try {
                Class.forName("com.mysql.jdbc.Driver").newInstance();
                connection = DriverManager.getConnection(connectionURL, "root", "root");
                File f = new File(saveFile);
                psmnt = connection.prepareStatement("insert into imagenes(cedula, nombre, imagen) values(?,?,?)");
                fis = new FileInputStream(f);
                psmnt.setString(1, cedula);
                psmnt.setString(2, nombre);
                psmnt.setBinaryStream(3, (InputStream) fis, (int) (f.length()));
                int s = psmnt.executeUpdate();
                if (s > 0) {
                    System.out.println("Uploaded successfully !");
                } else {
                    System.out.println("unsucessfull to upload file.");
                }
            } catch (Exception e) {
                e.printStackTrace();
            }
        }
    }
}

NOTE: the 2 values showed with System.out.print are null.

Please give me an idea.

THANKS

Stefan Evans

Bartender

Posts: 1845

posted 11 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Much as you may hate it, my suggestion would be to throw away half of this code, and use a library to parse the response for you.

The commons fileupload component is a commonly used one.
That library enables you to read both the uploaded file and the parameters sent along with it.

jhon masco

Ranch Hand

Posts: 98

posted 11 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Stefan Evans wrote:Much as you may hate it, my suggestion would be to throw away half of this code, and use a library to parse the response for you.

The commons fileupload component is a commonly used one.
That library enables you to read both the uploaded file and the parameters sent along with it.

Thanks Stefan
I will read about Jakarta FileUpload. Already I had seen it before but I never thinked that I would be diffcult submit values an images at the same time.
I will try these examples: example1 and example2
I hate when the examples just show how submit images and not data too!!!
If anyone know other alternative please let me know.
Gracias

sudhir nim

Ranch Hand

Posts: 212

I like...

posted 11 years ago

1
Number of slices to send:

Optional 'thank-you' note:

Send

You can read the other form parameters like this

Again, if you are just trying out, or if you have choice to use tomcat 7 (if you are starting a new project or just learning servlets),
Try out the @MultipartConfig and built in file upload support in servlet 3.0 Spec.
It has made life really easier, you will not need any additional library like commons file upload or any other multipart parser.

[Servlet tutorial] [Servlet 3.0 Cook Book]

jhon masco

Ranch Hand

Posts: 98

posted 11 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

sudhir nim wrote:Again, if you are just trying out, or if you have choice to use tomcat 7 (if you are starting a new project or just learning servlets),
Try out the @MultipartConfig and built in file upload support in servlet 3.0 Spec.
It has made life really easier, you will not need any additional library like commons file upload or any other multipart parser.

Thanks Sudhir

Nice tips specially @MultipartConfig. I will continue trying fileupload library while I change to tomcat 7.
Also I had found other good tips here if anyone need help must check the link.

Thank you very much.

jhon masco

Ranch Hand

Posts: 98

posted 11 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Hi again
Here the solution using jakarta fileupload library

Luck! and thanks

Politics is a circus designed to distract you from what is really going on. So is this tiny ad:

Free, earth friendly heat - from the CodeRanch trailboss

https://www.kickstarter.com/projects/paulwheaton/free-heat