11package com .databend .jdbc .examples ;
22
3- import jdk . internal . org . jline . utils . Log ;
3+ import com . databend . jdbc . DatabendNodes ;
44
5+ import java .util .logging .Logger ;
56import java .sql .Connection ;
67import java .sql .DriverManager ;
78import java .sql .PreparedStatement ;
89import java .sql .ResultSet ;
910import java .sql .SQLException ;
1011
12+
1113class Examples {
1214 private static Connection createConnection ()
1315 throws SQLException {
1416 String url = "jdbc:databend://localhost:8000" ;
1517 return DriverManager .getConnection (url , "databend" , "databend" );
1618 }
17-
19+ private static final Logger logger = Logger . getLogger ( DatabendNodes . class . getPackage (). getName ());
1820 public static void main (String [] args ) throws SQLException {
1921 // set up
2022 Connection c = createConnection ();
21- Log .info ("-----------------" );
22- Log .info ("Databend JDBC Examples" );
23+ logger .info ("-----------------" );
24+ logger .info ("Databend JDBC Examples" );
2325 // execute demo
2426 c .createStatement ().execute ("drop table if exists test_prepare_statement" );
2527 c .createStatement ().execute ("create table test_prepare_statement (a int, b string)" );
@@ -33,21 +35,21 @@ public static void main(String[] args) throws SQLException {
3335 statement .setString (2 , "b" );
3436 statement .addBatch ();
3537 int [] result = statement .executeBatch ();
36- Log .info ("Insert result: " + result [0 ]);
38+ logger .info ("Insert result: " + result [0 ]);
3739 }
3840 // update with PreparedStatement
3941 String updateSQL = "update test_prepare_statement set b = ? where a = ?" ;
4042 try (PreparedStatement statement = conn .prepareStatement (updateSQL )) {
4143 statement .setInt (2 , 1 );
4244 statement .setString (1 , "c" );
4345 int result = statement .executeUpdate ();
44- Log .info ("Update result: " + result );
46+ logger .info ("Update result: " + result );
4547 }
4648
4749 // executeQuery and return ResultSet
4850 ResultSet r = conn .createStatement ().executeQuery ("select * from test_prepare_statement" );
4951 while (r .next ()) {
50- Log .info ("Row: " + r .getInt (1 ) + ", " + r .getString (2 ));
52+ logger .info ("Row: " + r .getInt (1 ) + ", " + r .getString (2 ));
5153 }
5254
5355 // replace into with PreparedStatement
@@ -57,23 +59,23 @@ public static void main(String[] args) throws SQLException {
5759 statement .setString (2 , "d" );
5860 statement .addBatch ();
5961 int [] result = statement .executeBatch ();
60- Log .info ("Replace into result: " + result [0 ]);
62+ logger .info ("Replace into result: " + result [0 ]);
6163 }
6264 ResultSet r2 = conn .createStatement ().executeQuery ("select * from test_prepare_statement" );
6365 while (r2 .next ()) {
64- Log .info ("Row: " + r2 .getInt (1 ) + ", " + r2 .getString (2 ));
66+ logger .info ("Row: " + r2 .getInt (1 ) + ", " + r2 .getString (2 ));
6567 }
6668 // delete with PreparedStatement
6769 String deleteSQL = "delete from test_prepare_statement where a = ?" ;
6870 try (PreparedStatement statement = conn .prepareStatement (deleteSQL )) {
6971 statement .setInt (1 , 1 );
7072 int result = statement .executeUpdate ();
71- Log .info ("Delete result: " + result );
73+ logger .info ("Delete result: " + result );
7274 }
7375 ResultSet r3 = conn .createStatement ().executeQuery ("select * from test_prepare_statement" );
7476// Assert.assertEquals(0, r3.getRow());
7577 while (r3 .next ()) {
76- Log .info ("Row: " + r3 .getInt (1 ) + ", " + r3 .getString (2 ));
78+ logger .info ("Row: " + r3 .getInt (1 ) + ", " + r3 .getString (2 ));
7779 }
7880 }
7981}
0 commit comments