conexão com o banco de dados

public class CriadorTabelas {

	public static void main(String[] args) {

		Connection conn = null;
		Statement stmt = null;

		try {
			Class.forName("org.postgresql.Driver");
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		}

		String url = "jdbc:postgresql:agenda";
		Properties props = new Properties();
		props.setProperty("user","ivo");
		props.setProperty("password","ivo");

		try {
			conn = DriverManager.getConnection(url, props);
			stmt = conn.createStatement();
		} catch (SQLException e) {
			e.printStackTrace();
		}

		try {
			stmt.executeUpdate("DROP TABLE AMIGOS");
		} catch (SQLException e) {
		}

		try {
			stmt.executeUpdate("create table amigos ( " +
							"nome varchar(30) not null," +
							"email varchar(30)," +
							"primary key (nome))"
							);
			System.out.println("As tabelas foram geradas!");
		} catch (SQLException e) {
			e.printStackTrace();
		} finally {
			try {
				stmt.close();
				conn.close();
			} catch (SQLException e) {
				e.printStackTrace();
			}
		}
	}
}