package test;

import java.sql.*;

public class TesteConexao {
    public static void main(String[] args) {
        String url = "jdbc:mysql://root:VCIiGnIpVpAUCfAXxdaPSTvTvAJSNGuE@viaduct.proxy.rlwy.net:21894/railway";
        String usuario = "root";
        String senha = "VCIiGnIpVpAUCfAXxdaPSTvTvAJSNGuE";

        try (Connection conexao = DriverManager.getConnection(url, usuario, senha)) {
            String sql = "SELECT * FROM Funcionarios";
            Statement statement = conexao.createStatement();
            ResultSet resultSet = statement.executeQuery(sql);

            while (resultSet.next()) {
                int id = resultSet.getInt("idFuncionario");
                String nome = resultSet.getString("nomeFuncionario");
                String email = resultSet.getString("email");
                String senhaFuncionario = resultSet.getString("senha");
                String estadoLogin = resultSet.getString("estadoLogin");
                System.out.println("ID: " + id + ", Nome: " + nome + ", Email: " + email + ", Senha: " + senhaFuncionario + ", Estado de Login: " + estadoLogin);
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}