This is just a test project for me to learn Java struts/dao/spring. Application is like online music catalog - web based, using tomcat/mysql/struts.
Things that will be completed include:
Create a database scheme that has 3 tables
Table : MYMUSIC which contains fields : ID, (int) , ARTIST (varchar), TITLE (varchar), GENRE (int) Table : GENRE which contains 2 fields : ID (int), DESCRIPTION (varchar) Table : USER which contains 2 fields : username (varchar), password (varchar) Create a dynamic Web project with Tomcat Create a login page with username/password o on submit, go to a servlet and lookup the entered username/password in the database (you need to make a jdbc connection to mySQL for that)
+ if it doesn't match, give an error message and try again
+ if it matches, continue to the myMusic application (see next steps)
+ Create a jsp where you can enter a new song (Artist : textbox, Name : textbox, Genre : Dropdown with a list from the descriptions of the Genre table)
On submit, add a new row to the MYMUSIC table with the filled in values (ID is auto-incremented, Genre needs to be the integer value corresponding to the selected description), then go to the overbiew page. On cancel, go back to the overview page Create a jsp with an overview (read only) of all songs you have in the MYMUSIC table where genre shows you the description corresponding to the integer in the GENRE table. next to each line add an update and a delete button. clicking on the delete button will delete the corresponding row in the MYMUSIC table based on the id contained in the hyperlink clicking on the update button, will show the update screen. o On submit, the Artist and/or genre will be updated in the database, go back to the overview screen
o On Cancel, go back to the overview screen.
o Create a jsp where you can update a song(ID : readonly, Artist : textbox, Name : textbox, Genre : Dropdown with a list from the descriptions of the Genre table)
+ On submit, updates the song in the database and goes back to the overview screen
+ On Cancel, go back to the overview screen
+ Try to put all business logic in Servlets, where the servlets call all database related actions via DAO's (Data Access Object classes)
+ If trying to consult a JSP when not logged in, go to login page.
Use Patent Claims
These details are provided for information only. No information here is legal advice and should not be used as such.