Sun-microsystems eWay JDBC/ODBC Adapter Manual do Utilizador descarregar pdf (Página 85)

Chapter 6 Section 6.5

Implementing the JDBC/ODBC eWay Sample Projects Building and Deploying the prjJDBC_JCD Sample Project

JDBC/ODBC eWay Adapter User’s Guide 85 Sun Microsystems, Inc.

otdOutputDTD_DBemployee_1.setEmpNo( Integer.toString(

otdJDBC_1.getSelect_ps().get$Select_psResults().getEMP_NO() ) );

otdOutputDTD_DBemployee_1.setLastname(

otdJDBC_1.getSelect_ps().get$Select_psResults().getLAST_NAME() );

otdOutputDTD_DBemployee_1.setFirstname(

otdJDBC_1.getSelect_ps().get$Select_psResults().getFIRST_NAME() );

otdOutputDTD_DBemployee_1.setRate(

otdJDBC_1.getSelect_ps().get$Select_psResults().getRATE().toString()

);

otdOutputDTD_DBemployee_1.setLastDate(

otdJDBC_1.getSelect_ps().get$Select_psResults().getLAST_UPDATE().toSt

ring() );

FileClient_1.setText(

otdOutputDTD_DBemployee_1.marshalToString() );

FileClient_1.write();

}

} else {

FileClient_1.setText( "No record found!" );

FileClient_1.write();

}

\\ Writes a message to JCD_PsSelect_output0.dat to confirm when

records are selected, or when no records are available.

FileClient_1.setText( "Done Select" );

FileClient_1.write();

}

Creating the jcdTableSelect Business Rules

The jcdTableSelect Collaboration implements the Input Web Service Operation to read

the TriggerTableSelect.in file. It then copies the database resultset into the

otdInputDTD_DBEmployee OTD and selects all available records from the database

that meet a certain criteria. The Collaboration also writes a message to

JCD_TableSelect_output0.dat to confirm when records are selected, or when no

records are available.

Note: The where clause in the business rule reads the trigger value as a placeholder for

input. This permits you to modify the query to select a specific record. Also note that

all records are selected from the database when the TriggerTableSelect.in file is

empty.

The jcdTableSelect Collaboration contains the Business Rules displayed in Figure 34.

1 2 ... 80 81 82 83 84 85 86 87 88 89 90 ... 132 133

Sem comentários

Sun-microsystems eWay JDBC/ODBC Adapter Manual do Utilizador Página 85