java连接PostgresSQL，JDBC驱动

Java连接PostgresSQL代码示例：
添加maven依赖：

        <dependency>
            <groupId>org.postgresql</groupId>
            <artifactId>postgresql</artifactId>
            <version>9.4.1209.jre7</version>
        </dependency>

示例代码：

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

public class PostgresJDBCTest {
    public static void main(String[] args)throws Exception {
        Class.forName("org.postgresql.Driver");
        String url = "jdbc:postgresql://ip地址:端口号/数据库名称?currentSchema=模式名城";
        String username = "用户名";
        String password="密码";
        Connection connection = DriverManager.getConnection(url,username,password);
        String sql = "select count(1) from ad.test ";
        Statement statement = connection.prepareStatement(sql);
        ResultSet rs = statement.executeQuery(sql);
        while(rs.next()){
            int result = rs.getInt(1);
            System.out.println(result);
        }
    }
}