- lib/db2jcc.jar
- lib/db2jcc_license_cu.jar
- Test.java
javac -cp "lib/*:." Test.java && java -cp "lib/*:." Tes
https://www.ibm.com/support/knowledgecenter/SSEPGG_9.5.0/com.ibm.db2.luw.apdv.samptop.doc/doc/r0001094.html
- lib/db2jcc.jar
- lib/db2jcc_license_cu.jar
- Test.java
javac -cp "lib/*:." Test.java && java -cp "lib/*:." Tes
https://www.ibm.com/support/knowledgecenter/SSEPGG_9.5.0/com.ibm.db2.luw.apdv.samptop.doc/doc/r0001094.html
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(); | |
} | |
} | |
} |