/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 vote140 views1 answer
Typescrpt add onject to window namespace
TypeScript
0 vote172 views1 answer
Cannot declare 'TypingAnimationDirective' in an NgModule as it's not a part of the current compilation
TypeScript
0 vote144 views1 answer
Angular jasmine tobe empty array
TypeScript
4 votes149 views2 answers
Wht we need migrationts in django
TypeScript
1 vote155 views4 answers
Ok
TypeScript
0 vote159 views1 answer
Typescript interview questions
TypeScript
0 vote150 views1 answer
Clean broken shortcuts in windows start menu
TypeScript
0 vote142 views1 answer
They Take Their Medication Then The Device Owner Lets Them Press The Button | The Problem We Are Solving Is Kids Not Taking Their Medication Which Turns To Great Health Benefits In The Young Generation
TypeScript
31 votes173 views4 answers
How to see all commits in git
TypeScript
1 vote145 views2 answers
Append to lists python
TypeScript