/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */
package testdb;

import java.sql.*;

public class DataBaseUtil {

    // метод для получения соединения !!!
    // Connection - интерфейс для получения соединения с БД
    public static Connection getConn() throws SQLException {
        String connectionString = "jdbc:mariadb://localhost:3306/test?useUnicode=true&characterEncoding=UTF-8&user=root&password=";
        final Connection connection = DriverManager.getConnection(connectionString);
        return connection;
    }

    // select * from test.t2 t
    public static void printTableData() {
        // try-with-resources
        String sql = "select * from test.t2 t";
        try (Connection c = getConn();
                Statement s = c.createStatement();
                ResultSet rs = s.executeQuery(sql)) {

        } catch (SQLException ex) {
            ex.printStackTrace();
        }
    }
}