аЯрЁБс;ўџ ўџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџ§џџџџџџџўџџџўџџџ ўџџџўџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџRoot Entryџџџџџџџџџџџџўџџџџџџџџџџџџџџџўџџџџџџџџџџџџџџџўџџџџџџџџџџџџџџџўџџџўџџџўџџџўџџџ ўџџџўџџџўџџџўџџџ !"ўџџџ$%&'()ўџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџџўџ џџџџбљ ТЎ…бЊД`—кVTextStarWriter 5.0ЊFЪ& SfxDocumentInfo Stacy President ЭX1иЊ|Stacy President ЮX1$ЙНStacy President ЭX1р[‚ Info 0 Info 1 Info 2 Info 3 ЭX1tЊ|EЏ< TASK,0,1,H*2,0,100,1,5296;2276;100;0;0;18090;9930;0;0ЛЛџџSWG, A<  #$%&'()*./0123456789:;<=>?@ABCDGHK  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFQRSTUŒ 0WбP $' '(а.  . p. @ . . р. А. €. P. . №. Р!. $. `'. 0*. -. а/.  2. p5. @8. ;. р=. А@. 6')ОJ2< vStandardStandard@џџЩSW5HDR.0ЮX1$ЙН!џџOutline0 #Zўџр…ŸђљOhЋ‘+'Гй0 h t € Œ ˜ЄМдрьј2@€<^iю@ШАнƒС@€jклЦ„С@[­sиƒСStacy PresidentStacy PresidentSW5HDR.0ЮX1$ЙН!Š џџ Frameformatџџ ZeichenformatџџTextformatvorlageStandardџџRoot 5Standard  Illustration Table TextDrawingY .Y .Y .Y  .PНpЖ Уџџ2$99 €SAAPа/р=APdddAP d dSAAPа/р=APdddAP d dZSW5HDR.0ЮX1$ЙНC(569a(Build:5169)(SV569)]D!Address Book Fileџaddress!Š џџ Frameformatџџ ZeichenformatџџTextformatvorlageStandardџџRoot 5Standard  Illustration Table TextDrawingd"Щ1 џџџџџџ4 џџџџџџ5*џџjK standard.dicџ soffice.dicџXsun.dicџ@ IgnoreAllListџY .Y .Y .Y  .6Nз TўџStacy F. PresidentT'ўџCPS 216 Course Project PaperT ўџTыўџрI created a form-based query system similar to the interface used in Microsoft Access. It is desirable for users who are not familiar with databases like DB2 or may not know sql to perform sql queries. The purpose of the query system is to allow users to enter the information they are requesting from the database in a simple and quite user-friendly graphical user interface, and have the system generate the sql code, perform the query and return the results back to the user.T ўџTўџ This system is an Online CD Database System. It allows users to request information about compact disks, companies who supply them and listed prices for the cd. For example, if a user wanted to know all of the cd's by Michael Jackson, he or she could request this information from the database using the gui. The database was created using realistic data. I searched numerous websites that sold cd's (such as Amazon.com, and Columbia House) to get listings of cd titles and corresponding information. I created the database from this data and added item identification numbers to each of the cd's. I also created tables that stored information about these and other cd providers. A list of cd's that these providers sold and the various prices were also entered as data.T ўџT1ўџ&From the system, a user could request information about the artist for a specific cd title, all cd's by an artist, all cd's in a specific category (such as soft rock, classical, jazz, etc.), all cd's created by a certain record label, or stores that sell a cd and the list prices at each store.T ўџTAўџ6I initially proposed to use Prolog to verify the data entered by the user and to output the results in a formatted language based way. During the course of the design of the system, it was realized that using Prolog was not feasible because Prolog could not easily connect with DB2. The idea was then redesigned to use only Java programs to generate the gui, receive the information and to generate the results. I think that the realization of the problem with Prolog was made very late and therefore did not allow much time for the creation of the Java programs. The final system was designed as a graphical user interface created by a Java program and second Java program that connects to the database and generates the query submitted by the user. The most difficult part in developing the system was creating the gui and having the program use the result entered by the user to generate the queries. A lot of inter-activity had to be established between the two programs. The connection program had to be initialized first to allow the connection to the database. That program had to then call the program that would create the gui. The gui program had to interpret the user's selections and store the information received. The gui program had to then call the connection program, pass the stored information and have the connection program generate the query. Initially, this seemed like extra involvement for the programs, but because the gui program could not initiate the connection or generate the sql code, I thought it best to create it in this fashion, and it worked.T ўџiT}ўџrAs part of the graphical user interface, the user can initially make one of two selections. He or she can select:TўџSA  T@ўџ'General Information about Compact DisksSA  T ўџorTSўџ:Find supplier and pricing information about a specific cd.SA  T ўџT”ўџ‰If General Information is selected, then the user will be prompted to select what the resulting information should be based on, the cd's:T ўџT!ўџCategorySA  TўџArtistSA  T"ўџ Title or A8 T%ўџ Record LabelSA  T ўџTƒўџxand then prompted to enter this information. This will return all cd's related to the information provided by the user.T ўџTЮўџУIf Find Supplier is selected the user will be prompted to enter the cd's title in which they are looking for supplier information. This will return all stores that sell this item and the prices.T ўџTыўџрOverall, I did learn a lot from the project. I learned about connections from Java to retrieve database information and I learned a lot about the task in trying to create gui's that will allow the user to request this data.T ўџT ўџJџџprinter outside D128HP4050_4 PostScriptH`Tќlэс‚T`lќd,,lpr -P128128HP4050_47 UюзчЏU88а/м|?џџа,а/р=U Р! 2P€ТU Р! 2?ўџи‡BР! и‡B Р! ‚и‡BР! ƒи‡B$Р!H‰и‡Bl Р! Šи‡Bx Р!l “ и‡BфР! ”и‡B№Р!0˜и‡B Р!  ™и‡B,Р!ф Ќи‡B.Р!  ­и‡B/Р!  Ўи‡B(0Р!  Џи‡B41Р! АаЁќ>а/р=U Р! 2p€ТU Р! 2?ўџи‡BР!Ви‡BР!Ги‡BР!Ди‡B&Р! Еи‡B2Р!Жи‡B9Р! Зи‡BEР!Йи‡B] Р! Ки‡Bi Р!Ли‡Bp Р!Ми‡Bw Р! Ни‡Bƒ Р!Ои‡BŠР! Пи‡B–Р!РAи‡BЎР! РBи‡BКР!$РEи‡BоР! РFи‡BъР!$ РIи‡BР! !РJи‡BР! "РKlZRoot Entryџџџџџџџџбљ ТЎ…бЊД`—кV€ CompObjџџџџ<Ole џџџџџџџџџџџџpersist elements"џџџџSfxDocumentInfo џџџџџџџџuSfxWindowsџџџџџџџџ:SfxStyleSheetsџџџџџџџџzSwNumRulesџџџџџџџџџџџџUSummaryInformation( џџџџџџџџ@SwPageStyleSheets$џџџџ џџџџ#­StarWriterDocument&џџџџџџџџџџџџ Оџџџџџџџџџџџџўџџџ