From a299226547b15de587dad614f07ce459d01f3601 Mon Sep 17 00:00:00 2001 From: Kamal Wickramanayake Date: Sun, 3 May 2026 14:32:16 +0530 Subject: Added jdbc demo sample application --- .../demo/src/main/java/com/example/jdbc/App.java | 40 ++++++++++++++++++++++ 1 file changed, 40 insertions(+) create mode 100644 database/jdbc/demo/src/main/java/com/example/jdbc/App.java (limited to 'database/jdbc/demo/src/main/java') diff --git a/database/jdbc/demo/src/main/java/com/example/jdbc/App.java b/database/jdbc/demo/src/main/java/com/example/jdbc/App.java new file mode 100644 index 0000000..d3abc90 --- /dev/null +++ b/database/jdbc/demo/src/main/java/com/example/jdbc/App.java @@ -0,0 +1,40 @@ +package com.example.jdbc; + +import java.sql.Connection; +import java.sql.DriverManager; +import java.sql.ResultSet; +import java.sql.Statement; + +/** + * Hello world! + */ +public class App { + + static final String URL = "jdbc:mariadb://localhost:3306/bank"; + static final String USER = "bankuser"; + static final String PASS = "bankpwd"; + static final String QUERY = "SELECT id, name, email FROM user"; + + public static void main(String[] args) { + // Step 1: Open a connection, create a statement, and execute the query + try (Connection conn = DriverManager.getConnection(URL, USER, PASS); + Statement stmt = conn.createStatement(); + ResultSet rs = stmt.executeQuery(QUERY)) { + + System.out.println("Connected to the database successfully!"); + + // Step 2: Iterate through the result set and display the data + while (rs.next()) { + // Retrieve data by column name or index (starting at 1) + int id = rs.getInt("id"); + String name = rs.getString("name"); + String email = rs.getString("email"); + + // Print the results + System.out.println("ID: " + id + ", Name: " + name + ", Email: " + email); + } + } catch (Exception e) { + e.printStackTrace(); // Handle any SQL or connection errors + } + } +} -- cgit v1.2.3