How do I get database product information?

By I Wayan Saryada in JDBC 0 Comment

The code below helps you to get some product information about the database that you use in creating your program. You can retrieve database information such as the major and minor version of the product, the database product name and its release version.

package org.kodejava.jdbc;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.DatabaseMetaData;
import java.sql.SQLException;

public class DatabaseProductInfo {
    private static final String URL = "jdbc:mysql://localhost/kodejava";
    private static final String USERNAME = "kodejava";
    private static final String PASSWORD = "s3cr*t";

    public static void main(String[] args) {
        try (Connection connection =
                     DriverManager.getConnection(URL, USERNAME, PASSWORD)) {
            DatabaseMetaData metadata = connection.getMetaData();

            String productName = metadata.getDatabaseProductName();
            String productVersion = metadata.getDatabaseProductVersion();
            int majorVersion = metadata.getDatabaseMajorVersion();
            int minorVersion = metadata.getDatabaseMinorVersion();

            System.out.println("Product Name    = " + productName);
            System.out.println("Product Version = " + productVersion);
            System.out.println("Major Version   = " + majorVersion);
            System.out.println("Minor Version   = " + minorVersion);
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}

And here are the results:

Product Name    = MySQL
Product Version = 5.7.43
Major Version   = 5
Minor Version   = 7

Maven Dependencies

<dependency>
    <groupId>com.mysql</groupId>
    <artifactId>mysql-connector-j</artifactId>
    <version>8.4.0</version>
</dependency>

Maven Central

How do I get JDBC driver information?

By I Wayan Saryada in JDBC 0 Comment

JDBC stands for Java Database Connectivity. It is an API (Application Programming Interface) in Java that allows Java applications to interact with databases. JDBC provides a set of interfaces and classes for connecting to a database, executing SQL queries, and retrieving results.

It is part of the Java Standard Edition platform and is designed to be database-independent, enabling Java developers to write database code that can work with different database management systems (DBMS) without significant changes.

Key features of JDBC include:

  1. Connection Management: Establishing and managing a connection to a database.
  2. Statement Execution: Executing SQL queries and updates using various types of statements.
  3. Result Set Handling: Retrieving and processing the results of queries.
  4. Transaction Management: Managing transactions to ensure data integrity.
  5. Metadata Access: Retrieving metadata about the database and its structure.

Here is the code snippet to get the basic information about JDBC driver such as the driver name and the version.

package org.kodejava.jdbc;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.DatabaseMetaData;
import java.sql.SQLException;

public class JDBCDriverInfo {
    private static final String URL = "jdbc:mysql://localhost/kodejava";
    private static final String USERNAME = "kodejava";
    private static final String PASSWORD = "s3cr*t";

    public static void main(String[] args) {
        try (Connection conn =
                     DriverManager.getConnection(URL, USERNAME, PASSWORD)) {

            DatabaseMetaData metadata = conn.getMetaData();
            String driverName = metadata.getDriverName();
            String driverVersion = metadata.getDriverVersion();
            int majorVersion = metadata.getDriverMajorVersion();
            int minorVersion = metadata.getDriverMinorVersion();

            System.out.println("Driver Name    = " + driverName);
            System.out.println("Driver Version = " + driverVersion);
            System.out.println("Major Version  = " + majorVersion);
            System.out.println("Minor Version  = " + minorVersion);
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}

The result of our program:

Driver Name    = MySQL Connector/J
Driver Version = mysql-connector-j-8.4.0 (Revision: 1c3f5c149e0bfe31c7fbeb24e2d260cd890972c4)
Major Version  = 8
Minor Version  = 4

Maven Dependencies

<dependency>
    <groupId>com.mysql</groupId>
    <artifactId>mysql-connector-j</artifactId>
    <version>8.4.0</version>
</dependency>

Maven Central

How do I get currency symbol?

By I Wayan Saryada in Core API, Util Package 1 Comment 
package org.kodejava.util;

import java.util.Currency;
import java.util.Locale;

public class CurrencySymbol {
    public static void main(String[] args) {
        Currency currency = Currency.getInstance(Locale.JAPAN);
        System.out.println("Japan = " + currency.getSymbol());

        currency = Currency.getInstance(Locale.UK);
        System.out.println("UK = " + currency.getSymbol());

        currency = Currency.getInstance(Locale.US);
        System.out.println("US = " + currency.getSymbol());

        currency = Currency.getInstance(new Locale("in", "ID"));
        System.out.println("Indonesia = " + currency.getSymbol());
    }
}

The result of the code snippet above:

Japan = ¥
UK = £
US = $
Indonesia = IDR

How do I create mouse event using Robot class?

By I Wayan Saryada in AWT, Core API 0 Comment

In this example we are automating the process of creating mouse event using the java.awt.Robot class.

package org.kodejava.awt;

import java.awt.AWTException;
import java.awt.Robot;
import java.awt.event.InputEvent;

public class MovingMouseDemo {
    public static void main(String[] args) {
        try {
            Robot robot = new Robot();

            // Move mouse cursor to 200, 500
            robot.mouseMove(200, 500);

            // Press the mouse button #1.
            robot.mousePress(InputEvent.BUTTON1_DOWN_MASK);
            robot.mouseRelease(InputEvent.BUTTON1_DOWN_MASK);

            // Scroll the screen down for a mouse with a wheel support.
            robot.mouseWheel(150);
        } catch (AWTException e) {
            e.printStackTrace();
        }
    }
}

How do I get the color of a screen pixel?

By I Wayan Saryada in AWT, Core API 0 Comment

The example here show us how to get the color of a pixel in the screen. We use the Robot.getPixelColor(int x, int y) method to obtain the Color of the pixel.

package org.kodejava.awt;

import java.awt.Color;
import java.awt.Robot;
import java.awt.AWTException;

public class ColorPickerDemo {
    public static void main(String[] args) {
        try {
            Robot robot = new Robot();

            // The pixel color information at 20, 20
            Color color = robot.getPixelColor(200, 200);

            // Print the RGB information of the pixel color
            System.out.println("Red   = " + color.getRed());
            System.out.println("Green = " + color.getGreen());
            System.out.println("Blue  = " + color.getBlue());

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

Example output of code snippet above:

Red   = 35
Green = 38
Blue  = 53