package com.mycompany.data;

import java.sql.*;
import com.ibm.as400.access.*;

public class testAS400JDBC
{
  public testAS400JDBC(){
  }

  public static void main(String[] args){
    // define login info for as400
    String host = "1.2.3.4";
    String user = "USERNAME";
    String pwd = "PASSWORD";
 
    try{
      // make sure driver exists
      Class.forName("com.ibm.as400.access.AS400JDBCDriver");
    }catch(Exception e){
      System.out.println(e.toString());
    }

    try{
      // create a new connection from driver
      Connection con = DriverManager.getConnection("jdbc:as400://" + host, user, pwd);
      // create new statement from connection
      java.sql.Statement stmt = con.createStatement();

      // sql
      String sql="SELECT FNAME,LNAME FROM LIBRARY.FILE FETCH FIRST 10 ROWS ONLY";

      // execute query
      ResultSet rs = stmt.executeQuery(sql);  

      // loop through results
      while(rs.next()){
        System.out.println(rs.getString(1) + " " + rs.getString(2));
      }
 
      // close connection
      con.close();
      
    }catch(Exception e){
      System.out.println(e.toString());
    }
  }  
}