Win a copy of Learn Spring Security (video course) this week in the Spring forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Simple Database

 
Derek Boring
Ranch Hand
Posts: 65
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
Freddy Wong
Ranch Hand
Posts: 959
Eclipse IDE Java Linux
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic