Q1]

import javax.swing.*;
import java.awt.*;
import java.sql.*;

public class CollegeDetailsJTable extends JFrame {
    private JTable table;

    public CollegeDetailsJTable() {
        setTitle("College Details");
        setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
        setSize(600, 400);

       
        DefaultTableModel model = new DefaultTableModel();

    
        model.addColumn("CID");
        model.addColumn("CName");
        model.addColumn("Address");
        model.addColumn("Year");

        try (Connection connection = DriverManager.getConnection("jdbc:postgresql:database-name:postgres:password)) {
            String sql = "SELECT * FROM College";
            try (Statement statement = connection.createStatement();
                 ResultSet resultSet = statement.executeQuery(sql)) {
                while (resultSet.next()) {
                    model.addRow(new Object[]{
                            resultSet.getInt("CID"),
                            resultSet.getString("CName"),
                            resultSet.getString("Address"),
                            resultSet.getInt("Year")
                    });
                }
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }

   
        table = new JTable(model);
        table.setAutoResizeMode(JTable.AUTO_RESIZE_ALL_COLUMNS);

    
        JScrollPane scrollPane = new JScrollPane(table);
        getContentPane().add(scrollPane, BorderLayout.CENTER);
    }

    public static void main(String[] args) {
        SwingUtilities.invokeLater(() -> {
            CollegeDetailsJTable collegeDetailsJTable = new CollegeDetailsJTable();
            collegeDetailsJTable.setVisible(true);
        });
    }
}


Q2]

import java.io.IOException;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;

@WebServlet("/ChangeSessionTimeout")
public class ChangeSessionTimeout extends HttpServlet {
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
      
        String intervalStr = request.getParameter("interval");

        try {
        
            int interval = Integer.parseInt(intervalStr);

         
            HttpSession session = request.getSession();

           
            session.setMaxInactiveInterval(interval);

            response.getWriter().println("Session inactive time interval changed to " + interval + " seconds.");
        } catch (NumberFormatException e) {
            response.getWriter().println("Invalid interval value.");
        }
    }
}


