aspose file tools*
The moose likes JDBC and the fly likes I want to develop a simple application which is not complex Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "I want to develop a simple application which is not complex" Watch "I want to develop a simple application which is not complex" New topic
Author

I want to develop a simple application which is not complex

neeraj kaushik
Greenhorn

Joined: Feb 03, 2011
Posts: 6
I have to develop an application using JSP, AJAX, Database and servelets. The application needs a fex details shown on the web page which will be filled by the user and will want it to be simple not fuzzy logic.

I have no idea about database and JDBC kindly help me in choosing a database and develop this simple application.

Thank you for the forth coming response.
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336

Pretty much any relational database will do. What are your requirements?


JavaRanch FAQ HowToAskQuestionsOnJavaRanch
neeraj kaushik
Greenhorn

Joined: Feb 03, 2011
Posts: 6
it is very simple on a form i want one field to be filled by user then rest of them must be availabe in the form of drop down list from the database and when the form is complete and submitted DB must be updaed accordingly.
Mohamed Sanaulla
Saloon Keeper

Joined: Sep 08, 2007
Posts: 3056
    
  33

Neeraj, Welcome to JavaRanch


Mohamed Sanaulla | My Blog
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336

Well, any old DB will do for his. You probably want to avoid MS Access (you can only access this via ODBC or a commercial driver) but there are any number of databases out there you might like to try. MySQL is free and popular, Postgres similarly so, as is Hypersonic SQL or Derby, SQL Server Express is also free and comes with quite a good toolset if you like working in a Windows environment.
neeraj kaushik
Greenhorn

Joined: Feb 03, 2011
Posts: 6
Okay, I agree I downloaded SQL Server but have no idea how to use it and how to connect it with java programs.
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336

The documentation explains this. You should also probably look at our JDBC FAQs and Oracle's JDBC tutorial.
neeraj kaushik
Greenhorn

Joined: Feb 03, 2011
Posts: 6
the application do not need database to be created by the java program it will be created using the dbms itself. It only needs db retrieval and updation. Well I am still not sure which db to use.
neeraj kaushik
Greenhorn

Joined: Feb 03, 2011
Posts: 6
how to use Java DB is it esy to use. Since the application is small I do not want to download a big DB
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336


the application do not need database to be created by the java program it will be created using the dbms itself. It only needs db retrieval and updation. Well I am still not sure which db to use.

OK - what is your confusion? All the databases I listed above behave like this.


how to use Java DB is it esy to use. Since the application is small I do not want to download a big DB

Not sure I follow what you mean by "big DB". I wouldn't consider any of the database I listed above to be that big. What part are you struggling with?
neeraj kaushik
Greenhorn

Joined: Feb 03, 2011
Posts: 6
I have never worked on any database though I have seen many like oracle, sql server. I fear about the typical interface they have, I have installed sql server 2005 and I do not know how to create tables in it, is there any way to learn it.
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336

Yes. It comes with documentation that covers this. And MSDN is a good resource. SQL Server management studio is fairly intuitive as well.
Ashutosh M Kulkarni
Ranch Hand

Joined: Jun 07, 2010
Posts: 41

I think you should opt for MySQL for many reasons.
1. The most important was already told by Paul - it is popular.
2. Since it is popular, its issues and How To's are discussed over a wide range of forums. In case you have any trouble, finding a solution would not be a problem.
3. Also, it is FREE. Which saves you from the troubles such as license et al.
4. It is not a very big download/installation which also qualifies another one of your criteria.


SCJP 6, next stop - OCPJWCD!
Bear Bibeault
Author and ninkuma
Marshal

Joined: Jan 10, 2002
Posts: 60058
    
  65

Moved to the JDBC forum.


[Asking smart questions] [Bear's FrontMan] [About Bear] [Books by Bear]
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336

Ashutosh M Kulkarni wrote:I think you should opt for MySQL for many reasons.
1. The most important was already told by Paul - it is popular.
2. Since it is popular, its issues and How To's are discussed over a wide range of forums. In case you have any trouble, finding a solution would not be a problem.
3. Also, it is FREE. Which saves you from the troubles such as license et al.
4. It is not a very big download/installation which also qualifies another one of your criteria.


...though I would warn that the default MyISAM (if it is still the default?) database engine does not implement an RDBMS, which can be confusing if you are a beginner on this topic. Fine if all you want is a fairly basic persistent store for simple unrelated data, assuming you can tolerate some data loss. But something to be aware of if you choose to use it.

(NB: all the databases I listed above are free to use, the only caveat being that SQL Server express needs a Windows OS license)
 
wood burning stoves
 
subject: I want to develop a simple application which is not complex
 
Similar Threads
Copy excel file to access table
Writing a simple login app using JSP & MS Access
How to display tabs on a screen?
how to setup JSP? :confused:
Creating and building Standalone application