Re: Need to Learn about the Java ODBC
<kvnsmnsn@hotmail.com> wrote in message
news:5be1dfbb-06a1-4b1f-9557-a60af7f5b873@q70g2000hsb.googlegroups.com...
From February to July of last year I worked for a company where I
wrote C code that accessed a PostgreSQL database with SQL commands and
generated the output my supervisor wanted.
Now I'm working for a different company that doesn't have a C
compiler and doesn't really want me writing C code. The company does
have a Java compiler, and think Java is the better route to maintain-
able code. I'm still working with databases, and as I understand it I
can use the Java ODBC to generate SQL queries to get the information
my colleagues are looking for.
Does anybody on this newsgroup know how I would go about using
Java this way? Is there any documentation on how to use the ODBC?
I've coded with Java before; in fact I have about five years of expe-
rience with Java; but I've never done anything with SQL with it.
---Kevin Simonson
"You'll never get to heaven, or even to LA,
if you don't believe there's a way."
from _Why Not_
I am no expert, but here is a copy of an example from a book: "Beginning
Java 2" form Mike Murach and associates:
import java.sql.*;
import javax.swing.JOptionPane;
public class ConnectDB{
public static void main(String[] args){
Connection connection;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url = "jdbc:odbc:MurachBooks";
String user = "Admin";
String password = "";
connection = DriverManager.getConnection(url, user, password);
System.out.println("Connection made.");
Statement statement = connection.createStatement(
ResultSet.TYPE_SCROLL_SENSITIVE,
ResultSet.CONCUR_UPDATABLE);
String query = "SELECT BookCode, BookTitle, BookPrice "
+ "FROM Books ORDER BY BookCode ASC";
ResultSet books = statement.executeQuery(query);
books.first();
Book firstBook = new Book(books.getString(1),
books.getString(2),
books.getDouble(3));
System.out.println(firstBook.toString());
books.next();
String code2 = books.getString(1);
String title2 = books.getString(2);
double price2 = books.getDouble(3);
Book secondBook = new Book(code2, title2, price2);
System.out.println(secondBook.toString());
books.next();
String code3 = books.getString("BookCode");
String title3 = books.getString("BookTitle");
double price3 = books.getDouble("BookPrice");
Book thirdBook = new Book(code3, title3, price3);
System.out.println(thirdBook.toString());
}
catch (ClassNotFoundException e){
JOptionPane.showMessageDialog(null, e.getMessage());
System.exit(1);
}
catch (SQLException e){
JOptionPane.showMessageDialog(null, e.getMessage());
}
}
}