durga prasad wrote:
> 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
>
You would get more relevant responses if you told us the error you are
receiving. Most likely, you are encountering a classpath problem. Make
sure the PG JAR file is in your runtime classpath. Your code below
looks fine.
>
>
>
> 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
>
--
Guy Rouillier