/*
 * 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)) {
            // ResultSet - интерфейс для получения данных в виде набора записей (строк)
            while(rs.next()){
                String id = rs.getString("id");
                String name = rs.getString("name");
                System.out.println("printTableData.id="   + id);
                System.out.println("printTableData.name=" + name);
            }
        } catch (SQLException ex) {
            ex.printStackTrace();
        }
    }
}