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 button, the id in the database do increment by 1 however under the image column it state null.

i set my image data type as varchar

this is a sample of my code:

image.jsp

<%-- Document : image Created on : Jul 26, 2012, 9:00:33 PM Author : acer --%>

<%@page contentType="text/html" pageEncoding="UTF-8"%>

<html>
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
        <title>JSP Page</title>
    </head>
    <body>
<FORM ENCTYPE="multipart/form-data" ACTION="image2" METHOD=POST>

<table border="0" bgcolor=#ccFDDEE>
<tr>
<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="FileUpload" TYPE="file" value="./books/"></td>
</tr>
<tr><td colspan="2" > </td></tr>
<tr><td colspan="2"><input type="submit" value="Send File"> </td></tr>
<table>

    </FORM>
    </body>

</html>

image.java(Servlet)

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

protected void processRequest(HttpServletRequest request, HttpServletResponse response)
        throws ServletException, IOException {
    response.setContentType("text/html;charset=UTF-8");
    PrintWriter out = response.getWriter();
    try {
        String image = request.getParameter("file");


        Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
        String connURL = "jdbc:sqlserver://localhost:1433;"
                + "databaseName=Book Avenue Tables; user=sa; password=12345678;";
        Connection conn = DriverManager.getConnection(connURL);

        Statement stmt = conn.createStatement();

        String sqlStr = "INSERT INTO testimage(testimage)"
                + " VALUES ('" + image + "')";

        int rec = stmt.executeUpdate(sqlStr);
        if (rec > 0) {
           out.println("upload succesffully");






        }
    } catch (Exception e) {
        out.println(e);

    } finally {
        out.close();
    }
}

View Answers

July 27, 2012 at 5:19 PM

Here is a jsp code that allow the user to upload a file and save the file path to database.

1)form.jsp:

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

2)uploadFile.jsp:

<%@ page import="java.io.*,java.sql.*,java.util.zip.*" %>
<%
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("C:/UploadedFiles/"+saveFile);
FileOutputStream fileOut = new FileOutputStream(ff);
fileOut.write(dataBytes, startPos, (endPos - startPos));
fileOut.flush();
fileOut.close();
%><br><table border="2"><tr><td><b>You have successfully upload the file:</b>
<%out.println(saveFile);%></td></tr></table>
<%
Connection connection = null;
String connectionURL = "jdbc:mysql://localhost:3306/roseindia";
PreparedStatement psmnt = null;
try{
Class.forName("com.mysql.jdbc.Driver").newInstance();
connection = DriverManager.getConnection(connectionURL, "root", "root");
psmnt = connection.prepareStatement("insert into file(file_path) values(?)");
psmnt.setString(1, ff.getPath());
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 in folder and stored image path in mysql database using JSP
how to store image in folder and stored image path in mysql database using JSP how to store image in folder and stored image path in mysql database using JSP

How to store user name,city,state,image path into database and image into folder using jsp
How to store user name,city,state,image path into database and image into folder using jsp How to store user name,city,state,image path into database and image into folder using jsp

how to upload image from jsp to mssql
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

How to store image into database
How to store image into database Hi, all I want to store image into database using Java. Can anyone help me that how can i store image into database... through the following link How To Store Image Into MySQL Using Java

How to store an image in database
How to store an image in database Hi........... How to store an image in postgresql using a query. I mean tell me the way to store an image using datatype. I am using the datatype bytea but tell me how to insert the image

how to upload multiple files in jsp and saving the path in database and the file in folder
how to upload multiple files in jsp and saving the path in database and the file in folder how to upload multiple files in jsp and saving the path in database and the file in folder I have created a form for the upload of files

how to insert the physical path of an image in database - JDBC
how to insert the physical path of an image in database hello I m... path.. and also how to retrive that image path and show that picture in a small... it physical path will get saved in a database.. I have table created

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

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 I Upload File and Store that file name in Database using JSP
How I Upload File and Store that file name in Database using JSP Hi All, I m the beginner in JSP and I want to upload the file and store that file... form like Emp name, Emp id, city, address and one employee profile image(upload

how to display or retrive an image in jsp whose path is stored in oracle database
how to display or retrive an image in jsp whose path is stored in oracle database how to display or retrive an image in jsp whose path is stored in oracle database and the image is stored in my pictures folder

how to store and retrieve image from database
how to store and retrieve image from database how to store and retrieve images into database(oracle) and how to retrive images from database using jsp Here is a jsp code that insert and retrieve image from mysql

Unable to store the image into database
); } Hi, Please check the thread How to Insert image into database...Unable to store the image into database Hello, I have created below... button. The problem is coming due to JSP page is not able to find complete path

