<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%> <%@ page import="java.util.ArrayList" %> <%@ page import="java.sql.*" %> COPO Table

CO PO Matrix

<
<% // Retrieve the parameter value String sc = (String) request.getAttribute("Subjectcode"); ArrayList arr =new ArrayList<>(); %>

Subject Code:

<% try { Class.forName("com.mysql.cj.jdbc.Driver"); String jdbcURL = "jdbc:mysql://localhost:3306/anil"; String dbUser = "root"; String dbPassword = "21bq1a1207"; Connection connection = DriverManager.getConnection(jdbcURL, dbUser, dbPassword); String selectSQL = "SELECT * FROM "+sc; PreparedStatement preparedStatement = connection.prepareStatement(selectSQL); ResultSet resultSet = preparedStatement.executeQuery(); while (resultSet.next()) { String co = resultSet.getString("co"); String po1 = resultSet.getString("po1"); String po2 = resultSet.getString("po2"); String po3 = resultSet.getString("po3"); String po4 = resultSet.getString("po4"); String po5 = resultSet.getString("po5"); String po6 = resultSet.getString("po6"); String po7 = resultSet.getString("po7"); String po8 = resultSet.getString("po8"); String po9 = resultSet.getString("po9"); String po10 = resultSet.getString("po10"); String po11 = resultSet.getString("po11"); String po12 = resultSet.getString("po12"); String pso1 = resultSet.getString("pso1"); String pso2 = resultSet.getString("pso2"); %> <% } resultSet.close(); preparedStatement.close(); connection.close(); } catch (Exception e) { e.printStackTrace(); } %>
CO / PO PO1 PO2 PO3 PO4 PO5 PO6 PO7 PO8 PO9 PO10 PO11 PO12 PSO1 PSO2