import java.sql.*;

//conexão à base de dados
public class DBConnection
{
    private Connection con;
    private Statement st;
    private ResultSet rs;

    public DBConnection()
    {
        try
        {
            Class.forName("com.mysql.jdbc.Driver");
            con = DriverManager.getConnection("jdbc:mysql://localhost:3306/practice","root","");
            st = con.createStatement();
        }
        catch(Exception ex)
        {
            System.out.println("Error: "+ex);
        }
    }

    public void getData()
    {
        try
        {
            String query = "SELECT * FROM practice";
            rs = st.executeQuery(query);
            System.out.println("Records from Database");
            while(rs.next())
            {
                String id = rs.getString("id");
                String nome = rs.getString("nome");
                String preco = rs.getString("preco");
                System.out.println("ID: "+id+" Nome: "+nome+" Preço: "+preco);

            }
        }
        catch(Exception ex)
        {
            System.out.println(ex);
        }
    }
}