DATES RETREIVAL USING SERVLET:
//Keep this in your servlet and make sure to enter correct driver name, url, username and password
try
{
Date date = null;
Class.forName(driver name);
Connection con=DriverManager.getConnection(url, username, password);
Statement stmt=con.createStatement();
ResultSet rs=stmt.executeQuery("select sdate,noofleaves from leavetable where empid='001'");
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
while(rs.next())
{
String da=rs.getString(1);
int e=Integer.parseInt(rs.getString(2));
date=(Date)sdf.parse(da);
for(int i=0;i<e;i++)
{
date.setDate(date.getDate()+1);
out.println(date);
out.println("<br>");
}
}
} finally {
out.close();
}
}
