• Post Reply Bookmark Topic Watch Topic
  • New Topic

Can this project be done using JSP ?  RSS feed

 
william chaple
Ranch Hand
Posts: 135
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello, I wanted to make my own project for self practice, and also seems like fun.
Summary; My GF is a teacher and asked me to do an excel DB. Students name, Grade and average at the end. I had came up with an idea that I want to create a simple .JSP that will do the same.

a.) input Name, Subject, grade, and average into a database
b.) Be able to pull up all the students in the webpage when asked for and view the data.
c.) Very similar to excel, just in a .jsp / HTML form and be able to edit the "table/grid" when adding new grades


Is this possible to do in a website? Particularly .jsp/html with the ability to add a database, see all the students, grades, subjects and average at the same time?
 
Bear Bibeault
Author and ninkuma
Marshal
Posts: 66207
151
IntelliJ IDE Java jQuery Mac Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Yes, it is certainly possible. That's highly typical, in fact.
 
william chaple
Ranch Hand
Posts: 135
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Bear Bibeault wrote:Yes, it is certainly possible. That's highly typical, in fact.


Awesome! You rock!

Now, How would I start a project like this. I need a leap or a helping hand on the steps because throughout my school, we just use netbeans for everything and not really "used" programming for a real situation, so that is why I decided to make my own project.

So what would be the proper steps so I can launch this.

Currently I have netbeans. Would I need to link anything to it such as sql server as the database, or can link excel. Like ive seen programs where people used visual Basic and somehow linked it with Excel. Like it searches certain Names in excel, which is pretty cool. Can I use netbeans for this and automatically add a spreadsheet?

Sorry if I do not make sense, but hopefully I do =)
 
Ulf Dittmer
Rancher
Posts: 42972
73
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
For a web project I would not use Excel as the data source - web apps are inherently concurrent, and Excel (and Access) do not work well under those circumstances. If you are certain that there will only ever be a single user, it might be OK; in that case, the Apache POI library is the standard approach to reading and writing Excel files.

Visual Studio no doubt has some special Windows-only integration with Excel (probablv via COM or WSH) that would not be available in NetBeans, or non-Windows environments.
 
J. Kevin Robbins
Bartender
Posts: 1801
28
Chrome Eclipse IDE Firefox Browser jQuery Linux MySQL Database Netbeans IDE
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I agree; stay away from Excel and Access. That limits your application to users that have MS Office installed on their computer. A "pure" web app can be used by anyone with a browser, even from a tablet or smart phone.

Start by designing the application on paper. Don't even attempt to write any code until you understand what the components of the application are going to look like and how they are going to interact.

When that's done, I would probably design the database next. Then do some experimenting until you are comfortable reading and inserting records in the database. You'll want to read up on DAO's and DTO's (JavaBeans). Then you can finally take the notes you've scribbled out on paper (you did design it on paper first, right?) and start creating the pages and servlets.

Come back here as you need more help. Good luck.

 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!