Image upload java code in jsp-servlet
Connection class
public class DBConnection {
public Connection conn=null;
void getConnection()
{
try {
Class.forName("com.mysql.jdbc.Driver");
}
catch (ClassNotFoundException ex)
{
}
try {
conn= DriverManager.getConnection("jdbc:mysql://localhost:3306/ImageProcessing", "root","root");
} catch (Exception ex)
{
}
}
}
Database Connection
public class DataBase {
static String strDB;
public DataBase(String str) throws SQLException
{
DBConnection obj = new DBConnection();
obj.getConnection();
String str1=str;
PreparedStatement pstmt = obj.conn
.prepareStatement("insert into imagestore (ImagePath,row) values(?,?)");
int i=1;
pstmt.setString(1, str1);
pstmt.setInt(2,i );
pstmt.executeUpdate();
Statement stmt = obj.conn.createStatement();
String query = "SELECT ImagePath FROM ImageStore where row=1";
ResultSet rs = stmt.executeQuery(query);
while(rs.next())
{
strDB=rs.getString(1);
}
Statement stmt1 = obj.conn.createStatement();
String query1 = "delete from ImageStore where row=1";
stmt1.executeUpdate(query1);
}
}
Image pathUpload servled code
import java.io.File;
import java.io.FileInputStream;
import java.io.IOException;
import java.io.InputStream;
import java.io.PrintWriter;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.util.Iterator;
import java.util.List;
import javax.servlet.ServletContext;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import org.apache.commons.fileupload.FileItem;
import org.apache.commons.fileupload.disk.DiskFileItemFactory;
import org.apache.commons.fileupload.servlet.ServletFileUpload;
public class FirstImage extends HttpServlet{
static String filePath ;
@Override
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
File file ;
int maxFileSize = 5000 * 1024;
int maxMemSize = 5000 * 1024;
String fileName = null;
DBConnection obj = new DBConnection();
obj.getConnection();
ServletContext context = getServletContext();
filePath = getServletContext().getRealPath("/images");
System.out.println(filePath);
response.setContentType("text/html");
String contentType = request.getContentType();
if ((contentType.indexOf("multipart/form-data") >= 0)) {
DiskFileItemFactory factory = new DiskFileItemFactory();
factory.setSizeThreshold(maxMemSize);
factory.setRepository(new File("C:\temp"));
ServletFileUpload upload = new ServletFileUpload(factory);
upload.setSizeMax( maxFileSize );
try{
List fileItems = upload.parseRequest(request);
Iterator i = fileItems.iterator();
while ( i.hasNext () )
{
FileItem fi = (FileItem)i.next();
if ( !fi.isFormField () )
{
String fieldName = fi.getFieldName();
fileName = fi.getName();
boolean isInMemory = fi.isInMemory();
long sizeInBytes = fi.getSize();
if( fileName.lastIndexOf("\\") >= 0 ){
file = new File( filePath +"/"+
fileName.substring( fileName.lastIndexOf("\\"))) ;
}else{
file = new File( filePath +"/"+
fileName.substring(fileName.lastIndexOf("\\")+1)) ;
}
fi.write( file ) ;
}
}
}catch(Exception ex) {
System.out.println(ex);
}
}else{
System.out.println("no file uploaded");
}
try {
new DataBase(fileName);
}
}
in database create two columan row(number) and Imagepath(varchar(100))