Slip No 26 Q A

Write a java program to display list of college names from college table. (Assume College table (CID, CName, addr) is already created.

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

public class CollegeList {
    public static void main(String[] args) {
        try {
            // Load JDBC driver
            Class.forName("com.mysql.cj.jdbc.Driver");

            // Establish connection
            Connection con = DriverManager.getConnection(
                    "jdbc:mysql://localhost:3306/your_database_name",
                    "username",
                    "password"
            );

            // Create statement
            Statement stmt = con.createStatement();

            // Execute query
            ResultSet rs = stmt.executeQuery("SELECT CName FROM College");

            // Display college names
            System.out.println("List of Colleges:");
            while (rs.next()) {
                System.out.println(rs.getString("CName"));
            }

            // Close connections
            rs.close();
            stmt.close();
            con.close();

        } catch (Exception e) {
            System.out.println(e);
        }
    }
}