import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Scanner;
import java.util.logging.Level;
import java.util.logging.Logger;
public class Jdbc {
public static void main(String[] args) {
try {
Class.forName("com.mysql.jdbc.Driver");
String user = "root";
String pass = "lab44";
String url = "jdbc:mysql://localhost/Estoque";
Connection con = DriverManager.getConnection(url, user, pass);
String sql = "select qtd from Produtos";
ResultSet rs = con.createStatement().executeQuery(sql);
while (rs.next()) {
System.out.println(rs.getString("nome"));
}
} catch (ClassNotFoundException ex) {
Logger.getLogger(Jdbc.class.getName()).log(Level.SEVERE, null, ex);
} catch (SQLException ex) {
Logger.getLogger(Jdbc.class.getName()).log(Level.SEVERE, null, ex);
}
}
}