// get Connection
String address = jTextField1.getText();
String name = jTextField2.getText();
String user = jTextField3.getText();
String password = String.valueOf(jPasswordField.getPassword());
String url = "jdbc:oracle:thin:@" + address + ":1521:" + name;
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection connection = DriverManager.getConnection(url, user, password);
connection.setAutoCommit(false);
// get Result Set
String sql = "...";
Statement statement = connection.createStatement();
statement.execute(sql);
ResultSet resultSet = statement.getResultSet();
// get String
while (resultSet.next()) {
String str = resultSet.getString(i);
...
}
// close
statement.close();
resultSet.close();
connection.close();
Connection (Java 2 Platform SE 5_0)
DriverManager (Java 2 Platform SE 5_0)
Statement (Java 2 Platform SE 5_0)
ResultSet (Java 2 Platform SE 5_0)
留言列表