Problem in uploading image to to mysql database

Home Answers Viewqa JDBC Problem in uploading image to to mysql database

Daryll Sabate

Problem in uploading image to to mysql database
0 Answer(s) a year and 2 months ago
Posted in : JDBC

Hi, need some help here, i have a program where a user can input name, city and upload image. when a user click the submit button the name, city and the image(Save as BLOB) must be save in the database. and the image will also save in the desired folder. i have no problem in saving the image in the folder, my problem is it can't save the record to mysql database.

heres my code...

index.jsp

<%@ page language="java" %>
<HTML>
<HEAD><TITLE>Upload File</TITLE></HEAD>
<BODY> <FORM ENCTYPE="multipart/form-data" ACTION="upload.jsp" METHOD=POST>
<br><br><br>
<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>Name:</b></td>
<td><INPUT NAME="name" TYPE="text"></td>
</tr>
<tr>
<td><b>City:</b></td>
<td><INPUT NAME="city" TYPE="text"></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>
</BODY>
</HTML>

upload.jsp

<%@ page import="java.io.*" %>
<%@ page import="java.sql.*" %>
<%@ page import="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:/f/" + 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>
            <%
            String Name = request.getParameter("name");
                    String City = request.getParameter("city");
                    if (Name != null && City != null) {
                    Connection connection = null;
                    String connectionURL = "jdbc:mysql://localhost:3306/dropdown";
                    ResultSet rs = null;
                    PreparedStatement psmnt = null;
                    FileInputStream fis;

                        try {
                            Class.forName("com.mysql.jdbc.Driver").newInstance();
                            connection = DriverManager.getConnection(connectionURL, "root", "password");
                            File f = new File("C:/f/" + saveFile);
                            psmnt = connection.prepareStatement("insert into save_image(name, city, image) values(?, ?, ?)");
                            psmnt.setString(1, Name);
                            psmnt.setString(2, City);
                            fis = new FileInputStream(f);
                            psmnt.setBinaryStream(3, (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();
                        }
                    }
                }
            %>

View Answers

Problem in uploading image to to mysql database
Problem in uploading image to to mysql database Hi, need some help... be save in the database. and the image will also save in the desired folder. i have no problem in saving the image in the folder, my problem is it can't save

uploading problem
about file into database lib. i use navicat Mysql ... i use this code... <...uploading problem i use glassfish server.. using netbeans for jsp... curresponding image files start new upload"); %><

uploading image in php - PHP
uploading image in php I am looking for a PHP script to upload image into mysql database

Uploading an image into the table - JSP-Servlet
Uploading an image into the table how to upload an image into the table in java Hi friend, Code to help in solving the problem... to the specified database. */ psmnt = connection.prepareStatement ("insert into save_image

struts image uploading
struts image uploading please let me know how to upload image in database using struts ..i have written form class and 'm hanging out in action..."); Connection con=DriverManager.getConnection("jdbc:mysql

Image uploading
Image uploading Hi,can anyone explain the following code. The code related to uploading an image file to oracle database using java servlet. CODE import java.io.*; import java.io.IOException; import

error in uploading image from jsp to oracle 10g database
try to insert into the image into the database i got the above error please advice how to get rid of error JSP upload image in Mysql database...error in uploading image from jsp to oracle 10g database

Uploading a Profile with image[file] into a sql database
Uploading a Profile with image[file] into a sql database I need to upload a file along with the some text into a database ......[ Similar to http... , but upload file to database ] ... Pls help

uploading image in the form
uploading image in the form Hi All, I am working to build a form like railway registration form which accepts user id and password and image for authentication. And i want all users should be able to see the image once

Uploading Multiple Image On Server?
Uploading Multiple Image On Server? Hello sir, I am stuck with a problem of uploading multiple images on server. i have done a code which works fine for uploading single image,but it doesn't work with uploading multiple

Uploading image using jsp
Uploading image using jsp how to upload image using jsp. Already i tried, But that image file does not read. It returns only -1 without reading...("GET IMAGE PROBLEM :: "+ex); ex.printStackTrace(); } return result; } %> <

Having problem with image upload....
Having problem with image upload.... I am uploading profile pictures in my site.But after uploading when I visit my home page where it is supposed... is correct.I have renamed the image after uploading with time stamp so as to prevent

mysql problem - JDBC
mysql problem hai friends i have some problem with image storing in mysql. i.e while i am using image(blob) for insert the image it says... of creation of table in mysql. it will take any image and store in database

uploading a text file into a database
uploading a text file into a database how to upload a text file into a database using jchooser import java.io.*; import java.sql...."); Connection conn = DriverManager.getConnection("jdbc:mysql://localhost

