ja10

1. Write a Java program to display the Current Date using spring. [15 M]
2. import org.springframework.context.ApplicationContext;
   import org.springframework.context.annotation.AnnotationConfigApplicationContext;
   import org.springframework.context.annotation.Bean;
   import org.springframework.context.annotation.Configuration;

import java.time.LocalDate;

@Configuration
public class SpringDateApp {
@Bean
public LocalDate currentDate() {
return LocalDate.now();
}

public static void main(String[] args) {
    ApplicationContext context = new AnnotationConfigApplicationContext(SpringDateApp.class);
    LocalDate currentDate = context.getBean("currentDate", LocalDate.class);
    System.out.println("Current Date: " + currentDate);
}

}

2. Write a Java program to display first record from student table (RNo, SName, Per) onto
   the TextFields by clicking on button. (Assume Student table is already created).
   import javax.swing.;
   import java.awt.;
   import java.awt.event.ActionEvent;
   import java.awt.event.ActionListener;
   import java.sql.Connection;
   import java.sql.DriverManager;
   import java.sql.ResultSet;
   import java.sql.Statement;

public class DisplayFirstRecord extends JFrame {
private JTextField rNoField, sNameField, perField;
private JButton displayButton;

public DisplayFirstRecord() {
    setTitle("Display First Record");
    setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
    setLayout(new GridLayout(4, 2));

    rNoField = new JTextField(10);
    sNameField = new JTextField(10);
    perField = new JTextField(10);
    displayButton = new JButton("Display");

    add(new JLabel("Roll No:"));
    add(rNoField);
    add(new JLabel("Student Name:"));
    add(sNameField);
    add(new JLabel("Percentage:"));
    add(perField);
    add(new JLabel()); // Empty label for spacing
    add(displayButton);

    displayButton.addActionListener(new ActionListener() {
        public void actionPerformed(ActionEvent e) {
            try {
                Class.forName("com.mysql.jdbc.Driver");
                Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/test", "root", "");
                Statement stmt = con.createStatement();
                ResultSet rs = stmt.executeQuery("SELECT * FROM student LIMIT 1");
                if (rs.next()) {
                    rNoField.setText(rs.getString(1));
                    sNameField.setText(rs.getString(2));
                    perField.setText(rs.getString(3));
                }
                con.close();
            } catch (Exception ex) {
                System.out.println(ex);
            }
        }
    });

    pack();
    setVisible(true);
}

public static void main(String[] args) {
    new DisplayFirstRecord();
}

}