Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 232
  • Last Modified:

Possible methods ???



Hi,

I need to design and implement an inventory database for a medium size company.
I can program using the following:

- Java
- JSP
- MS Access
- HTML

1) What are the possible ways for doing this?

2) After finishing the implemenatation, what do i need to deliver to the company?? because nobody gives the source of his code.

3) How to deploy/install the database to about 10 computers???


Thanks a lot

0
bluesand4
Asked:
bluesand4
  • 4
  • 2
  • 2
  • +1
1 Solution
 
basicinstinctCommented:
How about you use a database server - don't use Access!  You could use MySQL as the DB - it's free, it's better than Access, and Access isn't free!  Use JDBC to access MySQL in Java.  Users could access the DB through a thin client (web browser) front end programmed in JSP.

This is only one of numerous possibilities for you to research/consider.
0
 
basicinstinctCommented:
Obviously you need an HTTP server in this setup too.  For only ten users it could be the same machine as the DB server.

This way you don't need to deploy anything on the 10 computers - set up the server and the users just need their web broswers.
0
 
radarshCommented:
Other than those, you need a Servlet Container such as Tomcat.

What you'll deliver is a .war file which contains all your JSPs, compiled classes, etc.

________
radarsh
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
bluesand4Author Commented:

Thanks guys for your replies.

Your idea is then to use the following:
- Tomcat for the jsp sites
- HTTP server (is it neccessary?? won't tomcat handle it?? )
- MySQL as DB
- JDBC for accessing the DB

Now, the question is, is it easy to make sites that show many info from the DB?? would they function as good as forms in Access??
0
 
basicinstinctCommented:
tomcat is a very lightweight server, it could handle it probably for ten users on a private LAN (ie, not exposed to the internet), but generally it is coupled with something a bit more robust, such as Apache or IIS.  If you use Apache the server can be Linux, so you won't need licences for anything (this config is called LAMJ - Linux, Apache, MySql, Java/JSP).  
0
 
basicinstinctCommented:
regarding your other question - a web browser interface is never going to be as rich as a fat client.  Both have pros and cons - it's up tp you to decide what is best for your particular case.  Of course, AJAX is making thin clients a lot more interactive, so if you want you could get into that.  
0
 
bluesand4Author Commented:
=========================================================
basicinstinct  wrote:

How about you use a database server - don't use Access!  You could use MySQL as the DB - it's free, it's better than Access, and Access isn't free!  Use JDBC to access MySQL in Java.  Users could access the DB through a thin client (web browser) front end programmed in JSP.

This is only one of numerous possibilities for you to research/consider.
==========================================================

But would it be easy to create all needed queries using java/MySQL ?? in access you can click a couple of times to have what you want. What are the disadvantages of access DB??
PS: company has about 3000 line items
0
 
Mujtaba_Alam_KhanCommented:
>> But would it be easy to create all needed queries using java/MySQL ?? <<

It easy to create all the queries using Java in MySql. As basicinstinct stated, it can be run on any OS.

Ms-Access might provided nice features but in the Long run, it gets slow and it can Only be used on Windows OS. It is not good for long term DB.

MySql is a better option, but I am not sure if It is good in the long term, if there are going to be thousand of records added later on. If the company can spend a few $$$ then maybe Oracle is the way to go. But I am not sure how much it cost.

But if there was a choice between Ms-Acess & MySql, it would have to be MySql, especially for a Web-Based Application. I have used it many times, it is realiable and fast.

-Muj ;-D

0
 
Mujtaba_Alam_KhanCommented:
Thanks very much

-Muj ;-D
0

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

  • 4
  • 2
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now