how to upload image from jsp to mssql

hi there!!, i'm using jsp and servlet to upload images to the database. however i have difficulty in uploading database. hope u can help

in my database: i have imagetbl that contain image column(to store the image) as varbinary and fileimage(to store the directory of the image) as while as imageID(primary key)

inside netbeans: image.jsp, uplaodimage.java(servlet)

View Answers

July 23, 2012 at 11:46 AM

Here is a code that uploads any file through a servlet and save it to mysql database.

1)page.jsp:

<%@ page language="java" %>
<HTML>
<FORM ENCTYPE="multipart/form-data" ACTION="../UploadServlet" METHOD=POST>
<center>
<table border="0" bgcolor=#ccFDDEE>
<tr>
<center><td colspan="2"><B>UPLOAD THE FILE</B><center></td>
</tr>
<tr><td colspan="2" > </td></tr>
<tr><td><b>Choose the file To Upload:</b></td>
<td><INPUT NAME="file" TYPE="file"></td>
</tr>
<tr><td colspan="2" > </td></tr>
<tr><td colspan="2"><input type="submit" value="Send File"> </td></tr>
<table>
</center>
</FORM>
</HTML>

2)UploadServlet.java:

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

public class UploadServlet extends HttpServlet{ 
     public void doPost(HttpServletRequest request,HttpServletResponse response) throws ServletException,IOException {
     response.setContentType("text/html");
     PrintWriter out = response.getWriter();

    String saveFile="";
    String contentType = request.getContentType();
    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);
    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;
    File ff = new File(saveFile);
    FileOutputStream fileOut = new FileOutputStream(ff);
    fileOut.write(dataBytes, startPos, (endPos - startPos));
    fileOut.flush();
    fileOut.close();
    out.println("You have successfully upload the file:"+saveFile);
    Connection connection = null;
    String connectionURL = "jdbc:mysql://localhost:3306/test";
    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 file(file_data) values(?)");
    fis = new FileInputStream(f);
    psmnt.setBinaryStream(1, (InputStream)fis, (int)(f.length()));
    int s = psmnt.executeUpdate();
    if(s>0){
    System.out.println("Uploaded successfully !");
    }
    else{
    System.out.println("Error!");
    }
    }
    catch(Exception e){
        e.printStackTrace();
        }
    }
  }
}

Advertisements

how to store image upload path to mssql database
how to store image upload path to mssql database hi there!!, i need help in storing the image upload path into the database. basically i just use file select to upload the image from jsp to database. however when i click submit

image upload with jsp from form
image upload with jsp from form hi i used the code specified in your following post http://www.roseindia.net/answers/viewqa/JSP-Servlet/9749-image...) org.apache.jsp.upload_jsp._jspService(upload_jsp.java:85

how to upload an image from a jsp page to a mysql database table using jsp
how to upload an image from a jsp page to a mysql database table using jsp how to upload an image from a jsp page to a mysql database table using jspstrong text

How display a Image on servlet from file upload - JSP-Servlet
How display a Image on servlet from file upload Dear Sir, I were ask a question that How display the Image on servlet through file upload. Today I...; Hi friend, I am sending running code. Image upload page

How display a image on servlet from file upload - JSP-Servlet
How display a image on servlet from file upload Dear Sir, My Question is: How display a image on servlet from file upload Your Answer: Hi friend, public class FileNotFoundException extends IOException Signals

How display a image on servlet from file upload - JSP-Servlet
How display a image on servlet from file upload Dear Sir, My issue is: How display a image on servlet from file upload I receive your answer today... upload page Employee Image

How display a Image on Servlet from file upload - JSP-Servlet
How display a Image on Servlet from file upload Dear Sir, My requirement is I want to display a Image on Servlet from File Upload... also install I the Live HTTP headers 0.14 from Google in Firefox. I run

Image upload file - JSP-Servlet
Image upload file I want a code for image upload jsp or servlet. Hi friend, For image upload jsp or servlet visit to : http://www.roseindia.net/jsp/file_upload/employee_upload_profile_image.shtml http

how to fetch image from mysql using jsp
how to fetch image from mysql using jsp how to fetch image from mysql using jsp

upload image using JSP Hibernate
upload image using JSP Hibernate sir, I want to take image from user and save to database(MYSQL) using Hibernate and JSP Thanks in advance

How to store and retrieve image from database in JSP?
How to store and retrieve image from database in JSP? Hi, In one of my application I have to store and then display the image in JSP. How to store and retrieve image from database in JSP? Thanks HI, You can use

How to retrieve image from mysql database in JSP?
How to retrieve image from mysql database in JSP? Hi, I need JSP same codes for learning to get image which is stored in MySQL Database. How to retrieve image from mysql database in JSP? Thanks Hi, You can write

How to retrieve blob image from database in JSP?
How to retrieve blob image from database in JSP? Hello, JSP is used... the blog image from database. How to retrieve blob image from database in JSP? Hi, Please check the tutorial Retrieve image from database using

image upload and stored in database - JSP-Servlet
image upload and stored in database How can i upload a image and store that image in a database

