Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- String sql = "SELECT poMast.ORDNO from AMFLIBL.POMAST AS poMast ";
- Class.forName("com.ddtek.jdbc.db2.DB2Driver");
- String url = "jdbc:datadirect:db2://hostname:port;DatabaseName=dbName;";
- Connection con = DriverManager.getConnection(url, "username","password");
- PreparedStatement preparedStatement = con.prepareStatement(sql);
- ResultSet rs = preparedStatement.executeQuery();
- System.out.println("ResultSet : n");
- System.out.println(" VNDNO");
- while (rs.next())
- {
- System.out.println(rs.getString("ORDNO"));
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement