ja27

1. Write a Java Program to display the details of College (CID, CName, address, Year)
   on JTable. [15 M]
   import javax.swing.;
   import javax.swing.table.DefaultTableModel;
   import java.awt.;
   import java.sql.Connection;
   import java.sql.DriverManager;
   import java.sql.ResultSet;
   import java.sql.SQLException;
   import java.sql.Statement;

public class CollegeDetails extends JFrame {
private JTable table;

public CollegeDetails() {
    setTitle("College Details");
    setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
    setSize(600, 400);

    // Create a JTable
    table = new JTable();
    JScrollPane scrollPane = new JScrollPane(table);
    getContentPane().add(scrollPane, BorderLayout.CENTER);

    // Get data from database and display on JTable
    displayCollegeDetails();
}

private void displayCollegeDetails() {
    DefaultTableModel model = new DefaultTableModel();
    model.addColumn("CID");
    model.addColumn("CName");
    model.addColumn("Address");
    model.addColumn("Year");

    Connection connection = null;
    Statement statement = null;
    ResultSet resultSet = null;

    try {
        // Establish connection to the database
        connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/mydatabase", "username", "password");

        // Execute query to fetch college details
        statement = connection.createStatement();
        resultSet = statement.executeQuery("SELECT * FROM college");

        // Add rows to the table model
        while (resultSet.next()) {
            model.addRow(new Object[]{
                    resultSet.getInt("CID"),
                    resultSet.getString("CName"),
                    resultSet.getString("address"),
                    resultSet.getInt("Year")
            });
        }

        // Set the table model to the JTable
        table.setModel(model);
    } catch (SQLException e) {
        e.printStackTrace();
    } finally {
        // Close the resources
        try {
            if (resultSet != null) {
                resultSet.close();
            }
            if (statement != null) {
                statement.close();
            }
            if (connection != null) {
                connection.close();
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}

public static void main(String[] args) {
    EventQueue.invokeLater(() -> {
        CollegeDetails frame = new CollegeDetails();
        frame.setVisible(true);
    });
}

}

2. Write a SERVLET program to change inactive time interval of session.
   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 doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// Get the session
HttpSession session = request.getSession();

    // Set the inactive time interval (in seconds)
    int interval = Integer.parseInt(request.getParameter("timeout"));
    session.setMaxInactiveInterval(interval);

    // Redirect back to the original page
    response.sendRedirect("original_page.jsp");
}

}