Sun Adapter for SQL Server Tutorials

jcdUpdate Collaboration Java Code

The completed Java source code for the jcdUpdate Collaboration appears as follows:


package prjSQLServer_JCDjcdALL;


public class jcdUpdate
{

   public com.stc.codegen.logger.Logger logger;

   public com.stc.codegen.alerter.Alerter alerter;

   public com.stc.codegen.util.CollaborationContext collabContext;

   public com.stc.codegen.util.TypeConverter typeConverter;

   public void receive( com.stc.connector.appconn.file.FileTextMessage input, 
otdSQLServer.OtdSQLServerOTD otdSQLServer_1, com.stc.connector.appconn.file.
FileApplication FileClient_1 )
       throws Throwable
   {
       FileClient_1.setText( "Update the Rate and Last_update fields .. " );
       FileClient_1.write();
       otdSQLServer_1.getDb_employee().update( input.getText() );
       while (otdSQLServer_1.getDb_employee().next()) {
           otdSQLServer_1.getDb_employee().setRATE( Double.parseDouble( "888" ) );
           otdSQLServer_1.getDb_employee().setLAST_UPDATE( java.sql.Timestamp.
valueOf( "2008-08-08 00:00:00.0" ) );
           otdSQLServer_1.getDb_employee().updateRow();
       }
       FileClient_1.setText( "Done Update." );
       FileClient_1.write();
   }

} 

Note –

The above code has been wrapped for display purposes.


Next Steps

For your next step, see Creating the Connectivity Maps .