The following is the source code for the server-side connection example. It is a modified version of the source code in samples-dir\SQLAnywhere\JDBC\JDBCConnect.java.
import java.io.*; import java.sql.*; public class JDBCConnect2 { public static void main( String args[] ) { try { // Open the connection. May throw a SQLException. Connection con = DriverManager.getConnection( "jdbc:default:connection" ); // Create a statement object, the container for the SQL // statement. May throw a SQLException. Statement stmt = con.createStatement(); // Create a result set object by executing the query. // May throw a SQLException. ResultSet rs = stmt.executeQuery( "SELECT ID, GivenName, Surname FROM Customers"); // Process the result set. while (rs.next()) { int value = rs.getInt(1); String FirstName = rs.getString(2); String LastName = rs.getString(3); System.out.println(value+" "+FirstName+" "+LastName); } rs.close(); stmt.close(); con.close(); } catch (SQLException sqe) { System.out.println("Unexpected exception : " + sqe.toString() + ", sqlstate = " + sqe.getSQLState()); } catch (Exception e) { e.printStackTrace(); } } } |
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |