photo upload using jsp

[geomar lubaton]

How do you upload a photo in jsp? And I also have to save it in my database... i used postgresql. Can anyone please help me.. I really need to finish my webapp asap. Thanks.

[Smitha Kochunny]

Hi,

Try using UploadBean (http://www.javazoom.net/jzservlets/uploadbean/uploadbean.html).

Thank You,
Smitha.

[Adeel Ansari]

http://jakarta.apache.org/commons/fileupload/.
And for database stuff please post in JDBC Forum. You will find better answers there.
Thanks.

[deshdeep divakar]

Try this

import java.io.*; 
import java.sql.*; 
import java.util.*; 
 
public class StoreFile1 
{ 
Connection con=null; 
 
public StoreFile1() 
{ 
 
} 
public void getFile(String filename1) throws Exception 
{ 
System.out.println("Before DataBase Connection1"); 
PreparedStatement pst = null; 
ResultSet rs=null; 
String s1="gif";
try 
{ 
      Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
                                          con=DriverManager.getConnection("jdbc :-o	 dbc:RT"," "," ");
      
      pst = con.prepareStatement("select images from pic where ftype=?"); 
      pst.setString(1,filename1); 
                        rs=pst.executeQuery();       
      while(rs.next()) 
      { 
byte[] b=rs.getBytes("images"); 
                                    System.out.println("b size= "+b.length);
if(filename1.equals(s1))
{
                                    FileOutputStream fos=new FileOutputStream(new File(".gif "));                   fos.write(b,0,b.length);
fos.flush(); 
fos.close();
}
else
{
                                                      FileOutputStream fos=new FileOutputStream(new File(".jpg ")); 
fos.write(b,0,b.length);
fos.flush(); 
fos.close();
}

       } 

System.out.println("File Written Successfully"); 
} 
catch(Exception e) 
{ 
System.out.println(" Problem : "+e); 
} 
finally 
{ 
con.close(); 
pst.close(); 
} 
 
} 
public static void main(String args[]) throws Exception 
{ 
StoreFile1 store1=new StoreFile1();
System.out.println("What is The File Description ");
String filename1 = new BufferedReader(new InputStreamReader(System.in)).readLine(); 
store1.getFile(filename1); 
} 
 
}   

Change Table name and attribute names as per ur requirments