/TypeScript/If exists certain line in sql table java condition

If exists certain line in sql table java condition

public void ftpTableCheck(String host, String port, String username, String password) {
    try {
        String query = "SELECT (count(*) > 0) as found FROM ftp WHERE Host LIKE ? AND Username LIKE ?";
        PreparedStatement pst = conn.prepareStatement(query);
        pst.setString(1, host);
        pst.setString(2, username);

        try (ResultSet rs = pst.executeQuery()) {
            // Only expecting a single result
            if (rs.next()) {
                boolean found = rs.getBoolean(1); // "found" column
                if (found) {
                    // You have rows
                } else {
                    // You have no rows
                }
            }
        }
    } catch (SQLException e) {
        e.printStackTrace();
    }
}

Source: stackoverflow.com

Similar codes

0 vote117 views1 answer
Representation of graph usig sets and hash in python
TypeScript
3 votes107 views3 answers
Email validation pattern angular
TypeScript
0 vote125 views1 answer
Ubuntu display stdouts of processn
TypeScript
7 votes165 views2 answers
Sort array of objects in react js
TypeScript
0 vote97 views1 answer
Generator typescript
TypeScript
0 vote111 views1 answer
Serenity-is change button text
TypeScript
1 vote117 views1 answer
==> restfulapi: Booting VM... There was an error while executing `VBoxManage`, a CLI used by Vagrant for controlling VirtualBox. The command and stderr is shown below.
TypeScript
2 votes112 views1 answer
Convert local url to base64 in javascript
TypeScript
1 vote109 views1 answer
Replace all br tags within node with paragraph opening and closing tags
TypeScript
0 vote103 views1 answer
Let variable name : any = () => { return new typescript fie}
TypeScript