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