Skip to content

Instantly share code, notes, and snippets.

@zeuxisoo

zeuxisoo/README.md

Last active October 7, 2016 06:55
Show Gist options
  • Save zeuxisoo/7fdc52ca5d799a9de4f0941efa2ca9a5 to your computer and use it in GitHub Desktop.
Save zeuxisoo/7fdc52ca5d799a9de4f0941efa2ca9a5 to your computer and use it in GitHub Desktop.
Download ZIP
Testing script for connect to db2 (10.5.5)
Raw
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

Raw
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();
}
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment