Example usage for com.vaadin.server FontAwesome UNLINK

Introduction

In this page you can find the example usage for com.vaadin.server FontAwesome UNLINK.

Prototype

FontAwesome UNLINK

To view the source code for com.vaadin.server FontAwesome UNLINK.

Click Source Link

Usage

From source file:com.swifta.mats.web.usermanagement.UserDetailsModule.java

@SuppressWarnings("unchecked")
private void updateLinksTable(String un) {
    StringBuilder sb = new StringBuilder();

    sb.append(/*from w w w.  jav a2s .c o  m*/
            " SELECT concat(ahd.firstname,' ',ahd.lastname) as Name, ah.username as 'username', ah.msisdn as msisdn, ah.email as email ");
    sb.append(" FROM linkaccountrelations pl, accountholders ah, accountholderdetails ahd ");
    sb.append(" where linkstatus = 'LINKED' and username = '" + un + "'");
    sb.append(" and ah.accountholderdetailid = ahd.accountdetailsid ");
    sb.append(" and pl.childuserresourceid = ah.accountholderid");

    String drivers = "com.mysql.jdbc.Driver";
    try {
        Class<?> driver_class = Class.forName(drivers);
        Driver driver = (Driver) driver_class.newInstance();
        DriverManager.registerDriver(driver);

        Connection conn = DriverManager.getConnection(MatsWebPortalUI.conf.DB, MatsWebPortalUI.conf.UN,
                MatsWebPortalUI.conf.PW);

        Statement stmt = conn.createStatement();

        ResultSet rs = stmt.executeQuery(sb.toString());

        Property<String> pUn;
        Property<String> pMsisdn;
        Property<String> pEmail;
        Property<Integer> pSn;
        Property<Button> pBtn;

        String msisdn;
        String email;
        Object rid;
        Button btnLink;
        Item r;

        while (rs.next()) {
            int x = container.size() + 1;
            un = rs.getString("username");
            msisdn = rs.getString("msisdn");
            email = rs.getString("email");

            rid = container.addItem();
            r = container.getItem(rid);

            pSn = r.getItemProperty("S/N");
            pUn = r.getItemProperty("Username");
            pMsisdn = r.getItemProperty("MSISDN");
            pEmail = r.getItemProperty("Email");
            pBtn = r.getItemProperty("Action");
            btnLink = new Button();
            btnLink.setIcon(FontAwesome.UNLINK);
            btnLink.setStyleName("btn_link");
            btnLink.setDescription("Unlink this account.");
            btnLink.addClickListener(new UNLinkClickHandler());
            btnLink.setId(un);
            btnLink.setData(rid);

            pSn.setValue(x);
            pUn.setValue(un);
            pMsisdn.setValue(msisdn);
            pEmail.setValue(email);
            pBtn.setValue(btnLink);

        }

        tb.setContainerDataSource(container);
        int t = container.size();
        if (t > 30)
            t = 30;
        tb.setPageLength(t);

    } catch (SQLException | ClassNotFoundException | InstantiationException | IllegalAccessException e) {

        errorHandler(e);
    }

}

---

• «
• 1
• 2
• »