Solved

DAO Vs JDBC

Posted on 2004-10-28
448 Views
Last Modified: 2006-11-17
Hello,
I'm tring to develop a java application system to connect with Ms Access, and to get or change database's information.
I knew there're lots of ways to come true this. But I'd like to use DAO with COM object or JDBC.
 I don't know which one is better on my project?
Can anybody give me an advice?
or Is there any better way to come true this project.
Thank you very much!
0
Question by:Dahai528
    6 Comments
     
    LVL 35

    Expert Comment

    by:TimYates
    I'd use JDBC...

    As soon as you try to add COM to your java project, you are adding a level of complexity that unless it is absolutely necessary, isn't worth doing...

    I'd suggest Hibernate, but that doesn't work on MS Access databases...

    Tim
    0
     

    Author Comment

    by:Dahai528
    Thank you Tim.
    I knew JDBC is a fast and easy way to connect with database and to get information. But Can JDBC get SQL Statement from Ms Access Query/View Component?
    And Can JDBC get Ms Access Form/Report Component Information? (I can't find)
    If it can, How?

    Thanks.
    0
     
    LVL 35

    Accepted Solution

    by:
    Off the top of my head, I'd say that it can access the Views, as Views are normally seen as just another table...  

    The form/report stuff is another area though, and I don't think you can :-(

    Either...  

    a) do some form of java reports/forms instead of using the access ones...
    b) use something like Jacob (http://jacob-project.sourceforge.net/wiki/index.php/Main_Page) to access the COM infrastructure as you originally said...

    Hopefully some other expert with better knowledge in this area can jump in and help....I have never used MS Access with java...

    Good luck!!

    Tim
    0
     
    LVL 21

    Expert Comment

    by:MogalManic
    The JDBCOdbc bridge will have access to your Tables (maybe your queries) only.  The forms and reports will have to be reverse engineered.  

    For the reports, I would suggest some sort of reporting framework (e.g http://jasperreports.sourceforge.net/).

    For the forms, either a servlet with HTML screens OR a swing application (there may even be a form framework for swing).
    0
     
    LVL 5

    Expert Comment

    by:JK2429
    0
     
    LVL 35

    Expert Comment

    by:TimYates
    what's that got to do with anything?
    0

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

     Java Android Coding Bundle

    Whether you're an Apple user or Android addict, learning to code for the Android platform is an extremely valuable, in-demand skill. It all starts with Java, the language behind the apps and games that make Android the top platform it is today.

    Suggested Solutions

    Title # Comments Views Activity
    twoTwo  challenge 35 59
    MaxSpan challenge 9 34
    SPLUNK REST  API call to Splunk to create and index? 2 12
    countPairs challenge 7 13
    For customizing the look of your lightweight component and making it look lucid like it was made of glass. Or: how to make your component more Apple-ish ;) This tip assumes your component to be of rectangular shape and completely opaque. (COD…
    Java had always been an easily readable and understandable language.  Some relatively recent changes in the language seem to be changing this pretty fast, and anyone that had not seen any Java code for the last 5 years will possibly have issues unde…
    Viewers learn about the “for” loop and how it works in Java. By comparing it to the while loop learned before, viewers can make the transition easily. You will learn about the formatting of the for loop as we write a program that prints even numbers…
    This video teaches viewers about errors in exception handling.

    913 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    12 Experts available now in Live!

    Get 1:1 Help Now