/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 vote118 views3 answers
Typescript optional parameters
TypeScript
0 vote121 views2 answers
_swapbatch.foreach multiple statements c#
TypeScript
0 vote145 views1 answer
How many blocks are there in minecraft
TypeScript
16 votes134 views6 answers
Create react native app typescript
TypeScript
0 vote70 views1 answer
NFS is reporting that your exports file is invalid. Vagrant does this check before making any changes to the file. Please correct the issues below and execute "vagrant reload":
TypeScript
21 votes128 views4 answers
Can't bind to 'ngmodeloptions' since it isn't a known property of 'input'
TypeScript
0 vote126 views1 answer
Which of the following statements will compile correctly?
TypeScript
0 vote125 views1 answer
Mongoose get all documents big
TypeScript
8 votes123 views3 answers
Update local angular cli
TypeScript
0 vote114 views1 answer
Bts assurance
TypeScript