servlet image upload issue

[fredrick esedo]

Hi everyone please i need a help. This code was used to upload image to a directory
as well as storing the image name eg fred.gif into the database. But when i tried to upload
the image itself now into the database it refuses to get uploaded
the code i used for the substitution is as follow

    
File database_filename=new File(pathname_dir);
fis=new FileInputStream(database_filename);
PreparedStatement ps = conn.prepareStatement("insert into test (fname,image) values (?,?)");
ps.setString(1,database_filename.getName());
ps.setBinaryStream(2,fis,database_filename.length());

Here is my main code thanks

   

import java.io.*;
import java.sql.*;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.ServletInputStream.*;
import java.io.PrintWriter;

public class UploadFile extends HttpServlet {

public void doPost(HttpServletRequest req,HttpServletResponse res)
{

try{

Class.forName("com.mysql.jdbc.Driver");
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost/love?user=root&password=root");
PrintWriter out=res.getWriter();

//out.println("<br>Content type is :: " +contentType);
//to get the content type information from JSP Request Header
String contentType = req.getContentType();
int flag=0;
FileInputStream fis=null;
FileOutputStream fileOut=null;
//here we are checking the content type is not equal to Null and as well as the passed data from mulitpart/form-data is greater than or equal to 0
if ((contentType != null) && (contentType.indexOf("multipart/form-data") >= 0))
{
DataInputStream in = new DataInputStream(req.getInputStream());
//we are taking the length of Content type data
int formDataLength = req.getContentLength();
byte dataBytes[] = new byte[formDataLength];
int byteRead = 0;
int totalBytesRead = 0;

//this loop converting the uploaded file into byte code
while (totalBytesRead < formDataLength) {
byteRead = in.read(dataBytes, totalBytesRead,formDataLength);
totalBytesRead += byteRead;
}

String file = new String(dataBytes);
//for saving the file name
String saveFile = file.substring(file.indexOf("filename=\"") + 10);
saveFile = saveFile.substring(0, saveFile.indexOf("\n"));
out.println("savefiledddd    "+saveFile);
int extension_save=saveFile.lastIndexOf("\"");
String extension_saveName=saveFile.substring(extension_save);

//Here we are invoking the absolute path out of the encrypted data

saveFile = saveFile.substring(saveFile.lastIndexOf("\\")+ 1,saveFile.indexOf("\""));
int lastIndex = contentType.lastIndexOf("=");
String boundary = contentType.substring(lastIndex + 1,contentType.length());
int pos;

//extracting the index of file
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;

out.println("savefile"+saveFile);

int file_No=22;
String pathname_dir="C:\\Tomcat 6.0\\"+saveFile;
File filepath=new File(pathname_dir);
out.println("filepath_  "+filepath);
fileOut = new FileOutputStream(filepath);
fileOut.write(dataBytes, startPos, (endPos - startPos));
fileOut.flush();
out.println("<h1> your files are saved</h1></body></html>");
out.close();

File database_filename=new File(pathname_dir);
fis=new FileInputStream(database_filename);
PreparedStatement ps = conn.prepareStatement("insert into test (fname) values (?)");
ps.setString(1,database_filename.getName());
ps.executeUpdate();
ps.close();
flag=1;

}

if(flag==1)
{
fileOut.close();
fis.close();
}
}catch(Exception e)
{
System.out.println("Exception Due to"+e);
e.printStackTrace();
}
}
}



 

[Devaka Cooray]

fredrick esedo wrote:the image itself now into the database it refuses to get uploaded

Are you getting any exception, or what's happen?

[fredrick esedo]

Thank you very much sir for your willingness to help.
There is no exception.the problem is that immediately i substituted this code below in and run the programme
nothing will be submitted into my database again.But if i should run the code as it is ,only the image name eg fred.gif
will be uploaded into my database may the problem can be from my SQL STATEMENT that i used.Please i need your help as even anywhere i can get the servlet code that will do the same image upload will be honured.
thanks and have a wonderful day

  
File database_filename=new File(pathname_dir);
fis=new FileInputStream(database_filename);
PreparedStatement ps = conn.prepareStatement("insert into test (fname,image) values (?,?)");
ps.setString(1,database_filename.getName());
ps.setBinaryStream(2,fis,database_filename.length());