BLOB and CLOB

[Maryam Nouhnejad]

I'm working with MySQL and I want to store some image data in my database and then read and show it in a table using BLOB & CLOB.

But I don't have any special background about this subject. I searched in the internet and found some sample codes but they were not exactly what I wanted...

Could you please send me some source codes related to this task?

I would be very grateful if you do, :p
Maryam
[ October 31, 2006: Message edited by: Bear Bibeault ]

[anand phulwani]

If Still Have Some Doubt Do Ask

   
import java.io.*;
import java.sql.*;
 
public class LoadImage
{
  public static void main( String[] args ) 
  {
    if( args.length < 3 )
    {
      System.out.println( "Usage: LoadImage <image-filename> <album-id> <desc>" );
      System.exit( 0 );
    }
 
    String filename = args[ 0 ];
    int albumId = Integer.parseInt( args[ 1 ] );
    String desc = args[ 2 ];
    Connection conn = null;
    PreparedStatement ps = null;
    try
    {
      Class.forName( "org.gjt.mm.mysql.Driver" );
      String url = "jdbc:mysql://localhost:3306/webphotogallery";
      String username = "root";
      String password = "";
      conn = DriverManager.getConnection( url, username, password );
      ps = conn.prepareStatement( 
        "INSERT INTO Image (album_id, image_desc, image_full) VALUES( ?, ?, ? )" );
 
      ps.setInt( 1, albumId );
      ps.setString( 2, desc );
 
      // Insert the image into the second Blob
      File image = new File( filename );
      FileInputStream fis = new FileInputStream( image );
      ps.setBinaryStream( 3, fis, ( int )image.length() );
 
      // Execute the INSERT
      int count = ps.executeUpdate();
      System.out.println( "Rows inserted: " + count );
    }
    catch( Exception e )
    {
      e.printStackTrace();
    }
    finally
    {
      try 
      {
        if( ps != null ) ps.close();
        if( conn != null ) conn.close();
      }
      catch( Exception ee )
      {
        ee.printStackTrace();
      }
    }
  }
}

[Maryam Nouhnejad]

Thank you very much for the answer... I'm gonna use it ...

[Aditya Kumar]

You could check out this link from Oracle: Oracle on LOB

Don't get overwhelmed by the length of the code, it could be used as a reference. Wee bit too comprehensive but you can dig into it and find exactly what you need.