jdbc

public static void main(String args[]) throws IOException
{
try
{
//Loads Type 2 Driver
Class.forName("COM.ibm.db2.jdbc.app.DB2Driver");

}
catch (ClassNotFoundException e)
{
System.err.println("Could not load DB2 driver! \n");
System.err.println(e.getMessage());
System.exit(1);
}

/* Type 2 driver url */
//String url = "jdbc:db2:r_m";
String url = "jdbc:db2://localhost:50000/r_m";

String query = "select fname,id from rohit.EMPLOYEEDETAILS;";

try
{
//Connect to a database
Connection conn = DriverManager.getConnection(url,"user","password");

//Create statement for the connections
Statement stmt = conn.createStatement();

//Execute the query
ResultSet rs = stmt.executeQuery(query);

//Loop through the result and print it out
System.out.println(query);
System.out.println("\nNAME \tID");
System.out.println("----------------------------");

while (rs.next())
{
System.out.print(rs.getString(1) + " \t" );
System.out.println(rs.getString(2));
}