-
Notifications
You must be signed in to change notification settings - Fork 0
/
MainDriver.java
52 lines (45 loc) · 2.4 KB
/
MainDriver.java
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
// Driver to test the Manager class
// Author: Siomara Pantarotto
// File : ManDriver.java
// Date : June,30,2000
import java.sql.*;
public class MainDriver {
///////////////////////////////////////////////////////////////////////////////
// Main - Principal entry
//
public static void main( String args[] )
{ Connection con = new DBConnection().getConnection();
Manager mgr1 = new Manager(con, "DEPTS", "Department" );
System.out.println("\n-------------------------------------------------------------");
Department d1 = (Department) mgr1.query("nbr = 1");
System.out.println("\nRowId : " + d1.getRowId());
System.out.println("Nbr : " + d1.getNbr());
System.out.println("Name : " + d1.getName());
System.out.println("Code : " + d1.getCode());
System.out.println("Party Budget: " + d1.getPartyBudget());
System.out.println("\n-------------------------------------------------------------");
Department d2 = (Department) mgr1.query("nbr = 999");
System.out.println("\nRowId : " + d2.getRowId());
System.out.println("Nbr : " + d2.getNbr());
System.out.println("Name : " + d2.getName());
System.out.println("Code : " + d2.getCode());
System.out.println("Party Budget: " + d2.getPartyBudget());
Manager mgr2 = new Manager(con, "EMPLOYEE", "Employee" );
System.out.println("\n-------------------------------------------------------------");
Employee e1 = (Employee) mgr2.query("id = 1");
System.out.println("\nRowId : " + e1.getRowId());
System.out.println("Id Number : " + e1.getId());
System.out.println("Last Name : " + e1.getLastName());
System.out.println("First Name : " + e1.getFirstName());
System.out.println("Email : " + e1.getEmail());
System.out.println("Salary/hour : " + e1.getSalary());
System.out.println("\n-------------------------------------------------------------");
Employee e2 = (Employee) mgr2.query("id = 999");
System.out.println("\nRowId : " + e2.getRowId());
System.out.println("Id Number : " + e2.getId());
System.out.println("Last Name : " + e2.getLastName());
System.out.println("First Name : " + e2.getFirstName());
System.out.println("Email : " + e2.getEmail());
System.out.println("Salary/hour : " + e2.getSalary());
}
}