Solved

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

Posted on 2006-07-09
6
211 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
Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

 
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

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

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…
Introduction This article is the last of three articles that explain why and how the Experts Exchange QA Team does test automation for our web site. This article covers our test design approach and then goes through a simple test case example, how …
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 theoretical tutorial explains exceptions, reasons for exceptions, different categories of exception and exception hierarchy.

758 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

21 Experts available now in Live!

Get 1:1 Help Now