Re: [INTERFACES] How to access postgresql database using jdbc driver?

I'm attaching here a simple Java program that will open, create a table
and query the table printing the results!

yourdb database must be previously created!

Best regards,
--
Constantin Teodorescu
FLEX Consulting Braila, ROMANIAimport java.io.*;
import java.sql.*;

public class tutorial {

    private Connection dc;
    private Statement st;


    public tutorial() {
        try {
            Class.forName("postgresql.Driver");
        } catch (Exception e) {
            e.printStackTrace();
            System.out.println("Cannot load PostgreSQL driver\n"+e.getMessage());
            System.exit(-1);
        }
    }

    public boolean openDatabase() {
        boolean result;
        try {
            dc = DriverManager.getConnection("jdbc:postgresql://localhost/yourdb","yourname","yourpassword");
            st = dc.createStatement();
            result = true;
        } catch (Exception e) {
            e.printStackTrace();
            System.out.println("Cannot connect to database\nError:"+e.getMessage());
            result = false;
        }
        return result;
    }

    public void run() {
        System.out.println("Starting work!");
        try {
            st.executeUpdate("create table people (id int4, name varchar(32))");
            st.executeUpdate("insert into people values(1,'teo')");
            st.executeUpdate("insert into people values(2,'peter')");
            ResultSet rs = st.executeQuery("select id,name from people");
            if ( rs != null) {
                while ( rs.next() ) {
                    System.out.println(rs.getString("name")+" has id= "+rs.getString("id"));
                }
                rs.close();
            }
            st.executeUpdate("drop table people");
        } catch (SQLException sqle) {
            System.out.println("A SQL exception occured : "+sqle.getMessage());
        }
        System.out.println("Finished!");
    }

    public static void main(String argv[]) {
        tutorial task = new tutorial();
        if ( task.openDatabase() ) task.run();
    }
}