Bill McQuain CS 2704 Spring 2001 Project 2: Templates ------------------------------------ ---------------------------------------------- Command: listBooks ------------------------------------ 0: ISBN: 0-06-102069-9 Title: Equal Rites AuthorID: P0003 Category: FANTASY Year: 1987 Sales: 32 ------------------------------------ 1: ISBN: 0-06-102070-2 Title: The Light Fantastic AuthorID: P0003 Category: FANTASY Year: 1986 Sales: 17 ------------------------------------ 2: ISBN: 0-345-33970-3 Title: The Fellowship of the Ring AuthorID: T0001 Category: FANTASY Year: 1981 Sales: 1043 ------------------------------------ 3: ISBN: 0-345-43481-1 Title: The Last Full Measure AuthorID: S0001 Category: FICTION Year: 1998 Sales: 83 ------------------------------------ 4: ISBN: 0-368-86760-X Title: The Abolition of Man AuthorID: L0001 Category: NONFICTION Year: 1947 Sales: 7 ------------------------------------ 5: ISBN: 0-380-79856-5 Title: The Ape Who Guards the Balance AuthorID: P0002 Category: FICTION Year: 1998 Sales: 217 ------------------------------------ 6: ISBN: 0-440-22401-2 Title: Heartwood AuthorID: B0001 Category: FICTION Year: 1999 Sales: 89 ------------------------------------ 7: ISBN: 0-466-60837-8 Title: Thunderhead AuthorID: P0004 Category: FICTION Year: 1999 Sales: 97 ------------------------------------ 8: ISBN: 0-684-71941-X Title: Look Homeward Angel AuthorID: W0003 Category: FICTION Year: 1957 Sales: 3 ------------------------------------ 9: ISBN: 0-7868-8930-6 Title: Cimmaron Rose AuthorID: B0001 Category: FICTION Year: 1997 Sales: 70 ------------------------------------ 10: ISBN: 0-8041-0858-7 Title: The Face of a Stranger AuthorID: P0001 Category: MYSTERY Year: 1990 Sales: 153 ------------------------------------ 11: ISBN: 0-8041-1037-9 Title: A Dangerous Mourning AuthorID: P0001 Category: MYSTERY Year: 1991 Sales: 179 ------------------------------------ 12: ISBN: 0-8041-1188-X Title: Defend and Betray AuthorID: P0001 Category: MYSTERY Year: 1992 Sales: 105 ------------------------------------ 13: ISBN: 0-8041-1283-5 Title: A Sudden, Fearful Death AuthorID: P0001 Category: MYSTERY Year: 1993 Sales: 225 ------------------------------------ 14: ISBN: 0-812-53253-8 Title: Ender's Game AuthorID: C0002 Category: SCIFI Year: 1985 Sales: 78 ------------------------------------ 15: ISBN: 0-812-54416-1 Title: The Saxon Shore AuthorID: W0001 Category: FICTION Year: 1998 Sales: 37 ------------------------------------ 16: ISBN: 0-812-54418-8 Title: The Fort at River's Bend AuthorID: W0001 Category: FICTION Year: 1999 Sales: 62 ------------------------------------ 17: ISBN: 0-812-55138-0 Title: The Skystone AuthorID: W0001 Category: FICTION Year: 1996 Sales: 59 ------------------------------------ 18: ISBN: 0-812-55140-0 Title: The Eagle's Brood AuthorID: W0001 Category: FICTION Year: 1997 Sales: 58 ------------------------------------ 19: ISBN: 0-991-54760-X Title: Beyond Good and Evil AuthorID: N0001 Category: NONFICTION Year: 1966 Sales: 1 ------------------------------------ ---------------------------------------------- Command: listAuthors ------------------------------------ 0: Name: Burke, James Lee ID: B0001 ------------------------------------ 1: Name: Card, Orson Scott ID: C0002 ------------------------------------ 2: Name: Lewis, C. S. ID: L0001 ------------------------------------ 3: Name: Nietzsche, Friedrich ID: N0001 ------------------------------------ 4: Name: Perry, Anne ID: P0001 ------------------------------------ 5: Name: Peters, Elizabeth ID: P0002 ------------------------------------ 6: Name: Pratchett, Terry ID: P0003 ------------------------------------ 7: Name: Preston, Douglas ID: P0004 ------------------------------------ 8: Name: Shaara, Jeff ID: S0001 ------------------------------------ 9: Name: Tolkien, J. R. R. ID: T0001 ------------------------------------ 10: Name: Whyte, Jack ID: W0001 ------------------------------------ 11: Name: Wolfe, Thomas ID: W0003 ------------------------------------ ---------------------------------------------- Command: delBook 0-06-102069-9 Book removed from dB. ---------------------------------------------- Command: delBook 0-991-54760-X Book removed from dB. ---------------------------------------------- Command: findAuthor P0003 Name: Pratchett, Terry 0-06-102070-2 The Light Fantastic P0003 FANTASY 1986 17 Total sales: 17 ---------------------------------------------- Command: findAuthor N0001 Name: Nietzsche, Friedrich Total sales: 0 ---------------------------------------------- Command: addBook 0-0022-2155-1 FICTION The Dark Tower, and Other Stories L0001 3 1977 Book added to dB. ---------------------------------------------- Command: findAuthor L0001 Name: Lewis, C. S. 0-0022-2155-1 The Dark Tower, and Other Stories L0001 FICTION 1977 3 0-368-86760-X The Abolition of Man L0001 NONFICTION 1947 7 Total sales: 10 ---------------------------------------------- Command: addBook 1-172-57960-X NONFICTION The Gay Science N0001 2 1974 Book added to dB. ---------------------------------------------- Command: findAuthor N0001 Name: Nietzsche, Friedrich 1-172-57960-X The Gay Science N0001 NONFICTION 1974 2 Total sales: 2 ---------------------------------------------- Command: addBook 1-019-10560-X FICTION Steppenwolf H0002 11 1963 Author H0002 not found in dB. ---------------------------------------------- Command: findAuthor H0002 Author H0002 not found in dB. ---------------------------------------------- Command: addAuthor Hesse, Hermann H0002 Author added. ---------------------------------------------- Command: addBook 1-019-10560-X FICTION Steppenwolf H0002 11 1963 Book added to dB. ---------------------------------------------- Command: findAuthor H0002 Name: Hesse, Hermann 1-019-10560-X Steppenwolf H0002 FICTION 1963 11 Total sales: 11 ---------------------------------------------- Command: delBook 0-808-56648-2 Book not removed from dB. ---------------------------------------------- Command: updateSales 42 0-671-75644-3 Book 0-671-75644-3 not found in dB. ---------------------------------------------- Command: addBook 0-671-75644-3 FICTION The Neon Rain B0001 59 1992 Book added to dB. ---------------------------------------------- Command: addBook 0-380-72047-7 FICTION A Stained White Radiance B0001 102 1993 Book added to dB. ---------------------------------------------- Command: addBook 0-345-33971-1 FANTASY The Two Towers T0001 1025 1981 Book added to dB. ---------------------------------------------- Command: addBook 0-345-33973-8 FANTASY The Return of the King T0001 997 1981 Book added to dB. ---------------------------------------------- Command: listBooks ------------------------------------ 0: ISBN: 0-0022-2155-1 Title: The Dark Tower, and Other Stories AuthorID: L0001 Category: FICTION Year: 1977 Sales: 3 ------------------------------------ 1: ISBN: 0-06-102070-2 Title: The Light Fantastic AuthorID: P0003 Category: FANTASY Year: 1986 Sales: 17 ------------------------------------ 2: ISBN: 0-345-33970-3 Title: The Fellowship of the Ring AuthorID: T0001 Category: FANTASY Year: 1981 Sales: 1043 ------------------------------------ 3: ISBN: 0-345-33971-1 Title: The Two Towers AuthorID: T0001 Category: FANTASY Year: 1981 Sales: 1025 ------------------------------------ 4: ISBN: 0-345-33973-8 Title: The Return of the King AuthorID: T0001 Category: FANTASY Year: 1981 Sales: 997 ------------------------------------ 5: ISBN: 0-345-43481-1 Title: The Last Full Measure AuthorID: S0001 Category: FICTION Year: 1998 Sales: 83 ------------------------------------ 6: ISBN: 0-368-86760-X Title: The Abolition of Man AuthorID: L0001 Category: NONFICTION Year: 1947 Sales: 7 ------------------------------------ 7: ISBN: 0-380-72047-7 Title: A Stained White Radiance AuthorID: B0001 Category: FICTION Year: 1993 Sales: 102 ------------------------------------ 8: ISBN: 0-380-79856-5 Title: The Ape Who Guards the Balance AuthorID: P0002 Category: FICTION Year: 1998 Sales: 217 ------------------------------------ 9: ISBN: 0-440-22401-2 Title: Heartwood AuthorID: B0001 Category: FICTION Year: 1999 Sales: 89 ------------------------------------ 10: ISBN: 0-466-60837-8 Title: Thunderhead AuthorID: P0004 Category: FICTION Year: 1999 Sales: 97 ------------------------------------ 11: ISBN: 0-671-75644-3 Title: The Neon Rain AuthorID: B0001 Category: FICTION Year: 1992 Sales: 59 ------------------------------------ 12: ISBN: 0-684-71941-X Title: Look Homeward Angel AuthorID: W0003 Category: FICTION Year: 1957 Sales: 3 ------------------------------------ 13: ISBN: 0-7868-8930-6 Title: Cimmaron Rose AuthorID: B0001 Category: FICTION Year: 1997 Sales: 70 ------------------------------------ 14: ISBN: 0-8041-0858-7 Title: The Face of a Stranger AuthorID: P0001 Category: MYSTERY Year: 1990 Sales: 153 ------------------------------------ 15: ISBN: 0-8041-1037-9 Title: A Dangerous Mourning AuthorID: P0001 Category: MYSTERY Year: 1991 Sales: 179 ------------------------------------ 16: ISBN: 0-8041-1188-X Title: Defend and Betray AuthorID: P0001 Category: MYSTERY Year: 1992 Sales: 105 ------------------------------------ 17: ISBN: 0-8041-1283-5 Title: A Sudden, Fearful Death AuthorID: P0001 Category: MYSTERY Year: 1993 Sales: 225 ------------------------------------ 18: ISBN: 0-812-53253-8 Title: Ender's Game AuthorID: C0002 Category: SCIFI Year: 1985 Sales: 78 ------------------------------------ 19: ISBN: 0-812-54416-1 Title: The Saxon Shore AuthorID: W0001 Category: FICTION Year: 1998 Sales: 37 ------------------------------------ 20: ISBN: 0-812-54418-8 Title: The Fort at River's Bend AuthorID: W0001 Category: FICTION Year: 1999 Sales: 62 ------------------------------------ 21: ISBN: 0-812-55138-0 Title: The Skystone AuthorID: W0001 Category: FICTION Year: 1996 Sales: 59 ------------------------------------ 22: ISBN: 0-812-55140-0 Title: The Eagle's Brood AuthorID: W0001 Category: FICTION Year: 1997 Sales: 58 ------------------------------------ 23: ISBN: 1-019-10560-X Title: Steppenwolf AuthorID: H0002 Category: FICTION Year: 1963 Sales: 11 ------------------------------------ 24: ISBN: 1-172-57960-X Title: The Gay Science AuthorID: N0001 Category: NONFICTION Year: 1974 Sales: 2 ------------------------------------ ---------------------------------------------- Command: listAuthors ------------------------------------ 0: Name: Burke, James Lee ID: B0001 ------------------------------------ 1: Name: Card, Orson Scott ID: C0002 ------------------------------------ 2: Name: Hesse, Hermann ID: H0002 ------------------------------------ 3: Name: Lewis, C. S. ID: L0001 ------------------------------------ 4: Name: Nietzsche, Friedrich ID: N0001 ------------------------------------ 5: Name: Perry, Anne ID: P0001 ------------------------------------ 6: Name: Peters, Elizabeth ID: P0002 ------------------------------------ 7: Name: Pratchett, Terry ID: P0003 ------------------------------------ 8: Name: Preston, Douglas ID: P0004 ------------------------------------ 9: Name: Shaara, Jeff ID: S0001 ------------------------------------ 10: Name: Tolkien, J. R. R. ID: T0001 ------------------------------------ 11: Name: Whyte, Jack ID: W0001 ------------------------------------ 12: Name: Wolfe, Thomas ID: W0003 ------------------------------------ ---------------------------------------------- Command: addAuthor Burke, James Lee B0001 Author not added. ---------------------------------------------- Command: addBook 0-345-33971-1 FANTASY The Two Towers T0001 1025 1981 Book not added to dB. ---------------------------------------------- Command: findAuthor B0001 Name: Burke, James Lee 0-380-72047-7 A Stained White Radiance B0001 FICTION 1993 102 0-440-22401-2 Heartwood B0001 FICTION 1999 89 0-671-75644-3 The Neon Rain B0001 FICTION 1992 59 0-7868-8930-6 Cimmaron Rose B0001 FICTION 1997 70 Total sales: 320 ---------------------------------------------- Command: addBook 0-380-72121-X FICTION In the Electric Mist with Confederate Dead B0001 65 1994 Book not added to dB. ---------------------------------------------- Command: addAuthor Gaines, Ernest J G0001 Author added. ---------------------------------------------- Command: addAuthor Gaimon, Neil G0002 Author added. ---------------------------------------------- Command: addAuthor Gardner, John G0003 Author not added. ---------------------------------------------- Command: addAuthor Boll, Heinrich B0003 Author not added. ---------------------------------------------- Command: addBook 0-161-06626-0 FICTION The Chronicles of Narnia L0001 247 1970 Book not added to dB. ---------------------------------------------- Command: addBook 1-020-34360-X FICTION The Journey to the East H0002 9 1956 Book not added to dB. ---------------------------------------------- Command: addBook 0-056-32560-X FICTION Narcissus and Goldmund H0002 3 1968 Book not added to dB. ---------------------------------------------- Command: addBook 0-812-52426-8 FANTASY Red Prophet C0002 84 1988 Book not added to dB. ---------------------------------------------- Command: addBook 0-812-50212-4 FANTASY Prentice Alvin C0002 77 1989 Book not added to dB. ---------------------------------------------- Command: addBook 0-812-50923-4 FANTASY Alvin Journeyman C0002 63 1996 Book not added to dB. ---------------------------------------------- Command: addBook 0-553-57299-7 MYSTERY The Alienist C0001 19 1994 Author C0001 not found in dB. ---------------------------------------------- Command: addBook 0-684-71941-X FICTION Look Homeward Angel W0003 3 1957 Book not added to dB. ---------------------------------------------- Command: addBook 0-380-00333-3 FICTION The Clown B0003 1 1965 Author B0003 not found in dB. ---------------------------------------------- Command: findAuthor G0001 Name: Gaines, Ernest J Total sales: 0 ---------------------------------------------- Command: findAuthor H0002 Name: Hesse, Hermann 1-019-10560-X Steppenwolf H0002 FICTION 1963 11 Total sales: 11 ---------------------------------------------- Command: findAuthor C0001 Author C0001 not found in dB. ---------------------------------------------- Exit command detected... shutting down. ----------------------------------------------