jdbc代码示例

Maven依赖

<dependency>
	<groupId>org.postgresql</groupId>
    <artifactId>postgresql</artifactId>
</dependency>

连接数据库

public class T0001 {
    public static void main(String[] args) throws SQLException, ClassNotFoundException {
        Class.forName("org.postgresql.Driver");
        Connection connection = DriverManager.getConnection("jdbc:postgresql://xx.xx.xx.xx:port/db_name","username","password");
        System.out.println(connection.isClosed());
    }
}
// 返回 connection.isClosed() -------> false 说明连接成功

Reference

• jdbc获得所有数据库表