// Fig. 16.15: Database.java
// Queries a database
package cartXML;
import java.sql.*;

public class Database {
   private Connection connection;
   private static String username;
   private static String password;
   private static String url;
   private Statement statement;

   public Database( String url, String username,
                    String password )
   {
      this.url = url;
      this.username = username;
      this.password = password;
   }

   public boolean connect()
   {
      try {
         Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver" );
         connection = DriverManager.getConnection( url, username,
            password );
         return true;
      }
      catch ( Exception ex ) {
         ex.printStackTrace();
      }

      return false;
   }

   public ResultSet get( String query )
   {
      try {
         statement = connection.createStatement();
         ResultSet rs = statement.executeQuery( query );
         return rs;
      }
      catch ( SQLException sqle ) {
         return null;
      }
   }

   public boolean update( String query )
   {
      try {
         statement = connection.createStatement();
         statement.executeUpdate( query );
         return true;
      }
      catch ( SQLException sqle ) {
         return false;
      }
   }

   public boolean shutDown()
   {
      try {
         connection.close();
         return true;
      }
      catch ( SQLException sqlex ) {
         return false;
      }
   }
}
/*
 **************************************************************************
 * (C) Copyright 2001 by Deitel & Associates, Inc. and Prentice Hall.     *
 * All Rights Reserved.                                                   *
 *                                                                        *
 * DISCLAIMER: The authors and publisher of this book have used their     *
 * best efforts in preparing the book. These efforts include the          *
 * development, research, and testing of the theories and programs        *
 * to determine their effectiveness. The authors and publisher make       *
 * no warranty of any kind, expressed or implied, with regard to these    *
 * programs or to the documentation contained in these books. The authors *
 * and publisher shall not be liable in any event for incidental or       *
 * consequential damages in connection with, or arising out of, the       *
 * furnishing, performance, or use of these programs.                     *
 **************************************************************************
*/