Re: [U2] JDBC - ClassPath - Victory

[Brutzman, Bill]

The following code works ok...

Thanks to all those who responded especially John, Jeff, Bruce, Charles,
Ben, and Mike.

--Bill

import java.sql.*;

public class Uni_101 {

    public static void main(String[] args) {
        try {

            try {
                Class.forName("com.ibm.u2.jdbc.UniJDBCDriver"); 
            }
            catch(Exception x){
                System.out.println( "Here " + x );
            }         
                                                  String url
= "jdbc:ibm-u2://192.168.0.102/SHIPPING";
                                                  String      userid
= "ups";
                                                  String
passWord  = "brown";

            Connection con = DriverManager.getConnection(url, userid,
passWord);
 
            Statement stmt = con.createStatement();

                                      String sql = "select @ID, NAME,
CITY, STATE from PACKSLIPS.X";
            ResultSet rs = stmt.executeQuery(sql);

            int i = 1;
            while (rs.next() && i < 6)
            {
                System.out.println("\nRecord "+ i +" :");
                System.out.println("\...@id : \t" + rs.getString(1));
                System.out.println("\tNAME :\t" + rs.getString(2));
                System.out.println("\tCITY :\t" + rs.getString(3));
                System.out.println("\tSTATE :\t" + rs.getString(4));
                i++;
            }

            rs.close();
            stmt.close() ;
            System.out.println("\n\t*--- QUERY test is done successful
---*\n");        
        
        }
        catch (SQLException e ) {
            System.out.println(e);
        }
    }

}
_______________________________________________
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users