Untitled

<%@page import="java.sql.*" %>
<%//String name=session.getAttribute("name").toString();
%>
<!DOCTYPE html>
<html lang="en">
<head>
  <title>Time Management System</title>
  <link href="tms.png" rel="shortcut icon" />

</head>
<body background="bg2.png">

    <div class="container">

<% Connection con;
   Statement st;
   ResultSet rs;

   try {
        Class.forName("com.mysql.jdbc.Driver");
      con=DriverManager.getConnection("jdbc:mysql://localhost:3306/timesheet","root","");
      st=con.createStatement();
      String sql ="SELECT TIMEDIFF( outtime, intime) FROM time";

           rs=st.executeQuery(sql);


                 while(rs.next())
                 {
                     out.print(rs.getString(1));
                 }

                 %>   &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
          <a href="home.jsp"> HOME PAGE</a></center>
        <%
      }
      catch(SQLException e)
      {out.println(e);
        e.printStackTrace();
      }
      %>

</div>
</body>
</html>