Java练习_连接pgsql数据库
package pgsqlDemo;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class pgsqlDemo {
public static void main(String[] args) throws SQLException {
String user = "user";
String passwd = "123456";
Connection c = DriverManager.getConnection("jdbc:postgresql://127.0.0.1:12502/dbtest",user, passwd);
Statement stmt = c.createStatement();
String sql = "select * from test.test_calendar limit 20";
ResultSet rs = stmt.executeQuery(sql);
while (rs.next()) {
String calendar_date = rs.getString("calendar_date");
String is_transaction = rs.getString("is_transaction");
String is_weekend = rs.getString("is_weekend");
System.out.println("日期:"+calendar_date+" 是否为交易日:"+is_transaction+" 是否为周末"+is_weekend);
}
}
}