Обсуждение: please checkits urgent

Поиск
Список
Период
Сортировка

please checkits urgent

От
"durga prasad"
Дата:
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

Re: please checkits urgent

От
Guy Rouillier
Дата:
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