Solved

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

Posted on 2006-07-09
6
213 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
  • 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 250 total points
ID: 17067337
0
Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

 
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

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
JDeveloper 12c for 32 bit 4 84
rhino JavaScript import, load 25 82
runtime exception 2 27
What's wrong with this code? 4 22
Introduction This article is the first of three articles that explain why and how the Experts Exchange QA Team does test automation for our web site. This article explains our test automation goals. Then rationale is given for the tools we use to a…
Java functions are among the best things for programmers to work with as Java sites can be very easy to read and prepare. Java especially simplifies many processes in the coding industry as it helps integrate many forms of technology and different d…
Viewers learn about the third conditional statement “else if” and use it in an example program. Then additional information about conditional statements is provided, covering the topic thoroughly. Viewers learn about the third conditional statement …
Viewers will learn about the regular for loop in Java and how to use it. Definition: Break the for loop down into 3 parts: Syntax when using for loops: Example using a for loop:

813 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

13 Experts available now in Live!

Get 1:1 Help Now