Need to Learn about the Java ODBC

[kvnsmnsn]

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_

 

[Arne Vajhøj]

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.

Don't use ODBC - use JDBC instead !

Start here:
http://java.sun.com/docs/books/tutorial/jdbc/

Arne

 

[Charles Hottel]

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 = "jdbcdbc: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());
}

}

}

 

[Lew]

Don't use ODBC - use JDBC instead !

Start here:
http://java.sun.com/docs/books/tutorial/jdbc/

Those points were also made in the answers to the multiposted version of this
question over in comp.lang.java.databases.