PC World Komputer 1997 May/Pcwk0597.iso/sybase/starbuck/samples.z/IJDBC_LookUp.wxc

Text File | 1996-12-10 | 6KB | 219 lines

Save Format v1.3
@begin ClassFile "IJDBC_LookUp"
 Exported 0;
 Abstract 0;
 Interface 0;
 PackageName "";
 Language "Java";

 @begin UserFunction "IJDBC_LookUp()"
  Compiler 1;
  GencodeSrcLine 12;
  FunctionName "IJDBC_LookUp::IJDBC_LookUp()";
 @end;

 @begin UserFunction "main(String args[])"
  Compiler 1;
  GencodeFunction 1;
  GencodeSrcLine 16;
  FunctionName "IJDBC_LookUp::main(String args[])";
 @end;

 @begin UserFunction "CreateMainForm()"
  Compiler 1;
  GencodeFunction 1;
  GencodeSrcLine 23;
  FunctionName "IJDBC_LookUp::CreateMainForm()";
 @end;

 @begin UserFunction "StartApp(String args[])"
  Compiler 1;
  GencodeSrcLine 26;
  FunctionName "IJDBC_LookUp::StartApp(String args[])";
 @end;

 @begin UserFunction "RunApp(String args[])"
  Compiler 1;
  GencodeSrcLine 34;
  FunctionName "IJDBC_LookUp::RunApp(String args[])";
 @end;

 @begin UserFunction "EndApp(String args[])"
  Compiler 1;
  GencodeSrcLine 119;
  FunctionName "IJDBC_LookUp::EndApp(String args[])";
 @end;

 @begin HPPPrefixBlock
@begin-code HPPPrefix

// add your custom import statements here
import java.io.*;
import java.sql.*;

@end-code;
  GencodeSrcLine 6;
 @end;

 @begin ClassContentsBlock
@begin-code ClassContents

    // add your data members here
    WebConnection server;

@end-code;
  GencodeSrcLine 122;
 @end;

@begin-code BaseClassList

extends Object

@end-code;

@begin-code GeneratedClassContents


@end-code;

@begin-code Code "IJDBC_LookUp::IJDBC_LookUp()"

    public @CLASSNAME@()
    {
        super();
    }

@end-code;

@begin-code Code "IJDBC_LookUp::main(String args[])"

    public static void main(String args[])
    {
        @@CLASSNAME@ app = new @CLASSNAME@();
        app.StartApp(args);
        app.RunApp(args);
        app.EndApp(args);
    }

@end-code;

@begin-code Code "IJDBC_LookUp::CreateMainForm()"

    public void CreateMainForm()
    {
    }

@end-code;

@begin-code Code "IJDBC_LookUp::StartApp(String args[])"

    public void StartApp(String args[])
    {
        server = new WebConnection(args);
        if (! server.getConnected() ) {
            System.err.println("Connection to Server failed");
            System.exit(2);
        }
    }

@end-code;

@begin-code Code "IJDBC_LookUp::RunApp(String args[])"

    public void RunApp(String args[])
    {
        //CreateMainForm();
        try {
            // Printing out headers
            server.writeln( "<CENTER><H1>JDBC ISAPI LookUp Sample</CENTER></H1>" );
            server.writeln( "<P>\n<BR>\n<HR>\n<BR>" );

            // Trying to load the Sybase JDBC Driver
            Class.forName( "com.sybase.jdbc.SybDriver" );

            // Creating the URL from the 'host' and 'port' specified
            String urlBase  = "jdbc:sybase:Tds:";
            String host     = null;
            String port     = null;
            String userId   = "dba";
            String password = "sql";
            String query    = "SELECT * FROM DBA.customer WHERE customer.id = 101";

            if( server.getIsPostMethod() ) {
                host = server.getFormVariable( "host" );
                port = server.getFormVariable( "port" );
            } else {
                host = server.getQueryVariable( "host" );
                port = server.getQueryVariable( "port" );
            }

            String url = urlBase + host + ":" + port;
            server.write( "<P>Trying to connect to: " );
            server.writeln( url );

            // Connect to the database at that URL.
            Connection _conn = DriverManager.getConnection( url, userId, password );
            Statement _stmt = _conn.createStatement();

            // Execute the query
            server.write( "<P>Sending query: " );
            server.write( query );
            server.writeln( "<BR>" );
            ResultSet _rs = _stmt.executeQuery( query );

            // Print out the customer's info
            _rs.next();
            server.writeln( "<H2><em>Customer Information</em></H2>" );


            server.write( "<P><strong>Id</strong>: " );
            server.writeln( _rs.getString( 1 ) );
            server.write( "<P><strong>First Name</strong>: ");
            server.writeln( _rs.getString( 2 ) );
            server.write( "<P><strong>Last Name</strong>: " );
            server.writeln( _rs.getString( 3 ) );
            server.write( "<P><strong>Adress</strong>: " );
            server.writeln( _rs.getString( 4 ) );
            server.write( "<P><strong>City</strong>: " );
            server.writeln( _rs.getString( 5 ) );
            server.write( "<P><strong>State</strong>: " );
            server.writeln( _rs.getString( 6 ) );
            server.write( "<P><strong>Zip</strong>: " );
            server.writeln( _rs.getString( 7 ) );
            server.write( "<P><strong>Phone</strong>: " );
            server.writeln( _rs.getString( 8 ) );
            server.write( "<P><strong>Company Name</strong>: " );
            server.writeln( _rs.getString( 9 ) );

            // Closing the statement and the connection
            if( _stmt != null ) {
                _stmt.close();
            }

            if( _conn != null ) {
                _conn.close();
            }

              server.writeln( "<P>\n<BR>\n<HR>\n<BR>" );

        } catch( WebServiceException e ) {
            server.writeln( "<H2>WebService Exception: " + e.getMessage() );
        } catch( ClassNotFoundException e ) {
            server.writeln( "<H2>ClassNotFound Exception: " + e.getMessage() );
        } catch( Exception e ) {
            server.writeln( "<H2>Unexpected Exception: " + e.getMessage() );
        }

    }

@end-code;

@begin-code Code "IJDBC_LookUp::EndApp(String args[])"

    public void EndApp(String args[])
    {
    }

@end-code;
@end;