ja29

1. Write a Java program to display information about all columns in the DONAR table
   using ResultSetMetaData. [15 M]
   import java.sql.*;

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

    String url = "jdbc:mysql://localhost:3306/your_database_name";
    String username = "your_username";
    String password = "your_password";

    try (Connection connection = DriverManager.getConnection(url, username, password)) {
        
        Statement statement = connection.createStatement();
        
     e
        ResultSet resultSet = statement.executeQuery("SELECT * FROM DONAR");
        
     
        ResultSetMetaData metaData = resultSet.getMetaData();
        
      
        int columnCount = metaData.getColumnCount();
        System.out.println("Columns in DONAR table:");
        for (int i = 1; i <= columnCount; i++) {
            System.out.println("Column Name: " + metaData.getColumnName(i));
            System.out.println("Column Type: " + metaData.getColumnTypeName(i));
            System.out.println("Column Size: " + metaData.getColumnDisplaySize(i));
            System.out.println();
        }
    } catch (SQLException e) {
        e.printStackTrace();
    }
}

}

2. Write a Java program to create LinkedList of integer objects and perform the following:
   i. Add element at first position
   ii. Delete last element
   iii. Display the size of link list
   import java.util.LinkedList;

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

    LinkedList<Integer> linkedList = new LinkedList<>();
    
   
    linkedList.addFirst(10);
    

    linkedList.removeLast();
    
  
    System.out.println("Size of linked list: " + linkedList.size());
}

}