Sun Microsystems SUN SEEBEYOND eWAY, Руководство пользователя

Страница: 56 / 115

Chapter 6 Section 6.2
Using VSAM Operations VSAM eWay Database Operations (JCD)
VSAM eWay Adapter User’s Guide 56 Sun Microsytems, Inc.
ƒ
SetScrollTypetoScrollSensitive
ƒ
SetScrollTypetoInsensitive
The Query (Select) Operation
To perform a query operation on a table:
1 Execute the
select()
method with the “
where
” clause specified if necessary.
2 Loop through the ResultSet using the next() method.
3 Process the return record within a
while()
loop.
For example:
package prjVSAM_JCDjcdALL;
public class jcdTableSelect
{
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,
otdVSAM.OtdVSAMOTD otdVSAM_1, dtd.otdOutputDTD_1935483687.Emp
otdOutputDTD_Emp_1, com.stc.connector.appconn.file.FileApplication
FileClient_1 )
throws Throwable
{
FileClient_1.setText( "Selecting record(s) from CICSEMP table
via table select .." );
FileClient_1.write();
otdVSAM_1.getCICSEMP().select( input.getText() );
while (otdVSAM_1.getCICSEMP().next()) {
otdOutputDTD_Emp_1.setENAME(
otdVSAM_1.getCICSEMP().getENAME() );
otdOutputDTD_Emp_1.setPHONE( typeConverter.intToString(
otdVSAM_1.getCICSEMP().getPHONE(), "#", false, "" ) );
otdOutputDTD_Emp_1.setMAILID(
otdVSAM_1.getCICSEMP().getMAILID() );
otdOutputDTD_Emp_1.setSALARY(
otdVSAM_1.getCICSEMP().getSALARY().toString() );
otdOutputDTD_Emp_1.setJOBID( typeConverter.doubleToString(
otdVSAM_1.getCICSEMP().getJOBID(), "#.000000;-#.000000", false, "" )
);
otdOutputDTD_Emp_1.setEMPID( typeConverter.intToString(
otdVSAM_1.getCICSEMP().getEMPID(), "#", false, "" ) );
otdOutputDTD_Emp_1.setDEPTID( typeConverter.shortToString(
otdVSAM_1.getCICSEMP().getDEPTID(), "#", false, "" ) );
otdOutputDTD_Emp_1.setDEPARTMENT(
otdVSAM_1.getCICSEMP().getDEPARTMENT() );
FileClient_1.setText( otdOutputDTD_Emp_1.marshalToString()
);
FileClient_1.write();
}
FileClient_1.setText( "Done table select." );
FileClient_1.write();