<%
            try {
                String driver = "org.postgresql.Driver";
                String url = "jdbc:postgresql://localhost:5432/tatnipi";
                String username = "portal";
                String password = "1";
                String myQuery = "SELECT * FROM nskv";
                Connection myConnection = null;
                
                PreparedStatement myPreparedStatement = null;
                
                ResultSet rs = null;
                
                Class.forName(driver).newInstance();
                
                myConnection = DriverManager.getConnection(url, username, password);
                
                myPreparedStatement = myConnection.prepareStatement(myQuery);
                rs = myPreparedStatement.executeQuery();


                out.println("<table border=1>");
                out.println("<TR>");
                out.println("<TH>ID</TH>");
                out.println("<TH>NSKV</TH>");
                out.println("<TH>X</TH>");
                out.println("<TH>Y</TH>");
                out.println("</TR>");
                
                if (rs.next()) {
                    Integer id = rs.getInt("id");
                    String nskv = rs.getString("nskv");
                    Integer x = rs.getInt("x");
                    Integer y = rs.getInt("y");
                    out.println("<tr><td>" + id + "</td><td>" + nskv + "</td><td>" + x + "</td><td>" + y + "</td></tr>");
                }
                out.println("</table>");

            } catch (ClassNotFoundException e) {
                e.printStackTrace();
            } catch (SQLException ex) {
                out.print("SQLException: " + ex.getMessage());
                out.print("SQLState: " + ex.getSQLState());
                out.print("VendorError: " + ex.getErrorCode());
            }
        %>

/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */
package com.mycompany.corr1;

/**
 *
 * @author vvf6426
 */
import java.io.Serializable;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;


public class NskvBean implements Serializable {

    //resource injection

    Connection con = null;
    PreparedStatement pst = null;
    ResultSet rs = null;

    String url = "jdbc:postgresql://localhost/tatnipi";
    String user = "portal";
    String password = "1";

    //connect to DB and get customer list
    public List<Nskv> getNskvList() throws SQLException {


        //get database connection
        con = DriverManager.getConnection(url, user, password);
        pst = con.prepareStatement("SELECT id, nskv FROM nskv");
        rs = pst.executeQuery();

        if (con == null) {
            throw new SQLException("Can't get database connection");
        }

        PreparedStatement ps = con.prepareStatement("select id, nskv, x, y from nskv");

        //get customer data from database
        ResultSet result = ps.executeQuery();

        List<Nskv> list = new ArrayList<Nskv>();

        while (result.next()) {
            Nskv cust = new Nskv();

            cust.setId(result.getInt("id"));
            cust.setNskv(result.getString("nskv"));
            cust.setX(result.getInt("x"));
            cust.setY(result.getInt("y"));

            //store all data into a List
            list.add(cust);
        }

        return list;
    }
}

/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */
package com.mycompany.corr1;

import java.io.Serializable;
import javax.persistence.Basic;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.Id;
import javax.persistence.NamedQueries;
import javax.persistence.NamedQuery;
import javax.persistence.Table;
import javax.validation.constraints.NotNull;
import javax.validation.constraints.Size;

/**
 *
 * @author vvf6426
 */
@Entity
@Table(name = "nskv")
@NamedQueries({
    @NamedQuery(name = "Nskv.findAll", query = "SELECT n FROM Nskv n")})
public class Nskv implements Serializable {
    private static final long serialVersionUID = 1L;
    @Id
    @Basic(optional = false)
    @NotNull
    @Column(name = "id")
    private Integer id;
    @Size(max = 10)
    @Column(name = "nskv")
    private String nskv;
    @Column(name = "x")
    private Integer x;
    @Column(name = "y")
    private Integer y;

    public Nskv() {
    }

    public Nskv(Integer id) {
        this.id = id;
    }

    public Integer getId() {
        return id;
    }

    public void setId(Integer id) {
        this.id = id;
    }

    public String getNskv() {
        return nskv;
    }

    public void setNskv(String nskv) {
        this.nskv = nskv;
    }

    public Integer getX() {
        return x;
    }

    public void setX(Integer x) {
        this.x = x;
    }

    public Integer getY() {
        return y;
    }

    public void setY(Integer y) {
        this.y = y;
    }

    @Override
    public int hashCode() {
        int hash = 0;
        hash += (id != null ? id.hashCode() : 0);
        return hash;
    }

    @Override
    public boolean equals(Object object) {
        // TODO: Warning - this method won't work in the case the id fields are not set
        if (!(object instanceof Nskv)) {
            return false;
        }
        Nskv other = (Nskv) object;
        if ((this.id == null && other.id != null) || (this.id != null && !this.id.equals(other.id))) {
            return false;
        }
        return true;
    }

    @Override
    public String toString() {
        return "com.mycompany.corr1.Nskv[ id=" + id + " ]";
    }
    
}