ja11 - Posts - OneCompiler

Design an HTML page which passes customer number to a search servlet. The servlet
searches for the customer number in a database (customer table) and returns customer
details if found the number otherwise display error message. [15 M]

<!DOCTYPE html> <html> <head> <title>Customer Search</title> </head> <body> <h2>Search Customer Details</h2> <form action="SearchServlet" method="get"> <label for="customerNumber">Enter Customer Number:</label> <input type="text" id="customerNumber" name="customerNumber" required> <br><br> <input type="submit" value="Search"> </form> </body> </html>

Write a Java program to display information about all columns in the DONAR table
using ResultSetMetaData.
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.Statement;

public class DisplayDonarTableColumns {
public static void main(String[] args) {
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 DONAR");

        ResultSetMetaData rsmd = rs.getMetaData();
        int columnCount = rsmd.getColumnCount();
        System.out.println("Columns in DONAR table:");
        for (int i = 1; i <= columnCount; i++) {
            System.out.println(rsmd.getColumnName(i) + " (" + rsmd.getColumnTypeName(i) + ")");
        }

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

}