Multiple image upload using JSP
Multiple image upload using JSP I have written a code to upload the multiple images using jsp, but when I execute this code, it throws Corrupt form...; fileSavePath_upload_user_dir = fileSavePath_upload_dir + > File.separator + user_image

How to retrieve image from database using jsp and servlet?
How to retrieve image from database using jsp and servlet? Hi, I am trying to find code for displaying the image from database in a JSP page. How to retrieve image from database using jsp and servlet

retrieving newly added records from mssql database and display in a jsp
retrieving newly added records from mssql database and display in a jsp�... from mssql database table and display those records in a jsp.And i have to delete these 10 records from the jsp and retrieve the next recently added 10 records

How to display image in jsp from database using Servlet?
How to display image in jsp from database using Servlet? Hi, How to display image in jsp from database using Servlet? Thanks Hi, You will find code and example program at Retrieve image from database using Servlet

How to retrieve single row from MSSQL
How to retrieve single row from MSSQL Hello sir, Sir i had created the table in MSSQL,the fields with patient name,pid,Dname(doctor name... created table in MSSQL,GUI in eclipse.How to achieve it.. Thanks & Regards

how to display image and text in single jsp page from the mysql database
how to display image and text in single jsp page from the mysql database hello please help me to display the image and text in single jsp page from mysql database if have any reference code please send me Thanks in advance

Image upload in mysql database using jsp servlet
Image upload in mysql database using jsp servlet Hello, I need code to insert image in mysql database, I have seen the code which is already in your portal but it is not inserting image into database it save in the folder

insert name city and upload image in database using mysql and jsp
insert name city and upload image in database using mysql and jsp insert name city and upload image in database using mysql and jsp

passing the form values with image upload - JSP-Servlet
passing the form values with image upload Hii . I want to get the solution for passing values with an image uploading form. I cant access the request values from the fields rather than image . I want to know how can cut

How to copy an jpeg image from one folder to other folder using jsp
How to copy an jpeg image from one folder to other folder using jsp hello, i am creating photo gallery where from admin side i allow admin to browse... be in my image folder...so,How to copy an jpeg image from one folder to other

image upload and stored in database - JSP-Servlet
image upload and stored in database How can i upload a image and store that image in a database Hi Friend, Try the following code: 1)page.jsp: Display file upload form to the user UPLOAD

Upload Image to Database through Servlet - JSP-Servlet
Upload Image to Database through Servlet Hello, I make a application from where I upload the Image from local disk then store in DB.Before storing the Image in DB I want to check this program. I include the commons

Upload and display image and text records using JSP and Oracle
Upload and display image and text records using JSP and Oracle Hi all, I'm using JSP and Oracle 10g. I could retrieve and display records from database. But i couldnot retrieve and display image. I want to store

image upload in webapp/upload folder
image upload in webapp/upload folder sir i want to store upload image in my project directory WebApp/Upload_image/ pls send the jsp servlet code when i upload the image one error found "system cannot found the specified path

upload image
upload image I want to upload image from user using Jdbc connectivity and servlets and Html pages. I tried code but getting error using multi parts,so please send the code

upload an image
upload an image Hello, i would like to upload an image to the database. how can i do it? what field type should i set in the database? thanx

How to copy an jpeg image from one folder to other folder using jsp
How to copy an jpeg image from one folder to other folder using jsp How to copy an image from one folder to another folder using jsp

upload image
upload image how can i retreive image from mysql using jsp...(connectionURL, "root", "root"); psmnt = connection.prepareStatement("SELECT image FROM save...' is image id from the table rs = psmnt.executeQuery(); if(rs.next()) { byte

how to upload and download images using buttons in jsp?
how to upload and download images using buttons in jsp? how to upload and download images using buttons in jsp

How to upload files to server using JSP/Servlet?
How to upload files to server using JSP/Servlet? How to upload files to server using JSP/Servlet

Upload Image and save in database using jsp-servlet mvc
Upload Image and save in database using jsp-servlet mvc Here is my code.. In jsp ... <form name=frm method="post" action="Device"> <table> <tr><TD ><B>Upload Image</B><

how to set the image and address in single row when genearting pdf fil from jsp - JSP-Servlet
how to set the image and address in single row when genearting pdf fil from jsp i need to set the image is left side and right side is address when genrating the pdf file from jsp Hi Friend, Try the following code

Text Editor Image upload
Text Editor Image upload how to browse an image from text editor instead of giving url of particular image using javascript

image upload
image upload How to access image file from database using jsp? �... rs=st.executeQuery("SELECT images FROM image WHERE id = 1"); if(rs.next...("image/jpeg"); while((size=sImage.read(bytearray))!= -1

Retrview image from sqlserver2000 and display in jsp - JSP-Servlet
Retrview image from sqlserver2000 and display in jsp How to retreview image from sqlserver2000 to jsp? pls give the solution i am using Tomcat 4... for more information, http://www.roseindia.net/jsp/ Thanks

retrive image from database using jsp without stream
retrive image from database using jsp without stream How to retrive image from database using jsp without stream like (inputStream

how to use image tag in jsp
how to use image tag in jsp How to use image tag in JSP

Ads