Page History

...

Right click on WebContent and Select New->jsp.
Name the jsp as index.jsp and Select Next.
Select Finish. This will create a template for index.jsp.

Add the following code to index.jsp.

Code Block

title	index.jsp
borderStyle	solid

<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
    pageEncoding="ISO-8859-1"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>Image Upload</title>
</head>
<body>
<h2>Select a Image and Upload it</h2>
<form action="/WebJDBC/ImageUpload">
<table>
<tr>
<td>
Location of the Image(full path)
</td>
<td>
<Input type="text" name="ImageLoc">
</td>
</tr>
<tr>
<td>
Name of the Image(Unique Name)
</td>
<td>
<Input type="text" name="ImageName">
</td>
</tr>
<tr>
<td>
<Input type="submit" value="submit">
</td>
<tr>
</table>
</form>
</body>
</html>

The <form action="/WebJDBC/ImageUpload"> suggests that once the form is submitted the request will be passed to ImageUpload. Next step is to add the servlet ImageUpload to process the request sent by the JSP client.

Right click on Java Resources and Select New->other.

Image Added
Select Web->Servlet. Select Next.

Image Added
Name the java package as jdbc and class as ImageUpload. Select Next.

Image Added
Select Finsih.

Image Added

Add the following code to ImageUpload.java.

Code Block

title	ImageUpload.java
borderStyle	solid


package jdbc;

import java.io.File;
import java.io.FileInputStream;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import javax.annotation.Resource;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.sql.DataSource;

public class ImageUpload extends javax.servlet.http.HttpServlet implements javax.servlet.Servlet {
	@Resource(name="jdbc/userds")
	 private DataSource ds;
   static final long serialVersionUID = 1L;
   
 	public ImageUpload() {
		super();
	}   	
	protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
doProcess(request, response);
	}  	
	
	protected void doProcess(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
		Connection dbconnect = null;
		PreparedStatement stmnt = null;
		String pic=request.getParameter("ImageLoc");
		String name=request.getParameter("ImageName");
		try{
			File f= new File(pic);
			FileInputStream fis=new FileInputStream(f);
			dbconnect= ds.getConnection();
			stmnt = dbconnect.prepareStatement("INSERT INTO PICTURES (" + "NAME," + "PIC )" + " VALUES(?,?)");
			stmnt.setString(1, name);
			stmnt.setBinaryStream(2, fis, (int)f.length());
			stmnt.execute();
			PrintWriter out= response.getWriter();
			out.println("Congratulations your image has been successfully uploaded");			
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
		finally
		{
		try{
    		dbconnect.close();
    		stmnt.close();
    	}catch(SQLException e){
    		e.printStackTrace();
    	}    
		}
	}
		
	
	protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
doProcess(request, response);
	}   	  	    
}

This completes the code for Image Upload.

Child pages

Versions Compared

Old Version 8

New Version 9

Key