'How make complex request in jdbc? [closed]

I want to get random name from database.

@Override
    public String createName() {
        String result = "empty";
        String sqlSelect;
        sqlSelect = "select * from names";
        String sqlOrderBy = "ORDER BY RAND()";
        String sqlLimit = "Limit 1";

        try {
            statement = connection.createStatement();
            resultSet = statement.executeQuery(sqlSelect + " ; " + sqlOrderBy + " + " + sqlLimit);
            //resultSet.getString("name");
            System.out.println("Random name from database: " + resultSet.getString("name"));
            result = resultSet.getString("name");

        } catch (SQLException e) {
            e.printStackTrace();
        }
        return result;
    }

I don't know how to create request rightly. I'm a beginner in jdbc



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source