ns30

Q1]

import javax.swing.;
import java.awt.;

public class IndianFlag extends JFrame {
private static final int WIDTH = 900;
private static final int HEIGHT = 600;
private static final Color SAFFRON_COLOR = new Color(255, 153, 51);
private static final Color GREEN_COLOR = new Color(18, 136, 7);
private static final Color WHITE_COLOR = Color.WHITE;

public IndianFlag() {
    setTitle("Indian Flag");
    setSize(WIDTH, HEIGHT);
    setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
    setLocationRelativeTo(null);
    setResizable(false);

    IndianFlagPanel flagPanel = new IndianFlagPanel();
    add(flagPanel);
}

public static void main(String[] args) {
    SwingUtilities.invokeLater(() -> {
        IndianFlag indianFlag = new IndianFlag();
        indianFlag.setVisible(true);
    });
}

static class IndianFlagPanel extends JPanel {
    @Override
    protected void paintComponent(Graphics g) {
        super.paintComponent(g);

        int width = getWidth();
        int height = getHeight();

      
        int flagWidth = width;
        int flagHeight = height;
        int saffronHeight = flagHeight / 3;
        int whiteHeight = flagHeight / 3;
        int greenHeight = flagHeight / 3;
        int chakraRadius = flagHeight / 15;
        int chakraDiameter = chakraRadius * 2;

     
        g.setColor(SAFFRON_COLOR);
        g.fillRect(0, 0, flagWidth, saffronHeight);

    
        g.setColor(WHITE_COLOR);
        g.fillRect(0, saffronHeight, flagWidth, whiteHeight);

        
        g.setColor(GREEN_COLOR);
        g.fillRect(0, saffronHeight + whiteHeight, flagWidth, greenHeight);

       
        g.setColor(NationalFlagColors.BLUE_COLOR);
        int centerX = flagWidth / 2 - chakraRadius;
        int centerY = saffronHeight + (whiteHeight / 2) - chakraRadius;
        g.fillOval(centerX, centerY, chakraDiameter, chakraDiameter);

       
        g.setColor(NationalFlagColors.WHITE_COLOR);
        for (int i = 0; i < 24; i++) {
            double angle = Math.toRadians(i * 15);
            int x1 = (int) (centerX + chakraRadius * Math.cos(angle));
            int y1 = (int) (centerY + chakraRadius * Math.sin(angle));
            int x2 = (int) (centerX - chakraRadius * Math.cos(angle));
            int y2 = (int) (centerY - chakraRadius * Math.sin(angle));
            g.drawLine(x1, y1, x2, y2);
        }
    }
}

}

Q2]

import java.sql.*;

public class ScrollableResultSetDemo {

private static final String JDBC_URL = "jdbc:mysql://localhost:3306/your_database_name";
private static final String USERNAME = "your_username";
private static final String PASSWORD = "your_password";

public static void main(String[] args) {
    try (Connection connection = DriverManager.getConnection(JDBC_URL, USERNAME, PASSWORD)) {
    
        Statement statement = connection.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);

     
        ResultSet resultSet = statement.executeQuery("SELECT * FROM Teacher");

       
        resultSet.last();

     
        int rowCount = resultSet.getRow();

      
        resultSet.beforeFirst();

        System.out.println("Teacher table data:");
        System.out.println("TID\tTName\tSalary");
        System.out.println("-----------------------------");

       
        while (resultSet.next()) {
            int tid = resultSet.getInt("TID");
            String tname = resultSet.getString("TName");
            double salary = resultSet.getDouble("Salary");

            System.out.println(tid + "\t" + tname + "\t" + salary);
        }

        System.out.println("-----------------------------");
        System.out.println("Total rows: " + rowCount);
    } catch (SQLException e) {
        e.printStackTrace();
    }
}

}