Latest Tutorials| Questions and Answers|Ask Questions?|Site Map



Home Answers Viewqa Java-Beginners how to include Timestamp into my enquiry form?
Login         

View Questions and Answers by Category

Advertisements


 
Have Programming Question? Ask it here!
 
 
 


Karen
how to include Timestamp into my enquiry form?
0 Answer(s)      4 years and 2 months ago
Posted in : Java Beginners


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.

Advertisement
View Answers

Related Tutorials/Questions & Answers:
Advertisements
 

 

 

DMCA.com