Java programming steps for connecting to the DB2 database to develop applications

We have introduced the implementation process of the DB2 database creation trigger and the methods and examples of calling the stored procedure of the DB2 database. In this article, we will introduceDB2Some steps for database Java programming. Next let's take a look at this process.

Java Database Link (JDBC)

DB2 Java supports JDBC, a supplier-centric dynamic SQL interface, which provides data access to applications through standard Java methods. JDBC is similar to DB2 CLI in that you do not have to pre-compile or compile JDBC programs. Applications compiled using JDBC only use dynamic SQL.

JDBC programming steps:

1. Establish a connection with the database:

 
 

  
  
Class.forName("Com.ibm.db2.jdbc.net.DB2Driver");  
  
  
 
  
  
connection con=DriverManager.getConnection(url); 
 
 

2. Create a Statement object:

 
 

  
  
Statement stmt=con.createStatement(); 
 
 

3. Execute the query statement:

 
 

  
  
ResultSet rs1_stmt.exe cQuery ("SQL statement ");
 
 

4. Get and set options:

ResultSetMetaData rsmd = rs. getMetaData ();

Int numCols = rsmd. getColumnCount () to obtain the total number of columns in the result set;

Rsmd. getColumnLabel (I) to obtain the record value;

SetMaxRows: set the maximum number of rows that a result set can accommodate.

SetQueryTimeout: Set the waiting time for a statement to be executed.

SetEscapeProcessing: notifies the driver of how to handle escape characters.

5. Disable Statement

 
 

  
  
stmt.clost(); 
 
 

Call layer interface (CLI)

CLI is not a new query language, but a simple interface for applications to use SQL statements to submit transactions for database query and modification, you still need to write it in SQL, including calling CLI functions.

The call layer interface (CLI) is one of the two mechanisms provided by DB2 to process dynamic SQL statements. That is, when an application is running for the first time, dynamic SQL statements are submitted to the database system, CLI depends on a group of function calls and can be embedded in the subject.

This article introduces the JDBC programming steps for DB2 databases and hopes to help you gain some benefits!