Skip to content

Commit 10e3800

Browse files
committed
fix
1 parent 02b750a commit 10e3800

File tree

1 file changed

+13
-11
lines changed
  • databend-jdbc/src/main/java/com/databend/jdbc/examples

1 file changed

+13
-11
lines changed

databend-jdbc/src/main/java/com/databend/jdbc/examples/Examples.java

Lines changed: 13 additions & 11 deletions
Original file line numberDiff line numberDiff line change
@@ -1,25 +1,27 @@
11
package 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;
56
import java.sql.Connection;
67
import java.sql.DriverManager;
78
import java.sql.PreparedStatement;
89
import java.sql.ResultSet;
910
import java.sql.SQLException;
1011

12+
1113
class 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

Comments
 (0)