0
I Use This!
Activity Not Available

Project Summary

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.

Tags

dao music mysql struts

In a Nutshell, mymusicproj...

 No code available to analyze

Open Hub computes statistics on FOSS projects by examining source code and commit history in source code management systems. This project has no code locations, and so Open Hub cannot perform this analysis

Is this project's source code hosted in a publicly available repository? Do you know the URL? If you do, click the button below and tell us so that Open Hub can generate statistics! It's fast and easy - try it and see!

Add a code location

Apache License 2.0
Permitted

Commercial Use

Modify

Distribute

Place Warranty

Private Use

Use Patent Claims

Sub-License

Forbidden

Use Trademarks

Hold Liable

Required

Include Copyright

Include License

State Changes

Include Notice

These details are provided for information only. No information here is legal advice and should not be used as such.

All Licenses

This Project has No vulnerabilities Reported Against it

Did You Know...

  • ...
    Black Duck offers a free trial so you can discover if there are open source vulnerabilities in your code
  • ...
    compare projects before you chose one to use
  • ...
    nearly 1 in 3 companies have no process for identifying, tracking, or remediating known open source vulnerabilities
  • ...
    data presented on the Open Hub is available through our API

 No code available to analyze

Open Hub computes statistics on FOSS projects by examining source code and commit history in source code management systems. This project has no code locations, and so Open Hub cannot perform this analysis

Is this project's source code hosted in a publicly available repository? Do you know the URL? If you do, click the button below and tell us so that Open Hub can generate statistics! It's fast and easy - try it and see!

Add a code location

Community Rating

Be the first to rate this project
Click to add your rating
   Spinner
Review this Project!
Sample ohloh analysis