mysql problem - JDBC
mysql problem hai friends please tell me how to store the videos in mysql plese help me as soon as possible thanks in advance Hi Friend, Create a database table image(image_id(bigint),image(blob))and use

jsp image problem - JSP-Servlet
jsp image problem hi everyone, How to display multiple images from mysql database to jsp page. please help me

photo uploading
photo uploading i want the code upload the image in oracle database

image uploading perminssion in server - JSP-Servlet
image uploading perminssion in server thanks dear, but i am working in Linux Ubuntu, how can i set the path in server. my problem is i am not able to access the folders wherever we are uploading the files, we are not able

file uploading
file uploading How to upload music files onto the server and save the file information to the mysql database fetch and play the music files on a display page without download thus streaming the files

image uploading perminssion in server - JSP-Servlet
image uploading perminssion in server Dear All, I am facing some problem image uploading in server that i working fine in my system, OS Ubuntu...; Hi friend, Plz give full source code with details to solve the problem

image uploading perminssion in server - JSP-Servlet
image uploading perminssion in server Thanks deepak following my... to writing image file in this path.. in multipartRequest. if u have any other uploading script please help me.. thanks Hi, Plz give

uploading a file - JSP-Interview Questions
uploading a file uploading a file and storing in database using... = DriverManager.getConnection("jdbc:mysql://localhost:3306/test", "root", "root...())); int s = st.executeUpdate(); JOptionPane.showMessageDialog(null,"image

Save profile and image to mysql database, and view the image in another jsp page
Save profile and image to mysql database, and view the image in another jsp page Pls. need help in saving the profile info with the image in mysql database.. some basic code pls in jsp... thanks in advance

Insert Image into Mysql Database through Simple Java Code
Insert Image into Mysql Database through Simple Java Code... simple java code that how save image into mysql database. Before running this java code you need to create data base and table to save image in same database

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

Image uploading in FTP Server
Image uploading in FTP Server I want to upload images to a ftp server every 1 hour automatically using java..please help

problem to do coding upload image in php
problem to do coding upload image in php can i get example coding how to upload image in php?i have try it but i dont no wheter it is correct or not because i can't save the image in folder and not connected to database mysql

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... using Java. We will use the MySQL database system to store the image

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

file uploading - Java Server Faces Questions
questions .But its not working for file uploading . U ask me to send the entire code... for lan but its not working for server pls tell me where is the problem...()+"_"+r+domainName; System.out.println("Final Image==="+finalimage

change the name of the image after uploading the image
change the name of the image after uploading the image my form consists of a textbox and uploading the image.after uploading the image i want to change the name of the image with the content of the textbox before saving

Uploading an image - JSP-Servlet
Uploading an image I am doing a jsp project. In this uploading an image is a part. For that i had done a coding for uploading... and uploading is done by different jsp coding. I don't know how to code for file size

image store in database - JDBC
; Inserting Image in Database Table http://www.roseindia.net/jdbc/jdbc-mysql/insert... 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

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

Problem in uploading java application
Problem in uploading java application I have uploaded my java application (folder created under webapps) using Filezilla FtpClient.Application... this problem

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

Uploading a Software and storing in the database
Uploading a Software and storing in the database I want to upload a software(may be of maximum 20mb) through JSP, and store it in the database. The coding present in the site for uploading and storing in the database

problem in selecting second arraylist from mysql database
problem in selecting second arraylist from mysql database Hi... in mysql database. In the below program , i have hard-coded that second list, but i want second list to be dynamic from database. Please, help me out. Thank

file uploading - JSP-Servlet
problem. Im not geeting the full output for the program. Even, the file is not uploaded to the server folder. Im not sure which part is having problem. Again, i've... to solve the problem as well. Thanks in advance. Input File

File Uploading Problem
File Uploading Problem I have a file uploading code but it create problem $(document).ready(function(){ $('#upload').click(function(){ var... it gives the problem org.apache.commons.fileupload.FileUploadException

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

displaying image
displaying image how to upload image and retrieve it form database mysql in php? Here is an example of uploading image using php. 1...', '$fileType', '$content')"; mysql_query($query) or die('Error, query failed'); include

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

Inserting Image in Database Table
helps the user to insert an image in the MySQL database table. To insert an image, you need to establish a connection with MySQL database. Lets' take... Inserting Image in Database Table

insert name city image in database using mysql and jsp
insert name city image in database using mysql and jsp how to insert name ,city and image in database in mysql and jsp Here is an example in jsp that insert name, city and image to database. <%@ page import

Latest
Frameworks
Category