Overview

Method

1. Insert Sample Data

Sample table) 
SQL>create table test01 (id  number, name varchar(100), day date);
SQL>insert into test01 values (1, 'KIM', sysdate);
SQL>insert into test01 values (2, 'LEE', sysdate);
SQL>insert into test01 values (3, 'PARK', sysdate);
SQL>commit;
SQL> select * from test01;

       ID NAME                 DAY
---------- -------------------- ------------------------------
        1 KIM                  2025/03/12
        2 LEE                  2025/03/12
        3 PARK                 2025/03/12

3 rows selected.

2. JAVA Code Sample

import java.sql.Connection;
import com.tmax.tibero.jdbc.ext.TbDataSource;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Date;
import java.util.Calendar;
import java.text.SimpleDateFormat;

public class TiberoBindVariableExample {


   public static void main(String[] args) {
       TbDataSource tds = new TbDataSource();
       tds.setURL("jdbc:tibero:thin:@127.0.0.1:7300:tibero7_2_2_287079");
       tds.setUser("tibero");
       tds.setPassword("tmax");


   try (Connection connection = tds.getConnection();
        PreparedStatement pstmt = connection.prepareStatement("SELECT * FROM test01 WHERE id = ? OR name = ? OR TO_CHAR(day, 'YYYY/MM/DD') = TO_CHAR(?, 'YYYY/MM/DD')")) {

       int id = 1;
       String name = "PARK";

       // Create today's date as java.sql.Date type
       Calendar cal = Calendar.getInstance();
       cal.set(Calendar.HOUR_OF_DAY, 0);
       cal.set(Calendar.MINUTE, 0);
       cal.set(Calendar.SECOND, 0);
       cal.set(Calendar.MILLISECOND, 0);
       Date today = new Date(cal.getTimeInMillis());

       pstmt.setInt(1, id);
       pstmt.setString(2, name);
       pstmt.setDate(3, today);

       try (ResultSet rs = pstmt.executeQuery()) {
           while (rs.next()) {
               System.out.println("ID: " + rs.getInt("id"));
               System.out.println("Name: " + rs.getString("name"));
               System.out.println("Day: " + rs.getDate("day"));
           }
       }

   } catch (SQLException e) {
       e.printStackTrace();
   }

   }
}

3. JAVA Compilation

$ javac -cp "/home/jinhwa/tibero7_2_2_287079/client/lib/jar/tibero7-jdbc.jar" TiberoBindVariableExample.java
$ ls -alt | grep Tibero
-rw-rw-r--  1 jinhwa jinhwa     2952  Mar 12 15:06 TiberoBindVariableExample.class
-rw-rw-r--  1 jinhwa jinhwa     1329  Mar 12 15:03 TiberoBindVariableExample.java

4. JAVA Execution Result

$ java -cp "/home/jinhwa/tibero7_2_2_287079/client/lib/jar/tibero7-jdbc.jar:." TiberoBindVariableExample
ID: 1
Name: KIM
Day: 2025-03-12
ID: 2
Name: LEE
Day: 2025-03-12
ID: 3
Name: PARK
Day: 2025-03-12