total time calculator (starttime+endtime) in servlet USING DATABASE IN SQL2000 PLZ ANY ONE HELPME

 <%-- 
    Document   : insertdate
    Created on : Jul 19, 2013, 3:48:28 PM
    Author     : CG0T4908
--%>

<%@page contentType="text/html" pageEncoding="UTF-8"%>
<%@page import="java.sql.*"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
   "http://www.w3.org/TR/html4/loose.dtd">

<html>
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
        <title>JSP Page</title>
    </head>
    <body bgcolor="#4eeerwty">
     <%
    String Empname=request.getParameter("empname");
    String Empid=request.getParameter("empid");
    String projectname=request.getParameter("projectname");

      String Requirementid=request.getParameter("RequirementID");


     String taskid=request.getParameter("taskid");

    String category=request.getParameter("category");
    String Datet=request.getParameter("Date");


      String Starttime=request.getParameter("starttime");
        String Min=request.getParameter("minutes");
       String ampms=request.getParameter("ampms");
     String Endtime=request.getParameter("Endtime");
     String Endmin=request.getParameter("endtimeminutes");
      String Endampm=request.getParameter("endtimeampm");
      String TaskDescription =request.getParameter("comments");
           String tottime =request.getParameter("Endtime");

//System.out.println("Reqqq"+Starttime);//
    Connection con;
    Statement st;
    Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
    try
     {
        //int Dated =Integer.parseInt("Date");
        // char Dater=Character.parseChar("Date");

        con=DriverManager.getConnection("jdbc:microsoft:sqlserver://10.32.4.27:1433;DatabaseName=chinna;User=sa;Password=sa");
        st=con.createStatement();
        int f=st.executeUpdate("insert into inserttable(projectname,RequirementID,taskid,category,datet,Starttime,Endtime,TaskDescription,TotalTime,EmployeeID)values('"+projectname+"','"+Requirementid+"','"+taskid+"','"+category+"','"+Datet+"','"+Starttime+"/"+Min+"/"+ampms+"','"+Endtime+"/"+Endmin+"/"+Endampm+"','"+TaskDescription+"','"+tottime+"','"+Empid+"')");
        if(f==1)
            {
        out.println("Data  Saved");
        }
        else
            {
              out.println("Failed");
         }
        }
    catch(Exception e)
            {
        out.println("error"+e.getMessage());
        }

   %>
</body>
</html>
View Answers