Showing posts with label T-SQL. Show all posts
Showing posts with label T-SQL. Show all posts

Thursday, April 8, 2010

Query Displayer JAVA Program

As a continuation for my earlier post in JDBC, here is a sample program I got from Java™ How to Program, by H.M. Deitel,
sql,jereme

It looks like a query analyzer. You can use this to test the retrieval of data.

You can download the source at:
Query Displayer.zip


Just modify the following lines of code on DisplayQueryResults.java
static final String JDBC_DRIVER = "sun.jdbc.odbc.JdbcOdbcDriver";
static final String DATABASE_URL = "jdbc:odbc:NWIND";
static final String USERNAME= "";
static final String PASSWORD= "";

// default query selects all rows from authors table
static final String DEFAULT_QUERY = "SELECT * FROM Products";


For a copy of the ebook Java how to Program, visit
javaforbidden.4shared.com
The password is: itspot
(shhh... please don't tell them about this, ok?)