import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.Properties;

public class ConnectionPropertiesExample {

    public static void main(String[] args) {

        String url = "jdbc:mysql://localhost:3306/jdbc_demo";

        // Creating connection properties
        Properties properties = new Properties();

        properties.setProperty("user", "root");
        properties.setProperty("password", "password");
        properties.setProperty("useSSL", "false");
        properties.setProperty("serverTimezone", "UTC");
        properties.setProperty("characterEncoding", "UTF-8");

        try {
            // Establishing connection using properties
            Connection connection =
                    DriverManager.getConnection(url, properties);

            System.out.println("Database connected successfully!");

            // Creating Statement
            Statement statement = connection.createStatement();

            // Executing query
            ResultSet resultSet =
                    statement.executeQuery("SELECT * FROM employee");

            System.out.println("\nEmployee Details:");

            while (resultSet.next()) {
                System.out.println(
                        resultSet.getInt("employee_id") + " | "
                        + resultSet.getString("employee_name") + " | "
                        + resultSet.getString("department") + " | "
                        + resultSet.getDouble("salary")
                );
            }

            // Closing resources
            resultSet.close();
            statement.close();
            connection.close();

            System.out.println("\nConnection closed successfully!");

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