databasecontact.java

来自「Java the UML Way 书中所有源码」· Java 代码 · 共 38 行

/*
 * DatabaseContact.java   E.L. 2001-08-26
 */

import javax.swing.*;
import java.sql.*;
class DatabaseContact {
  public static void main(String[] args) throws Exception {
    String databaseDriver = "oracle.jdbc.driver.OracleDriver";
    Class.forName(databaseDriver);

    String userName = JOptionPane.showInputDialog("User Name: ");
    String password = JOptionPane.showInputDialog("Password: ");
    String databaseName = "jdbc:oracle:thin:@loiosh.stud.idb.hist.no:1521:orcl";
    Connection conn
      = DriverManager.getConnection(databaseName, userName, password);

    Statement statement = conn.createStatement();

    ResultSet res = statement.executeQuery("select * from person");
    while (res.next()) {
      int idNo = res.getInt("identNo");
      String firstName = res.getString("firstname");
      String lastName = res.getString("lastname");
      System.out.println(idNo + ": " + firstName + " " + lastName);
    }
    res.close();
    statement.close();
    conn.close();
    System.exit(0);  
  }
}

/* Example Run:
100: EDWARD BROWN
101: ANN MARGARET GREEN
102: JOHN JOHNSON
*/