import 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();
	}
}