import java.sql.*;
import java.util.*;
import java.util.logging.*;

// java -cp postgresql-9.4-1201.jdbc4.jar:. DBtest

public class pc_shop {

	public static void main(String[] args) {
		String url = "jdbc:postgresql://localhost:5432/project";
		String user = "postgres";
		String password = "a14r23";
		Connection con = null;

		//CONNECTING
		try {
			con = DriverManager.getConnection(url, user, password);

		} catch (SQLException ex) {
		        Logger lgr = Logger.getLogger(pc_shop.class.getName());
    			lgr.log(Level.WARNING, ex.getMessage(), ex);

		}

		list_component_current_stock(con);
	}

	public static void list_component_current_stock(Connection con){
		//RUN AN EXAMPLE QUERY
		try {
				Statement st = con.createStatement();
		        String query = "SELECT * FROM stock_view";
		        ResultSet rs = st.executeQuery(query);
		        System.out.println("+-----------------------------------------+------------+---------------+");
		        System.out.println("| Name                                    | Kind       | current stock |");
		        System.out.println("+-----------------------------------------+------------+---------------+");
		        while (rs.next()) {
		            	String name = rs.getString("name");
		            	String kind = rs.getString("kind");
		            	String current_stock = rs.getString("current_stock");
		            	System.out.printf("| %-40s| %-10s | %-13s | \n", name, kind, current_stock);
		        }
		        System.out.println("+-----------------------------------------+------------+---------------+");
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}
}