testtrack.java

来自「此程序都是企业级 的数据库开发程序 全面揭示了JAVA对数据库的操作」· Java 代码 · 共 67 行

package statements;

import java.sql.*;
import java.util.*;
import connections.ConnectionFactory;

public class TestTrack {
  public static void main(String[] args) {
    Connection connection = null;
    PreparedStatement ps = null;

    try {
      connection = ConnectionFactory.getConnection();
      String sql = Track.getFindTrackTitleSql();
      ps = connection.prepareStatement(sql);
      Track track = new Track();
      track.setQueryStatement(ps);

      String subs = "ee";
      System.out.println("\nSearch track titles for " + subs);
      Vector v = track.findByTrackTitle(subs);
      Iterator iterator = v.iterator();
      while (iterator.hasNext()) {
        Track t = (Track) iterator.next();
        checkForSubstring(t.getTrackTitle(), subs);
      } 

      subs = "You";
      System.out.println("\nSearch track titles for " + subs);
      v = track.findByTrackTitle(subs);
      iterator = v.iterator();
      while (iterator.hasNext()) {
        Track t = (Track) iterator.next();
        checkForSubstring(t.getTrackTitle(), subs);
      } 

      sql = Track.getFindRecordTitleSql();
      ps = connection.prepareStatement(sql);
      track.setQueryStatement(ps);
      subs = "ac";
      System.out.println("\nSearch recording titles for " + subs);
      v = track.findByTrackTitle(subs);
      iterator = v.iterator();
      while (iterator.hasNext()) {
        Track t = (Track) iterator.next();
        checkForSubstring(t.getRecordingTitle(), subs);
      } 

    } catch (Exception e) {
      e.printStackTrace();
    } finally {
      ConnectionFactory.close(ps);
      ConnectionFactory.close(connection);
    } 
  } 

  static void checkForSubstring(String fullString, String substring) {
    System.out.print("Checking '" + fullString + "' for '" + substring +
                     "' : ");
    if (fullString.indexOf(substring) != -1) {
      System.out.println("OK");
    } else {
      System.out.println("ERROR!");
    } 
  } 
}