InterSystems Learning Services| InterSystems

「ゲスト」として閲覧しています。進捗は記録されません。

トピックアウトライン

Using JDBC with InterSystems IRIS
Using JDBC with InterSystems IRIS
Content Type
Video

Duration
4m

Level
Introductory

Learn how to use JDBC to connect your Java applications to InterSystems IRIS® data platform.
- Mark me "complete" for this video.

Code Used in This Video

Reference	Timestamp	Code
Location of the JDBC Driver	0:45	\dev\java\lib\JDK17 or \dev\java\lib\JDK18
URL (connection string)	0:53	jdbc:IRIS://host_IP:SuperServerPort/namespace
Java class that connects to InterSystems IRIS using the JDBC driver, then creates a statement object and executes a SQL query	n/a	Begin code: import com.intersystems.jdbc.; public class JDBCLearnTaxi { public static void main (String[] args) { String dbUrl = “jdbc:IRIS://127.0.0.1:1972/User”; //replace String user = “superuser”; String pass = “SYS”; try { IRISDataSource ds = new IRISDataSource(); ds.setURL(dbUrl); ds.setUser(user); ds.setPassword(pass); Connection dbconnection = ds.getConnection(); System.out.println(“Connected to InterSystems IRIS via JDBC.”); Statement myStatement = dbconnection.createStatement(); ResultSet myRS = myStatement.executeQuery(“select from zeppelin.GreenTrip”); //READ while (myRS.next()) { String venderID = myRS.getString(“vendorID”); String tripType = myRS.getString(“Trip_type”); String passCount = myRS.getString(“passenger_count”); Date tipAmount = myRS.getDate(“Tip_amount”); System.out.println(venderID + “\t”+tripType + “\t” + passCount + “\t” + tipAmount); } } catch (SQLException e) { System.out.println(e.getMessage()); } } } End code

Reference

Timestamp

Code

Location of the JDBC Driver

0:45

\dev\java\lib\JDK17

\dev\java\lib\JDK18

URL (connection string)

0:53

jdbc:IRIS://host_IP:SuperServerPort/namespace

Java class that connects to InterSystems IRIS using the JDBC driver, then creates a statement object and executes a SQL query

n/a

Begin code:

import com.intersystems.jdbc.*;

public class JDBCLearnTaxi {
   public static void main (String[] args) {
      String dbUrl = “jdbc:IRIS://127.0.0.1:1972/User”; //replace
      String user = “superuser”;
      String pass = “SYS”;

      try {
         IRISDataSource ds = new IRISDataSource();
         ds.setURL(dbUrl);
         ds.setUser(user);
         ds.setPassword(pass);
         Connection dbconnection = ds.getConnection();
         System.out.println(“Connected to InterSystems IRIS via JDBC.”);
         Statement myStatement = dbconnection.createStatement();

         ResultSet myRS = myStatement.executeQuery(“select * from zeppelin.GreenTrip”);

         //READ
         while (myRS.next()) {
            String venderID = myRS.getString(“vendorID”);
            String tripType = myRS.getString(“Trip_type”);
            String passCount = myRS.getString(“passenger_count”);
            Date tipAmount = myRS.getDate(“Tip_amount”);

            System.out.println(venderID + “\t”+tripType + “\t” + passCount + “\t” + tipAmount);
          }

      }
      catch (SQLException e)
     {                 
        System.out.println(e.getMessage());
      }
   }
}

End code

What's Next?
What's Next?
Learn how to connect your Java applications to InterSystems® products and technologies (learning path, 3h).
Read more about JDBC (documentation).

トピックアウトライン

Using JDBC with InterSystems IRIS

Code Used in This Video

What's Next?

Languages available

Share Your Feedback!

Report Issue/Feedback