import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.Statement;

 

public class TestAS400 {

       public static void main(String[] args) {

 

             try {

                    String url = "jdbc:as400://IP";

                    Class.forName("com.ibm.as400.access.AS400JDBCDriver");

                    java.sql.Connection con = DriverManager.getConnection(url, "ID",

                                 "PASSWD");

                    Statement stmt = con.createStatement();

                    StringBuffer s = new StringBuffer();

                    s.append("\n SELECT");

                    s.append("\n SNO ,");

                    s.append("\n DATE ");

                    s.append("\n RNO  FROM SCHEMA.TABLE");

                    ResultSet rs = stmt.executeQuery(s.toString());

 

                    while (rs.next()) {

                           String e_projum = rs.getString("SNO");

                           String seq = rs.getString("DATE");

                           String itemname = rs.getString("RNO");

                           System.out.print(e_projum + "           ");

                           System.out.print("             " + seq + "           ");

                           System.out.println("          " + itemname);

                    }

                    rs.close();

                    stmt.close();

                    con.close();

             } catch (Exception ex) {

                    ex.printStackTrace();

             }

       }

}