DB2的jdbc连接

package com.lyc.db2;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import junit.framework.TestCase;

import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;

public class DB2Test extends TestCase {
 
 private static Log logger = LogFactory.getLog(DB2Test.class);
 public void test1(){
  logger.debug("nihao");
 }
 public void testDB2() {
  Connection conn=null;
  ResultSet rs = null;
  try{
   Class.forName("com.ibm.db2.jcc.DB2Driver").newInstance();
   String url = "jdbc:db2://localhost:50000/sample";
   String user = "db2admin";
   String password = "db2admin";
   String sql = "select * from T_PERSON";
   conn= DriverManager.getConnection(url,user,password);
   rs = conn.createStatement().executeQuery(sql);
   while(rs.next()){
    String result = rs.getString("NAME");
    logger.debug(result);
   }
   logger.debug("连接成功");
  } catch (InstantiationException e) {
   logger.debug("数据库连接关闭失败");
   e.printStackTrace();
  } catch (IllegalAccessException e) {
   logger.debug("数据库连接关闭失败");
   e.printStackTrace();
  } catch (ClassNotFoundException e) {
   logger.debug("");
   e.printStackTrace();
  } catch (SQLException e) {
   e.printStackTrace();
  } finally {
   try {
    conn.close();
   } catch (SQLException e) {
    logger.debug("数据库连接关闭失败");
    e.printStackTrace();
   }
  }
 }
}