The Insert Operation (Using Database Operations)

Using Database Operations

The Insert Operation

To perform an insert operation on a table:

Execute the insert() method. Assign a field.

Insert the row by calling insertRow()

This example inserts an employee record.

package prjSybase_JCDjcdALL;


public class jcdInsert
{

    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, otdSybase.OtdSybaseOTD otdSybase_1,
     dtd.otdInputDTD_1206505729.DB_Employee otdInputDTD_DB_Employee_1,
 com.stc.connector.appconn.file.FileApplication FileClient_1 )
        throws Throwable
    {
        FileClient_1.setText( "Inserting records in to
 db_employee table......" );
        FileClient_1.write();
        otdInputDTD_DB_Employee_1.unmarshalFromString(
 input.getText() );
        otdSybase_1.getDb_employee().insert();
        for (int i1 = 0; i1 < otdInputDTD_DB_Employee_1.
countX_sequence_A(); i1 += 1) {
            otdSybase_1.getDb_employee().setEMP_NO(
 typeConverter.stringToShort( otdInputDTD_DB_Employee_1.
getX_sequence_A( i1 ).getEmpNo(), "#", false, 0 ) );
            otdSybase_1.getDb_employee().setLAST_NAME(
 otdInputDTD_DB_Employee_1.getX_sequence_A( i1 ).getLastname() );
            otdSybase_1.getDb_employee().setFIRST_NAME(
 otdInputDTD_DB_Employee_1.getX_sequence_A( i1 ).getFirstname() );
            otdSybase_1.getDb_employee().setRATE(
 new java.math.BigDecimal( otdInputDTD_DB_Employee_1.
getX_sequence_A( i1 ).getRate() ) );
            otdSybase_1.getDb_employee().setLAST_UPDATE(
 typeConverter.stringToTimestamp( otdInputDTD_DB_Employee_1.
getX_sequence_A( i1 ).getLastDate(), "yyyy-MM-dd hh:mm:ss", false, "" ) );
    otdSybase_1.getDb_employee().insertRow();
        }
        FileClient_1.setText( "Insert Done." );
        FileClient_1.write();
    }

}