?
Solved

reading and writing to an MS Access DB using a java application

Posted on 2006-07-09
6
Medium Priority
?
217 Views
Last Modified: 2010-03-31
Hi,
I have an MS access DB that I want to access through a JAVA application.
I need to know all the connection commands, and how to invoke SQL commands through java.
I would be glad to see an example of such connection commands, and invoking a "select" and  "update" queries.
note: I prefer a connection soultion that doesn't involve installing or modifying any system drivers or settings.  (if it's possible)

please help,

thanks,
Nimrodon.
0
Comment
Question by:nimrodon
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
6 Comments
 
LVL 86

Expert Comment

by:CEHJ
ID: 17067304
0
 

Author Comment

by:nimrodon
ID: 17067326
Hi,
thanks for your comment.
after creating the connection, how do I embed the SQL commands in the code?

Nimrodon.

0
 
LVL 86

Accepted Solution

by:
CEHJ earned 1000 total points
ID: 17067337
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 92

Expert Comment

by:objects
ID: 17067429
0
 
LVL 86

Expert Comment

by:CEHJ
ID: 17067481
:-)
0
 

Author Comment

by:nimrodon
ID: 17067482
thanks CEHJ.  the java almanac is a great resource.
objects, my problem was already solved when I got your comment,sorry.
good day,
Nimrodon.
0

Featured Post

Get real performance insights from real users

Key features:
- Total Pages Views and Load times
- Top Pages Viewed and Load Times
- Real Time Site Page Build Performance
- Users’ Browser and Platform Performance
- Geographic User Breakdown
- And more

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Go is an acronym of golang, is a programming language developed Google in 2007. Go is a new language that is mostly in the C family, with significant input from Pascal/Modula/Oberon family. Hence Go arisen as low-level language with fast compilation…
In this post we will learn different types of Android Layout and some basics of an Android App.
Viewers will learn about arithmetic and Boolean expressions in Java and the logical operators used to create Boolean expressions. We will cover the symbols used for arithmetic expressions and define each logical operator and how to use them in Boole…
This tutorial covers a practical example of lazy loading technique and early loading technique in a Singleton Design Pattern.
Suggested Courses
Course of the Month11 days, 4 hours left to enroll

770 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