Dahai528
asked on
DAO Vs JDBC
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!
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!
ASKER
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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).
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).
what's that got to do with anything?
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