package test;

import java.sql.*;

public class PostgerTest {
    public static void main(String[] args) throws ClassNotFoundException {
        Connection con = null;
        Statement st = null;
        ResultSet rs = null;

        String url = "jdbc:postgresql://172.18.20.145:54321/db_wht";
        String user = "wanghaotian1";
        String password = "123456";

        String url2 = "jdbc:postgresql://172.18.20.145:54321/db_wht?user=wanghaotian1&password=123456";

        Class.forName("org.postgresql.Driver");
        try{
            con = DriverManager.getConnection(url2);//如何用一个参数连接
            st = con.createStatement();
            rs = st.executeQuery("select * from t_product");

            while(rs.next()){
                System.out.println(String.format("%d, %-15s, %f",rs.getInt("n_id"),rs.getString("c_name"),rs.getFloat("n_price")));;
            }
            rs.close();
            st.close();
            con.close();

        }catch (SQLException throwables){
            throwables.printStackTrace();
        }
    }
}