Untitled

<%@ page language="java" import="java.sql.*" contentType="text/html; charset=ISO-8859-1" pageEncoding="ISO-8859-1"%><%@ page import="java.util.Date"%><%@ page import="java.sql.*" %><%@ page import="java.text.*" %><%@ page import="java.text.SimpleDateFormat" %><html><head><title>Display Current Date & Time</title></head><body><center><h1>Display Current Date & Time</h1></center><%Date currentDate = new Date();out.println("Current Date is:"+currentDate);%><% String txtDate = new SimpleDateFormat("yyyy-mm-dd").format(currentDate);out.println("Current Date in text format is:"+txtDate);%><%try{Class.forName("com.mysql.jdbc.Driver");Connection  conn = DriverManager.getConnection("jdbc:mysql://retail:3306/rs","RS","orbisindia");Statement stmt1 = conn.createStatement();ResultSet rs1 = stmt1.executeQuery("select * from retail_inventory") ;while (rs1.next()){out.println(txtDate.toString());out.println((rs1.getString(6).toString()));out.println((txtDate.toString())  - (rs1.getString(6).toString()) );%><br><%}conn.closeatch(Exception e){out.println(e);}%></body></html>