Reading and Writing Images from SQLServer in WebDynpro

[Former Member]

Creating DataSource

Lets start with creating the Datasource in the VisualAdministrator .For creating datasource i would suggest you to go through the thread where Lohita explained in detail on how to install the JDBC driver and creating the Datasource in VisualAdministrator .

Before stating your coding in WebDynpro ,we can test the Datasource in VisualAdmin itself.Select JDBC Connector->Select Your DataSource->Goto DB Initialization Tab and select "Add Statement".

Enter a valid select statement and click on "execute" button .You can see the sample screen shots below

Writing Image to a Table

First we will create a table with one column of type IMAGE in SQLServer

Create a FileUpload UIElement on he WebDynpro view so that user can select a particular Image file and after clicking on a button it should add a new record to the above created table.The resource property of FileUpload UIElement should be bound to a value attribute of type "com.sap.ide.webdynpro.uielementdefinitions.Resource"

The following code will read the image file from the FileUpload UIElement and write it into the table
try{   Context ctx = new InitialContext();   DataSource ds = (DataSource) ctx.lookup("jdbc/<<DataSourceName>>");    Connection con=ds.getConnection();   Statement  st=con.createStatement();   PreparedStatement pSt=con.prepareStatement( "insert into TABLENAME values(?)");// Read the datasource of the FileUploadIWDResource res=wdContext.currentContextElement().getResource() ;    InputStream in = res.read(false);    ByteArrayOutputStream bOut = new ByteArrayOutputStream();    int length;    byte[] part = new byte[10 * 1024];    while ((length = in.read(part)) != -1) {         bOut.write(part, 0, length);    }    in.close();   pSt.setBytes( 1,bOut.toByteArray());   pSt.execute() ;   bOut.close();  wdComponentAPI .getMessageManager().reportSuccess("Executed sucesfully");} catch(Exception e) {  wdComponentAPI.getMessageManager() .reportWarning( e.toString() ); }

Reading from the Table

Find the code below for reading the Image from a table and writing to a context .Here you need to create a valueNode "ImageTable" and valueattributes "Name" of type String and "Image" of type Binary

try{     Connection con=new SAPDBConnection().getConnection();  Statement  st=con.createStatement();  ResultSet rs = st.executeQuery("SELECT  * FROM SDN_USERS");  while(rs.next())  { String name=rs.getString( 1); byte[] b=rs.getBytes(2); IWDResource res=WDResourceFactory.createCachedResource(b,"MyImage",WDWebResourceType.JPG_IMAGE);  IPrivateGeneratorView .IImageTableElement imageEle=wdContext.createImageTableElement();  imageEle .setName( name); imageEle.setImage( res.getUrl(WDFileDownloadBehaviour.OPEN_INPLACE.ordinal()));   wdContext.nodeImageTable() .addElement(imageEle );}  } catch(Exception e){  wdComponentAPI.getMessageManager().reportWarning(e.toString()); }

Once you have context ready you can display images in different ways !!! Following is example for showing Images from Database in a WebDynpro table .

Screenshots of creating Datasource

We have one weblog Uploading and Downloading Images in MaxDB Database written by Balakrishnan.He explaind writing and reading images from MaxDB very well. On the top my weblog explains configuring the Datasource for SQLServer and directly displaying the images through context instead of writing to a file using FileOutputStream