/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 vote184 views2 answers
Check if breckets clossing properly
TypeScript
1 vote211 views2 answers
Solitaire
TypeScript
1 vote169 views1 answer
Duplicate names in sql
TypeScript
3 votes193 views2 answers
Cannot find name 'require'. Do you need to install type definitions for node? Try `npm i @types/node` and then add `node` to the types field in your tsconfig.
TypeScript
-2 votes162 views1 answer
Nuclear power plants
TypeScript
0 vote173 views1 answer
Exclude code from hints delphi 7
TypeScript
1 vote174 views1 answer
Nx specify dependencies
TypeScript
1 vote168 views2 answers
Ts-node command compile typescript
TypeScript
7 votes171 views1 answer
How many alphabets in english
TypeScript
1 vote164 views1 answer
Route resource adonis
TypeScript