JAVA 27

27 details of College && time interval of session.

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.");
    }
}

}