Java连接PostgreSQL数据库

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

标签： 代码

版权申明：本站文章部分自网络，如有侵权，请联系：west999com@outlook.com
特别注意：本站所有转载文章言论不代表本站观点！
本站所提供的图片等素材，版权归原作者所有，如需使用，请与原作者联系。