• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Liutauras Vilda
  • Campbell Ritchie
  • Tim Cooke
  • Bear Bibeault
  • Devaka Cooray
Sheriffs:
  • Jeanne Boyarsky
  • Knute Snortum
  • Junilu Lacar
Saloon Keepers:
  • Tim Moores
  • Ganesh Patekar
  • Stephan van Hulst
  • Pete Letkeman
  • Carey Brown
Bartenders:
  • Tim Holloway
  • Ron McLeod
  • Vijitha Kumara

Simple Database  RSS feed

 
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
 
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.
 
Consider Paul's rocket mass heater.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!