preparedstmttest.java

Java the UML Way 书中所有源码

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

import javax.swing.*;
import java.sql.*;
class PreparedStmtTest {
  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);
    String sqlStatement = "select * from person where firstName like ? and lastName like ?";
    PreparedStatement statement = conn.prepareStatement(sqlStatement);

    do { // infinite loop for test purposes
      String searchCritFirstName
        = JOptionPane.showInputDialog("Search Criterion, First Name: ");
      String searchCritLastName
        = JOptionPane.showInputDialog("Search Criterion, Last Name: ");
      statement.setString(1, searchCritFirstName.toUpperCase());
      statement.setString(2, searchCritLastName.toUpperCase());

      System.out.println(
        "\nThe Search Criteria: " + searchCritFirstName + " " + searchCritLastName);

      ResultSet res = statement.executeQuery();
      while (res.next()) {
        int identNo = res.getInt("identNo");
        String firstName = res.getString("firstName");
        String lastName = res.getString("lastName");
        System.out.println(firstName + " " + lastName);
      }
      res.close();
    } while (true);
  }
}

/* Example Run:

The Search Criteria: % _____
EDWARD BROWN
ANN MARGARET GREEN

The Search Criteria: % %n
EDWARD BROWN
ANN MARGARET GREEN
JOHN JOHNSON
*/