/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 vote232 views1 answer
Typescript implement
TypeScript
4 votes254 views2 answers
When a vector in c++ is resized what happens to the elements of the vector
TypeScript
0 vote210 views1 answer
Online doctor appointments in pakistan
TypeScript
2 votes253 views2 answers
How to close all ports angular
TypeScript
3 votes238 views1 answer
Squash commits in remote branch
TypeScript
0 vote235 views1 answer
Typescript equals string
TypeScript
7 votes228 views3 answers
How to call a function that other scripts can access in unity
TypeScript
0 vote226 views1 answer
Ionic iosa app not making requests to server
TypeScript
0 vote223 views1 answer
Create if not exists rails
TypeScript
2 votes214 views1 answer
Angular add httpclient
TypeScript