| Home Page
Contact Page
Favorite Links
Roles and Responsibilities
Photo Page
Custom Page
About Page
Custom3 Page
Custom4 Page
Photo2 Page
Photo3 Page
Photo4 Page
Photo6 Page
|
|
|
Pricelist Extractor
In the event of extracting the pricelist for other components, open the "SiteList.txt" file and add in the URL of the pricelist you want in e.g. Hardwarezone.
However, this program is not in anyway relevant to the project. Ignore the other menus and select Database -> Create... . It will download the pricelist and save it in a file called "Pricelist output.txt" in the current directory.
The "" in the "Pricelist output.txt" file is added for ease of database conversion. E.g. highlight all the soundcards in Wordpad and replace "" with "Soundcard" and likewise for other components. After which it can be converted to Access database format using a program.
Prepared by: Teo Kim Huat on Tue, 22 January 2002
|
|
|
Source Code v1.1
Additional functions have been added for Client/Server team to use. The codes required to run on servlet is removed, and the test function has been made as simple as possible so that the usage of the functions is easier to understand . The main class of importance to the Client/Server sub-team will be ClientRecordManager, which should provide ALL the functions you need. A Record object, which contains the various parameters, has been included.
Part of the code has been generated using Rational Rose. For those who have not installed it yet, please do install it. Remember to save at an older version if you want to use the RR in the Lab.
Below are just some descriptions for the attached files:
DB Class Diagram.gif: Class diagram for the database using PrintScreen.
DatabaseManager.zip: Source codes. Unzip into "DatabaseManager" directory. Use together with TestDatabaseManager, which should be replaced by the servlets. Remember to set the class paths.
TestDatabaseManager.java: Example of how the functions may be used. The two most important classes the Client/Server sub-team should know are the ClientRecordManager and Record. Extra functionality will be provided for Martin who will be doing the administrator's servlets. This is extended from ClientRecordManager.
Database1.mdb : Database samples. Note 2 shops are selling Product-ID 51, hence try entering 51 at the prompt when running TestDatabaseManager.class. It will rearrange the records in order of ascending price. One problem faced: There was an extra line after the Vendor's name.
Posted by: Beng Heng on Sunday, 3 March 2002
|
|
|
Source Code v1.2
- Just unzip and type compile in the directory.
- Copy the following to the tomcat or servletrunner directory
1) PriceListServlet.class
2) CategoryServlet.class
3) "Database" folder
- Overwrite the old "Hardware Database.mdb" with the one in the unzip
directory
- Run CategoryServlet, select Optical Storage then CD-R/CD-RW
- Improvement: Able to generate links to PriceListServlet instead of the "Need redirection, not implemented yet"
Posted by: Kim Huat on Thursday, 7 March 2002
|
| |
|
|
|
