artistsearchbean.java

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

package javabean;

import connections.ConnectionFactory;
import statements.Track;

import java.util.Vector;
import java.sql.*;

public class ArtistSearchBean {

  private String searchCriteria;

  public ArtistSearchBean() {
    searchCriteria = "";
  }

  public String getSearchCriteria() {
    return searchCriteria;
  }

  public void setSearchCriteria(String searchCriteria) {
    if (searchCriteria == null) {
      this.searchCriteria = "";
    }
    else this.searchCriteria = searchCriteria;
  }

  /**
   * Execute the search and return the results of our search as a Track array
   */
  public Track[] executeSearch() {
    Track t = new Track();
    Track[] searchResult = null;

    Connection conn = null;
    PreparedStatement ps = null;
    try {
      conn = ConnectionFactory.getConnection();
      ps = conn.prepareStatement(t.getFindArtistSql());
      t.setQueryStatement(ps);
      Vector v = t.findByArtistName(searchCriteria);
      searchResult = (Track[])v.toArray(new Track[0]);      
    }
    catch (SQLException sqle) {
      sqle.printStackTrace();
    }
    finally {
      try {
        if (ps != null) ps.close();
        if (conn != null) conn.close();
      }
      catch (SQLException sqle) {
        throw new java.lang.InternalError("Something really bad happened.");
      }
   }
   return searchResult;
  }

}