Testing script for connect to db2 (10.5.5)

README.md

Directory structure

- lib/db2jcc.jar
- lib/db2jcc_license_cu.jar
- Test.java

Comple and Run

javac -cp "lib/*:." Test.java && java -cp "lib/*:." Tes

Sample Db Schema

https://www.ibm.com/support/knowledgecenter/SSEPGG_9.5.0/com.ibm.db2.luw.apdv.samptop.doc/doc/r0001094.html

DB2 Jar

http://www.dbschema.com/jdbc-drivers/Db2JdbcDriver.zip

Test.java

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;
import java.sql.ResultSet;
import java.util.ArrayList;

class Test {
	
	public static void main(String args[]) {
		String dsn      = "jdbc:db2://localhost:50000/SAMPLE";
		String username = "db2inst1";
		String password = "db2inst1-pwd";
		
		System.out.println("Hello world");
		
		try {
			Class.forName("com.ibm.db2.jcc.DB2Driver").newInstance();

			Connection connection = DriverManager.getConnection(dsn, username, password);

			Statement statement = connection.createStatement();
			ResultSet resultSet = statement.executeQuery("select * from org");
			
			ArrayList<String> columnList;
			
			while(resultSet.next()) {
				columnList = new ArrayList<String>();
				
				columnList.add(String.valueOf(resultSet.getInt("DEPTNUMB")));
				columnList.add(resultSet.getString("DEPTNUMB"));
				columnList.add(String.valueOf(resultSet.getInt("MANAGER")));
				columnList.add(resultSet.getString("DIVISION"));
				columnList.add(resultSet.getString("LOCATION"));
				
				System.out.println(String.join(" - ", columnList));
			}
		}catch(Exception e) {
			e.printStackTrace();
		}
	}
	
}