驱动包的下载:
http://jdbc.postgresql.org/download.html
把驱动包放人到classpath中
示例代码:
代码如下:
package com.hbk.test;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
public class PostgreSQLTest {
public static void main(String[] args) {
Connection conn = null;
Statement stmt = null;
try {
Class.forName("org.postgresql.Driver");
conn = DriverManager.getConnection("jdbc:postgresql://localhost:5432/postgres","postgres","123456");
System.out.println("连接数据库成功!");
stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("select * from tb_test;");
while(rs.next()){
int id = rs.getInt("id