JAVA - How to run an SQL Select query using JDBC?
A SQL SELECT query is used to get data from a table. The results of the select query is called a result set.
try
{
// Create a result set containing all data from my_table
Statement stmt = connection.createStatement();
ResultSet rs = stmt.executeQuery("SELECT * FROM my_table");
}
catch (SQLException e)
{
}