Official Site

click here to view our new site launched

Pages

Friday, December 17, 2010

DB2 connectivity code

try{
Class.forName("com.ibm.db2.jcc.DB2Driver");
System.out.println("JDBC IBM Driver is loaded");
}
catch(Exception e)
{
System.out.println("Exception 1 :"+e);
out.println("Exception 1 :"+e);
}
Connection conn=null;
Statement stmt;
try{


conn=DriverManager.getConnection("jdbc:db2://localhost:50000/TEMP" ," db2admin" ,"db2admin");
System.out.println("Connected to DB2");
//out.println("Connected to DB2");
}
catch(Exception e)
{
System.out.println("exception 2 : "+e);
//out.println("exception 2 : "+e);

}
try{
PreparedStatement stm = null;
stmt=conn.createStatement();
ResultSet r=stmt.executeQuery("select * from SYSTEM.TEM");
//out.print("DFDF:");
while(r.next())
{out.print(""+r.getString(1));
}
conn.close();
}
catch(Exception e){
}
$2.49 .COM at GoDaddy.com! Expires 5/14/13