aspose file tools*
The moose likes JDBC and the fly likes Simple Database Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Simple Database" Watch "Simple Database" New topic
Author

Simple Database

Derek Boring
Ranch Hand

Joined: Aug 15, 2006
Posts: 65
Hi Everyone,

If this is in the wrong place, please forgive me. I am writing a fairly simple program to manage leads for my business. This is not a full blown CRM type of project, nor am I ever intending it to be. It's purpose is simply to keep track of the leads' contact information and keep a history of what was accomplished each time the lead was called. (leads being prospects for sales in this instance) I currently have it set up to use a separate file for each individual lead that contains all of the lead's information and history. I'm using a JTree to show the groups and subgroups (directories) and the leads (files). This works decently now, but loads very slowly. I'm considering the options of loading all the leads lazily, or switching to a database. I want to switch over to a database for better performance and because I know it's just the better way to do it. I'm having a terribly tough time understanding how to use JDBC. I took two years of Java programming courses and two semesters of Oracle database, but that was several years ago and we never mixed the two. Can anyone here point me to a very simple database I could use? The database will not be accessed my multiple users, and not even multiple instances of the program. I don't want to have to install anything (such as a DB Server) on my work computer, I just want to be able to email the JAR to my work computer and use it. If nothing like this is available, can anyone point me to a "JDBC Tutorial for Dummies" sort of thing? I really appreciate everyone here, you guys are awesome.

-Derek


Life is 10% what happens and 90% how you react to it.
Attitude is everything.
Freddy Wong
Ranch Hand

Joined: Sep 11, 2006
Posts: 959

You can try embedded database systems, such as HSQLDB or JavaDB (comes with JDK). Those DBs are fairly straightforward to use and can be embedded inside your application. I personally prefer HSQLDB over JavaDB.

As for tutorial, you may take a look at the Sun JDBC Tutorial.

Hope it helps.


SCJP 5.0, SCWCD 1.4, SCBCD 1.3, SCDJWS 1.4
My Blog
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Simple Database