/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 vote338 views1 answer
Array.join typescript
TypeScript
5 votes276 views2 answers
Pass function as argument typescript
TypeScript
0 vote280 views1 answer
Typescript infinite loop
TypeScript
0 vote256 views2 answers
Paragraph dots after 2 lines css
TypeScript
0 vote247 views1 answer
Increase space between border dots css
TypeScript
0 vote260 views1 answer
Get angular width
TypeScript
7 votes286 views2 answers
Add new key in array objects using map
TypeScript
3 votes257 views2 answers
Write an SQL query to fetch details of employees whose name starts with an alphabet 'A' and contains 10 alphabets.
TypeScript
0 vote257 views1 answer
From __future__ import unicode_literals import youtube_dl ydl_opts = {} with youtube_dl.YoutubeDL(ydl_opts) as ydl: ydl.download(['VideoURL'])
TypeScript
0 vote296 views1 answer
Typescript clearinterval not working
TypeScript