Sun-microsystems eWay JDBC/ODBC Adapter Manual de usuario descargar pdf (Pagina 61)

Chapter 5 Section 5.2

Using JDBC/ODBC Operations JDBC eWay Database Operations (JCD)

JDBC/ODBC eWay Adapter User’s Guide 61 Sun Microsytems, Inc.

{

FileClient_1.setText( "Selecting record(s) from db_employee

table via table select .." );

FileClient_1.write();

otdJDBC_1.getDB_EMPLOYEE().select( input.getText() );

while (otdJDBC_1.getDB_EMPLOYEE().next()) {

otdOutputDTD_DBemployee_1.setEmpNo(

typeConverter.shortToString( otdJDBC_1.getDB_EMPLOYEE().getEMP_NO(),

"#", false, "" ) );

otdOutputDTD_DBemployee_1.setLastname(

otdJDBC_1.getDB_EMPLOYEE().getLAST_NAME() );

otdOutputDTD_DBemployee_1.setFirstname(

otdJDBC_1.getDB_EMPLOYEE().getFIRST_NAME() );

otdOutputDTD_DBemployee_1.setRate(

otdJDBC_1.getDB_EMPLOYEE().getRATE().toString() );

otdOutputDTD_DBemployee_1.setLastDate(

typeConverter.dateToString(

otdJDBC_1.getDB_EMPLOYEE().getLAST_UPDATE(), "yyyy-MM-dd hh:mm:ss",

false, "" ) );

FileClient_1.setText(

otdOutputDTD_DBemployee_1.marshalToString() );

FileClient_1.write();

}

FileClient_1.setText( "Done table select." );

FileClient_1.write();

}

The Insert Operation

To perform an insert operation on a table:

1 Execute the insert() method. Assign a value to a field.

2 Insert the row by calling insertRow()

This example inserts an employee record.

package prjJDBC_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,

com.stc.connector.appconn.file.FileApplication FileClient_1,

dtd.otdInputDTD_1394195520.DBemployees otdInputDTD_DBemployees_1,

dtd.otdOutputDTD882991309.DBemployee otdOutputDTD_DBemployee_1,

otdJDBC.OtdJDBCOTD otdJDBC_1 )

throws Throwable

{

FileClient_1.setText( "Inserting records into db_employee

table .." );

FileClient_1.write();

1 2 ... 56 57 58 59 60 61 62 63 64 65 66 ... 132 133

Comentarios a estos manuales

Sin comentarios

Sun-microsystems eWay JDBC/ODBC Adapter Manual de usuario Pagina 61

Comentarios a estos manuales

Relacionado con productos y manuales para Hardware Sun-microsystems eWay JDBC/ODBC Adapter