Joel P. Schroeder Course Description: IS 314 - Business Software Engineering This course develops programming skills to the intermediate level. It develops techniques of data access, input, output, and processing in a business environment using object-oriented programming tools. And it utilizes beginning SQL programming techniques. Assignment #2: Article Rating Program Connected to a database. This project directly builds on the first project. In this project you add database functionality to the primary areas of: 1) User Account Creation: Allow users to create an account. This should enable users to submit the following pieces of information: a. First Name b. Last Name c. Desired User Name d. Desired Password 2) The new user information should be written to the database (likely its own table). Make sure that the password is written to the database in the MD5 format per the IST data hash. 3) You should not allow for duplicate usernames to be created. 4) User Login: Allow users to login through the system. The login must pull information from the database for the verification process. You cannot store the password locally in the application somewhere. 5) Article Submission: Allow logged in users to create new article submissions. This MUST include the following article fields: a. Article Title b. Article Description (Short) c. Article Category d. Article URL 6) When the newly submitted article is submitted to the database (likely its own table) you must also date/time stamp the article. This will be necessary for retrieving the articles later. 7) Article Display: You must display two types of article. These include: a. The three articles with the highest vote count b. The three most recently submitted articles 8) In addition to these primary components, your submission must include the following: a. Article Category must be populated with database information. This information cannot be hard coded into the application b. Stored procedures. All SQL statements must be interacted with through CALLS to the stored procedures located in the mySQL database. c. Try/Catch around your DB items d. Hide you DB login information in the system properties. This program includes multiple files that could not be displayed here in a one page format. However, these are a few of the forms that were created in order to complete this assignment. This form is used to login to an existing account: This is the form used in order to create a new account:
This is the form used to rate an article that has already been uploaded to the site:
In order to submit new articles to the database, this form must be used:
And finally, this form shows the top three rated articles as well as the top three newest articles:
|