image insertion into database

[abhiN]

hi

can anybody send me sample progrm in java for how to insert and retrive image to and from mysql database..

thanks..
byee

[JForum4Hari]

Use BLOB datatype and in Db you can use Image Datatype

[Eranga]

Yes Binary Large Object is the solution.

Code:

Statement stm; // You have to implement the statement to your connection
ResultSet rs = stm.executeQuery(sql_query);

if(rs.next()) {
    Blob blob = rs.getBlob(column);
}

[pao]

Hey I have done this before, so I dug this out of one of the classes I wrote.

Apologies if its a little long winded or whatever, I wrote it over 2 years ago, but it is working within a production environment.

You might need to play around with it a little bit but it should be enough:

Code:

//Writes filedata to database and returns the ID of the new Signature record
   private int writeImageFile(byte[] fileData, String fileName, String imageType, String mode, Integer signatureIDIn, HttpServletRequest request) throws Exception {
        //If the previous code found a file that can be uploaded then
        //save it into the database via a pstmt
        String sql = ""; 
        UtilDBquery udbq = getUser(request).connectToDatabase();
        Connection con = null; 
        int signatureID = 0;
        PreparedStatement pstmt = null;
        
        try {
            
            udbq.setUsePreparedStatements(true);
            con = udbq.getPooledConnection();
            con.setAutoCommit(false);
            
            if((!mode.equals("U")) || (mode.equals("U") && signatureIDIn == 0)) {
                sql = "SELECT SEQ_SIGNATURE_ID.nextval FROM DUAL";
                
                
                pstmt = con.prepareStatement(sql);
                ResultSet rs = pstmt.executeQuery();
                
                while(rs.next()) {
                   signatureID = rs.getInt(1);
                }
                
                if (fileName != null && imageType != null) {
                    sql = "INSERT INTO T_SIGNATURE (SIGNATURE_ID, SIGNATURE) values (?,?)";
                    
                    InputStream is2 = new ByteArrayInputStream(fileData);
                    
                    pstmt = con.prepareStatement(sql);
                    
                    pstmt.setInt(1, signatureID);
                    
                    pstmt.setBinaryStream(2, is2, (int)(fileData.length));
                    
                    pstmt.executeUpdate();
                    pstmt.close();
                    con.commit();
                    con = null;
                }    
            }
            
            if(mode.equals("U") && signatureIDIn != 0) {
                signatureID = signatureIDIn.intValue();
                
                if (fileName != null && imageType != null) {
                    sql = "UPDATE T_SIGNATURE SET SIGNATURE = ? WHERE SIGNATURE_ID = ?";
                    
                    InputStream is2 = new ByteArrayInputStream(fileData);
                    
                    pstmt = con.prepareStatement(sql);
                    
                    pstmt.setBinaryStream(1, is2, (int)(fileData.length));
                    pstmt.setInt(2, signatureID);
                    pstmt.executeUpdate();
                    pstmt.close();
                    con.commit();
                    con = null;
                }
            }
            
            
        } catch (Exception e) {
            con = null;
            throw new Exception(e.toString());
            
        } 
        return signatureID;
   }