DB2jar包及连接

DB2连接的两种方式：
JCC这种方式不用配置客户端 UNIX window 下均可以连接

public static void getConnection() {
		String driver = "COM.ibm.db2.jdbc.app.DB2Driver";
		String url = "jdbc:db2:TNS";//app连接方式 本地必须配置客户端 客户端必须配置需连接数据库的TNS
		String userName = "username";
		String passWord = "password";
		Connection conn = null;
		Statement st = null;
		ResultSet rs = null;
		String sql = "";
		try {
			Class.forName(driver).newInstance();
			conn = DriverManager.getConnection(url, userName, passWord);
			st = conn.createStatement();
			sql = "select count(*) from syscat.tables where tabname= 'xxxxx' ";
			rs = st.executeQuery(sql);
			while (rs.next()) {
				System.out.println("****" + rs.getString(1) + "****");
			}
			conn.close();
		} catch (Exception e) {
			System.out.println("select jcc 异常" + e);
		}
	}

	public static void getConnection2() {
		String driver = "com.ibm.db2.jcc.DB2Driver"; 
		String url = "jdbc:db2://10.70.9.202:50000/zmccdev";//默认是50000具体的自己查查 
		//unix环境  下 输入 DB2 输入  LIST NODE DIRECTORY 查看相关机器的监听端口
		String userName = "dw";
		String passWord = "dwdev";
		Connection conn = null;
		Statement st = null;
		ResultSet rs = null;
		String sql = "";
		try {
			Class.forName(driver).newInstance();
			System.out.println("****new succ****");
			try {
				conn = DriverManager.getConnection(url, userName, passWord);
			} catch (RuntimeException e) {
				System.out.println(" runtime Exception conn error");
				e.printStackTrace();
			}
			System.out.println("****conn succ****" + conn);
			st = conn.createStatement();
			System.out.println("****st succ****" + st);
			sql = "select count(*) from syscat.tables where tabname= 'TEST_LOAD_L' ";
			rs = st.executeQuery(sql);
			while (rs.next()) {
				System.out.println("****" + rs.getString(1) + "****");
			}
			conn.close();
		} catch (Exception e) {
			System.out.println("202 select jcc 异常" + e);
		}
	}