File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Swing / AWT / SWT and the fly likes i need help and advice in a DB access App Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » Swing / AWT / SWT
Bookmark "i need help and advice in a DB access App" Watch "i need help and advice in a DB access App" New topic

i need help and advice in a DB access App

Mahmoud Hadad
Ranch Hand

Joined: Jan 09, 2006
Posts: 67
Hi all,
i'm developing an application using netBeans 5.0 IDE.This is my first application.It's for a lawyer.i need some advices at my work.i have created a DB file called LawyersDB.i have some static data for one case and some details about each case for example evrey case has it's own case date ,results and so on(those fields might change for one case) but for example in evrey case the defendant name won't change so i created two tables ,the first to contain data that don't change as the same case proceeds and one that contains the details for each case.i have made a class for executing SQL statements.and another class for checking the calling method parameters before i execute SQL statements.and other classes for the GUI presentation and so on.These are my problems that is really irricting me :
1-I want to register my LawyersDB for ODBC when user first time uses my software.
2-I want to extract rows from my DB file into a table.
3-How can i invoke windows installer to install/uninstall my app, and can i register my DB to the ODBC using a windows installer package.
please advice at where i'm getting at and what resources should i look at to finish this app.

Thanks in advance,
Mahmoud Hadad
I agree. Here's the link:
subject: i need help and advice in a DB access App
It's not a secret anymore!