Java连接PostgreSQL数据库

2016-12-20 13:17| 发布者: zhangjf| 查看: 486| 评论: 0

摘要: 代码 import java.sql.DriverManager;import java.sql.Connection;import java.sql.SQLException;import java.sql.ResultSet;import java.sql.Statement;public class PG{ public static void main(String args) ...

[Java]代码

import java.sql.DriverManager;
import java.sql.Connection;
import java.sql.SQLException;
import java.sql.ResultSet;
import java.sql.Statement;
public class PG{
public static void main(String []args){
System.out.println("PostgreSQL JDBC...");
try {
Class.forName("org.postgresql.Driver");
}catch (ClassNotFoundException e){
System.out.println("could not find postgreSQL JDBC Driver");
e.printStackTrace();
return;
}
Connection connection = null;
try {
connection = DriverManager.getConnection(
"jdbc:postgresql://localhost:5432/postgres",
"postgres",
"");
}catch (SQLException e){
System.out.println("Connection Failed");
e.printStackTrace();
return;
}
if (connection != null){
System.out.println("connect db successful!");
}else {
System.out.println("Failed to make conn!");
}
try {
Statement stmt = connection.createStatement();
ResultSet rs = stmt.executeQuery("SELECT 1 AS A");
if(rs!=null){
rs.next();
System.out.println(rs.getInt("a"));
}else {
System.out.println("null");
}
rs.close();
stmt.close();
connection.close();
}catch (Exception exp){
exp.printStackTrace();
}
}
}

复制代码

收藏邀请

上一篇：tomcat突然抽风下一篇：java中常用的时间处理类TimeUtil

		自动登录	找回密码
密码			立即注册

Java连接PostgreSQL数据库

最新评论

相关分类