please checkits urgent

From: "durga prasad" <kdgprasad(at)gmail(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: please checkits urgent
Date: 2007-07-17 12:02:23
Message-ID: 6dd360360707170502sc830adbl521ec6a784ff9725@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

hi

iam durga prasad,

iam using Postgresql8.2 when iam trying to connect
the driver is not working (org.postgresql.Driver) can please send me the
driver class of java to connect to DB,please revert to me immediately
following code i have used: pls correct and revert tome

import java.sql.*;
import java.io.*;
class Conc {
public static void main(String[] args) throws Exception {

//Class.forName(" JDBC Driver goes here");

Class.forName("org.postgresql.Driver");

//jdbc:postgresql://host:port/database

Connection con=DriverManager.getConnection
("jdbc:postgresql://localhost:5432/postgres","poks","aqswdefr");

Statement stmt=con.createStatement();

//system.out.println("Creating Table---->");
//stmt.executeUpdate("Create table emp(eid int, ename varchar2(12))");

System.out.println("Inserting row--->");
stmt.executeUpdate("Insert into emp values('bbbb',2)");
System.out.println("One row is Inserted.....");

System.out.println("Getting data ---->");

ResultSet rs=stmt.executeQuery("select * from emp");

while(rs.next())
System.out.println(rs.getInt(1)+" "+rs.getString(2));

rs.close();
stmt.close();
con.close();
} //main()
} //class

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Guy Rouillier 2007-07-17 18:11:25 Re: please checkits urgent
Previous Message Oliver Jowett 2007-07-16 23:29:52 Re: Stream Copy for 8.1 - 8.3dev