ns29

Q1]

import java.sql.*;

public class DonarTableColumnsInfo {

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)) {
        DatabaseMetaData metaData = connection.getMetaData();

       
        ResultSet resultSet = metaData.getColumns(null, null, "DONAR", null);
        System.out.println("Columns information for the DONAR table:");

        while (resultSet.next()) {
            String columnName = resultSet.getString("COLUMN_NAME");
            String columnType = resultSet.getString("TYPE_NAME");
            int columnSize = resultSet.getInt("COLUMN_SIZE");

            System.out.println("Column Name: " + columnName);
            System.out.println("Column Type: " + columnType);
            System.out.println("Column Size: " + columnSize);
            System.out.println("-----------------------------------");
        }
    } catch (SQLException e) {
        e.printStackTrace();
    }
}

}

Q2]

import java.util.LinkedList;

public class LinkedListOperations {
public static void main(String[] args) {

    LinkedList<Integer> linkedList = new LinkedList<>();


    linkedList.addFirst(10);
    linkedList.addFirst(20);
    linkedList.addFirst(30);

    
    System.out.println("LinkedList after adding elements at first position: " + linkedList);


    linkedList.removeLast();


    System.out.println("Size of LinkedList: " + linkedList.size());
}

}