Using Database Operations

The Delete Operation

ProcedureTo perform a delete operation on a table

  1. Execute the delete() method.

    In this example DELETE an employee.


    package prjSQLServer_JCDjcdALL;
    
    public class jcdDelete
    {
    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( "Deleting record............" );
            FileClient_1.write();
            otdSQLServer_1.getDb_employee().delete( input.getText() );
            FileClient_1.setText( "Delete Done." );
            FileClient_1.write();
        }
    }