import junit.framework.*;
public class AllTests {
  public static Test suite() {
    TestSuite suite  = new TestSuite();
    suite.addTest(new Driver("testApplication"));
    return suite;
  }
  public static void main(String args[]) {
    Test allTests = suite();
    TestResult result = new TestResult();
    allTests.run(result);
    result.print();
  }
}
import junit.framework.*;
import java.sql.*;
public class Driver extends TestCase {
  public Driver(String s) { super(s); }
  public void testApplication() {
    GUI gui = new GUI();
    Report rpt = new Report();
    DataBase db = new DataBase("suppDB","any","any");
    String key;
    String[] fields;
    String table;
    String query;
    ResultSet rs = null;
    String line;
    
  }
}
import java.sql.*;
public class DataBase {
  private static final String driverName = "org.gjt.mm.mysql.Driver";
  private String url   = "jdbc:mysql://gold.mcs.csuhayward.edu:3306/";
  private String dbuser;
  private String dbpass;
  private String dbname;
  public DataBase(String name, String user, String password) {
    dbuser = user;
    dbpass = password;
    dbname = name;
    url = url + dbname;
  }
  public ResultSet executeQuery(String query) throws Exception {
    ResultSet rs;
    Class.forName(driverName);
    Connection con = DriverManager.getConnection(url,dbuser,dbpass);
    Statement stmt = con.createStatement();
    stmt.execute(query);
    rs = stmt.getResultSet();
    return rs;
  }
}
public class GUI {
  public String getKey() {
    return "";
  }
  public String[] getFields() {
    String[] fields = new String[0]; 
    return fields;
  }
  public String getTable() {
    return "";
  }
  public void displayReport(String s) {
  } 
}
import java.sql.*;
public class Report {
  public String formQuery(String key, String table) {
    String query = "select * from ";
    query += table + " where S_NO = '" + key + "'";
    return query;
  }
  public String generateReport(ResultSet rs, String key, String[] fields) {
    String line = "";
    try {
      if (rs.next()) {
        for (int i=0; i<fields.length; i++)
          line += fields[i] + ": " + rs.getString(fields[i]) + "  ";
      }
      else
        line = "Cannot find key: " + key;
    } catch (Exception e) { line = e.getMessage(); }
    return line;
  }
}