Mysql UTC_TIMESTAMP() Function Example Using Java Servlet

Mysql UTC_TIMESTAMP() Function Example Using Java Servlet


Posted in : Java Posted on : September 1, 2011 at 1:46 PM Comments : [ 0 ]

In this tutorial you will learn how to use utc_timestamp, utc_timestamp() function of mysql with java servlet.

Mysql UTC_TIMESTAMP() Function Example Using Java Servlet

In this tutorial you will learn how to use utc_timestamp, utc_timestamp() function of mysql with java servlet.

UTC_TIMESTAMP, UTC_TIMESTAMP() function of mysql gives back the current UTC time and date in either of the format 'YYYY-MM-DD HH:MM:SS' or YYYYMMDDHHMMSS.uuuuuu depends on the context i.e. either string or numeric context.

Syntax :

utc_timestamp; or utc_timestamp();

Now, since I have to use this function in java servlet program, therefore I have created a java servlet class named MysqlUtcTimeStampServlet which extends the HttpServlet class. In the body of class I overridden the method doGet() and created an objects of HttpServletRequest and HttpServletResponse into its parameter. Inside the doGet() method first I set the mime type that in which format the browser will show the output. In the next line I used the getWriter() method of ServletResponse interface with the object of HttpServletResponse. HttpServletResponse interface extends this method from the ServletResponse. In continue we have to make a connection between java code and database system. So, since I am using Mysql in the example given below therefore, I am loading the driver of mysql and make a connection by using the getConnection() method of DriverManager class. It returns a Connection. Further I am passing the two queries 1. "SELECT UTC_TIMESTAMP;" (This query will return the output as 2011-08-25 06:09:04.0) and 2. "SELECT UTC_TIMESTAMP();" (This query will return the output as 2011-08-25 06:09:04.0) into the parameter of prepareStatement() method of Connection interface which gives an object of PreparedStatement interface. In the next line I used the executeQuery() method of PreparedStatement interface which returns a ResultSet object that holds the result of query. At last I have extracted the result from the ResultSet object.

Example :

MysqlUtcTimeStampServlet.java

import java.io.IOException;
import java.io.PrintWriter;
import java.sql.SQLException;
import java.sql.DriverManager;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

public class MysqlUtcTimeStampServlet extends HttpServlet
{
 public void doGet(HttpServletRequest request, HttpServletResponse response)
 throws IOException, ServletException
 {
  response.setContentType("text/html");
  PrintWriter out = response.getWriter();
  String className = "com.mysql.jdbc.Driver";
  String url = "jdbc:mysql://192.168.10.13";
  String user = "root";
  String password = "root";
  String sql = "SELECT UTC_TIMESTAMP";
  String sql1 = "SELECT UTC_TIMESTAMP()";
  
  Connection con;
  PreparedStatement ps, ps1;
  ResultSet rs, rs1;
  
  try
  {
	Class.forName(className);
	con = DriverManager.getConnection(url, user, password);
	ps = con.prepareStatement(sql);
	ps1 = con.prepareStatement(sql1);
	rs = ps.executeQuery();
	rs1 = ps1.executeQuery();
	
	out.println("<table>");
	out.println("<tr>");
	out.println("<td><b>UTC_TIMESTAMP</b></td>");
	out.println("</tr>");
	
	while(rs.next())
	{
	  String utcTimeStamp = rs.getString(1);
	  out.println("<tr>");
	  out.println("<td>"+utcTimeStamp+"</td>");
	  out.println("</tr>");
	}
	
	out.println("<tr>");
	out.println("<td><b>UTC_TIMESTAMP()</b></td>");
	out.println("</tr>");
	
	while(rs1.next())
	{
	  String utcTimeStamp1 = rs1.getString(1);
	  out.println("<tr>");
	  out.println("<td>"+utcTimeStamp1+"</td>");
	  out.println("</tr>");
	}
  }
  catch(SQLException sx)
  {
	out.println(sx);
  }
  catch(ClassNotFoundException cx)
  {
    out.println(cx);
  }
 }
}

web.xml

<?xml version="1.0" encoding="UTF-8"?>
<web-app id="WebApp_ID" version="2.4" xmlns="http://java.sun.com/xml/ns/j2ee" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd">
<display-name>mysqlDate</display-name>

<servlet>
<servlet-name>MysqlUtcTimeStampServlet</servlet-name>
<servlet-class>MysqlUtcTimeStampServlet</servlet-class>
</servlet>

<servlet-mapping>
<servlet-name>MysqlUtcTimeStampServlet</servlet-name>
<url-pattern>/MysqlUtcTimeStampServlet</url-pattern>
</servlet-mapping>

</web-app>

Output :

When you will execute the above example you will get the output as :

NOTE : Output may vary on system to system because it gives the current system date and time

Download Source Code

Go to Topic «PreviousHomeNext»

Your Comment:


Your Name (*) :
Your Email :
Subject (*):
Your Comment (*):
  Reload Image
 
 

 
Tutorial Topics