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
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 |