upload image to database
upload image to database i am try to upload image to MySql database using netbeans. when jsp execute it return no error. but also data does inserted in database. i am using blob datatype and preopared statement

how to store and then immediately retrieve when store the image into database?
how to store and then immediately retrieve when store the image into database? how to store and then immediately retrieve when store the image into database? Here is a jsp code that insert and retrieve image from

store & retrive the image from oracle database
store & retrive the image from oracle database how can i store the image path in tha database & fetch that image from oracle database

Image name,image path into database and image into folder using jsp
Image name,image path into database and image into folder using jsp How to insert image path and image name into oracle database and image into folder using jsp

image store in database - JDBC
to store image into database. Check at http://www.roseindia.net/servlets/insert...image store in database Dear Deepak Sir, If I want to store image...; Inserting Image in Database Table http://www.roseindia.net/jdbc/jdbc-mysql/insert

how to show image as a link which path coming from database
how to show image as a link which path coming from database iam not getting proper answer for it. I am using netbeans .the url coming instring from database ,want to display as image on jsp . please help me

store and retrive image from the database
store and retrive image from the database please provide me with the code and the explanation of what each line does for the below query. -how to store and retreive images from sql database using sql commands -how to store

How to store multiple images in folder and images path in database at a time using jsp?
How to store multiple images in folder and images path in database at a time using jsp? I wanna browse multiple images in one form and store them in one folder and their path into datrabase

How to store url path?
How to store url path? Image is stored in physical directory like...() + ".PNG"; this physical directory is working fine but I want store in url path like this String file = "http://www.queen.com/website/screenshots/" + username

inserting an path of an image in database - JDBC
time its full path should be inserted in the database(MS Sql 2000).. I m able to save it in folder..but can you plz tell me how an the full path of image can...inserting an path of an image in database hello kindly help related

How To Store Multilple Images In MySQL database dynamically with image uploader and then retrieve them in image gallery using java
How To Store Multilple Images In MySQL database dynamically with image uploader and then retrieve them in image gallery using java How To Store Multilple Images In MySQL database dynamically with image uploader

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 to store url path in file ?
How to store url path in file ? Hi, How to store url path in file ? this my program public class Image implements Runnable..."; This is store phiscal directory but i want store url path like

how to store image file and videofile in ms access database using java? - JDBC
how to store image file and videofile in ms access database using java? how to store image file and video file in ms access database using java

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...:101249][ServletContext(id=29091418,name=Upload,context-path=/Upload)]: Servlet class

upload file to server and store recode in database
upload file to server and store recode in database i want to upload a file into the server and store a recode in mysql database.any one know the code

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

i am inserting an image into database but it is showing relative path not absolute path
i am inserting an image into database but it is showing relative path not absolute path hi my first page......... Image Enter your name: Upload photo: Father name: Age: Username: Password Qualification: Gender: Phone

i am inserting an image into database but it is showing relative path not absolute path
i am inserting an image into database but it is showing relative path not absolute path hi my first page......... <html> <head>...="text" name="sname"><br><br> Upload photo:<input type="file

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

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

How to Store Image using JSF
How to Store Image using JSF Hi How to upload images in db. using jsf. For jsf photo uploading .. I used this one code for upload image.. But this code haven't option to upload any images . i want to store image in db

store and retrive image from database - JDBC
store and retrive image from database how to store and retrive an image in database using java? Hi friend, Code for store image...()); } } } For retrieve image from database visit to : http

image is display from path of mysql database
image is display from path of mysql database <%@ page import...(); %>You have successfully upload the file:<%out.println(saveFile);%> <..._path) values(?)"); psmnt.setString(1, ff.getPath()); int s = psmnt.executeUpdate

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

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 Store Image Into MySQL Using Java
how to store an image into the database using Java and MySQL. This example explains you about all the steps that how to store image into MySQL database... you about how to store image into database using Java. We will use the MySQL

image upload in java
image upload in java Hi, I am working with java. In my application... select any image i want to store that selected image into specified folder and that path stored into database, for furhter retrivation . Please guide me

how to save uploaded image in database using javascript
how to save uploaded image in database using javascript Please can you tell me how to store uploaded image in database using java I'll use...; Now i want to store it on database...ADS_TO_REPLACE_1 Please help me Thanks

How i upload file and save that record in database using JSP?
How i upload file and save that record in database using JSP? Hi All, I m the beginner in JSP and I want to upload the file and store that file... like Emp name, Emp id, city, address and one employee profile image(upload

Ads