Re: oops - Trying to do a simple connect to 7.2.1 DB -- unix

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(at)ontko(dot)com or nick(at)fankhausers(dot)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
>
>