DaniWeb Forum Index > Web Development > JSP

Store and retrieve image from mysql db with JSP

Please support our JSP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Feb 2009

Posts: 4

Reputation: gusfraba is an unknown quantity at this point

Solved Threads: 0

gusfraba

Offline

Newbie Poster

Store and retrieve image from mysql db with JSP

Feb 16th, 2009

I've had nighmares about this since 3 days ago and couldn't find anything by googling so here I am.

As the title says so i need to find a way to store and then retrieve images from a mysql database I have tired the code below to do so (the storing part) but it just saves empty blobs.

I'd apreciate the help and since i haven't seen much about the topic so will a lot of people

 Help with Code Tags 
 JSP Syntax (Toggle Plain Text) 
<html>
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
    </head>
    <body>
        <%
            String description = null;
 
            MyImage image= new MyImage();
 
            try
            {
                //Download com.oreilly package
                MultipartRequest multi= new MultipartRequest(request,".",5*1024*1024);
                Enumeration files=multi.getFileNames();
                File file=null;
 
                for(int i = 0 ; files.hasMoreElements() ; i++)
                {
                    String name=(String)files.nextElement();
                    String filename=multi.getFilesystemName(name);
                    String type=multi.getContentType(name);
                    file=multi.getFile(name);
                    description = multi.getParameter("description");
 
                    out.println("The File is "+archivo.getCanonicalPath() + "<br>");
 
                    BufferedImage img = ImageIO.read(file);
                    ByteArrayOutputStream bas = new ByteArrayOutputStream();
 
                    ImageIO.write(img, "pnm", bas);
 
                    byte[] data = bas.toByteArray();
 
 
                    if(i == 0){
                        image.setLoginImage(data);
                    }
                    if(i == 1){
                        image.setReportImage(data);
                    }
                }
 
                image.setDescription(description);
 
               String error = validateFields();
 
                if(error.equals("")){
                    try{
                        EntityManager em = MyEntityManager.getEntityManager();
                        em.getTransaction().begin();
                        em.persist(image);
                        em.getTransaction().commit();
                    }catch(Exception e){
                        session.setAttribute("Error", e.getMessage());
                    }
                }else{
                    session.setAttribute("Error", error);
                }
            }catch(Exception e){
                session.setAttribute("Error", e.getMessage());
            }
        %>
    </body>
</html>
<html>
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
    </head>
    <body>
        <%
            String description = null;

            MyImage image= new MyImage();

            try
            {
                //Download com.oreilly package
                MultipartRequest multi= new MultipartRequest(request,".",5*1024*1024);
                Enumeration files=multi.getFileNames();
                File file=null;

                for(int i = 0 ; files.hasMoreElements() ; i++)
                {
                    String name=(String)files.nextElement();
                    String filename=multi.getFilesystemName(name);
                    String type=multi.getContentType(name);
                    file=multi.getFile(name);
                    description = multi.getParameter("description");

                    out.println("The File is "+archivo.getCanonicalPath() + "<br>");

                    BufferedImage img = ImageIO.read(file);
                    ByteArrayOutputStream bas = new ByteArrayOutputStream();

                    ImageIO.write(img, "pnm", bas);
                    
                    byte[] data = bas.toByteArray();


                    if(i == 0){
                        image.setLoginImage(data);
                    }
                    if(i == 1){
                        image.setReportImage(data);
                    }
                }

                image.setDescription(description);

               String error = validateFields();

                if(error.equals("")){
                    try{
                        EntityManager em = MyEntityManager.getEntityManager();
                        em.getTransaction().begin();
                        em.persist(image);
                        em.getTransaction().commit();
                    }catch(Exception e){
                        session.setAttribute("Error", e.getMessage());
                    }
                }else{
                    session.setAttribute("Error", error);
                }
            }catch(Exception e){
                session.setAttribute("Error", e.getMessage());
            }
        %>
    </body>
</html>

Last edited by peter_budo; Feb 16th, 2009 at 8:26 pm. Reason: Keep It Organized - For easy readability, always wrap programming code within posts in [code] (code blocks) and [icode] (inline code) tags.

•

Join Date: Nov 2007

Posts: 16

Reputation: danielernesto is an unknown quantity at this point

Solved Threads: 1

danielernesto danielernesto is offline

Offline

Newbie Poster

Re: Store and retrieve image from mysql db with JSP

-1

Feb 16th, 2009

Have you tried
this.ShootMySelf(this.myGun);

•

Join Date: Feb 2009

Posts: 4

Reputation: gusfraba is an unknown quantity at this point

Solved Threads: 0

gusfraba

Offline

Newbie Poster

Re: Store and retrieve image from mysql db with JSP

-1

Feb 16th, 2009

•

Originally Posted by danielernesto

Have you tried
this.ShootMySelf(this.myGun);

Mean Motha****er

•

Join Date: Dec 2004

Posts: 4,262

Reputation: peter_budo has much to be proud of

Solved Threads: 493

peter_budo peter_budo is online now

Online

Code tags enforcer

Re: Store and retrieve image from mysql db with JSP

Feb 16th, 2009

Have look at this example. If you modify code correctly you will be able to select image to upload through JSP and submit it to servlet for database insertion

Learn to see in another's calamity the ills which you should avoid.
Publilius Syrus
(~100 BC)
LJC - London Java Community, Graduate & Undergraduate Software Development Community, JAVAWUG (Java Web User Group), The London Android Group

•

Join Date: Feb 2009

Posts: 4

Reputation: gusfraba is an unknown quantity at this point

Solved Threads: 0

gusfraba

Offline

Newbie Poster

Re: Store and retrieve image from mysql db with JSP

Feb 16th, 2009

Thanx Peter_budo I had already seen an example like that one but this one is easier to modify, I'll give it a try

•

Join Date: Feb 2009

Posts: 1

Reputation: nm.nehamehta11 is an unknown quantity at this point

Solved Threads: 0

nm.nehamehta11 nm.nehamehta11 is offline

Offline

Newbie Poster

Re: Store and retrieve image from mysql db with JSP

Feb 25th, 2009

hey m a biotechnologist. i want to develop a database . can u tell what would be easy to learn.. JSP or PHP???

•

Join Date: Dec 2004

Posts: 4,262

Reputation: peter_budo has much to be proud of

Solved Threads: 493

peter_budo peter_budo is online now

Online

Code tags enforcer

Re: Store and retrieve image from mysql db with JSP

Feb 25th, 2009

I will say PHP if you looking for faster learning and development cycle as JSP require quite extensive knowledge of Java to be able to comprehend and correctly use other Java web based technologies.
On other hand Java is more secure and provide large scope of add-on technologies that may increase your productivity

•

Join Date: Feb 2009

Posts: 4

Reputation: gusfraba is an unknown quantity at this point

Solved Threads: 0

gusfraba

Offline

Newbie Poster

Re: Store and retrieve image from mysql db with JSP

Feb 25th, 2009

It depends a lot on you background if you already know java it'll be much easier with jsp but if you're starting from zero php is better, more flexible and there's more documentation about it