// 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)

 

全站熱搜
創作者介紹
創作者 fabch2 的頭像
fabch2

小刻家

fabch2 發表在 痞客邦 留言(0) 人氣()