Untitled


//car registration
<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
    pageEncoding="ISO-8859-1"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
    <head>
        <title>Login System</title>
    </head>

    <body>
       <p> <a href="logout.jsp">Logout</a></p>
       <p><a href="lauction.jsp"></a></p>

        <%
        String username=(String)session.getAttribute("username");
        String id=(String)session.getAttribute("ClientID");


        //redirect user to login page if not logged in
        if(username==null){
            response.sendRedirect("index.html");
        }

        %>
        <%@ page import ="java.sql.*" %>
        <%@ page import ="javax.sql.*" %>
        <%@ page import ="java.time.*" %>
        <%@ page import ="java.text.*" %>
        <%@ page import = "java.util.*" %>
        <%@ page import ="java.time.LocalDateTime" %>
        <%@ page import ="java.time.format.*" %>
        <%@ page import ="java.util.Date" %>
        <%@ page import ="java.text.ParseException" %>
        <%@ page import ="java.text.SimpleDateFormat" %>
        <%@ page import ="java.time.format.DateTimeFormatter" %>
        <%String type=request.getParameter("type");
        session.putValue("type",type);
        String model=request.getParameter("model");
        String year=request.getParameter("year");
        String details=request.getParameter("details");
        String details=request.getParameter("endDate");
        Class.forName("com.mysql.jdbc.Driver");
        java.sql.Connection con = DriverManager.getConnection("jdbc:mysql://localhost/auction",
        "root","cenk");
        Statement st= con.createStatement();

        DateTimeFormatter fm = DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm:ss");
        LocalDateTime today = LocalDateTime.now();
        fm.format(TS);
        String sDate = fm.format(TS);


        String insert_clients = "INSERT INTO auction_items (cartype, carmodel, caryear, cardetails, startDate, enddate, clientID) Values ('"+type+"', '"+model+"', '"+year + "', ' "+details+"','"+sDate+"','"+endDate+"','"+id+"')";

        st.executeUpdate(insert_clients);
        out.println("Registered car Successfully");
        response.sendRedirect("lauction.jsp");

        %>


    </body>
</html>


//date code to be injected
              LocalDateTime today = LocalDateTime.now();
              Date endDate = new Date();
              DateTimeFormatter sdfToday = DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm:ss");
              LocalDateTime date2 = sdfToday.parse(edate);
              date2 = sdfToday.format(date2);