public static Connection getcon() {
        Connection con = null;
        try {

            Class.forName("org.postgresql.Driver").newInstance();

            con = DriverManager.getConnection(url, username, password);
        } catch (Exception e) {
            System.out.println(e);
        }
        return con;

    }