import java.sql.*;
try {
Connection conn = DriverManager
.getConnection(url, userName, password);
// Connect to the database
// ...
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery(
"SELECT " +
" Language, Percentage " +
"FROM countrylanguage " +
"WHERE CountryCode = 'RUS' " +
"ORDER BY Percentage DESC");
// Get first row
rs.next();
System.out.println(
rs.getString(1) + ": " + rs.getString(2));
// Get all rows
while (rs.next()) {
System.out.println(
rs.getString(1) + ": " + rs.getString(2));
}
conn.close();
}
catch (Exception e) {
e.printStackTrace();
}