how to include Timestamp into my enquiry form?

how to include Timestamp into my enquiry form?

Dear expert,

I'd like to include a timestamp function into my enquiry form.

However, I am stuck at the servlet portion whereby I want to map my Timesatmp class to my update_time field in my database.

Here's my Timestamp.java code:


public class Timestamp{
private Timestamp updatedTime;

public void setUpdatedTime(Timestamp updatedTime){
this.updatedTime = updatedTime;
}

public Timestamp getUpdatedTime(){
return updatedTime; } }

And here's my servlet :

import java.io.*;
import java.io.PrintWriter;
import javax.servlet.*;
import javax.servlet.http.*;
import java.sql.*;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.sql.Timestamp;


public class ProcessEnquiry extends HttpServlet {
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType("text/html;charset=UTF-8");

PrintWriter out = response.getWriter();
Connection con = null;
ResultSet rs = null;
PreparedStatement ps = null;
Statement stmt = null;
String strName = "";
String strEmail = "";
String strContact = "";
String strEnquiry = "";
String strMessage = "";

String strCreateRecordSQL = "";
try {
Class.forName("com.mysql.jdbc.Driver");
con = DriverManager.getConnection("jdbc:mysql://localhost/xxx", "xxx", "xxx");
strName = request.getParameter("name").trim();
strEmail = request.getParameter("e-mail").trim();
strContact = request.getParameter("contact").trim();
strEnquiry = request.getParameter("enquiry").trim();
strTime = return updated_time;

strCreateRecordSQL = "INSERT INTO enquiry";
strCreateRecordSQL += "(strName, strEmail, strContact, "
+ " strEnquiry, updated_time) "
+ "VALUES (?,?,?,?,?)";
ps = con.prepareStatement(strCreateRecordSQL);
//Fill up the blanks (?) in the SQL with the form data
ps.setString(1, strName);
ps.setString(2, strEmail);
ps.setString(3, strContact);
ps.setString(4, strEnquiry);
ps.setString(5, strTime);
ps.executeUpdate();
out.println("Your mail is sent");
strMessage = "<a href=\"index.jsp\">Click here to return to Home Page";
out.println(strMessage);
} catch (SQLException e) {
throw new ServletException("Servlet could not display records", e);
} catch (ClassNotFoundException e) {
throw new ServletException("JDBC Driver Not Found", e);
} finally {
try {
if (rs != null) {
rs.close();
rs = null;
}
if (stmt != null) {
stmt.close();
stmt = null;
}
if (con != null) {
con.close();
con = null;
}
} catch (SQLException e) {
throw new ServletException("Servlet could not display records", e);
}
}
out.close();
}
}

In my database column I have added in this field -

updated_time

Hope to hear from you soon....am very excited about this DAO concept and really hope to learn it from you guys....many thanks.
View Answers









Related Tutorials/Questions & Answers:
how to include Timestamp into my enquiry form? - Java Beginners
ModuleNotFoundError: No module named 'formv'
Advertisements
ModuleNotFoundError: No module named 'formy'
ModuleNotFoundError: No module named 'forml'
ModuleNotFoundError: No module named 'odoo10-addon-account-invoice-pro-forma-sequence'
ModuleNotFoundError: No module named 'odoo10-addon-account-invoice-pro-forma-sequence'
How to include?
ModuleNotFoundError: No module named 'django-enquiry'
ModuleNotFoundError: No module named 'django-enquiry'
ModuleNotFoundError: No module named 'django-enquiry'
product enquiry form
How to include website in google search?
How can I to my database to my application
use forms.
how to include a java class in jsp - JSP-Servlet
How to use RequestDispatcher include method
how to include an html page inside a tab
How to use Bean Area in Oracle Forms 9i with Sample code ?
how to refresh my GUI page
JSP WITH MULTIPLE FORMS
How to connect to the database to my application if my database is made up in oracle
How to include a File using directive and include action
How can I find my DHCP IP address on my computer?
How can I connect my database to my application ?
Multiple Forms in JSP
How To Include Two Jsp page in another jsp page?
how to include a session class in java awt code - JavaMail
how can i export a .jar file include .mbd file?
ModuleNotFoundError: No module named 'aldryn-forms'
ModuleNotFoundError: No module named 'aldryn-forms'
ModuleNotFoundError: No module named 'aldryn-forms'
ModuleNotFoundError: No module named 'capybara-forms'
ModuleNotFoundError: No module named 'cms-forms'
ModuleNotFoundError: No module named 'Constellation-Forms'
ModuleNotFoundError: No module named 'djangocms-forms'
ModuleNotFoundError: No module named 'dynamic-forms'
ModuleNotFoundError: No module named 'forms_extras'
ModuleNotFoundError: No module named 'google_forms'
ModuleNotFoundError: No module named 'manhattan-forms'
ModuleNotFoundError: No module named 'needle-forms'
ModuleNotFoundError: No module named 'normal-forms'
ModuleNotFoundError: No module named 'normal-forms'
ModuleNotFoundError: No module named 'omero-forms'
ModuleNotFoundError: No module named 'pulpo-forms'
ModuleNotFoundError: No module named 'pulpo-forms'
ModuleNotFoundError: No module named 'pyoracle-forms'
ModuleNotFoundError: No module named 'semanticui_forms'
ModuleNotFoundError: No module named 'tornado-forms'
ModuleNotFoundError: No module named 'aldryn-forms'
ModuleNotFoundError: No module named 'capybara-forms'

Ads