Re: oops - Trying to do a simple connect to 7.2.1 DB -- unix - Mailing list pgsql-jdbc

And what's the error you get when you compile/run ?

Dave
On Sat, 2002-08-17 at 09:17, Michael Hanna wrote:
> I forgot to include the code..here it is.
>
> ---
>
>
> /**
>   * A demo program to show how jdbc works with postgresql
>   * Nick Fankhauser 10/25/01
>   * nickf@ontko.com or nick@fankhausers.com
>   * This program may be freely copied and modified
>   * Please keep this header intact on unmodified versions
>   * The rest of the documentation that came with this demo program
>   * may be found at http://www.fankhausers.com/postgresql/jdbc
>   */
>
>
>
> import java.sql.*;   // All we need for JDBC
> import java.text.*;
> import java.io.*;
>
> public class HelloPostgresql
> {
>    Connection       db;        // A connection to the database
>    Statement        sql;       // Our statement to run queries with
>    DatabaseMetaData dbmd;      // This is basically info the driver
> delivers
>                                // about the DB it just connected to. I use
>                                // it to get the DB version to confirm the
>                                // connection in this example.
>
>    public HelloPostgresql(String argv[])
>      throws ClassNotFoundException, SQLException
>    {
>      String database = argv[0];
>      String username = argv[1];
>      String password = argv[2];
>      Class.forName("org.postgresql.Driver"); //load the driver
>      db = DriverManager.getConnection("jdbc:postgresql:"+database,
>                                       username,
>                                       password); //connect to the db
>      dbmd = db.getMetaData(); //get MetaData to confirm connection
>      System.out.println("Connection to
> "+dbmd.getDatabaseProductName()+" "+
>                         dbmd.getDatabaseProductVersion()+"
> successful.\n");
>      sql = db.createStatement(); //create a statement that we can use
> later
>
>
>      String sqlText = "create table jdbc_demo (code int, text
> varchar(20))";
>      System.out.println("Executing this command: "+sqlText+"\n");
>      sql.executeUpdate(sqlText);
>
>
>      sqlText = "insert into jdbc_demo values (1,'One')";
>      System.out.println("Executing this command: "+sqlText+"\n");
>      sql.executeUpdate(sqlText);
>
>
>      sqlText = "insert into jdbc_demo values (3,'Four')";
>      System.out.println("Executing this command twice: "+sqlText+"\n");
>      sql.executeUpdate(sqlText);
>      sql.executeUpdate(sqlText);
>
>
>      sqlText = "update jdbc_demo set text = 'Three' where code = 3";
>      System.out.println("Executing this command: "+sqlText+"\n");
>      sql.executeUpdate(sqlText);
>      System.out.println (sql.getUpdateCount()+
>                          " rows were update by this statement\n");
>
>
>      System.out.println("\n\nNow demostrating a prepared statement...");
>      sqlText = "insert into jdbc_demo values (?,?)";
>      System.out.println("The Statement looks like this: "+sqlText+"\n");
>      System.out.println("Looping three times filling in the fields...\n");
>      PreparedStatement ps = db.prepareStatement(sqlText);
>      for (int i=10;i<13;i++)
>      {
>        System.out.println(i+"...\n");
>        ps.setInt(1,i);         //set column one (code) to i
>        ps.setString(2,"HiHo"); //Column two gets a string
>        ps.executeUpdate();
>      }
>      ps.close();
>
>
>      System.out.println("Now executing the command: "+
>                         "select * from jdbc_demo");
>      ResultSet results = sql.executeQuery("select * from jdbc_demo");
>      if (results != null)
>      {
>        while (results.next())
>        {
>          System.out.println("code = "+results.getInt("code")+
>                             "; text = "+results.getString(2)+"\n");
>        }
>      }
>      results.close();
>
>
>      sqlText = "drop table jdbc_demo";
>      System.out.println("Executing this command: "+sqlText+"\n");
>      sql.executeUpdate(sqlText);
>
>
>      db.close();
>    }
>
>    public static void correctUsage()
>    {
>      System.out.println("\nIncorrect number of arguments.\nUsage:\n "+
>                         "java   \n");
>      System.exit(1);
>    }
>
>    public static void main (String args[])
>    {
>      if (args.length != 3) correctUsage();
>      try
>      {
>        HelloPostgresql demo = new HelloPostgresql(args);
>      }
>      catch (Exception ex)
>      {
>        System.out.println("***Exception:\n"+ex);
>        ex.printStackTrace();
>      }
>    }
> }
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>
>