Cisco CiscoWorks LAN Management Solution 4.0 Technical References

This section contains:

This section contains the sample code for:

The following is the sample code to connect to the database, using the Jconnect JDBC access method:

import java.util.Date;

import java.sql.*;

public class JdbcAccess {

private static Connection 

;

private static Statement 

;

private static ResultSet 

;

/**

 * @param args

 */

public static void main(String[] args) throws SQLException, ClassNotFoundException {

Class.forName("com.sybase.jdbc2.jdbc.SybDriver");

// The following information such as port, and service names are to be 

// changed based on the application database that you want to connect. 

// For example, conn = DriverManager.getConnection("jdbc:sybase:Tds:localhost:

// <ServerPort>?SERVICENAME=<DBName>","<View username>","<View password>");

conn = DriverManager.getConnection("jdbc:sybase:Tds:

:

?

SERVICENAME=

","

","

");

System.out.println("[" + new Date() + "] INFO: Connection successful...");

//Create Statement now

 = 

.createStatement();

String query = "SELECT Device_Id, Device_Display_Name, Management_IPAddress FROM 

Network_Devices";

 = stmt.executeQuery(query);

while (

.next()) {

System.out.println("Device_Id: " + rs.getString("Device_Id"));

System.out.println("Device_Display_Name: " + 

.getString("Device_Display_Name"));

System.out.println("Management_IPAddress" + 

.getString("Management_IPAddress"));

System.out.println("-----------------------------------------------------------");

}

}

}

This sample code uses the Jconnect JDBC driver. You must include the Jconnect Jar file 
(NMSROOT/lib/classpath/jconn2.jar) in the CLASSPATH before you connect to the database.