java

package model;
import java.sql.Date;
import java.sql.Time;
import java.sql.Timestamp;
import java.time.Clock;


public class Zamestnanec {
    private Integer id;
    private String meno;
    private Date narodeny;
    private Integer plat;
    private Timestamp zamestnany_od;
    private Boolean muz;

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

    public String getMeno() {return meno;}
    public void setMeno(String meno) {this.meno = meno;}

    public Date getNarodeny() {return narodeny;}
    public void setNarodeny(Date narodeny) {this.narodeny = narodeny;}

    public Integer getPlat() {return plat;}
    public void setPlat(Integer plat) {this.plat = plat;}

    public Timestamp getZamestnany_od() {return zamestnany_od;}
    public void setZamestnany_od(Timestamp zamestnany_od){ this.zamestnany_od = zamestnany_od;}

    public Boolean getMuz() { return muz;}
    public void setMuz(Boolean muz) {this.muz = this.muz;}


    public Zamestnanec() {
    }

    public Zamestnanec(Integer id, String meno,Date narodeny, Integer plat,Timestamp zamestnany_od,Boolean muz){
        setId(id);
        setMeno(meno);
        setNarodeny(narodeny);
        setPlat(plat);
        setZamestnany_od(zamestnany_od);
        setMuz(muz);
    }
}















import org.postgresql.ds.PGPoolingDataSource;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.HashMap;
import java.util.Iterator;
import java.util.LinkedList;
import java.util.List;
import java.util.Properties;
import java.util.Random;

public class Runner {
    public static void main(String[] args) throws SQLException {

        PGPoolingDataSource source = new PGPoolingDataSource();
        source.setDataSourceName("A Data Source");
        source.setServerName("localhost");
        source.setDatabaseName("projekt_DBS");
        source.setUser("bruno");
        source.setPassword("fiit");
        source.setMaxConnections(10);

        Connection conn = null;
        Properties connectionProps = new Properties();
        connectionProps.put("user", "bruno");
        connectionProps.put("password", "fiit");
        String connectionString = "jdbc:postgresql://localhost:5432/projekt_DBS";

        try {

            conn = DriverManager.getConnection(
                    "jdbc:postgresql://localhost:5432/projekt_DBS", "bruno",
                    "fiit");

        } catch (SQLException e) {

            System.out.println("Connection Failed! Check output console");
            e.printStackTrace();
            return;

        }

        if (conn != null) {
            System.out.println("You made it, take control your database now!");
        } else {
            System.out.println("Failed to make connection!");
        }
    }
}