以前用JAVA在做数据库连接的时候还没试过用Postgresql  由于JDBC简便性，使得连接各种数据库也方便，只需设置几个参数。

用JDBC操作要先下载驱动包

To determine JDK/JVM compatibility this following list matches up versions of the JVM with the JDBC specification implemented.

• JDK 1.1 - JDBC 1. Note that with the 8.0 release JDBC 1 support has been removed, so look to update your JDK when you update your server.
• JDK 1.2, 1.3 - JDBC 2.
• JDK 1.3 + J2EE - JDBC 2 EE. This contains additional support for javax.sql classes.
• JDK 1.4, 1.5 - JDBC 3. This contains support for SSL and javax.sql, but does not require J2EE as it has been added to the J2SE release.
• JDK 1.6 - JDBC4. Support for JDBC4 methods is limited. The driver builds, but the majority of new methods are stubbed out.

如果项目采用JDK1.5 那就要下载JDBC3的驱动

下载地址如下

http://jdbc.postgresql.org/download.html

 

JDBC连接参数如下

String dbDriver = "org.postgresql.Driver";

String url = "jdbc:postgresql://localhost:5432/dxcom";

String userName="postgres";

String password="123456";

 

我下的版本是   Postgresql版本 8.4   postgresql-8.4.0-1-windows.exe

下载地址：http://www.postgresql.org/download/

我们从官方可以看到  Postgresql支持各种平台

Downloads

PostgreSQL Core Distribution

The core of the PostgreSQL object-relational database management system is available in several source and binary formats. The full package includes:

• The core server with full documentation (html, man)
• Several command line tools (e.g. psql, pg_ctl, pg_dump, pg_restore)
• C library (libpq) and embedded C processor (ecpg)
• Several server-side procedural languages (e.g. plpgsql, pltcl, plperl)
• Several popular add-on packages (e.g. metaphone, pgcrypto and other useful enhancements)

In addition, some 'one click' installers include additional packages such as pgAdmin and PostGIS.

Binary packages

Pre-built binary packages are available for a number of different operating systems: