//carReg.jsp


        <%@ 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");

        %>




//lauction.jsp

        <form action="carReg.jsp" method="post">

        <center>
        Car Type:<input type="text" name="type" /> </p>
        Car Model:<input type="text" name="model" /></p>
        Car Year:<input type="text" name="year" /></p>
        Car Details:<input type="text" name="details" /></p>
        Auction end Date: <input type="datetime-local" name="endDate" min="2018-10-28"/></p>
        </center>
        <input type="submit" />

    </form>