Connection connection = DriverManager.getConnection(
"jdbc:odbc:datasource", "login", "password");
Statement statement = connection.createStatement();
ResultSet resultSet = statement.executeQuery(
"SELECT anInt, aString, aFloat FROM Table1");
while (resultSet.next()) {
int anInt = resultSet.getInt("anInt");
String aString = resultSet.getString("aString");
float aFloat = resultSet.getFloat("aFloat");
}
|