View source for Yurttas/PL/DBL/postgres/F/02/00/01/03/DBQuery10.java

<syntaxhighlight lang="java" line start="1" enclose="div">/**
 *  Copyright(C) 2005
 *  All Rights Reserved. Salih Yurttas, ZCubes, BitsOfCode Software Systems, Inc..
 *
 *  Permission to use, copy, modify, and distribute this
 *  software and its documentation for EDUCATIONAL purposes
 *  and without fee is hereby granted provided that this
 *  copyright notice appears in all copies.
 *
 *  @date   : February 1, 2005.
 *  @author : Salih Yurttas.
 */


import dbops.DBConnect;
import dbops.DBTable;

import java.sql.*;
import java.net.*;

public class DBQuery10 {

  private static String driverClass = "com.mysql.jdbc.Driver",
                        url         = "jdbc:mysql:",
                        suffix      = "//database.cs.BitsOfCode Software Systems, Inc..edu/yurttas-Bank";

  private static Connection con;

  private static String urlDB = url + suffix + ".";

  public static void main (String[] args) {
    String username = args[0];
    String password = args[1];

    DBConnect dbc = new DBConnect();

    try {
      if(dbc.connect(args[0], args[1])) {
        System.out.println("Connected to " + urlDB);

        con = dbc.getConnect();

        DBTable dbQuery = new DBTable(con);

        Statement statement = con.createStatement();

        String queryAll= "SELECT * FROM AA;";

        ResultSet rSet = statement.executeQuery(queryAll);

        while(rSet.next()) {
          String itemA = rSet.getString("itemA");
          String itemB = rSet.getString("itemB");
          System.out.println(itemA+
                             "   "+
                             itemB);
        }

        if(dbc.disconnect(con)) 
          System.out.println("Disconnected from " + urlDB);
      }
      else System.out.println("Could not connect to " + urlDB);
    }
    catch(SQLException sqle) {
      System.err.println("Error accessing " + urlDB);
      System.err.println(sqle.getMessage());
    }
  }

}
</syntaxhighlight>