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