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.
Life is 10% what happens and 90% how you react to it.
Attitude is everything.
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.