#146 Code Review of a JDBC Method for Getting Server Time

Companies:

Innotech

Themes:

JavaJDBCCode Review

Perform a code review:

// Determine the current time on the database server
public Date GetServerTime(Connection conn) {
    PreparedStatement st = conn.prepareStatement(
        "select sysdate from dual where dummy = :1"
    );

    ResultSet rs = st.executeQuery();
    st.setString(1, "x");
    Date d = rs.getString(1);

    return d;
}

Question review

Mentor

Answer as you would in a real interview. I’ll ask follow-up questions, then compare your answer with the reference answer and show your accuracy as a %.

Sign in to start the dialogue The mentor keeps the context of the current question and your previous messages.