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; } }