ns5 - Posts - OneCompiler

Q1]

import java.util.*;

public class StudentDetails {
public static void main(String[] args) {
Hashtable<String, String> studentDetails = new Hashtable<>();

    studentDetails.put("1234567890", "John Doe");
    studentDetails.put("9876543210", "Jane Smith");
    studentDetails.put("8765432109", "Alice Johnson");

    
    Enumeration<String> mobileNumbers = studentDetails.keys();
    System.out.println("Student Details:");
    while (mobileNumbers.hasMoreElements()) {
        String mobileNumber = mobileNumbers.nextElement();
        String studentName = studentDetails.get(mobileNumber);
        System.out.println("Mobile Number: " + mobileNumber + ", Student Name: " + studentName);
    }
}

}

Q2]

<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>

<!DOCTYPE html> <html> <head> <meta charset="UTF-8"> <title>Online Multiple Choice Test</title> </head> <body> <h2>Online Multiple Choice Test</h2>

<%@ page import="java.sql.*" %>
<%@ page import="java.util.*" %>
<%@ page import="java.io.*" %>

<%!

    public Connection getConnection() throws SQLException, ClassNotFoundException {
        String jdbcURL = "jdbc:mysql://localhost:3306/your_database_name";
        String dbUser = "your_username";
        String dbPassword = "your_password";
        Class.forName("com.mysql.cj.jdbc.Driver");
        return DriverManager.getConnection(jdbcURL, dbUser, dbPassword);
    }
    
 
    public Map<String, String> getRandomQuestion(Connection conn) throws SQLException {
        Map<String, String> questionMap = new HashMap<>();
        Statement stmt = null;
        ResultSet rs = null;
        try {
            stmt = conn.createStatement();
            rs = stmt.executeQuery("SELECT * FROM questions ORDER BY RAND() LIMIT 1");
            if (rs.next()) {
                questionMap.put("question_text", rs.getString("question_text"));
                questionMap.put("option_1", rs.getString("option_1"));
                questionMap.put("option_2", rs.getString("option_2"));
                questionMap.put("option_3", rs.getString("option_3"));
                questionMap.put("option_4", rs.getString("option_4"));
                questionMap.put("correct_option", rs.getString("correct_option"));
            }
        } finally {
            if (rs != null) rs.close();
            if (stmt != null) stmt.close();
        }
        return questionMap;
    }
%>

<%
    Connection conn = null;
    try {
        conn = getConnection();
        Map<String, String> questionMap = getRandomQuestion(conn);
        if (!questionMap.isEmpty()) {
            String questionText = questionMap.get("question_text");
            String option1 = questionMap.get("option_1");
            String option2 = questionMap.get("option_2");
            String option3 = questionMap.get("option_3");
            String option4 = questionMap.get("option_4");
            String correctOption = questionMap.get("correct_option");
%>

<form action="CalculateScore.jsp" method="post">
    <p><b>Question:</b> <%= questionText %></p>
    <input type="radio" name="choice" value="1"> <%= option1 %><br>
    <input type="radio" name="choice" value="2"> <%= option2 %><br>
    <input type="radio" name="choice" value="3"> <%= option3 %><br>
    <input type="radio" name="choice" value="4"> <%= option4 %><br><br>
    <input type="hidden" name="correctOption" value="<%= correctOption %>">
    <input type="submit" value="Next">
</form>

<% 
        } else {
            out.println("<p>No questions available.</p>");
        }
    } catch (Exception e) {
        out.println("<p>Error: " + e.getMessage() + "</p>");
    } finally {
        if (conn != null) conn.close();
    }
%>

</body> </html>